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
- Power Query
- Power Pivot
- DAX
- Power BI
- 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
