In this exercise of the eazyBI training we want to mix the content of an Excel file with our Jira issues using an Account/cube of the one of the most famous plugins for Business Intelligence and Analytics for Atlassian Jira called eazyBI.
First we need an Excel file of course, we will use a column with the Jira issues keys in each row (We will use this column to match in the issues in the Jira cube/datasource).
Now we can upload the file in eazyBI, go to your Jira cube and click in “Source Files”
Here you can push the Excel file, after this we need to map and configure the columns
Now map the columns like in this picture:
Remember use the cube “Issues” as name, use dimension Issue and Level Issue en each column. In the Issue Key column select “Skip missing”. In the rest of columns set the name of each column as Property name.
Import the Excel rows in the Jira cube. Then we can create a new report super easy!
In rows select Issues dimension (and show only the Issue Key to see better the results)
In columns use “Measures” dimension and activate the custom properties (that’s super automatic!)
Now you can see the results! Measures mixed! WOW! if your Excel has changes you can upload again and the data will be refreshed, amazing!