Scribd
Upload
909 views

Power BI AI

This document introduces self-service AI features in Power BI Desktop including question and answer (Q&A), insights, what-if parameters, analytic lines, integration with cognitive services, Azure machine learning, R, and Python. It provides demos and documentation links for each feature, which allow users to enrich business intelligence with artificial intelligence capabilities like machine learning models and natural language queries without advanced coding.

Uploaded by

spiderweb
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
909 views

Power BI AI

This document introduces self-service AI features in Power BI Desktop including question and answer (Q&A), insights, what-if parameters, analytic lines, integration with cognitive services, Azure machine learning, R, and Python. It provides demos and documentation links for each feature, which allow users to enrich business intelligence with artificial intelligence capabilities like machine learning models and natural language queries without advanced coding.

Uploaded by

spiderweb
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 20

Self-Service AI with

Power BI Desktop
Enrich your Business Intelligence with Artificial Intelligence
Markus Ehrenmüller-Jensen
Artificial Intelligence (AI)
From automagical stuff to machine learning
algorithms
From GUI to scripts (DAX, M, R)
Agenda
Q&A
Quick Insights
What-if Parameter
Analytic Line
R Integration & Python Integration
Cognitive Services
Azure Machine Learning
Key Influencer Visual
Decision Tree Visual
Web by Example
Column by Example
DEMO
Questions & Answers (Q & A)
Ask a question using natural language
Refine via a related question
Provides answers from the data inside Power BI
Columns, Measures, Content, Filter, Visualisation
Synonyms
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-q-and-a-tips
Insights
Majority, Top/Bottom, Correlation, Low Variance,
Steady share with parent
Overall Trends, Seasonality, Change points, Time
series outliers
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-insight-types
What-if-parameter
Advanced analytics by running scenarios on your
data
Parameter changeable via a slicer
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Analytic Line
Analytics Pane for out-of-the-box lines
Constant, min, max, average, median, percentile
Forecasting
DAX or R
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
Cognitive Services
Enrich your data by using a pre-trained machine
learning model

https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi-key-phrases
https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/how-tos/text-analytics-how-to-install-containers
Azure Machine Learning
Enrich your data by using a self-trained machine
learning model

https://powerbi.microsoft.com/en-us/blog/power-bi-azure-ml/
R Integration
Source
https://docs.microsoft.com/en-us/power-bi/desktop-r-scripts
Transformation
https://docs.microsoft.com/en-us/power-bi/desktop-r-scripts
Visual
https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

https://docs.microsoft.com/en-us/power-bi/service-r-packages-support
Python Integration
Source
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts

Transformation
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts

Visual
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals

https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/
Key Influencer Visual
You bring one dimension and multiple metrics,
Power BI will detect metric values are typical for
the each dimension value
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
Decomposition Tree Visual
You bring one metric and multiple dimensions,
Power BI will detect which metric has high or low
values on each dimension
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree
Web by Example
Extract data from web page,
even when there is no tidy table
https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example
Column by Example
Create new column, without typing any formula
https://docs.microsoft.com/en-us/power-bi/desktop-add-column-from-example
Where are the instructions?
New platform for all technical
documentation
docs.microsoft.com

All content
open source, hosted on GitHub, community-enabled & in your
own language

Help the community of users


worldwide
https://aka.ms/intldocs & https://aka.ms/msossloc
Questions?
Markus Ehrenmüller-Jensen
Founder & BI Architect
[email protected]
@MEhrenmueller
/markus-ehrenmueller
www.savorydata.com

SQL Server 2005 - 2019


BI Developer
Database Developer
Database Admin

You might also like