Power BI
Analytics
Data Analytics using Power BI
Build interactive Power BI dashboards confidently
Course Overview
This hands-on course covers the complete Power BI reporting lifecycle, from connecting to multiple data sources and transforming data to building interactive dashboards and publishing reports. Participants will learn Power Query, data modeling, DAX, visualization techniques, and Power BI Service to create business-ready dashboards that deliver actionable insights.
What You'll Learn
- β Connect and transform data from multiple sources
- β Build interactive dashboards using Power BI visuals
- β Create DAX calculations for business reporting
- β Implement drill-through, filters, and bookmarks
- β Publish and share reports using Power BI Service
Prerequisites
- π Basic understanding of data visualization concepts
- π Basic understanding of dashboarding concepts
- π Familiarity with Microsoft Excel is beneficial
Curriculum
Introduction to Power BI βΎ
- βΈ What is Business Intelligence?
- βΈ Introduction to Power BI
- βΈ Power BI Ecosystem: Desktop, Service, Mobile App
- βΈ Power BI vs Excel
Getting Started with Power BI Desktop βΎ
- βΈ Installing Power BI Desktop
- βΈ Overview of the Power BI Interface
- βΈ Connecting to Different Data Sources
- βΈ Data Loading vs Data Transformation
Data Transformation with Power Query βΎ
- βΈ Introduction to Power Query Editor
- βΈ Cleaning Data
- βΈ Transforming Columns
- βΈ Creating Custom Columns
- βΈ Applied Steps and Undo
DAX Fundamentals βΎ
- βΈ What is DAX?
- βΈ Calculated Columns vs Measures
- βΈ SUM
- βΈ AVERAGE
- βΈ COUNT
- βΈ DISTINCTCOUNT
- βΈ IF
- βΈ SWITCH
- βΈ Basic Time Intelligence
Creating Visualizations βΎ
- βΈ Introduction to Visuals
- βΈ Bar, Column, Pie, Line, Table and Card Visuals
- βΈ Slicers and Filters
- βΈ Sorting and Formatting Charts
- βΈ Using Tooltips
Interactive Reporting βΎ
- βΈ Report-Level, Page-Level and Visual-Level Filters
- βΈ Drill-Down and Drill-Through
- βΈ Cross-Filtering Between Charts
- βΈ Bookmarks and Selection Pane
Publishing and Sharing Reports βΎ
- βΈ Publishing to Power BI Service
- βΈ Creating Dashboards in Power BI Service
- βΈ Sharing Reports and Dashboards
- βΈ Power BI Mobile View
System Requirements
Hardware
- β’ 64-bit (x64) Processor or better
- β’ Minimum 2 GB RAM (4 GB Recommended)
- β’ Minimum 1 GB Free Disk Space
- β’ Display Resolution 1440 Γ 900 or higher
Software
- β’ Windows 10, Windows 8.1, or Windows Server 2012 R2 or later
- β’ Power BI Desktop (32-bit or 64-bit)
- β’ Work Email Address for Power BI Service
- β’ Power BI Desktop is not supported on macOS
Course Details
Have questions about this training?
Your Trainer
Vaidehi Nair
Corporate Trainer
15+ of experience Β· Corporate Trainer | Python Developer | Power BI Consultant | AI Solutions
View Trainer Profile βYou Might Also Like
Request a Batch
Course
Get in Touch