Business Intelligence with Excel

About this course

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.