6-Hour Virtual Boot Camp on Microsoft Power BI

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.

• 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

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

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.

• 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

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 processes

Jackie 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 life examples, adding a touch of natural humour.