Discover Classes. Earn 10% Rewards.

Power BI Bootcamp

Master the art of creating dynamic data visualizations and compelling dashboards with Power BI. Connect multiple data sources, use Power Query, and unlock the full potential of Power BI's time intelligence reports. Elevate your business reporting skills with this comprehensive training.

  • All levels
  • 18 and older
  • $599
  • Earn 5,990 reward points
  • Price Lock Guarantee
  • 185 Madison Ave, New York, NY & Virtually Online
  • 14 hours over 2 sessions

Start Dates (4)

  • $599
  • 14 hours over 2 sessions
20 seats left
Book
Show all 2 sessions
  • Wed, May 08 at 10:00am - 5:00pm
  • Thu, May 09 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Mon, Jun 17 at 10:00am - 5:00pm
  • Tue, Jun 18 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Wed, Aug 21 at 10:00am - 5:00pm
  • Thu, Aug 22 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Tue, Nov 05 at 10:00am - 5:00pm
  • Wed, Nov 06 at 10:00am - 5:00pm
Showing 14 of 4

Class Description

Description

What you'll learn in this power bi class:

Create dynamic data visualizations for business reports with Power BI. Learn how to connect multiple data sources into a single relational model, use Power Query, and make detailed time intelligence reports.

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 at a Glance

  • 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

Course Syllabus

Level I

  • Introduction to Power BI
  • Data Extraction
  • Data Transformation
  • Relationships
  • Data Visualization & Analytics
  • Power BI Service

Level II

  • Data Transformation
  • Data Visualization & Analytics
  • Power BI Service

Learn more about Power BI Bootcamp at Noble Desktop.

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 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
  • Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
  • For cancellations and reschedules, please email us at [email protected]"

Reviews of Classes at Noble Desktop (373)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Noble Desktop

Noble Desktop is a renowned educational institution that specializes in providing comprehensive training in various creative and technology-related fields. Established in 1990 and headquartered in New York City, Noble Desktop has earned a stellar reputation for its high-quality courses and innovative...

Read more about Noble Desktop

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Noble Desktop

Noble Desktop

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Reviews of Noble Desktop at coursehorse.com

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a 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.

  • Price Lock Guarantee

    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!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...