Microsoft Power BI Training
Microsoft Power BI is a business intelligence platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool t. A free version of Power BI is intended for small to midsize business owners; a professional version called Power BI Plus is available for a monthly subscription fee.
The following courses are offered. All courses can be customized and delivered at your location.
Need private Power BI Training for your organization?
- Course topics tailored to your group's specific Power BI needs
- Courses can be customized with your specific data (additional fee applies)
- Up to 25 attendees=lower cost/attendee
- Contact Marilyn Kump for details
Power BI Professional Training Course Offerings
Upcoming schedule for instructor led, live, online courses.
- Introduction to Power BI: Nov 18, 19, 21 & 22, 2024
Learn more and register - Advanced Power BI: Dec 9, 10, 12 & 13, 2024
Learn more and register - Introduction to Power BI: Feb. 10, 11, 13 & 14, 2025
Learn more and register
- Applied Power BI: Mar. 3, 5, 10, 12, 2025
Learn more and register
- Advanced Power BI: Mar. 31, Apr. 1, 3 & 4, 2025
Learn more and register
- Introduction to Power BI: May 12, 13, 15 & 16, 2025
Learn more and register
A Certificate of Completion is provided with all courses showing number of contact hours (instruction), and field of study as "Information Technology" for continuing education purposes. Power BI courses are 14 contact hours and equivalent to 1.4 CEU's, except the Introduction - Advanced Analyzing Data with Power BI which is 24 contact hours and 2.4 CEU's.
The term CEU is not a trademarked term; therefore, any educational institution may use it to describe their courses. Professions and industries usually regulate their approved continuing education within their bylaws and not one institute or accrediting body has become a standard to accept in this regard.
Professionals should always consult their Association or regulating body prior to embarking on continuing education and not assume a CEU will be accepted as part of their professional development.
Three classes from the following list:
- Data Visualization Principles, Storyfinding and Storytelling
- Introduction to Tableau or Introduction to PowerBI
- Advanced Tableau or Advanced PowerBI
To achieve a Certificate of Competency, all three classes must be taken through the Center for Business Analytics. In the event that professional experience meets the prerequisite for a class, another approved class may be substituted (limited to 1 class per Certificate of Competency)
Applied Power BI
Elevate your business intelligence with this comprehensive Power BI developer course.
This intensive program equips you with the practical skills and industry-proven techniques to transform raw data into actionable insights. Developed by a veteran Power BI consultant, the curriculum goes beyond theory, providing you with the hands-on experience to immediately add value to your organization.
Through a blend of interactive exercises and real-world case studies, you'll master the entire Power BI development lifecycle, from data acquisition and modeling to creating compelling visualizations and reports.
- Goal of this course is to enable attendees to translate lessons learned during our time together and apply them immediately and add value to your teams.
- This training doesn’t just teach theory, but uses real world examples to help attendees apply Power BI in their day to day work environment.
Who should enroll?
- Business analysts and professionals with some Power BI experience seeking to advance their developer skills
- Individuals who have completed the Center for Business Analytics' "Introduction to Power BI" and are ready to take the next step
Enroll now and become a Power BI master!
| Day 1 & 2 | Day 3 & 4 |
|---|---|
Day 1 Business Intelligence Overview Day 2 Available Charts in Power BI |
Day 3 Introduction to DAX Day 4 Conditional Formatting |
- 4 online sessions
- Time commitment 12-16 hours
- Certificate of Completion.
This training can also be customized and delivered at your location.
Instructor: Spencer Baucke
Introduction to Power BI
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. The material will focus on the core building blocks of PowerBI.
No prior experience required.
| Day One | Day Two | |
|---|---|---|
· Overview of PowerBI Service · Loading data into PowerBI · Creating simple visuals · Using PowerBI quick measures · Data viz design tips · Creating interactive reports with filters, cards, KPI’s and targets
By the end of day one, students will be able to load data into PowerBI and create a fully interactive report based on simple calculations. |
· Data modeling – table relationships, calculated fields, DAX measures · What-if scenarios · Forecasting tools · Using R within PowerBI · Sharing and deploying dashboards · Data security · Final PowerBI project By the end of day two, students will be able to model large datasets within PowerBI, generate dynamic dashboards, and deploy those dashboards for use in their businesses. |
- 4 online sessions with live instructor
- Time commitment 12-16 hours
- Certificate of Completion.
- Optional class for “Data Visualization” Certificate of Competency
This training can also be customized and delivered at your location.
Instructor: Jack Johnson
Advanced Power BI
This course takes a deep dive into advanced level Power BI skills, covering lesser known but more advanced skills from the Power BI set of features. This course is a continuation of the "Introduction to Power BI" class or the following knowledge is recommended prior to taking this course: how to connect to data, how to build basic data models, basic PowerBI visualizations, and basic DAX knowledge. Desired Outcomes: • Create more sophisticated calculations and metrics using advanced DAX functionality • Improve the end user experience with various interactive reporting tools • Efficiently publish and deploy PowerBI reports across an organization.
| Day One | Day Two |
|
|---|---|---|
Advanced Data Modeling with DAX · Running totals and moving averages · Filtered calculations and subtotals< · Calculated tables · DAX variables · Advanced time intelligence functions Data Transformations in the Query Editor · Removing duplicates · Identifying errors · Merging queries · Conditional logic · Normalization Spatial Analysis · ArcGIS maps Integrating R with Power BI |
Features for Interactive Reporting · Parameters and What-if Analysis · Action Buttons · Bookmarks · Drill-through · Power BI analyze distribution · Bookmarks · Report Themes · Power BI templates Deployment and Security · Power BI free vs premium · Creating apps and workspaces · Reports vs dashboards · Data Gateways and Scheduled Refresh · Row-level Security · Dataflows (preview feature) |
- 4 online sessions
- Time commitment 12-16 hours
- Certificate of Completion.
- Optional class for “Data Visualization” Certificate of Competency
This training can also be customized and delivered at your location.
Instructor: Jack Johnson
Data Visualization Principles, Storyfinding, and Storytelling
NOTE: This class is tool agnostic and is a general survey of data visualization designed for anyone who wants to learn more how to create effective visualizations using any software
Data visualization—the study of the visual representation of data—plays a crucial role in the work of researchers and analysts. Organizations tasked with producing, releasing, and analyzing large amounts of data can more effectively analyze and communicate their work by understanding how to better visualize their data. Often, however, visualizing research results is considered secondary to the analysis, which ultimately limits the effective relay of information.
The Data Visualization Training is a two-day workshop that provides a well-rounded introduction to the field of data visualization to create better, more effective data visualizations. The workshop (detailed below) includes an overview of the field of data visualization, an overview of different visualization types, strategies and best practices to visualizing data, and how to use data visualization to tell stories and more effectively communicate information.
Workshop outlines can be found below and can be modified and tailored for specific needs.
Topics
- Introduction to data visualization and why it’s important
- Principles of visual perception
- Understanding the preattentive attributes
- Data visualization fundamentals and best practices
- Thinking critically about visualization design
- Compare and contrast real-world examples
- Telling a story through visualization and effectively present results to an audience
- How to use data visualization to analyze data
- Creating visual insights from data that generate action
- Design principles for creating effective data visualization
- Creating dashboards to monitor organizational status and gain understanding of the data
- Principles of dashboard design
Objectives
- Understand the fundamentals of data visualization
- Become familiar with types of data and visualization
- Learn data visualization best practices
- Broaden attendees’ graphic literacy
- Increase clarity and impact of messages through data visualization
- Examine clients visualizations for feedback and learning opportunity
No prior experience required
- 4 online sessions
- Time commitment 12-16 hours
- Certificate of Completion.
- Required class for “Data Visualization” Certificate of Competency
These trainings can also be customized and delivered at your location.
Intructor: Jeff Shaffer
Introduction - Advanced: Analyzing Data with Microsoft Power BI
Microsoft Power BI is a business intelligence platform that provides business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool. A free version of Power BI is intended for small to midsize business owners; a professional version called Power BI Plus is available for a monthly subscription fee. This course combines Introduction and Advanced Power BI materials in an extended training that can prepare attendees to take the "Data Analytics with Power BI Certification" exam that is required to receive the MS Data Analyst Associate Certificate.
This double session class combines Introduction and Advanced Power BI trainings.
No prior experience required
The MS exam is not required to receive a Certificate of Completion for this course.
Attendees must make their own arrangements to take the MS certification exam if they want to receive the MS Data Analysts Associate Certification.
This class will be 8 sessions over four weeks
Major Topic |
Skills Covered |
Preparing the Data |
Getting data from different sources Profiling the data Cleaning, transforming and loading data |
Modeling the Data |
Designing a data model Developing a data model Creating measures by using DAX Optimizing model performance |
Visualizing the Data |
Creating reports Creating dashboards Enriching reports for usability |
Analyzing the Data |
Enhance reports to expose highlights Perform advanced analysis |
Deploy and Maintain Deliverables |
Manage datasets Create and manage workspaces |
- 8 online sessions
- Time commitment 32-36 hours
- Certificate of Completion.
- This class counts as both Introduction and Advanced Power BI towards the “Data Visualization” Certificate of Competency
Online Course Fees: See registration page
These trainings can also be customized and delivered at your location.
Instructor: Jack Johnson
MS Power Platform Fundamentals: Power BI, Power Apps, Power Automate & Virtual Agents
The Microsoft Power Platform is a collection of low-code products that enable business users to easily access, analyze, and automate the data captured in the organization. The Power Platform is a collection of four products: Power BI, Power Apps, Power Automate, and Power Virtual Agents. Each individual product can tackle individual challenges within a business, but connecting these products together allow organizations to create seamless and robust end-to-end solutions that tackle an organization’s most difficult problems, all without the need for extensive IT knowledge. The Power Platform is built on the idea that all levels of the organizations should be able to build sophisticated, automated solutions that improve productivity and enable data-driven decision-making.
Power BI allows an organization to create reports and dashboards that aggregate, analyze, visualize, and share data, allowing for data-driven decisions across all levels of the business. Power BI’s user interface is fairly intuitive for users familiar with Excel, enabling business users to quickly generate and share automated reports that provide new insights into the business. Since its release in 2015, Power BI has become the most widely used business intelligence tool in the market.
Power Apps gives everyone in an organization the ability to quickly create applications in a low-code environment that can be deployed throughout the business. Advanced functionality, including pre-built AI components, can now be leveraged by non-developers. Power Apps can be used across all functions of a business to improve & standardize processes, capture data, create approval or service request applications, and enable improved cross-function collaboration within an organization.
Power Automate empowers everyone within an organization to streamline business processes using low-code, drag-and-drop tools with hundreds of prebuilt connectors to external data sources that automate repetitive tasks with ease. Examples of uses cases would be setting automatic reminders for past due tasks, moving data between systems, sending an email every time a file is updated, connecting to external data sources, and automating tasks like computing data in Excel.
MS Power Platform Course Details
Power BI (Day 1)
Preparing data
- Extracting data from different sources
- Cleaning, transforming, and loading the data
Modeling data
- Designing an optimized data model
- Create measures by using the Power BI formula language (DAX)
Visualizing Data
- Create reports
- Generating insights and analyzing data
- Enriching reports for usability
Deployment
- Sharing Reports
- Monitoring Usage
- Security
Power Apps (Day 2)
App Development
- Model-Driven apps
- Canvas apps
- Connecting to external data
- Learn controls and formulas
Testing
- Performance checks of apps
- Testing security and permissions
Deployment
- Sharing apps
- Updating existing applications
Power Automate (Day 3)
Flow Development
- Automated Flows vs Scheduled Flows vs Instant FlowsCreating triggers, actions, conditions, and logic
Running flows with buttons, trigger tokens, user inputConnecting to external data sourcesDevelop automated approval process
Process Advisor
- Analyze flow processes with recordings
- Test security
Power Virtual Agents (Day 4)
Chatbot Development
- Creating topics
- Calling actions
- Understanding message nodes, question nodes, conditions, and trigger phases
- Leveraging pre-built entities
Deployment/Administration
- Publishing chatbot
- Monitoring chatbot usage
- Monitoring chatbot performance
Power Platform Integration (Day 4)
Develop robust solutions integrating multiple components of the Power Platform
- Leveraging Power App in Power BI
- Automating Power BI refresh through Power Automate
- Automating approval process through Power Apps and Power Automate
- 4 online sessions
- Time commitment 12-16 hours
- Certificate of Completion.
These trainings can also be customized and delivered at your location.
Power BI Instructors
Jack Johnson
Partner at Amend Consulting
Jack 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.
Instructor For: Introduction to Power BI and Advanced Power BI
Spencer Baucke
Spencer Baucke is co-founder of Maverick Data and a data and analytics expert. Spencer has worked in consulting for 10 years and has implemented Power BI infrastructure and solutions at numerous Fortune 500 companies. Spencer holds numerous certifications in the Microsoft data and analytics stack and has taught Power BI classes through the University of Cincinnati Center for Business Analytics for the past several years.
Instructor For: Applied Power BI
Data Visualization Instructor
Jeffrey Shaffer
Jeffrey A. Shaffer is the Director of the Applied AI Lab and the Kirk and Jacki Perry Professor of Analytics, as well as an Assistant Professor-Educator at the University of Cincinnati’s Carl H. Lindner College of Business.
He is known for his expertise in data visualization, analytics, artificial intelligence, and Tableau, Mr. Shaffer is an in-demand speaker at conferences, symposiums, and corporate training programs worldwide. He has taught data visualization extensively, including for the University of Cincinnati, the Center for Business Analytics, KPMG Advisory University and numerous Fortune 500 companies.
An accomplished data visualization specialist, Mr. Shaffer was a five-time Tableau Zen Master, earning him induction into the prestigious Tableau Visionary Hall of Fame in 2021. He is the co-founder and leader of the Cincinnati Tableau User Group and has been recognized in multiple Tableau contests, including Iron Viz, and the Tableau Quantified Self Visualization Contest.
He co-authored The Big Book of Dashboards, a renowned resource in data visualization, and curates TableauReferenceGuide.com. His blog, DataPlusScience.com, is a respected source of insights in the field, earning accolades from the Kantar Information is Beautiful Awards. Additionally, he co-hosts the award-winning data podcast Chart Chat, honored with the 2021 Data Literacy award for Most Interesting Data Podcast.
Instructor For: Data Visualization Principles, Storyfinding and Storytelling. Also, teaches all versions of Tableau and Generative AI in Business.
Testimonials
- The essentials were covered. The content was appropriate without being too slow.
- Well versed and knew his stuff
- Covered a lot of material in a short period of time. Well done
- Gabe is very knowledgeable and did a very good job presenting the material
- Great class, relevant and very helping in enhancing my skills
For more information on these training courses or custom training, please contact
