This 6-hour Microsoft Power BI training takes beginners through the whole workflow, from raw data to a published dashboard. It is led by a Microsoft Certified Trainer and Microsoft Certified: Power BI Data Analyst Associate with more than 20 years of teaching experience.
You'll start with what Power BI offers compared with Excel and tour a live dashboard in Desktop and online. Next you'll import and clean data from Excel, text and CSV files and folders with Power Query, merge queries, and build relationships in a data model.
Later modules cover hiding fields, simple DAX measures and calendar tables, then building reports with slicers, filters, bookmarks, buttons and common chart types before publishing and sharing in Power BI online.
WHY SHOULD YOU ATTEND?
Power BI can feel overwhelming, and many people struggle to learn it from scattered sources. This boot camp breaks the tool into clear modules so beginners and those filling gaps can follow each step, with practical exercises along the way.
It suits data, BI, financial, healthcare and program analysts, project, marketing, sales, HR and operations managers, IT staff, educators and researchers. You'll need Power BI Desktop and a Power BI online subscription; trial versions work for the course.
AREA COVERED
Understanding Power BI
- Introduction to Power BI
- How Power BI compares with Excel
- Tour of an existing dashboard in Power BI Desktop and online
- Overview of the Power BI workflow
ETL with Power Query
- Importing data from multiple sources
- Cleaning data with Power Query
- Merging queries to join data sources
Data modeling fundamentals
- Creating relationships in Power BI
Next-level data modeling
- Hiding fields in reports
- Creating simple DAX measures
- Building a calendar table for analysis
Reports and visualizations
- Building reports and dashboards
- Using slicers, filters and other visualization tools
- Creating tables, matrices, cards, column charts and bar charts
Publishing and sharing
- Best practices for publishing reports in Power BI online
- Sharing insights with stakeholders
LEARNING OBJECTIVES
- Explain the advantages of Power BI over Excel and navigate Desktop and online
- Import data from Excel, text, CSV and folder sources
- Clean, transform and merge data with Power Query
- Build a data model with relationships, hidden fields and a calendar table
- Create simple DAX measures
- Design reports with slicers, filters, bookmarks, buttons and charts
- Publish and share reports and dashboards in Power BI online
WHO WILL BENEFIT?
- Data Analysts
- Business Intelligence Professionals
- Project Managers
- Marketing Managers
- Financial Analysts
- IT Professionals
- Sales Managers
- HR Professionals
- Operations Managers
- Healthcare Analysts
- Educators and Academic Researchers
- Program Analysts
- Financial Analysts
Power BI can feel overwhelming, and many people struggle to learn it from scattered sources. This boot camp breaks the tool into clear modules so beginners and those filling gaps can follow each step, with practical exercises along the way.
It suits data, BI, financial, healthcare and program analysts, project, marketing, sales, HR and operations managers, IT staff, educators and researchers. You'll need Power BI Desktop and a Power BI online subscription; trial versions work for the course.
Understanding Power BI
- Introduction to Power BI
- How Power BI compares with Excel
- Tour of an existing dashboard in Power BI Desktop and online
- Overview of the Power BI workflow
ETL with Power Query
- Importing data from multiple sources
- Cleaning data with Power Query
- Merging queries to join data sources
Data modeling fundamentals
- Creating relationships in Power BI
Next-level data modeling
- Hiding fields in reports
- Creating simple DAX measures
- Building a calendar table for analysis
Reports and visualizations
- Building reports and dashboards
- Using slicers, filters and other visualization tools
- Creating tables, matrices, cards, column charts and bar charts
Publishing and sharing
- Best practices for publishing reports in Power BI online
- Sharing insights with stakeholders
- Explain the advantages of Power BI over Excel and navigate Desktop and online
- Import data from Excel, text, CSV and folder sources
- Clean, transform and merge data with Power Query
- Build a data model with relationships, hidden fields and a calendar table
- Create simple DAX measures
- Design reports with slicers, filters, bookmarks, buttons and charts
- Publish and share reports and dashboards in Power BI online
- Data Analysts
- Business Intelligence Professionals
- Project Managers
- Marketing Managers
- Financial Analysts
- IT Professionals
- Sales Managers
- HR Professionals
- Operations Managers
- Healthcare Analysts
- Educators and Academic Researchers
- Program Analysts
- Financial Analysts
Speaker Profile
Jackie Kiadii
Jackie Kiadii is an MVP and Microsoft Certified Trainer specializing in Excel, Power Query, and Power BI. For the past 20 years. She has taught business professionals how to use software to increase their productivity. In addition to training, Jackie works as a consultant helping companies manage their data and automate their Excel processesJackie Kiadii started off as a consultant in 2001, and somewhere along the way she discovered that she has a passion for teaching people how to get the most out of their software in the shortest time possible. She draws people into her presentation with real …
Upcoming Webinars
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
Project Management For Administrative Professionals
Onboarding is NOT Orientation - How to Improve the New Empl…
Managing Complex Projects - Project Management
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Negotiating Skills For Professional Results - Winning Strat…
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
FDA Technology Modernization Action Plan (TMAP) and Impact …
Paying and Receiving Payments for Referrals: You Can Go to …
Human Factors Usability Studies Following ISO 62366 and FDA…
Construction Lending And Real Credit Administration: Evalua…
Validation Statistics for Non-Statisticians
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Discover how Emotional Intelligence turns AI from a technic…
Batch Record Review and Product Release
ChatGPT for HR - Build HR Policy Framework and Strategy
Female to Female Hostility @Workplace: All you Need to Know
Copilot and HR: An Introduction for HR Professionals
The Perfect Storm Coming to Healthcare: Value Based Care Me…
Language is Code - Intro to AI - Generative AI - ChatGPT an…
Major cGMP Issues: FDA Concerns in 2026
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
ChatGPT and Project Management: Leveraging AI for Project M…
I-9 Audits: Strengthening Your Immigration Compliance Strat…
Pivot tables beginner to advanced + 20 advanced Pivot table…
Emotional Intelligence: Mastering the Emotions of Great Lea…