Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel and Power BI Advanced Data Analysis Course

ExcelIsFun via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course develops advanced data analysis skills across Excel, Power Query, Power Pivot, Power BI, DAX, and M Code. Practical examples cover PivotTable reports, dashboards, data shaping, and modeling problems such as date dimensions, multiple fact tables, and slowly changing dimensions.

Syllabus

DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!
DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!
DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.
DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)
DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class
DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.
DAME 07: How to Make Effective Dashboard. Three Examples in Power BI
MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations
MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size
MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table
MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!
MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports
MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas
MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable
MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not
MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot
MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions

Taught by

ExcelIsFun

Reviews

Start your review of Excel and Power BI Advanced Data Analysis Course

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.