Discover Classes. Earn 10% Rewards.

Power BI Bootcamp

Learn to analyze and visualize data with Power BI, a versatile tool that bridges the capabilities of Excel, Access, SQL, and more. This comprehensive training teaches you to build compelling dashboards and clear data visualizations, helping you make smarter, faster decisions backed by real insight. A strong addition to any data-focused professional's skill set.

  • Advanced
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 185 Madison Ave, New York, NY & Virtually Online
  • 14 hours over 2 sessions

Express Checkout – $799


Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (12) $799/person

Show all 2 sessions
  • Wed, Nov 04 at 10:00am - 5:00pm
  • Thu, Nov 05 at 10:00am - 5:00pm
20 left
Book
Show all 2 sessions
  • Tue, Dec 15 at 10:00am - 5:00pm
  • Wed, Dec 16 at 10:00am - 5:00pm
20 left
Book
Show all 2 sessions
  • Wed, Jan 20 at 10:00am - 5:00pm
  • Thu, Jan 21 at 10:00am - 5:00pm
20 left
Book
Show all 2 sessions
  • Tue, Feb 23 at 10:00am - 5:00pm
  • Wed, Feb 24 at 10:00am - 5:00pm
20 left
Book
Show all 2 sessions
  • Tue, Mar 30 at 10:00am - 5:00pm
  • Wed, Mar 31 at 10:00am - 5:00pm
20 left
Book
Showing 1 – 5 of 12

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

Many assume Power BI is exclusively for advanced developers and IT professionals. In reality, countless individuals without programming experience or data analysis backgrounds successfully learn and master Power BI. Power BI was developed by integrating the strongest features from Microsoft Excel, Access, SQL, and complementary technologies, addressing gaps that existed across these separate platforms and streamlining the journey from raw data to actionable insights.

This comprehensive training transitions from your existing knowledge of these technologies, demonstrating how Power BI addresses the same business problems more effectively. To illustrate Power BI's capabilities, you'll learn to utilize Power Query for data retrieval, leverage Power BI's data model to integrate multiple datasets, and apply Power BI's report view to develop compelling dashboards and interactive data visualizations. Through hands-on case studies integrating multiple features simultaneously, you'll discover how to quickly generate measures to calculate SUM, COUNT, MAX, and additional aggregations with simple clicks. You'll also work with Power BI's sophisticated filtering capabilities and explore Power BI's DAX language for powering your data visualizations and analysis.

For additional learning resources, explore the Power BI Bootcamp at NYIM Training.

Syllabus

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

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (750)

(4.5-star rating across 750 reviews)

This class: 5.0 out of 5 from 1 review

  • Power BI Bootcamp

See reviews for other classes at NYIM Training
loading...
Hide Reviews

Similar Classes

NYIM Training

NYIM is a highly regarded training provider that offers courses teaching computer software programs to business professionals. With a practical and hands-on approach, they have earned a reputation for their real-world application-focused instruction.

View school profile
NYIM Training
Vetted by CourseHorse

A verified Brooklyn educator.

Loading...