P O W E R B I    A R C H I T E C T U R E

VI S UALI Z AT I ON

B U S I N E S S   U S E R

Overview

• The value of offering
• Licensing and pricing
• positioning

Importing & Transforming DATA

• Importing data from various sources
• Connection types
• Query Editor
• Overview
• Understanding Query design & ETL Process
• Understanding Applied Steps
• Data Transformation
  1. Cleaning Data
  2. Merging Data Sets
  3. Appending Data Sets
  4. Transform
  5. Add Columns
  6. Conditional Columns
  7. Custom Columns

POWER BI DESKTOP

• Overview of Power BI Desktop
• Similarities to Excel Power Pivot
• Similarities to Excel Power Query
• Technical Options & Settings
• Monthly Update

Report       Functionality

• Drill-Downs
• Drill-Through
• Slice by Relative Dates
• Focus Mode - See Details
• Setting Visual Interactivity
• Exporting Data from Power BI Desktop
• Using Power BI Desktop Quick Insights

DATA  MODELLING

• Creating Relationships
• Bidirectional Relationships
• Custom sorting of columns
• Data Types & Formatting

Report Building