This is an advanced data analysis course that takes you from an intermediate level to a super-user level through hands-on practice. You will go deep into data analytics in Excel and explore Microsoft's powerful Business Intelligence tools.
What you will learn
Business Intelligence fundamentals and how Excel works as a BI tool
Advanced Pivot Tables — formatting, drill down, calculations, sorting, filtering and Top 10 reports
Dashboard capabilities — slicers, multi-pivot dashboards and enterprise dashboards
PowerPivot — measures, relationships and consolidating multiple data sources
PowerQuery — connecting, transforming and loading data from a wide variety of sources
PowerView — interactive data visualization and reports
An introduction to PowerBI — Microsoft's complete Business Intelligence solution
Who should take this course
Data Analysts and Data Scientists who want to master BI in Excel
Professionals who want to build enterprise-grade dashboards and reports
Anyone who has working knowledge of vLookup and Pivot Tables and wants to go further
Prerequisites
Users are expected to have working knowledge of the vLookup function and Pivot Tables. The course gradually moves through PowerPivot, PowerQuery and PowerView, introduced by Microsoft, and gives you a solid foundation to step into PowerBI.