Today’s Wednesday Wisdom’s subject was on Power BI, A Microsoft application for business intelligence and interactive visual reporting. We were shown how to import multiple data files from Excel into Power BI, how to create relationships between this data and then how to manipulate the data. The outcome of this was an aesthetically pleasing and accurate report based on one of Stream’s past campaigns. 

As said previously this report was interactive, meaning that you could click on a subject on that report and drill down to see all the information available. For instance, one of the pages of the report create was all about the rewards that were redeemed in this past campaign. What you could is click on a specific reward that you want to spotlight and instantly the rest of the page will shift from reporting on all rewards to just reporting on the reward spotlighted. This is great for identifying the best preforming rewards. 

Further to this report we were shown some ‘outside the box’ ways to utilise the functions of Power BI in the form of Stream’s Helpdesk management. In this Power BI deck, we will soon be able to answer any helpdesk query simply by answering a few questions using a simple, easy to use, flowchart that can lead anyone to the answer of any helpdesk query.

We look forward to seeing what else Power BI can do for us here at Stream.