Power BI Cheat Sheet

Key Definitions

• Power BI: Business analytics service by Microsoft for visualizing data.

• Dataset: A collection of data that Power BI uses to create reports.

• Report: A collection of visualizations based on a dataset.

• Dashboard: A single-page view that combines multiple reports and visualizations.

Important Concepts

Data Sources

• Connects to various sources: SQL, Excel, Web, etc.

• Supports both cloud and on-premises data.

Visualizations

• Different types: Bar charts, Line graphs, Pie charts, etc.

• Use slicers for filtering data dynamically.

DAX (Data Analysis Expressions)

• Formula language for calculations in Power BI.

• Enables creating calculated columns and measures.

Key Formulas

• SUM: Adds up all values in a column.

• AVERAGE: Calculates the mean of a column.

Common Mistakes to Avoid

Common Mistake: Forgetting to refresh datasets after updates.

Memory Tricks

Tip: "DAX" — Data Analysis Expressions

Key Diagrams

+-------------------+
|     Dashboard     |
|                   |
|  +-------------+  |
|  |   Report 1  |  |
|  +-------------+  |
|  +-------------+  |
|  |   Report 2  |  |
|  +-------------+  |
+-------------------+