Power BI
Power BI Syllabus
Master Power BI, the industry-leading tool for business intelligence and data visualization. This hands-on course will take you from the basics of Power BI to advanced DAX calculations, data modeling, dashboard design, and real-world business applications. Learn how to turn raw data into powerful insights that drive strategic decision-making.
- Tool Introduction
- Power Query: Intro & Column Transformations
- Power Query: Merging and Appending
- Power Query: Best Practices
- Introduction to DAX
- Introduction to DAX – II
- Introduction to Data Modeling
- Introduction to Creating Visuals
- Fix Data Holes
- . Problem Statement
- How a ‘Project Charter’ is Used in Companies
- Session Debrief
- Simplified: Profit and Loss Statemen
- Data Warehouse, OLTP vs OLAP, Data Catalog
- MySQL and Import Data
- SQL, Star Schema, Fact vs Dimension Tables
- Load and connect data with MySQL
- Create a Date Dimension Table
- Validate Data against Benchmark Numbers
- Review Finance View Mockups
- Transform Data in Power Query Editor
- Create Calculated Columns in Power Query Editor
- Power Query Best Practices
- DAX Behaviour: Filter Context
- DAX: Using Calculate to Change Filter Context
- All and ALLEXCEPT
- Direct Filters and FILTER Function
- DAX Calculated Column
- Power Query or DAX for Generating Calculated Columns
- Data Modelling: Star and Snowflake Schema
- Data Modeling: Connect Dimensions with Fact Tables
- Why Do We Need Dimension Tables?
- Create Calculated Columns Using DAX
- Easy Way to Verify Your Numbers in Power BI
- Optimize Report and Reduce File Size by 25 %
- Prepare a List of Metrics
- Calculate Function & Filter Context
- Creating Metrics
- Create P&L Table Structure
- Create Last Year (LY) Column
- Build an Ultimate DAX Measure for P & L Table Structure – I
- Build an Ultimate DAX Measure for P & L Table Structure – I
- Create ‘Quarters’ & ‘YTD/YTG’ Slicers
- Create a Line chart to Show Performance Over Time
- Build Top Product, Market & Region Visuals
- Finance View: Add Net Profit
- Review Sales View Mockup
- Build Top Customers & Performance Matrix Visuals
- Build Product Performance & Unit Economics Visuals
- Build Marketing View
- Supply Chain Basics
- Review Mock Up
- Build Key Measures
- Build Visuals
- Dashboard vs Report
- 15 Design Rules for an Effective Dashboard
- Finalise Page Layout Design
- Create Home Page
- Design Finance Dashboard
- Add Key Elements to Finance Dashboard
- Design to Sales, Marketing & Supply Chain Dashboard
- Create a User Acceptance Test report
- Create a Power BI account
- Create a Workspace in Power BI
- Create a Live Excel Report from Power BI
- Stakeholder Analysis and its Significance
- Quick Fix: Chg% formula
- Implementing Dynamic Benchmark
- Adding Dynamic Slicer to Filter Visual
- Create a Toggle Button to Switch between Two Visuals
- Create a Tool Tip to Show Trend
- Adding Market Share Data
- Create an Executive Dashboard
- Performance Optimization
- Fix Data Quality Issues
- Power BI Service Overview, Report Sharing, and Apps
- How to Set Up Automatic Data Refresh: My SQL
- How to Set Up Automatic Data Refresh: Excel
- Collaboration, Bookmarks, and Insights in Power BI Service
- Documentation and Maintenance
- Implementing Dynamic Targets (Add Targets)
- (Create a dynamic switch between Targets and LY)
- (P & L visuals to compare Target or LY based on selection)
- Adding Dynamic Slicer to Filter Visual
- Toggle Button to Switch between Two Visuals
- Create a Tool Tip to Show Trend
- (KPI Visuals)
- (Key Insights by Subzone)
- (Market Share Visual & Conditional Formatting)
- (Final Enhancements)
Contact Us
What You’ll Learn
- Power BI fundamentals: Data connections, transformations, and visualization
- Building interactive dashboards for finance, sales, and supply chain
- Understanding DAX calculations for advanced analytics
- Data modeling using star and snowflake schema
- Automating reports with Power BI Service
- Hands-on real-world business scenarios
