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
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…