Power BI

Terminology

• Power BI Desktop
  • Power Query Editor
    • Data Preparation & Transformation
  • Data Model
    • Data Analysis & Expressions
    • Relationships
    • Reports
• Power BI Pro
  • Workspaces
  • Gateways
  • Apps
• Power BI Mobile

Power BI Desktop Workflow

• Data Preparation

  • Query Editor

    • Applied Steps

  • Clean & Transform

  • ETL (Extract & Transform & Load)

• Data Analysis

  • Data & Model View

  • Inspect & Explore & Understand Data

  • View + Edit Relationship between Tables

• Data Visualization

  • Report View

  • Create Reports with Multiple Visuals

Power BI Desktop Interface

View	Sub View	Description
Report
	Canvas
	Filters
	Visualizations
	Fields
Data
	Ribbon	Table Tools & Column Tools
	Table
	Data
Model
	Properties
	Fields

VS Excel

	Excel	Power BI
Size	Quick Calculations	Big Data
Visual	Reports in Tabular Format	Interactive Visualization
Collaborate	Single Tool Only	Collaboration