PowerPivot for Business Intelligence teaches you " How to import data from different sources, Analyze the same using PowerPivot, PowerQuery, PowerView and Report the same to SharePoint location.

Topics Covered

Excel Basics, Tables, Structural reference, Most popular formulas, Pivot tables, Introduction to PowerPivot, Importing the data from different sources, Building Data Models, Calculated fields, DAX formulas, Time Intelligence, Using Slicers, Building Dashboards and KPIs, Sharing and Reporting the Dashboards.

Who should attend

People who are into Data Analysis, MIS Reporting, Big Data Analysis, building Dashboards and who want to master PowerPivot and DAX formulas to manage their business.

Pre-requisites

Participants with ready knowledge in Excel's Pivot tables, Structural reference, Advanced formulas in Excel i.e. Sumifs, Countifs, Vlookups etc who want to go to the next level Business Intelligence reporting..

What you need to bring

You can bring your Laptops and Datacards for your real time practice."

Key Takeaways

Good familiarity with PowerPivot concepts, Building Data Models and creating Pivottables using PowerPivot, Using DAX formulas for calculated fields, Building Dashboards using PowerQuery, PowerPivot and PowerView.