Advanced Microsoft Power BI
Offered By: LinkedIn Learning
Course Description
Overview
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
- Introducing the course project
- Power Query and M language
- DAX language
- Efficient data strategies
- 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
- 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
- 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
- Next steps and additional resources
Taught by
Helen Wall
Related Courses
Практики работы с данными средствами Power Query и Power PivotSaint Petersburg State University via Coursera Практики анализа экономических данных от простого к сложному
Saint Petersburg State University via Coursera Introduction to Power BI
DataCamp Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Excel Básico Avançado 5 Cursos - Formação Especialista
Udemy