Published 11/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 36 lectures (5h 36m) | Size: 3 GB
Understand Database Normalization and Relationships
Learn why you need a Rolling Calendar when you have date fields
Learn a multitude of functions in six DAX Category types
Install and create new stunning visuals with unique slicers
Prior to enrolling this course, you should have taken my Power BI Data Analysis course offered here on UDEMY, or another equivilent introductory course to Power BI.
Welcome to my intermediate level for Power BI users who want to delve deeper into the DAX functional language. After taking my Power BI Data Analysis Course (for bners) you now will be ready to take your skills to the next level and really get a grasp on the DAX language that is used in Power BI formulas.
In this course we will implement over 30 DAX functions from across nine different categories
Conditional & Logical Functions
Date & Functions
Math & Stats Functions
Table & Filter Functions
Infamous CALCUALTE Function
I will teach you how to problem solve your formulas and how to build them in pieces, so they are easier to understand and use that knowledge to have your measures call other measures. Not to mention learn to build a measures table to hold all the measure you will create for your report to keep them organized and all in one place.
You will also learn the need to have a rolling calendar and the benefits it provides for those people who have a multitude of tables with date fields and how the table will auto adjust its dates as new data is added.
All that combined with installing appealing new visuals from the marketplace and using stunning slicers to make your reports more interactive for your user. By the end of this course, you will have the confidence to build out your formulas to get the results you need and the visually appealing new visuals on your reports that show the results of your data analysis for the company!
Students who have a solid foundation from using Power BI
Advanced Power BI users with 2-3 years working with functions in general
Someone who wants to upgrade their Power BI Knowledge and take it to the next level