Power BI – Introduction

In this hands-on workshop, you learn how to develop design principles and work them into data visualization as a practice. Work with simple, structured data files (e.g., Excel .xlsx or .csv) to become proficient at connecting to, cleaning up, creating variables from, and applying DAX functions to transform boring tables into beautiful interactive reports. Rehearse ways to connect different data sources to each other as well as visuals all within the Power BI canvas. No prior knowledge of Microsoft Power BI is required. You are encouraged to bring your own data to work with in the course.

This course can be applied to the Data Analysis Certificate.

Instructor

Brendon  Dorn , MS

Brendon Dorn , MS

Brendon Dorn performs research, simulation and analysis of various energy and functional strategies at HGA to identify and quantify their impact on the overall project. Dorn’s efforts are used to provide successful, cost-effective and energy-efficient outcomes to assist in savings and ... read more

Benefits and Learning Outcomes

  • Understand data sources used with Power BI
  • Connect to, clean up and use data sources effectively
  • Become proficient at transforming tables into interactive reports
  • Create data visualizations that deliver a clear message

Course Outline/Topics

This course is delivered on two consecutive Mondays to allow time to absorb the material presented and practice skills as possible.

Cumulatively, the course covers:

  1. The grammar of graphics (a framework)
  2. Download, orienting to Power BI workspace and connecting to data
  3. Data cleaning, transformation, relational connections with other data and creating new variables in Query Editor
  4. Creating graphs, formatting filtering relationships and editing
  5. Intro to DAX: Calculating columns and measures
  6. Power BI native analytics functions – forecast, percentiles and what-if scenarios

All sessions are Face-to-Face unless otherwise noted.

Date: 2 Mon, Nov 11-18

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Brendon Dorn MS

Fee: $845

CEUs: 1.4, CEUs:

Enrollment Limit: 20

Program Number: 5027-12263

Registration Deadline: Mon., Nov. 11

Register Now

Date: 2 Mon, Mar 23-30, 2020

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Brendon Dorn MS

Fee: $845

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5027-12266

Registration Deadline: Mon., Mar. 23, 2020

Register Now

Share