How Duolingo Plans to Reach 100M Users

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

LinkedIn Learning

Advanced Microsoft Power BI

via LinkedIn Learning

Write review
Coursera Ad

Google AI Professional Certificate - Learn AI Skills That Get You Hired

Learn More → Corporate Finance Institute Ad

Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn advanced uses of Microsoft Power BI. Learn how to perform calculations, effectively leverage the DAX language in data modeling, make advanced queries, and more.

Syllabus

Introduction
  • Explore advanced features of Power BI
  • What you should know
  • Exercise files
1. Working with Power BI
  • Introducing the course project
  • Power Query and M language
  • DAX language
  • Efficient data strategies
2. DAX Language
  • DAX tables and GENERATESERIES
  • DAX columns
  • DAX measures
  • DATE, YEAR, MONTH, and DAY date DAX functions
  • CALENDAR and CALENDARAUTO DAX functions
  • DAX measure evaluation context
  • CALCULATE DAX function
  • DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions
  • Challenge: Crop modeling
  • Solution: Crop modeling
3. DAX Formulas
  • ALL DAX function
  • POWER DAX function
  • DIVIDE DAX function
  • Variables in DAX formulas
  • Iterator DAX functions and SUMX
  • FILTER DAX function
  • Challenge: Rate of change by commodity
  • Solution: Rate of change by commodity
4. Advanced DAX Calculations
  • SELECTEDVALUE DAX function
  • IF DAX function for conditional formulas
  • EOMONTH DAX function
  • DATEDIFF DAX function
  • BLANK and ISBLANK DAX functions
  • Filtering between tables
  • DAX acrobatics
  • GENERATE and ROW DAX functions with calculated dates tables
  • DATESBETWEEN DAX function
  • DATEADD DAX function
  • MTD, QTD, and YTD date DAX functions
  • DAX quick measures
  • Power BI summarized view
  • Challenge: DAX time intelligence modeling
  • Solution: DAX time intelligence modeling
Continuing Your Power BI Learning Journey
  • Next steps and additional resources

Taught by

Helen Wall

Reviews

4.5 rating at LinkedIn Learning based on 1612 ratings

Start your review of Advanced Microsoft Power BI

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.