Learn Excel Power Query, Power Pivot, DAX & Power BI

Learn Microsoft’s popular and highly demanded business intelligence tools Power Query, Power Pivot, DAX & Power BI

This course will go a step further than the standard Excel course and teach tools which are even more advanced and powerful for the serious analyst.

What you’ll learn

  • Connect, shape and transform data from a wide range of sources using Power Query.
  • Create a data model based on the underlying data using using database methods in Power Pivot.
  • Create columns and measures using the DAX formula language for advanced analysis and insight.
  • Explore trends using Pivot Tables, charts, slicers, cube functions & dashboards in Excel.
  • Design an interactive dashboard using Power BI.
  • Learn Microsoft’s most important Business Intelligence tools in 1 course.

Course Content

  • Introduction –> 4 lectures • 3min.
  • Power Query: Connect to & Transform Data –> 15 lectures • 2hr 18min.
  • Power Pivot: Create A Data Model –> 14 lectures • 1hr 13min.
  • DAX: Analyse the Data Model Using DAX Formulas –> 25 lectures • 2hr 52min.
  • Power BI: Analyse Data with Interactive Visuals –> 22 lectures • 1hr 38min.
  • Conclusion & Further Resources –> 3 lectures • 9min.

Learn Excel Power Query, Power Pivot, DAX & Power BI

Requirements

  • A version of Excel compatible with Power Pivot (Microsoft 365, Standalone 2013/2016, Professional Plus 2013/2016, Professional/Home & Business 2019).
  • Intermediate Excel knowledge is assumed including Pivot Tables.
  • A PC (Use of these tools not available on a Mac Computer).

This course will go a step further than the standard Excel course and teach tools which are even more advanced and powerful for the serious analyst.

With this course you will learn all of Microsoft’s most important business intelligence tools Power Query, Power Pivot, DAX & Power BI all in a single course. The 8 hours of video content, quizzes, and assignments have been carefully designed to help you progress to a data analyzing wizard in the most logical way possible. The course comes with lifetime access, downloadable materials and 30 day money back guarantee

Throughout the course we will use many data sets as examples and will even conclude by creating a Data Model and Dashboard based on the Microsoft ‘Northwind’ sales data set

You could be 8 hours away from becoming an Excel expert!

Contents

  1. Power Query
  2. Power Pivot
  3. DAX
  4. Power BI