Power BI Bootcamp

Level 1

Introduction to Power BI

• Why Use Power BI?
• Power BI Desktop
• Power BI Pro vs. Free
• Explanation of ETL process (Extract, Transform, Load)
• Data Types

Creating a Visualization

• Importing Data
• Choosing different types of data visualizations (column charts, bar charts, pie charts, donut charts, and more)
• Cleaning Up the Appearance: Axis Labels, Display Units, Title, and more
• Adding Data Labels
• Card Visuals

Publishing & Sharing

• Publishing Reports (to app.powerbi.com)
• Sharing Reports
• Collaborate on Reports with Comments
• Adding a Power BI report to PowerPoint
• Workspaces: What are they, publishing to the appropriate workspace, and creating/managing
• Exporting a PDF

Links to Data Source Files

• How Power BI Links to Data Files
• Managing Links to Data Source Files

Extracting & Transforming Data

• Extracting data from various sources: Text/CSV files, Excel worksheets, Multiple Files in a Folder, and more
• Transforming data using the Power Query Editor:
  ETL = Extract, Transform, Load
  ELT = Extract, Load, Transform

Data Transformations

• Use First Row as Headers
• Remove Empty rows (null data)
• Split Column By Delimiter
• Applied Steps
• Merge Queries
• Append Queries
• Fill Down
• Transpose
• Pivot
• Column profiling for data quality check
• Query Dependencies

Relationships

• Relationship importance
• Understanding types of relationship
• Creating relationships
• Cross filter relation: Single or Both

Building/Design a Report

• Adding a Title
• Adding a Logo
• Adding a Background (Solid Color or Photo)

Measures

• Create Measures
• Using Measures in a Data Visualization

Calculated Columns

• Using DAX to create a Calculated Column
• Navigating Related Tables using DAX

Slicers

• What Slicers Are
• Adding & Using a Slicer