Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 15 Minute(s)
Language
English
Taught by
Jarrod Hill
Rating
Course Overview
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.
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
Course Content
- 6 section(s)
- 83 lecture(s)
- Section 1 Introduction
- Section 2 Power Query: Connect to & Transform Data
- Section 3 Power Pivot: Create A Data Model
- Section 4 DAX: Analyse the Data Model Using DAX Formulas
- Section 5 Power BI: Analyse Data with Interactive Visuals
- Section 6 Conclusion & Further Resources
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
Skills covered in this course
Reviews
-
mmaha lakshmi
Even though i am using power query in my day to day work, now learning step by step in a correct way
-
KKelley Clark
I found the course easy to follow and understand. I feel like I have a solid foundational learning, which is what I wanted. My only challenge was some of the sections were a bit too much for me in one sitting, and it wasn't evident how to group them into logical smaller sections. I appreciate Jarrod (the instructor) making a few unintentional mistakes. It is like bonus material. First, it is a reminder that everyone makes mistakes which can be reassuring when learning new material. Second, it is helpful to see some troubleshooting (aka bonus material). Lastly, the FAQs included a reference to Jarrod's New Zealand accent. Thank you for "not doing anything about it." It added to my enjoyment of the class.
-
LLia Orfei
A good overview of the main tools to work with these MS applications.
-
RRandy Stewart
Audio was bad, video was bad, mistakes made by the trainer, connection to web site did not work, just overall not what I expected.
