Columbus A/S

10/12/2021 | News release | Distributed by Public on 10/12/2021 01:24

AI and Power BI provide completely new opportunities for business development

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.