Visit uwm.edu/sce/coronavirus for information about fall 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.

The course involves lecture, demonstration, hands-on practice and instructor coaching. No previous knowledge of Power BI is required.

This course can be applied to the Data Analysis Certificate.

Instructor

Michael  Carlo, MBA

Michael Carlo, MBA

Mike Carlo is an independent business owner at Carlo Consultants LLC working on Power BI and modern data warehouse implementations. He has been a  Microsoft MVP (certified Most Valuable Professional) since 2017, creator of PowerBI.tips, developer of multiple Power BI ... read more

Who Should Attend

Individuals charged with identifying data insights and sharing them with others.

Benefits and Learning Outcomes

  • Understand capabilities and uses of Power BI
  • Understand the four phases of handling data in Power BI: load, model, visualize and report
  • Apply understanding of the four phases to analyze real-world examples
  • Extract, Transform and Load sample data
  • Model sample data into tables with accurate relationships
  • Create visualizations from sample data
  • Explore options for sharing and reporting data visualizations

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, and 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

Testimonials

"Mike did a great job; very objective and supportive."  —  Raul Setien, Wells Vehicle Electronics LP, Mexico, May 2021

"Mike Carlo provided great instruction and insight to the usefulness and power in using Power BI. The tutorial PDFs were great tools to support and guide through the natural sticking points of learning a new program. I thoroughly enjoyed the classes and look forward to learning more about this program and how to incorporate it into work-related reports. Thank you!"  —  Russell Kruse, Wells Vehicle Electronics , May 2021

"Mike was great! I would take another class with him. Very knowledgeable about this subject, and a great personality."  —  Carlie Herbst, Wells Vehicle Electronics, May 2021

"Mike is very skilled at both Power BI and his presentation skills. Very easy to listen to and entertaining."  —  Mike Adams - Regional Sales Manager, Wells Vehicle Electronics, May 2021

"This course was great. Hands-on learning is necessary for this program. The instructor was awesome – so knowledgeable and approachable."  —  Course participant, April 2021

"Excellent instructor, expert in the field, open to questions, fixed issues that came up, kept the class upbeat and helped out the people who got lost."  —  Deb Newton, Wells Vehicle Electronics, February 2021

"Very interactive and practical. Excellent! Very good instructor – perfectly masters the subject, is very patient and explains well."  —  Arturo Marquez Absalon, Wells Vehicle Electronics, February 2021

Date: 2 Fri, Oct 1-8

Delivery Method: Live Online

Time: 8:30am-4:30pm CT

Platform: Zoom

Instructor: Michael Carlo MBA

Fee: $895

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5020-13895

Note: Participants will receive instructions and course links prior to the first day of class.

Registration Deadline: Oct 1

Register Now

Share

Join Our Email List

Get the latest on courses and certificates in your areas of interest.

Working...