Data Analytics using Power BI Power BI Analytics

Data Analytics using Power BI

Build interactive Power BI dashboards confidently

πŸ“˜ 7 modules πŸ• 16 hours 🎯 Intermediate

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

8 sessions Β· 16 hours
β‚Ή8,000

Have questions about this training?

Your Trainer

Vaidehi Nair

Vaidehi Nair

Corporate Trainer

15+ of experience Β· Corporate Trainer | Python Developer | Power BI Consultant | AI Solutions

View Trainer Profile β†’

You Might Also Like

β–Ά Watch Demo