# Power BI Course Online

100% online with software and live support

Canonical URL: <https://vdci.edu/courses/power-bi-course-online>

## Overview

Power BI is a leading analytics platform built to simplify the path from raw data to meaningful insights. It enables you to design interactive data visualizations such as charts, graphs, maps, and dashboards that are both visually compelling and analytically useful. With extensive control over appearance and interactivity, Power BI turns complex datasets into clear, dynamic reports that support better decision-making.

In this hands-on course, you will learn how to bring data into Power BI from multiple sources, including Excel, Text and CSV files, and SQL databases using Power Query. You will organize, clean, and filter data, apply aggregation functions like SUM, COUNT, and MIN and MAX, and create visuals that surface important trends and insights. The course also introduces Power BI’s DAX language, allowing you to perform advanced calculations and build customized data models for deeper analysis.

## What you'll learn

- Import and prepare data from sources such as Excel, CSV files, and online databases using Power Query
- Build interactive visuals, including charts, maps, cards, and slicers, to uncover trends and patterns
- Apply DAX Data Analysis Expressions to create measures, calculated columns, and custom summaries
- Create polished reports by adding titles, logos, and formatting for a professional presentation
- Manage relationships between tables to enable dynamic and responsive reporting
- Share and collaborate on reports through the Power BI Service with options for exporting, commenting, and app connections
- Create dashboards and understand how dashboards differ from reports when presenting to stakeholders
- Schedule data refreshes and manage reusable datasets to keep reports current and scalable

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

## Instructors

### Garfield Stinvil — Instructor

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

### Colin Jaffe — Instructor

Colin Jaffe is a programmer, writer, and teacher with a passion for creative code, customizable computing environments, and simple puns. He loves teaching code, from the fundamentals of algorithmic thinking to the business logic and user flow of application building—he particularly enjoys teaching JavaScript, Python, API design, and front-end frameworks.

Colin has taught code to a diverse group of students since learning to code himself, including young men of color at All-Star Code, elementary school kids at The Coding Space, and marginalized groups at Pursuit.

Colin lives in Brooklyn with his wife, two kids, and many intricate board games.

### Brian McClain — Instructor

Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp, where he is now a lead instructor and course developer for both JavaScript and Python. He teaches Web Development, JavaScript, Python for Data Science, Machine Learning, and AI. He taught Python Data Science and Machine Learning as an Adjunct Professor of Computer Science at Westchester County College.

Brian is also an active industry professional in the field of generative AI app development. His website and iOS app, Artmink, provide appraisals of art and antiques from user-uploaded images.

## Pricing

**Tuition:** $799