# Power BI Bootcamp

Canonical URL: <https://training-nyc.com/courses/power-bi-bootcamp>

## Overview

Many people think Power BI is for advanced developers. In truth, plenty of people without prior experience in programming or data analysis are able to learn and use Power Bi. Power BI was created by combining the best features from Microsoft Excel, Access, SQL, and other related technologies to fill in the capability gaps that exist across these technologies, streamlining the process from data to insights. 

In this training, we’ll transition from what you know about these technologies and show you how Power BI solves the same problems more efficiently. To give you an understanding of what Power BI can do, you’ll learn to use Power Query to query data, Power BI’s data model to connect datasets, and Power BI’s report view to create compelling dashboards and data visualizations. Using case studies that bring together multiple capabilities at once, you’ll learn how to easily create measures to find SUM, COUNT, MAX, and more with a click of a button. You'll also work with the different filter options and use Power BI’s DAX language to power your data visualizations.

## What you'll learn

- Connect multiple data sources into a relational data model
- Identify where and how Power BI can be best used in your organization to solve pressing data issues
- Create multiple reports in Power BI to tell a story of your company’s performance
- Create a measure on the fly to solve the vast majority of business problems
- Keep your measures organized so that you know what they do and how they work
- Quickly create time intelligence reports with things like year-over-year comparisons, saving you hours as compared to how you might do it in Excel

## Curriculum

### 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

### Level 2

#### Filters

- Adding Filters
- Adjusting Filter settings

#### Intro to DAX: Data Analysis Expressions

- SUM vs SUMX
- CONCATENATEX
- COUNT vs COUNTX

#### Quick Measures

- YTD (Year-to-Date)
- Year-over-year-change

#### Map Visuals

- Creating and Customizing a Map Visual

#### Drill Down & Drill Through

- How to use Drill Down
- How to use Drill Through
- How Drill Down differs from Drill Through

#### Getting Data from Online Spreadsheets

- Getting Data from a Google Sheet
- Getting Data from Excel File Stored in OneDrive

#### Refreshing Data

- How Datasets work in the Power BI Service
- Manually Refreshing or Scheduled Refresh

#### Reusable Power BI Datasets

- About Reusable Power BI Datasets
- Creating & Using Power BI Datasets

#### Dashboards

- Dashboards vs Reports
- Creating a Dashboard

## Schedule
- Jun 10, 2026 – Jun 11, 2026 — NYC
- Jul 20, 2026 – Jul 21, 2026 — NYC
- Aug 25, 2026 – Aug 26, 2026 — NYC
- Sep 28, 2026 – Sep 29, 2026 — NYC
- Nov 4, 2026 – Nov 5, 2026 — NYC
- Dec 15, 2026 – Dec 16, 2026 — NYC

## Pricing

**Tuition:** $799