Power BI is a powerful data visualization and reporting tool provided by Microsoft. It’s increasingly becoming a crowd favorite for it’s versatility and ease of access. While parts of the interface are intuitive, the best way to ensure your team hits the ground running and avoids roadblocks is by covering the tool’s functionality with an expert!

In this 16-hour course, we cover connecting to data, writing formulas, building visuals and customizing reports. Ready for your team to take their data communication to the next level? Book us for a private training!

  • Course Duration: 16-Hours

  • Private Training Cost: $12,000

  • Attendee Limit: 18 Students

Suggested TIMING

  • Day One, 8:30 am to 12:30 pm (Pacific Time)

  • Day Two, 8:30 am to 12:30 pm (Pacific Time)

  • Day Three, 8:30 am to 12:30 pm (Pacific Time)

  • Day Four, 8:30 am to 12:30 pm (Pacific Time)

WHAT WILL YOU GET?

In addition to two half-days of instruction, attendees will walk away with a 100+ page digital manual and data files to revisit the concepts on their own later, as well as access to class recordings for two weeks.

WHERE WILL THIS BE HOSTED?

This training will be hosted virtually.

Agenda

Topics we will explore include:

Day One

Introduction to Power BI

  • Review Example Reports

  • Desktop vs. Service

  • Interface and Vocabulary

Connecting to Data

  • Data Connection Interface

  • Load vs. Transform Data

  • Basic Data Transformations

Data Modeling Introduction

  • Adding Multiple Tables

  • Relating Multiple Tables

  • Customizing Relationships

Day Two

Basic Visuals

  • Text Tables

  • Cards

  • Bar Charts

  • Line Graphs

  • Pie Charts

  • Donut Charts

Formatting Visuals

  • Size

  • Colors

  • Labels

Writing Formulas

  • Add a Column

  • Create a Measure

  • Row vs. Filter Context

  • Aggregate Formulas

  • String Formulas

  • Logic Formulas

  • Date Formulas

Day Three

Power Query Basics

  • Power Query Interface

  • Filtering

  • Data Types

  • Group By

  • Add Columns

Advanced visuals

  • Line and Stacked Column Chart

  • 100% Stacked Bar Charts

  • Progress Toward a Goal

Geographic Maps

  • Geographic Fields

  • Map Types

  • Customizing a Map

Day Four

Filtering and Interactivity

  • Adding Slicers

  • Customizing Slicers

  • Interactivity Between Visuals

Formatting a report

  • Background Colors

  • Borders

  • Adding Images

Sharing

  • Publishing to Power BI Service

  • Sharing Reports

  • Automation

Requirements:

  • A Personal Computer

  • An External Monitor (strongly recommended)

  • Power BI Desktop Installed

Prerequisites:

Some data experience is ideal but not necessary. We recommend reviewing our Power BI Basics video for general familiarity with the product.

What You Will Get:

  • A 150+ page digital manual

  • Data files to revisit concepts

  • Access to class recordings for two weeks

Instructor:

Eric Parker is a widely-recognized Business Intelligence training expert who has delivered hundreds of sessions on Tableau, Alteryx and Power BI since 2014. He splits his time 50-50 between teaching and consulting on projects, bringing his real-world insights to the classroom. When not neck deep in data, he’s walking his dog, wrestling his boys or metal detecting a nearby beach!