Power BI Basics
Start building reports and dashboards with Microsoft Power BI through a practical, step-by-step introduction. This course guides participants through the workflow of loading data, transforming it with Power Query, building a data model, and creating interactive visualizations. Hands-on workshops cover cleaning an Online Retail dataset and developing a report around defined business questions. Participants also explore publishing, sharing, and collaboration to understand how their reports can support everyday work.
Course at a Glance
| Description | Detail |
|---|---|
| Duration | 1 day — 6 hours. |
| Level | Beginner |
| Format | Classroom workshop. |
| Learning Approach | Guided practice with data preparation and report-building workshops. |
| Prerequisites | Power Query, data modelling, interactive visuals, publishing, and sharing. |
| Course Output | A Power BI report developed during the workshop. |
Learning Objectives
By the end of the course, participants will be able to:
- Explain the basic Power BI workflow from data loading to reporting.
- Connect to data sources and perform basic transformations with Power Query.
- Create columns and measures and define relationships between tables.
- Build interactive reports using visuals, slicers, and filters.
- Improve report usability with formatting and navigation.
- Understand the workflow for publishing and sharing reports.Â
Course Outline
Module 1: Introduction & Setup
Get familiar with Power BI and Power BI Desktop. Explore the workflow from loading and transforming data to modelling, visualization, and dashboards.
Module 2: Load & Transform Data
Connect to sources such as Excel, web data, and CSV files. Practice changing data types, removing rows and columns, and filtering data with Power Query.
Workshop 1: Clean and transform an Online Retail dataset.
Module 3: Build a Data Model
Learn the role of columns, measures, and table relationships. Organize the data model to support calculations and report development.
Module 4: Create Interactive Visualizations
Build visuals such as cards, column charts, pie charts, tables, and maps. Add slicers, filters, conditional formatting, and navigation using pages, bookmarks, and buttons.
Workshop 2: Build a report that answers the assigned business questions.
Module 5: Dashboards, Publishing & Sharing
Explore the relationship between reports and dashboards. Learn about pinning visuals, mobile layouts, publishing, sharing, and collaboration.
Module 6: Review & Next Steps
Review the completed workflow, discuss participant questions, and identify ways to apply and develop these skills further at work.
Who Should Attend
Professionals, managers, and team members who are new to Power BI and want to create reports from business data. The course is suitable for participants across functions who want practical experience in preparing data, building visualizations, and understanding how to share their reporting work.