Introduction to Power BI

Microsoft PowerBI is a business intelligence software rapidly gaining in popularity. Due to its comprehensive suite of data visualization and integration tools as well as its affordable pricing models, Gartner has ranked Microsoft PowerBI on par with Tableau.

The course is designed to be an introduction to Microsoft PowerBI and its use as a data analytics and reporting tool. There will be an even mix of lecturing and working sessions where the students will be developing their own dashboards with some sample data.

Overview

  • Format: 4 live online sessions  (3.5 hours each) with a live instructor, held over one week
  • Total Time Commitment: 14 hours
  • Certificate: Certificate of Completion provided
  • Audience: Open to all skill levels; no prior experience required, but a background in Excel is helpful
  • Mode: Virtual via Zoom 
  • Course Fee: $1,095

Dates & Times

  • Session 1: Monday, August 10, 2026
  • Session 2: Tuesday, August 11, 2026
  • Session 3: Thursday, August 13, 2026
  • Session 4: Friday, August 14, 2026

Instruction + Q&A  is 12:45 PM ET to 4:15 PM ET

Each sessions begins and ends with Q&A.

Learning Objectives

  • Understand the importance and value of BI solutions
  • Create automated reports to visualize key business metrics
  • Deploy reports to your company to drive decision making

Topics Covered

Session 1

Power BI Overview

  • What is Power BI?
  • Business Intelligence Industry

Reporting Basics

  • Connecting to Data
  • Visualizations

 

Session 2

Building Interactive Reports

  • Building Reports
  • Transforming/Cleaning Data

Data Modeling

  • Data Models & Table Relationships
  • Data Modeling Best Practices

 

Session 3

DAX Expressions

  • Beginner/Intermediate DAX
  • Measures and Calculated Columns

Time Intelligence

  • Calendar Tables
  • Time Functions

 

Session 4

Hands-On Exercises

  • CVG Flights
  • Superstore
  • HR Analysis

Additional Topics

  • Bookmarks/Buttons/Creating Interactive Reports
  • Security/Deployment Best Practices

Additional Information

  • A good internet connection and dual screens are recommended to maximize the learning experience. 
  • Meeting invite, Zoom link and class materials will be sent to registered attendees approximately 3-5 days before the class.

A Certificate of Completion is provided with this course showing number of contact hours and field of study as "Information Technology" for continuing education purposes. This course provides 14 contact hours and is equivalent to 1.4 CEUs.

Instructors

Jack Johnson

Jack Johnson is a certified Change Management professional and senior management consultant at AMEND Consulting. With ten years of experience leading businesses through major change initiatives, Jack has developed a competency and reputation for helping companies solve their greatest challenges through process improvement and technology solutions.

Jack received his BBA in Finance and Entrepreneurship with a minor in Data Analytics from University of Cincinnati in 2017.

Katie Fields

Katie is the Associate Business Intelligence Practice Leader at AMEND Consulting. With a background in psychology and statistics, Katie prioritizes understanding individual and organizational needs and pairs it with advanced analytics to build insightful solutions that support decision-making. Katie has spent over six years creating business intelligence solutions, with majority of her time spent in Power BI and Tableau, and she frequently partners with data engineering professionals to design, develop, and deploy full technology and analytics programs for clients.

Katie received her BA in Psychology with a minor in Management from Miami University in 2015 and her MA in Industrial/Organizational Psychology from Middle Tennessee State University in 2017.

Kirran Magowan

Kirran is a Business Intelligence Consultant at AMEND Consulting. Kirran is a passionate consultant with a proven track record of uncovering actionable insights in finance and system operations to drive solutions for clients. With expertise in data analysis, visualization, and strategic decision-making, Kirran excels at transforming complex datasets into clear, impactful narratives that support organizational growth. Kirran brings a dynamic approach to teaching and mentoring future business intelligence leaders inside and outside of AMEND.

Kirran has a double BA in Finance and Information Systems along with a MS in Information Systems from the University of Cincinnati.

Greta Speidel

Greta is a consultant in AMEND's Business Intelligence Practice. She is a passionate problem-solver who helps turn complex data into clear, actionable insights. With a strong foundation in data analysis, visualization, and business strategy, she specializes in building impactful reporting solutions that support smarter decision-making. Greta believes that how insights are communicated and presented is just as critical as the insights themselves. She brings a thoughtful, user-focused approach to every project, and emphasizes training users on how to take advantage of these tools.

Greta holds a BSBA in Finance from The Ohio State University and has spent the past five years developing business intelligence tools in Power BI that drive growth, efficiency, and innovation.

Course Fee: $1095

Please email Marilyn Kump or call 513-556-5710 with any questions.