<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

Back in April I attended the Power BI Summit which had more than 100 presentations, and I came away with the conviction that we have come a long way in the Power BI world.
One thing clearly stood out in the flurry of news and presentations: namely, how Microsoft has really made great strides to integrate AI technology into Power BI Pro & Premium.
Until recently, most businesses assumed you needed a Ph.D. in computer science to work with AI. But platform providers like Microsoft have been busy integrating AI tools into their products and services in order to put that power into the hands of ordinary users and developers.
It's pretty wild what the combination of Power BI and AI lets you do today!

Let’s look at just 5 of the new AI “hacks” available in Power BI, which will really make your BI products pop.

Power BI AI hack # 1: Automated Analyses

Good reporting is about telling a story, and data reporting is no different. It can be the story of the result of a campaign, or the story of the development in earnings over the last 3 years. The art is to identify the real story, and then convey it.

With Power BI you have an alternative to starting the analysis from scratch, namely the “Smart Narratives” feature. When you choose the Smart Narratives visualization Power BI adds a box to your report with an analysis of the data already written for you, noting important trends and data points. From here you can then start diving into data and researching different dimensions, adding your own insights and understanding as you edit the text.
Smart Narratives is a shortcut to building reports, but it is also an opportunity to gain completely new insights. At the same time we can reduce the risk of “confirmation bias,” where we often find only the results and explanations that we are looking for, consciously or unconsciously.

In addition to Smart Narratives, Power BI also has a Q&A function where you can enter questions about the data and Power BI provides answers. Power BI can learn to understand what you are asking about in your own words. If you use the word 'school', for example, Power BI may not understand it, but you could then link it to 'education' - and Power BI then learns that 'school' is equal to 'education'.

Power BI AI hack # 2: Anomalies

When you work with time series data, such as earnings over time, there will naturally be variations in the data from week to week or month to month. Traditionally analysts would study a graph reminiscent of a jagged mountain ridge and have to assess whether everything looks normal or if there are important surprises in the data.

Large fluctuations in the upward or downward direction are usually visually obvious. But does this mean that there is an irregularity in the underlying data, or is it an expected fluctuation- for example because you have run a new sales campaign?

These are important distinctions, but generally easy to diagnose. It is more difficult to spot the 'invisible' irregularities - where there is nothing that stands out to the human eye, perhaps because the data is highly volatile.

With the Analytics function 'Anomalies', Power BI uses AI to look at the underlying data and automatically detects if there are irregularities in your time series data. The Anomalies feature also provides explanations of the irregularities to help with root cause analysis.

Of course, each time series is different and the threshold for what counts as an important anomaly can vary a lot. Therefore, you can control how sensitive the algorithm in Power BI should be to changes in data, and when a deviation should be marked as an irregularity.

Power BI AI hack # 3: Analyze

You have reported the turnover figures for the current year to the sales director in a clear bar chart, month by month. The month of February shows a marked increase in revenue - and now the director would like an explanation for the increase.

Instead of having to embark on a laborious detective job, right-click on the column for February. In no time, you have a new analysis of the February figures, clearly presented. Here you can see that it was Denmark, Germany and the USA in particular that experienced an increase in revenue in February, while Denmark, Germany and France had the largest relative change in sales figures.

With this AI functionality, you move from getting answers to what's happening, to also getting answers to why it's happening. AI looks deeper into the numbers, and looks behind patterns and trends. In the example here, we have taken as our starting point a finished report, which the sales director wants to elaborate on - but it is also obvious to use the Analyze functionality in connection with the report being built up.

Power BI AI hack # 4: Decomposition Tree

Another way to dive behind the numbers is by using Power BI's functionality “Decomposition Tree.”

The thinking behind the Decomposition Tree is: What value would you like to analyze (a measurement or aggregation of data), and what dimensions would you like to explain the value by (by performing data derivation)? Maybe you want to look at your supply chain and analyze what percentage of your products you have in backorder? Or maybe you want to analyze sales of a particular product category (books) by various factors, such as genre and publisher?

With the Decomposition Tree function in Power BI, you can visualize data across multiple dimensions. The function automatically collects data, so you can perform data extraction in your dimensions in any order. You can use the tool for ad hoc exploration and root cause analysis - and you can also ask Power BI to find the next dimension in your data so that you can perform detailed deductions based on specific criteria.

Power BI AI hack # 5: Visualization of key influencers 

Data reporting is about the “what” but data analysis is always about the “why:”

- Your customer service manager wants to know why your customers are giving your call center bad reviews.

- Your product manager wants to know, what are the characteristics of your product that customers are particularly happy with, and what they are especially tired of?

- Your sales manager would like to know if these are the same factors that cause sales to increase in the Danish and Norwegian markets?

- And your HR manager has a gut feeling that commuting time and seniority are important for the increase in employee turnover - but is that right, and which weighs heaviest?

The visualization of Key Influencers helps you understand the factors behind the value you are interested in. Key Influencers analyze data, rank the factors that matter, and show them as key factors behind your outcomes of interest.

With this tool you can see not just the factors that affect, for example, employee turnover, but also compare the relative importance of the factors and see if, for example, commuting time has a greater impact on employee turnover than seniority.

 


Be sure to explore these and other new features available in Power BI on your own data and see how much more your BI pops with a little AI on top!

I hope that this blog found you well, and feel free to get in touch if you have any questions.

Topics

Discuss this post

Recommended posts

Do you want to see significant success in your business?  Then, use your data: Make your data work for you and make the right fact-based decisions. You can unveil surprising stories hidden in your existing data when you are curious and open-minded to find new knowledge.
BI implementations often do not yield anticipated results because of a lack of user adoption and cultural change. Therefore, it is not enough that your BI partner implements the BI solution as a technology project; they also take full responsibility for your user adoption. Organizations can take full advantage of BI investments only when its users leverage insights and reports from the solution to make decisions.
The main misconception that I encounter every day is that for a business to become data-driven, it must be governed by data based on facts, rather than on human judgment or intuition. However, being a data-driven business does not mean ruling the human factor out of the equation; on the contrary, it is about enabling automated decision-making more accurately.
Data mining seems to be the holy grail of enterprise software today. Yet while many have heard of it, few have seen it in action. Even fewer seem to know how to actually use it. Mainstream adoption seems to perpetually hover just below the horizon, but creating a solid business case has been challenging, especially for small or mid-size businesses without the budget for tailor made solutions.
In my second project, one year into my career as an ERP consultant, I was tasked to participate in a data migration project. One of our clients had acquired a competitor and had to migrate them from their current (soon-to-be legacy) system to the global M3 solution of the mother company. As the target solution was already defined, it was believed that all that had to be done was to work backwards from the data architecture of the new solution and find the corresponding data in the legacy system.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down