Power BI Artificial Intelligence.md

Power BI Artificial Intelligence (AI)

---

It is crucial for data analysts to explore and visualize data to help their stakeholders gain effective insights quickly. Business demands have evolved from executives asking what, which and when something happened, to asking why it happened and what will occur in the future. AI is the answer and Power BI adopted AI for analysts and business decision-makers!

---

AI is Changing Power BI

AI Insights

• Use AI Insights in Power BI Desktop
• Use insights in Power BI Desktop to explain increases and decreases seen in visuals
• Automated Machine Learning in Power BI

Smart Narrative

• Smart Narrative

Key Influencers

• Key influencers visualization
  • With categorical values, Key Influencers uses ML.NET to run logistic regression for categorical metrics, using the One-hot encoding, Replace missing value, and Normalize mean variance data transformations and the L-BFGS Logistic Regression algorithm. While in numerical values, Key Influencers uses ML.NET to run linear regression, using the same data transformations as the categorical key influencers and using the SDCA regression algorithm. On the other hand, the Top Segments uses ML.NET to run a decision tree, using Fast tree algorithms (categorical and numerical), to find interesting subgroups. learn more

Q&A

• Introduction to Power BI Q&A visual
• Tips for asking questions in Power BI Q&A ⭐
• Top N analysis
  • Q&A visual e.g., "What are the top 5 customers by sales in clustered column?", Top N filter, TOPN DAX formula

Quick Insights

• Quick Insights and Scoped Insights

Decomposition Tree

• Use the decomposition tree visual in Power BI

Column from an Example

• Add a column from an example
• Get data from a Web page by providing an example

Anomaly Detection

• Anomaly detection
• Cognitive Services in Power BI - The services that are supported today are Sentiment Analysis, Key Phrase Extraction, Language Detection, and Image Tagging.

Clustering

• Clustering using Scatter Charts

Time Series

• Time Series
  • Forecasting with Line Chart
  • Scatter chart
  • Play Axis
• Grouping and Binning
• Advanced analytics custom visuals

Python

• Run Python scripts in Power BI Desktop
• Use Python in Query Editor

R

• Create Power BI visuals using R
• Use R in Power Query Editor

Articles and Videos

Articles

• Creating Machine Learning models in Power BI
• Types of insights supported by Power BI
• View data insights on dashboard tiles with Power BI

Videos

• AI in Power BI 📺 - AI can help everyone in an organization automatically find patterns in their data, understand what the data means, and predict future outcomes to help business drive results.
• Microsoft Power BI: AI powered analytics - Come learn how to use AI in Microsoft Power BI to solve your business problems.