Power BI – Introduction

DATES TO BE ANNOUNCED

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 following certificates:
Business Analysis Certificate
Data Analysis Certificate

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

Who Should Attend

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

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