Excel Structure and Analyze large data with Power BI
Topics covered:
Intro (0:00)
Purpose of data analysis (2:30)
Data Analysis process (4:06)
Good data vs Bad data (5:34)
Rules for Good data (9:05)
Common Examples of badly formatted data (10:41)
How to handle cross-tab data with Power Query (14:44)
Gather data from the web with (18:57)
Power Query's Data Catalogue Search (20:00)
Split Column by Delimiter (20:05)
Refresh live data in Power Query (23:20)
Summarize Data in Pivot Tables (24:26)
Do Calculation right inside Pivot Tables with Calculated Fields (27:33)
Avoid Wrong calculations with Get Pivot Data (29:10)
Data Visualization with Conditional Formatting & Quick Analysis (31:12)
Limitations of Pivot Table (34:38)
Why use Power Pivot (35:19)
Analyze 43 million rows of data within Power Pivot (36:40)
Build interactive dashboards with Power View (41:42)
Share Power View reports on Sharepoint (47:15)
Manage viewing rights with Excel's Browser View option
Create 3D map reports in Power Map (49:38)
Power BI Preview (55:20)
Summary: Which tool to use in which scenario? (59:03)
Notes to Developers (59:17)
This is a recording of the Data Analytics Webinar for Microsoft, powered by Economic Times. The webinar was conducted by Dr. Nitin Paranjape, Office MVP and Microsoft Regional Director.