Skip to main content

Zebra BI charts

Zebra BI charts

Zebra BI is a developer of data Visualization software for creating business charts, presentations, dashboards and reports. They are the most powerful charting visual in Power BI. Simply click to display waterfall, variance, column, area, line, dot, lollipop, ‘hills&valleys’ and other types of charts.

Zebra BI are the first and only IBCS-certified visuals for Power BI. Zebra BI is available for Microsoft Excel and Power BI.

Features of Zebra-BI charts:
  •  Chart slider – change chart in 1 click
  • 12 business charts available in several layouts
  •  Calculates absolute and relative variances
  • Advanced waterfall charts with subtotals
  • Combo charts with adjustable 2nd value axis
  • Segmented charts – display your forecasts
  • Customizable design
  • Custom number formats
  • Works in Report Server, mobile apps
  • World's first fully responsive visual!
I am building the charts in excel using Zebra-BI add-in. Below are the steps I followed to build the charts in excel using Zebra_BI.

Step-1: Zebra-BI add-in for excel will be available in the below link. After going to the website, click on the button showed in the below fig.

Step-2: After clicking on the button, it will be directed to another page where we need to give product details for installation, details and mail ID. After submitting the details installation link will be sent to the mail.


Step-3: Click on the link that was sent to the mail and .msi file will start downloading. After file downloads open the file and install it.

Step-4: After installing, open new excel file and Zebra BI add-in will be seen in the excel ribbon.


Step-5: Now, I will take few sample data sets and build different charts for the data sets. Charts can be seen in Visualize tab which can be seen in the below fig.


Step-6: Below is the fig shows data set for Actual and Budget Sales in kEUR from Jan to Dec.


Step-7: To see the variance between Actual and Budget select anywhere inside the data set. I have selected the variance chart which represents in column as shown in below fig.


Step-8: Below is the chart which shows the variance for the data. To adjust the number format, click on the chart setting which is highlighted in below fig.


Step-9: In the highlighted dropdown, we can adjust the number values.


Step-10: Chart styles can be changed in Apply style tab as shown in below fig.

Step-11: To get the representation for Oct, write some value in the cell highlighted.


Step-12: Below fig shows the representation for Oct month.


Step-13: Below is the chart representation for Headcount.


Step-14: Below are the variance representation in two ways. First chart in the left side shows the variance by adding Actual and Budget data and second chart in the right side shows the variance in Plus-Minus by subtracting the Budget data from Actual data.


Step-15: Below are the Waterfall representation charts for the data set for 8 different items.












Comments

Post a Comment

Popular posts from this blog

Adding formulas to the Dataforms - Hyperion Planning

We all know, how to create a data form using rows, columns, page and POV. In this I want to explain how to add Formula rows/columns in Hyperion Web form. Here in this blog I have used application called VIZAGPLN. All the screenshots show this application only. Step-1: Go to Planning Application > Navigate > Applications > Planning > VIGAZPLN as shown below. Step-2: Go to Administration >  Manage >  Forms and Ad Hoc Grids to open the forms shown as below. Step-3: Select the form and click on edit, shown as below. Step-4: Go to Layout and click on edit select member selector icon to insert require Member/members in rows and columns as shown below. I will explore further how to add formula row/column with below three requirements for better understanding.             Req1) Displaying Half year sales using Sum function:                       Sum function returns the sum of rows, columns or cell.                       Example:
2 comments
Read more

Password encryption in MAXL script

Password encryption in MAXL script An objective of this blog is to provide information about how to encrypt the Username and Password in Maxl script. To login into Essbase Server, in traditional method we manually enter the User credentials and do the process. We also have another process to login into Essbase server and do the process i.e. through Maxl scripts in which we can automate Maxl scripts through batch by scheduling and also through command prompt we can run the process by calling the Maxl. Through manually login User credentials are remembered by the user whereas through Maxl script we give the User credentials in text file. So, there might be a chance of stealing the User credentials. To provide the more security we do User credential encryption. There will be two basic keys are used Encrypt: Public key Decrypt: Private key The Public and Private Key pair comprises of two uniquely related Cryptographic keys (It is a string of data used to lock and unlock cry
Post a Comment
Read more

Block creation for data storage members

We all have the confusion that, how block creation happens in Essbase. Even I used to have that confusion. So, I wanted to clear that confusion by clearly explaining how block creation happens using data storage members. In Block storage, I am going to tell about, 1.      Block size. 2.      The potential number of blocks. 3.      The number of existing blocks. 1.    Block size: The size of each cell is 8kb. So the size of a block will be 8* no. of. Cells (Dense * Dense) bytes. Fig: 1.1 In the above picture, if you see we have two dense members i.e. Product and Year. For block size, we need to take members which are stored only. So no of cells= 9*1bytes. So Block size= 8*(9*1) = 72bytes. Below Fig shows the Block size, Fig: 1.2 2.    Potential Number of blocks: Maximum number of blocks that are derived from the product of one sparse member to other sparse members. Consider Fig: 1.1 we have five sparse members i.e. Account. Entity, Version, Period
3 comments
Read more