Get Ready For PL 300 Power BI Exam|Implicit and explicit|Semi-additive|quick Measures #Day-12
Channel: BnfAnalytics
Date: 2023-08-15

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/PowerBI_PL300

00:00 Introduction
08:20 Implicit and explicit measures
19:06 Statistical Functions
22:12 Semi- additive Measures
36:15 Quick Measures
44:52 Calculated Tables


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:
https://www.youtube.com/channel/UCNEQglw2eH-oloJAdxaMeHw/join

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