Power BI
DAX
Power Query
Data Modelling
Dashboarding
Data Visualization
Data Storytelling
Basic Power BI for Data Analysis & Dashboarding From Data Preparation and DAX to Interactive Business Dashboards
Transform business data into interactive insights and dashboards
📘 5 modules
🕐 16 hours
🎯 Intermediate
Course Overview
This hands-on Power BI program covers the complete workflow of business intelligence and dashboard development. Participants will learn to connect and transform data using Power Query, build data models and relationships, create analytical calculations using DAX, design interactive reports, apply dashboard storytelling principles, and publish and share Power BI solutions.
What You'll Learn
- ✓ Understand the Power BI ecosystem and workflow
- ✓ Connect and transform Excel and CSV data using Power Query
- ✓ Build fact and dimension tables and establish relationships
- ✓ Create analytical measures using DAX
- ✓ Use CALCULATE, aggregation and time-based calculations
- ✓ Design interactive reports using visuals, slicers and filters
- ✓ Apply drill-through, bookmarks and report navigation
- ✓ Build management dashboards using storytelling principles
- ✓ Publish and share reports through Power BI Service
Prerequisites
- 👉 Basic understanding of data
- 👉 Basic familiarity with Excel
- 👉 Basic understanding of tables, charts and business reporting
Curriculum
Power BI Foundations & Data Preparation ▾
- ▸ Understanding Business Intelligence
- ▸ Introduction to Power BI
- ▸ Power BI ecosystem
- ▸ Power BI vs Excel
- ▸ Understanding reports, dashboards and semantic models
- ▸ Power BI Desktop interface
- ▸ Connecting Excel and CSV datasets
- ▸ Importing and profiling data
- ▸ Introduction to Power Query
- ▸ Removing duplicates and unwanted rows
- ▸ Handling missing and inconsistent data
- ▸ Changing data types
- ▸ Splitting and merging columns
- ▸ Creating custom columns
- ▸ Merge vs Append
- ▸ Pivot and Unpivot
Data Modelling & Relationships ▾
- ▸ Understanding Power BI data models
- ▸ Fact and dimension tables
- ▸ Primary and foreign keys
- ▸ Creating relationships between tables
- ▸ Cardinality
- ▸ Cross-filter direction
- ▸ Common date tables
- ▸ Star schema fundamentals
- ▸ Calculated columns vs measures
- ▸ Building an efficient data model
- ▸ Hands-on multi-table data modelling
DAX for Business Analysis ▾
- ▸ Introduction to DAX
- ▸ Measures vs calculated columns
- ▸ Basic aggregation measures
- ▸ SUM, AVERAGE and COUNT
- ▸ DISTINCTCOUNT
- ▸ IF and SWITCH
- ▸ CALCULATE fundamentals
- ▸ Understanding filter context
- ▸ Business KPI calculations
- ▸ Percentage and variance calculations
- ▸ Time-based calculations
- ▸ Creating reusable analytical measures
Power BI Visualizations & Interactive Reports ▾
- ▸ Choosing the right visual for the business question
- ▸ Bar and column charts
- ▸ Line and trend charts
- ▸ Cards and KPI visuals
- ▸ Tables and matrices
- ▸ Slicers and filters
- ▸ Formatting visuals
- ▸ Conditional formatting
- ▸ Tooltips
- ▸ Drill-down and drill-through
- ▸ Cross-filtering and visual interactions
- ▸ Bookmarks and Selection Pane
- ▸ Report navigation
Dashboard Design, Storytelling & Publishing ▾
- ▸ Designing effective dashboard layouts
- ▸ KPI-first dashboard design
- ▸ Visual hierarchy
- ▸ Selecting visuals for management audiences
- ▸ Identifying trends, patterns and anomalies
- ▸ Forecasting and analytical features
- ▸ Dashboard storytelling
- ▸ Executive summary pages
- ▸ Mobile-friendly report design
- ▸ Publishing reports to Power BI Service
- ▸ Creating dashboards
- ▸ Sharing and collaboration
- ▸ Data refresh concepts
- ▸ End-to-end Power BI dashboard project
System Requirements
Hardware
- • Minimum 4 GB RAM recommended
- • Processor: 1 GHz 64-bit processor or better
- • Minimum 1 GB available disk space
- • Display resolution of at least 1440 x 900 recommended
- • Stable Internet connection
Software
- • Power BI Desktop
- • Power BI Service access
- • Work email for Power BI Service
- • Microsoft Excel for source datasets
- • Windows operating system
Course Details
8 sessions
· 16 hours
₹3,000
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