Call us: 
Power BI - Data Analysis & Visualization
Course Description
Master data analysis, visualization, and dashboard creation using Microsoft Power BI with real-world datasets and hands-on labs.
What you'll learn in this course?
Perfect for analysts, business users, and freshers aiming to work with data and create impactful dashboards.
-
Understand Business Intelligence concepts and Power BI architecture
-
Connect to various data sources including SQL Server, Excel, SharePoint, and Web APIs
-
Transform and model data using Power Query and relationships
-
Create and customize reports and dashboards with visuals and DAX expressions
-
Publish, share, and manage reports on Power BI Service
-
Implement Row-Level Security (RLS) and manage data refreshes
Includes in-class projects, real-world datasets, and hands-on labs for practical experience.
Course Curriculum
Step-by-step coverage from Business Intelligence fundamentals to publishing interactive dashboards and managing enterprise-level deployments.
- Business Intelligence Concepts
- Stages and Use Cases of BI
- Overview of BI Tools
- Introduction to Power BI, Components, Pricing
- Architecture and Installation of Power BI Desktop
- Overview of Power BI Interface
- Understanding Building Blocks
- Creating a Simple Report
- Overview of Power BI Workflow
- Connecting Excel, CSV, and PDF Files
- Importing Data from Folders
- Using SaaS Connectors
- Introduction to Power Query Editor
- Connecting to SQL Server (Import, Direct), SQL Query, and Azure SQL
- Extracting Data from Web, OData, SharePoint
- Build Reports Using Existing Semantic Models
- Shaping and Formatting Data
- Understanding Data Types
- Basic Transformations (Rename, Split, Merge, Move)
- Applied Steps Overview
- Merge Queries and Append Queries
- Using Parameters in Queries
- Grouping and Aggregating Data
- Creating Custom and Conditional Columns
- Building Relationships between Tables
- Understanding Cardinality and Cross-Filter Direction
- Handling Inactive Relationships
- Data Modeling Best Practices
- Data Visualization (Column, Bar, Line, Area, Doughnut)
- Charts and Tables (Add Conditional Formatting, Sparklines)
- Creating KPIs, Waterfall Chart, Funnel Chart, Maps Chart
- Forecast, Linear, Exponential Equations, Trend Analysis
- Using Filter Pane and Slicer
- Custom Visuals and Visual Marketplace
- Drill-Through Analysis
- Dual Axis and Combo Charts
- Managing Hierarchies
- Drill Down and Drill Through Concepts
- Page Navigation and Bookmarks
- Conditional Formatting in Visuals
- Managing Visual Interactions
- Purpose of DAX
- Creating Calculated Tables, Measures, Columns, Visual Calculations
- Understanding Row and Filter Context
- Aggregations (Sum, SumX, Count, CountX, CountAX, etc.)
- Time Intelligence (NextYear, NextMonth, SamePeriodLastYear, YTD, etc.)
- Filter Functions (All, AllExcept, Calculate, AllSelected, etc.)
- Relationship Functions (Related, RelatedTable, UseRelationship, etc.)
- Table Functions (Distinct, GroupBy, Union, Intersect, Filter, Except, etc.)
- Logical Functions (IF, Switch, And, Or, Nested, etc.)
- Creating Cumulative Metrics
- Implementing Ranking Functions
- Publishing Reports to Power BI Service
- Creating Dashboards, Sharing and Managing Reports
- Building Real-Time Dashboards and Monitoring Data Refresh Schedules
- Building and Managing Workspaces
- Dashboard vs Report Differences
- Sharing Reports and Setting Up Subscriptions
- Managing Usage Metrics and Alerts
- Implementing Row-Level Security (RLS)
- Working with Dataflows
- Incremental Data Refresh and Deployment Pipelines
- Overview of Data Gateway
- Installation and Configuration
- Scheduling Data Refreshes
- Gateway Troubleshooting
- Connecting and Transforming Complex Data
- Building Relationships and Using DAX
- Creating Advanced Visualizations
- Managing Workspaces and Sharing
- Implementing Security Policies and RLS
- Connecting Real-Time Data
- Embedding Reports Using API
- Working with Premium Features like Dataflows and Pipelines
Eduzek Trainer
Industry Practitioner & Skilled MentorEduzek trainers bring solid industry experience and a passion for teaching. With practical insights and a student-first approach, they guide learners through real-world scenarios and ensure strong conceptual understanding across all skill levels.
Level
Duration
Certification