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
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 Mon, Oct 23 & 30
Delivery Method: Live Online
Time: 8:30am-4:30pm CT
Platform: Zoom
Instructor: Michael Carlo MBA
Fee:
$845 by Oct 9, 2023
$895 after Oct 9, 2023
CEUs: 1.4
Enrollment Limit: 20
Program Number: 5020-15424
Note: Participants will receive instructions and course links prior to the first day of class.
Registration Deadline: Oct 23, 2023
Date: 2 Mon, Mar 4 & 11
Delivery Method: Live Online
Time: 8:30am-4:30pm CT
Platform: Zoom
Instructor: Michael Carlo MBA
Fee:
$845 by Feb 19, 2024
$895 after Feb 19, 2024
CEUs: 1.4
Enrollment Limit: 20
Program Number: 5020-15430
Note: Participants will receive instructions and course links prior to the first day of class.
Registration Deadline: Mar 4, 2024
