Power BI and Power Query for Excel Users

About this course

I'm a professional analyst with 18 years' experience in BI in a corporate setting. This is exactly how I teach my new analysts.For each project, there is an Excel version, a Power Query version, and a Power BI version. This reinforces learning, and you will see how Microsoft has ingeniously linked the platforms, and the role each one plays.Some Courses Advertise Hundreds of Hours of Content...I keep it straight to the point. I will not be listing all the Excel functions, I will not be explaining every Power BI menu ribbon item...instead, we will jump straight into real projects, and I will guide you step-by-step through the analytics process.We will approach each project the same way:Define the business problem;Review and classify raw data and source systems;Load, transform, cleanse, and organize data into a data model;Build the visualizations and reportsWe will do an Excel version, a Power Query version, and a Power BI version.Once you do a handful of projects, you will notice patterns to the process.This is where things begin to "click". And that's more powerful than any course that simply walks you through what each function does and then has one Case Study at the end.My goal is to help you see those patterns today and think and work like an analyst.Follow along as we complete Real World projects.

Course objectives

• Help students identify patterns in data analysis processes
• Teach practical application of Power BI and Power Query through real projects