Top Visualisation Tools in Power BI:
1. Stacked Bar Chart — Compare categories
2. Line Chart — Show trends over time
3. Pie Chart — Show proportions
4. Filled Map — Geographic data
5. Scatter Plot — Correlation analysis
6. Matrix — Tabular data with subtotals
7. Slicer — Interactive filtering
8. Card — Single value (KPI)
9. Gauge — Progress toward a goal
10. Treemap — Hierarchical data

Pro Tip: Use the right visual for your data type. Avoid over-complicating dashboards.

Popular Custom Visuals (AppSource):
1. Word Cloud — Text analysis
2. Radar Chart — Multi-variable comparison
3. Chord Diagram — Relationships and flow
4. Sankey Diagram — Flow and process
5. Animated Bar Chart — Time-series animation
6. Calendar Visual — Date-based data
7. Histogram — Distribution analysis
8. Sunburst — Hierarchical data (like a pie)
9. Network Graph — Connections and networks
10. Gantt Chart — Project timelines

How to Add: Go to Visualisations pane → Get more visuals → Search and add.

Common Power Query (M) Transformations:
1. Remove Columns — Select and remove unnecessary columns
2. Filter Rows — Keep or remove rows based on criteria
3. Change Data Type — Convert text to number, date, etc.
4. Merge Tables — Combine tables based on a key
5. Append Tables — Stack tables vertically
6. Pivot / Unpivot — Reshape data
7. Add Custom Column — Create new columns with M formulas
8. Group By — Summarise data (count, sum, average)

Power Query Editor: Home → Transform → Manage Data Source Settings

Essential DAX Formulas:
1. CALCULATE — Modify filter context
   Total Sales = CALCULATE(SUM(Sales[Amount]), Sales[Year] = 2026)

2. SUMX — Iterate over rows
   Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Price])

3. FILTER — Return a filtered table
   Top Products = FILTER(Products, Products[Sales] > 10000)

4. RELATED — Get value from related table
   Product Category = RELATED(Products[Category])

5. TIME INTELLIGENCE:
   Year-to-Date Sales = TOTALYTD(SUM(Sales[Amount]), Sales[Date])

6. DIVIDE — Safe division
   Profit Margin = DIVIDE(SUM(Sales[Profit]), SUM(Sales[Revenue]), 0)

7. COUNTROWS — Count rows in a table
   Order Count = COUNTROWS(Orders)

Power BI Q&A (Natural Language) Examples:
1. "Show sales by region for 2026"
2. "What is the total profit by product category?"
3. "Which month had the highest revenue?"
4. "Trend of sales over the last 12 months"
5. "Compare sales vs target by salesperson"

How to Enable: Double-click on the report canvas to open Q&A box.
Tip: Use synonyms and data labels for better results.

AI Visuals in Power BI:
1. Key Influencers Visual
   - Identifies factors that impact a metric
   - Example: "What influences customer churn?"

2. Decomposition Tree
   - Visual breakdown of a metric by dimensions
   - Example: "Show revenue by product, region, and quarter"

3. Clustering (in R/Python visuals)
   - Group similar data points
   - Example: "Segment customers based on purchasing behaviour"

4. Forecast
   - Predict future values using time series
   - Example: "Forecast sales for the next 3 months"

5. Anomaly Detection
   - Identify outliers in data
   - Example: "Detect unusual order patterns"

Power BI Pro Features:
✅ Share dashboards and reports
✅ Collaborate in workspaces
✅ Create and publish apps
✅ Schedule data refreshes
✅ Row-level security (RLS)
✅ Audit logs and activity monitoring
✅ Embed reports in apps and websites
✅ Integration with Microsoft Teams
✅ Mobile access

Pro Tip: Power BI Pro is included with Microsoft 365 E5. Check your licensing.

Security and Sharing Tools:
1. Row-Level Security (RLS)
   - Restrict data access by user role
   - Example: "Sales reps can only see their regions"

2. Workspaces
   - Collaborative environments for teams
   - Share reports and datasets

3. Data Sensitivity Labels
   - Classify data (e.g., confidential, public)
   - Enforce data governance

4. Endorsement
   - Mark reports as "certified" or "promoted"
   - Improve discoverability

5. Sharing Permissions
   - Control who can view, edit, or share
   - Use links for external sharing