Duration 2 days – 14 hrs
Overview
This hands-on training course is designed for business users who want to create interactive dashboards and reports using Microsoft Power BI. It focuses on data storytelling, allowing participants to turn raw data into meaningful insights through visualizations. Learners will gain practical experience in connecting to data sources, transforming data, building visual reports, and publishing dashboards to Power BI Service.
Objectives
- Understand the Power BI ecosystem and user interface
- Connect to and import data from various sources
- Clean and shape data using Power Query
- Create interactive reports and dashboards using visuals and filters
- Use slicers, drill-through, and bookmarks for effective data storytelling
- Publish and share reports through Power BI Service
Audience
- Business analysts and department managers
- Sales, marketing, finance, HR, and operations professionals
- Anyone responsible for generating reports or business insights
- Users who want to visualize and communicate data effectively
Pre- requisites
- Basic understanding of Excel or any spreadsheet tool
- No prior experience with Power BI is required
Course Content
Day 1: Power BI Fundamentals and Data Preparation
Introduction to Power BI
- Overview of Power BI Desktop and Power BI Service
- Components: Power Query, Data Model, Reports, Dashboards
Getting Data into Power BI
- Connecting to Excel, CSV, and online data sources
- Data loading vs. data transformation
Data Cleaning and Shaping with Power Query
- Removing errors and duplicates
- Merging and appending queries
- Changing data types and creating calculated columns
Data Modeling Basics
- Relationships between tables
- Introduction to DAX (Data Analysis Expressions)
Hands-On Lab:
- Import and transform a sample business dataset
Day 2: Building Visual Reports and Dashboards
Creating Visualizations
- Bar, column, pie, line, map, and KPI visuals
- Customizing visuals: labels, colors, interactions
Filters and Slicers
- Report, page, and visual-level filters
- Using slicers for interactivity
Enhancing Reports for Storytelling
- Drill-through and drill-down
- Using bookmarks, tooltips, and buttons
- Designing intuitive and impactful reports
Publishing and Sharing
- Publishing to Power BI Service
- Creating dashboards and sharing content
- Exporting to PDF or PowerPoint
Capstone Activity:
- Build a business dashboard from scratch
- Present insights and tell a compelling data story
