Data analytics using AI with Excel and Power BI 2020 - no programming required
Learn powerful AI - artificial intelligence - features built into Excel (Office 365 Pro Plus) and Power BI Desktop - which is free to use.
Use Ideas to find new insights from the same old data you have been using for years. Just ask questions and get not just answers but readymade Pivot tables as well.
Use Power BI as your assistant - ask - why did revenue decrease? Tell me the reason. AI can be very simple to use - without knowing any programming at all. The only skill you need is to know is the mouse click!
Content
00:00 Introduction 00:00
01:15 Office Dark Mode
02:08 Flash Fill
06:32 Data Cleanup with Power Query
16:32 Excel tables
19:22 Clean data rules
25:22 Unpivot data
32:32 Folder consolidation
39:00 PDF import
45:05 Data Shaping
57:05 AI in Excel - Mobile Photo To Data
59:22 AI in Excel - Ideas
01:01:02 What is analytics
01:08:32 AI - Quick Insights in Power BI
01:13:22 AI - Q&A in Power BI
01:18:32 AI - Explain the decrease in Power BI
01:20:52 AI - Smart Narratives
01:26:00 AI - Decomposition Tree
Dr Nitin Paranjape
Microsoft MVP
Most Valuable Professional
Also Check out https://efficiency365.com
