Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit 5: Power BI - Coggle Diagram
Unit 5: Power BI
-
Glossary
- Calculation engine for Power BI.
- Models complex data, sets up relationships.
- Uses DAX language for calculations.
- Works in Excel or Power BI.
- Data Analysis eXpressions.
-
- Example: =SUM(Table1[Salary]).
- Used for Power Pivot calculations.
- Power Query's data processing language.
-
- Writes instructions for data operations.
- Technical language for transformations.
- Links tables based on a column.
- One-to-many or many-to-many.
-
- Uses columns with the same meaning.
- Displayed in visuals/tables/cards.
- Three types: Implicit, Explicit, Quick.
- Implicit measures auto-generated.
- Created with DAX or quick measure.
- Tables, relationships, measures.
- Centralized data structure.
- Called a cube or tabular model.
-
- Restrict data in reports or visuals.
- Filter levels: Slicers, Visual, Page, Report.
- Slicers interact with visuals.
- Other filters in the "Filter Pane."
-
-