Power BI AI Features for all Data Analysts
Published Jun 01 2023 12:00 AM 16.1K Views
Microsoft

 

10x.png

 

Gone are the days where all you are required to do as a Data Analyst is to create Reports and Dashboards for the business. We are now in the age of decision intelligence where you are required to directly support business decisions through the output from your Power BI Reports and Dashboards.

 

To meet this level of demand and expectations, you need to start leveraging the AI capabilities in Power BI. In case you are not aware, Power BI has so many AI Features that will 10x your productivity and greatly improve the quality of your work.

 

Let's Explore the AI Features together

 

 

 

theoyinbooke_0-1685614070801.png

 

Before we explore the AI Features covered in this blog, kindly take few seconds to fill this Survey. We also have a joke for you at the end of the Survey: Kindly take few seconds to fill this survey about Power BI DAX

 

 

Smart Data Discovery and Visualization in Power BI

Power BI is rich in AI features; Smart Data Discovery and Visualization is one of them. While some people have used these features before, many do not know that it is enabled and delivered through the power of Artificial Intelligence.

 

Smart Discovery enables Power BI to automatically discover and visualize your data. Let's have an example as can be illustrated below using a data in Power BI Service.

 

Smart Data Visualization.gif

 

This feature is also available in different forms within Microsoft Ecosystem. Let's look at the Data stored in SharePoint List below.

 

SDV SharePoint List.gif

 

Another way to see this in action is through Microsoft Teams. Let's look at Power BI Integration in Microsoft Teams and how the Smart Data Discovery and Visualization get the teams activity data analyzed and visualized.

 

SDV Teams.gif

 

 

Natural Language Query (NLQ) in Power BI

Natural Language Query in Power BI is magical. by directly typing your question, you can get quick answers and insights about your data. See how this feature is used via QnA in Power BI Service.
 
pbi QnA.gif

 

 

Anomaly Detection in Power BI

This feature can help quickly spot and detect any unusual or unexpected patterns/data points within your dataset. You can better detect and visualize Anomalies. This puts a lot of power in your hands.
 
anomalies.gif

 

 

Key Influencers in Power BI

A lot of Power BI Data Analysts are not familiar with this feature. Also, we have people that are aware of it but haven't used it before or not frequently.
If I were you, I would use this over and over again because it can help me understand a lot about business.
 
keyinfluencers.gif

 

 

Decomposition Tree in Power BI

Decomposition Tree Visual in Power BI is an artificial intelligence (AI) visualization. It can be leveraged for Ad Hoc exploration and conducting root cause analysis.
You can you it to find the next dimension to drill down into based on certain criteria.
 
decompositionTree.gif

 

Sentiment Analysis with AI in Power BI

Perform sentiment analysis on your dataset without writing codes. This can be helpful when analysis customer survey with their feedback
 
sentiment analysis.gif

 

Forecasting with AI in Power BI

Yes, you can also run forecasting with Power BI. In this example, we are forecasting for "Total Defect" items for the next couple of months. This predictive insight can help you prescribe measures to reduce the outcome.
 
forecast.gif

 

 

Additional Resources

Power BI DAX Suggestion Project - https://aka.ms/DAXPowerBISession 

Enable DAX Suggestion in Power BI : https://aka.ms/EnableDAXSuggestion 

 

 

 

 

 

Co-Authors
Version history
Last update:
‎Jun 01 2023 03:12 AM
Updated by: