Home → Training → Microsoft Training → Power BI

Foundation to Advanced2–4 DaysIn-Person & Virtual

Power BI Training

From connecting your first dataset to building enterprise-grade interactive dashboards with advanced DAX. India's most practical Power BI training — built around your organisation's real data.

Book This Training →View Curriculum

⏱

2 to 4 DaysBased on level selected

👥

10–25 ParticipantsOptimal batch size

📶

Foundation to AdvancedAll levels available

🌍

In-Person or VirtualIndia & International

🏆

MCT-Certified TrainerMicrosoft Certified

What Your Team Will Achieve

Build reports and dashboards that drive real decisions — not just pretty charts.

🔌

Connect Any Data Source

Import data from Excel, SQL, SharePoint, web pages, APIs and cloud services — all inside Power BI Desktop.

🧹

Clean & Transform Data

Use Power Query to shape messy data — remove errors, merge tables, pivot/unpivot, apply M language transformations.

📐

Build Proper Data Models

Create star schemas, define table relationships, and use best-practice modelling so DAX calculations work correctly at scale.

📊

Write DAX Calculations

Calculate measures, YTD, running totals, RANKX, CALCULATE and advanced intelligence functions for business KPIs.

🎨

Design Stunning Dashboards

Apply visual design principles, bookmarks, drillthrough, tooltips, and mobile layouts for professional-grade dashboards.

🚀

Publish & Share Reports

Publish to Power BI Service, set up Row-Level Security, schedule refreshes, and share dashboards with stakeholders.

Who Should Attend

Anyone responsible for data, reporting or analytics in your organisation.

📊

MIS & Analytics

Replace manual Excel reports with automated Power BI dashboards

💰

Finance Teams

P&L, budget variance, cash flow dashboards with live data

🛒

Sales & Marketing

Sales pipeline, campaign performance and regional analysis

⚙️

Operations

Production KPIs, supply chain and operational scorecards

👔

HR Teams

Headcount, attrition, training and payroll analytics

Curriculum

Six modules progressing from data import to enterprise dashboard deployment.

01Getting Started with Power BI Desktop

Power BI ecosystem overview — Desktop, Service, Mobile. Interface walkthrough. Connecting to Excel, CSV and web data sources. Understanding query editor vs report view. Building your first report. Saving and publishing basics.

Power BI DesktopData SourcesFirst Report

02Power Query — Data Transformation

Power Query editor interface. Removing nulls, errors and duplicates. Splitting, merging and appending queries. Pivot and unpivot columns. Custom columns and conditional columns. M language introduction. Applied steps best practices.

Power QueryM LanguageMerge QueriesTransformations

03Data Modelling & Relationships

Star schema design — fact and dimension tables. Creating and managing table relationships. Relationship cardinality and cross-filter direction. Date table creation for time intelligence. Avoiding many-to-many problems. Model best practices for performance.

Star SchemaRelationshipsDate TableData Modelling

04DAX — From Basics to Advanced

Calculated columns vs measures — when to use which. SUM, AVERAGE, COUNT, DISTINCTCOUNT. CALCULATE and filter context. Time intelligence — YTD, MTD, SAMEPERIODLASTYEAR. RANKX, TOPN, SWITCH. Variables in DAX. Common KPI formulas for sales, finance and HR.

DAXCALCULATETime IntelligenceKPI Measures

05Visualisations & Dashboard Design

Choosing the right visual for the data. Bar, line, scatter, map, treemap, KPI cards. Conditional formatting. Slicers, filters and bookmarks. Drillthrough pages and cross-highlighting. Tooltips. Mobile layout design. Applying corporate branding and colour themes.

VisualsBookmarksDrillthroughDashboard Design

06Power BI Service — Publishing & Sharing

Publishing to Power BI Service. Workspaces and app creation. Setting up scheduled data refresh. Row-Level Security (RLS) — creating roles and rules. Sharing reports and dashboards. Embedding in SharePoint and Teams. Power BI usage metrics.

Power BI ServiceRow-Level SecurityScheduled RefreshSharing

Delivery Options

Flexible formats to suit your team's location and schedule.

🏢

In-Person

Trainer at your premises with hands-on labs using your own data. Best for teams of 10–25.

💻

Live Virtual

Instructor-led via Teams. Participants share screens, work through labs and ask questions in real time.

🔀

Hybrid

Combine in-room and remote participants. Suitable for enterprises with distributed analytics teams.

Your Trainer

Pradip Pardeshi

Founder & Director · Microsoft Certified Trainer (MCT)

Pradip has delivered Power BI training to 34,000+ learners across pharma, manufacturing, FMCG and financial services. He builds Power BI dashboards for enterprise clients, bringing hands-on implementation experience to every training session. Every lab uses real datasets from your industry.

Microsoft Certified TrainerPower BIDAXPower QueryDashboard Design

Book Power BI Training for Your Team

We'll design your programme around your actual data — sales reports, finance dashboards, operations KPIs — so learning is immediately applicable.

Built around your organisation's real data and reports
Foundation, Intermediate or Advanced — you choose the level
Available in-person across India and internationally
Post-training email support included — no expiry
Response within 24 hours

Request a Proposal

Your Name *

Work Email *

Phone

Company *

Level Required

Data sources used in your organisation