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

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

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)

Description

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

Who this course is for:

Intermediate users of Excel looking to take their data analysis skills to the next level
Both students with no experience and those with some experience of these tools will benefit from the course
Anyone looking to to develop their career in the data analysis field