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