Visit uwm.edu/sce/coronavirus for information about spring 2021.

Share

Power BI – Introduction

Power BI transforms your organization’s data into rich visuals for you to collect and organize so you can focus on what matters to you. In this course, you learn how to connect to data, then clean and transform it. You also create a data model and report on KPIs. Lastly, you produce visualizations on the data and publish them to share. The course includes an introduction to DAX language and best practices.

This hands-on course provides the opportunity to learn and practice using Power BI following guided examples. No previous knowledge of Power BI is required.

This course can be applied to the Data Analysis Certificate.

Instructor

Steven Campbell, MS

Steve Campbell is a data and AI consultant focusing on the power platform technologies, especially Power BI. Coming from the business world, Steve holds a bachelor’s degree in marketing with a master’s in finance from UWM. He is a regular ... read more

Who Should Attend

Data analysts and others charged with presenting data to others and identifying key insights.

Benefits and Learning Outcomes

Participants in this class are introduced to the following concepts and given the opportunity to practice using them.

  • Power Query Window
  • Basic data transformations
  • Import Excel data
  • Connect to other data sources
  • Star schema
  • Dimension/fact tables
  • Managing relationships
  • Creating visualizations
  • Visualization interactivity
  • Correct use of different visualizations
  • Adding a layout
  • Making a bookmark
  • Adding navigation buttons
  • Adding custom tooltips
  • DAX Measures
  • Sharing a report
  • Best practices and optimization

Course Outline/Topics

The course teaches all skills needed to build a rich report and covers the following:

Extract, transform and load data

  • Learn how to combine data sources, perform complex transformations, then load to the model
  • Understand the Power Query window

Model data and create Key Performance Indicators (KPIs)

  • Model data best practices and create relationships between tables
  • Learn an intro to the DAX language
  • Make DAX measures and columns for KPIs
  • Measure time intelligence
  • Use best practices for data optimization

Visualize the data

  • Learn how to create rich visualizations
  • Add a layout to make stunning reports
  • Use advanced features such as tooltips and bookmarks for advanced analysis
  • Use the correct graph and best practices for visual layout design

Share the reports

  • Deploy your reports to share with the correct people in your organization
  • Use best practices for sharing and maintaining reports

Prerequisites

Data Foundations

Date: Mondays, Dec 7 and 14

Delivery Method: Live Online

Time: 8:30am-4pm CT

Platform: Zoom

Instructor: Steven Campbell MS

Fee: $895

CEUs: 1.4

Enrollment Limit: 12

Program Number: 5020-13008

Note: Participants will receive instructions and course links approximately one week prior to first class.

Registration Deadline: Dec 1

Register Now

Date: Mon, Mar 29 and Apr 5

Delivery Method: Live Online

Time: 8:30am-4pm CT

Platform: Zoom

Instructor: Steven Campbell MS

Fee:

$845 by Mar 15, 2021
$895 after Mar 15, 2021

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5020-13042

Note: Participants will receive instructions and course links approximately one week prior to first class.

Registration Deadline: Mar 23, 2021

Register Now

Share