Blog Post

Educator Developer Blog
3 MIN READ

Power BI AI Features for all Data Analysts

theoyinbooke's avatar
theoyinbooke
Icon for Microsoft rankMicrosoft
Jun 01, 2023

 

 

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

 

 

 

 

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.

 

 

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

 

 

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.

 

 

 

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.
 

 

 

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.
 

 

 

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.
 

 

 

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.
 

 

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
 

 

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.
 

 

 

Additional Resources

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

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

 

 

 

 

 

Updated Jun 01, 2023
Version 2.0
  • Derek_Meyer's avatar
    Derek_Meyer
    Copper Contributor

    Also worth a look? https://maxpowerbi.pro/when-ai-meets-bi-how-artificial-intelligence-may-change-power-bi-development/