About the Course
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 CoveredExcel 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 attendPeople 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-requisitesParticipants 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 bringYou can bring your Laptops and Datacards for your real time practice."
Key TakeawaysGood 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.