Thread by @DAAXRasheed

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

👇🏽

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…

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…

3. Visualise + Analyse Data

* Type, number, position, size, interaction + hierarchy of Visuals
* Formatting + Custom Visuals (pbiviz)
* Slicers + Filters
* Report Page + Theme
* Analyse Excel in PBI service only for Import mode
* Paginated Report
* Report-Dashboard-Tile-Mobile

* Pin Q & A in PBI Service
* Bookmarks, Tooltip
* Edit interrection
* Navigate Report
* Group Visuals
* Export data to Excel, PPT or PDF
- Analyse feature on visual for Import mode
- Outliers, Group + Bin data
- AI Visuals
- Forecasting + Reference line

learn.microsoft.com/en-us/shows/ex…

4. Deploy & Maintain Assets

* Gateway for on-premises data
* Schedule + incremental Refesh
* RLS
* Roles; Admin, member, contributor, viewers
* Creat App
* Sensitivity labels + Access to Data
- Data Alerts + subscriptions
- Promote or Certify dataset

learn.microsoft.com/en-us/shows/ex…