14 March 2020 - DataCamp - Power BI & AI - Kingdom of possibilities

Transcript

1. Power BI & AI Kingdom of possibilities Aroh Shukla
2. About Aroh Technical Consultant, Microsoft MCT & Nintex vTE Experience: Office 365, SharePoint Online, Data Platform Office 365 & Power BI Trainer LinkedIn: https://www.linkedin.com/in/arohshukla/ Blog: aarohblah.blogspot.com Aroh Shukla (Microsoft MCT)
3. Agenda • Overview of AI in Power BI • End User Insights • AI Visuals • Overview of Key Influencers Visual • Overview of Decomposition Tree Visual • Demos: Dataflow, Key Influencers Visual, Decomposition Tree Visual • Q and A • (Slide Deck, Demo Samples and Blog will be shared after Event )
4. Investment areas of AI in Power BI Sentiment Analysis Key Phrase Extraction Create ML models Explore predictions Python Integration R Integration Extend with Azure ML Integrate into reports AI Visualizations Natural Language
5. Power BI is a business analytics service that delivers insights to enable fast, informed decisions with stunning visuals. Any data, any way, anywhere Whatis Power BI? 1. Power BI Desktop 2. Power BI Service 3. Power BI Mobile
6. Microsoft Power BI Desktop
7. What is Dataflow? Many definitions about Power BI Dataflow • Self-service data prep or Self-self ETL (Extract-Transform-Load) • Way that is reusable & repeatable for others • A collection of entities • Entities are similar to tables. • Definition • Dataflow is simply Power Query in the cloud. • Power Query process that runs in cloud independently from any Power BI reports. • Dataflows are used to ingest, transform, integrate, and enrich big data/AI • A lot of ML capabilities are built on top of Dataflow. (More computation power on cloud than Desktop)
8. What is Dataflow?
9. Power BI Pro vs Premium SQLSaturday#893 – Singapore
10. Key Influencers Visual When to use key influencers • Factors affect the metric being analysed. • Contrast the relative importance of these factors. How AI helps • Visual a couple of algorithm like ML.NET, One-hot encoding, Replace missing value etc.
11. Key Influencers Visual – Limitations Considerations • Direct Query is not supported • Azure Analysis Services and SSAS is not supported • Publish to Web is not supported • .NET FX 4.6 above or higher is required • Aggregates and measures are not supported.
12. Decomposition Tree Visual Visualize data • across multiple dimensions • automatically aggregates data • ad hoc exploration and conducting root cause analysis. Visual Inputs • Analyse – metric to analyse • Explain By: one or more dimensions you would like to drill down into. AI splits • High Value: highest value of the measure being analysed. • Low Value: lowest value of the measure being analysed.
13. Decomposition Tree Visual – Limitations The decomposition tree is not supported • On-premises Analysis Services AI splits are not supported • Azure Analysis Services • Direct Query • Power BI Report Server • Publish to Web • Complex measure
14. Please Evaluate the session: Power BI & AI : DataCamp2020– Singapore