Get Ready For PL 300 Power BI Exam |Module-2|Create model calculations by using DAX
Power BI Training from Basics to advance as per Exam PL:300 Microsoft Power BI associate certification.
#powerbi #bnfanalytics
Dataset link: https://github.com/BnfAnalytics/Power...
00:00 Module-2 Model the data
00:46 Introduction
07:01 Create Single aggregation measure( SUM,Average, Count, Min, Max)
07:37 Examples of single aggregation
24:16 CALCULATE to manipulate Filters
24:44 Examples of CALCULATE DAX functions
40:00 Using ALL function
45:50 Profit Margin with custom filters
53:30 Running total of sales
Domain 2: Model the data (25–30%)
2.1. Design and implement a data model
2.1.1. Configure table and column properties
2.1.2. Implement role-playing dimensions
2.1.3. Define a relationship's cardinality and cross-filter direction
2.1.4. Create a common date table
2.1.5. Implement row-level security roles
2.2. Create model calculations by using DAX
2.2.1. Create single aggregation measures
2.2.2. Use CALCULATE to manipulate filters
2.2.3. Implement time intelligence measures
2.2.4. Identify implicit measures and replace with explicit measures
2.2.5. Use basic statistical functions
2.2.6. Create semi-additive measures
2.2.7. Create a measure by using quick measures
2.2.8. Create calculated tables
2.3. Optimize model performance
2.3.1. Improve performance by identifying and removing unnecessary rows and columns
2.3.2. Identify poorly performing measures, relationships, and visuals by using Performance Analyzer
2.3.4. Improve performance by choosing optimal data types
2.3.5. Improve performance by summarizing data
Join this channel to get access to perks:
/ @bnfanalytics
At BnF Analytics we build a community that can support our society in terms of education.
Objective:
To provide free education to all either students or professionals.
Upgrade the skills to achieve goals of career.
Build a community of educationist for all age group learners.
To prepare students for targeted companies like Google, Microsoft, Amazon, Fortune 500 etc.
1. SQL
2. Python
3. Tableau
4. Power BI
5. R
6. Spreadsheets