Excel 2013 Data Analytics Webinar: How to Structure and Analyze large data with Power BI tools

In this 1 hour Webinar, Dr. Nitin Paranjape (Office MVP) will show you how to structure and analyze large amount of data in just a few seconds using Excel 2013's Power BI features: Pivot Table, Power Pivot, Power Query and Power View.

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.

[jafukk]

No words to tell. It is more than excellent. It is very usefull presentation to the people who know excel very well and want utelise this knowledge for further development and improvement

[pavan]

Very impressive information on excel capabilities. Your articulate content can give many people new ways to think and apply these "POWERS" into their lives, personal or professional. Looking forward to your further content. Thank you.

[ariesmigu]

Please do a webinar with the new Power Bi Desktop App in Windows 10. I also want to know how to import powerpivot file to the Power BI. Thanks!