Discover and read the best of Twitter Threads about #Querry
Most recents (1)
Pass your PL-300 (Microsoft Power BI #Data Analyst) #Exam like a Pro with these #FREE Preparation tips from @Microsoft itself.
PS: PL-300 exam tests 4 domain knowldege of @MSPowerBI
which are explained thus
👇🏽
PS: PL-300 exam tests 4 domain knowldege of @MSPowerBI
which are explained thus
👇🏽
1. Prepare the Data
* Get data from different sources
Import, DirectQuery or Dual
* Cleaning data in Power #Querry: Pivot + unpivot, Appending + merging queries,naming queries best practice, DISTINCT vs UNIQUE #values ...
* Query #error type
learn.microsoft.com/en-us/shows/ex…
* Get data from different sources
Import, DirectQuery or Dual
* Cleaning data in Power #Querry: Pivot + unpivot, Appending + merging queries,naming queries best practice, DISTINCT vs UNIQUE #values ...
* Query #error type
learn.microsoft.com/en-us/shows/ex…
2. Model the Data (largest % of the exam)
• Customize Column + #table properties
• Hierarchy for drill through
• Data #Modeling: Star schema, cardinality, filter direction
* Date Table (best practice)
* Measures with DAX
* Performance Analyzer
learn.microsoft.com/en-us/shows/ex…
• Customize Column + #table properties
• Hierarchy for drill through
• Data #Modeling: Star schema, cardinality, filter direction
* Date Table (best practice)
* Measures with DAX
* Performance Analyzer
learn.microsoft.com/en-us/shows/ex…
