Overview


This course or Guided Project is your ultimate guide to mastering the Advanced and Modern analytical capabilities in Microsoft Excel.

This course covers how to connect and shape Data with Power Query, Data Modeling with PowerPivot and DAX and Dashboard design with PivotCharts and Slicers.

As a bonus, this course also shows you how to utilize a Data Model built in Microsoft Excel to design an interactive Dashboard in Microsoft Power BI.


What you'll learn through this guided project:

  • How to connect and transform data in Power Query
  • How to model data and perform advanced calculations using DAX
  • How to analyze data using PivotTables and slicers
  • How to visualize data and build an interactive dashboard using Pivot charts and slicers
  • How to use Excel Data Models with Microsoft Power BI
  • How to build an interactive dashboard in Microsoft Power BI


Why you should enroll in this course

  • Step by step instruction
  • 4+ HD Hours of video
  • Lifetime Access
  • Downloadable videos and Sample files
  • Option to ask questions for clarification

Upskill for 50% less!




What we are going to build together in this course

 

Course Content


  Introduction to the course
Available in days
days after you enroll
  Data Cleaning and Cleaning w/ Power Query
Available in days
days after you enroll
  Data Modeling w/ PowerPivot and DAX
Available in days
days after you enroll
  Data Analysis with PivotTables
Available in days
days after you enroll
  Dashboard Design
Available in days
days after you enroll
  Excel and Power BI Together
Available in days
days after you enroll

Access your course here. Works only after payment


$60

Access the course