• Self-Service Business Intelligence (SSBI)
• SSBI Tools
• Power BI vs Tableau vs QlikView
• Introduction to Power BI
• Why Power BI?
• Key Benefits of Power BI
• Power BI Workflow
• Components of Power BI
• Power BI Architecture
• Building Blocks of Power BI
• Question Bank & Assessments
• Introduction to Power BI Preview
• Downloading Training Data Files
• Power BI Account Setup
• Signing Up for Power BI Service
• Loading Data into Power BI Service
• Practical Activities & Exercises
• Understanding the Power BI Interface
• Creating Reports in Power BI Desktop
• Report Design Fundamentals
• Report Development Best Practices
• Table Styles & Formatting
• Matrix Visualization
• Tables & Matrix Practical Activities
• Data Aggregation Methods
• Cards & Multi-Row Cards
• KPI Visualization
• Percentage Calculations
• Data Presentation Best Practices
• Visual-Level Filters
• Page-Level Filters
• Drill-Through Filters
• Interactive Filtering Techniques
• Practical Activities on Filters
• Filter-Based Reporting
• Creating DAX Measures
• DAX Measure Activities
• Calculate Function
• Advanced Measure Development
• Business Calculations using DAX
• Performance Optimization Techniques
• Creating Relationships
• Managing Relationships
• Relationship Calculations
• Data Modeling Concepts
• Star Schema & Snowflake Schema
• Best Practices in Data Modeling
• Data Extraction Techniques
• Basic Transformations – Part 1
• Basic Transformations – Part 2
• Aggregating Data
• Data Cleaning Techniques
• Data Reshaping & Preparation
• Query Optimization
• Stacked & 100% Stacked Charts
• Column Chart Challenges
• Graph Formatting Options
• Analysis Graphs
• Area Charts
• Ribbon Charts
• Additional Visualizations
• Scatterplots & Bubble Charts
• Advanced Visualization Techniques
• Interactive Report Design
• Dashboard Challenges & Activities
• Publishing Reports to Power BI Service
• Pinning Visuals to Dashboards
• Mobile Reports
• Q&A Visuals
• App Workspaces
• Publishing Applications
• Themes & Branding
• Custom Visualizations
• Advanced DAX Formulas
• Date Functions
• Date Formatting Techniques
• Creating Date Master Tables
• Time Intelligence Functions
• Business Scenario Calculations
• Introduction to Databases
• What is SQL?
• Database Design Fundamentals
• Normalization Concepts
Data Definition Language (DDL)
• Create Table
• Alter Table
• Drop Table
Data Querying
• SELECT Statement
• WHERE Clause
• AND, OR, IN, NOT IN Conditions
• ORDER BY Clause
• GROUP BY Clause
• HAVING Clause
Data Manipulation Language (DML)
• INSERT INTO
• UPDATE Statements
• DELETE Statements
SQL Joins
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN
• SELF JOIN
Advanced SQL
• Wildcards
• LIKE & NOT LIKE
• Escape Characters
• Regular Expressions (REGEXP)
SQL Functions
• String Functions
• Numeric Functions
• Aggregate Functions
- SUM
- AVG
- MAX
- MIN
- COUNT
- DISTINCT
Database Programming
• User Defined Functions
• Stored Procedures
• SQL Best Practices
• Why Tableau?
• Tableau Desktop Installation
• Tableau Interface Overview
• Tableau File Types
• Tableau Data Visualization Fundamentals
• Connecting Tableau to CSV Files
• Creating Bar Charts
• Creating Area Charts
• Creating Maps
• Creating Scatterplots
• Creating Pie Charts
• Creating Tree Maps
• Creating Interactive Dashboards
• Creating Storylines
• Data Blending Techniques
• Table Calculations
• Parameters
• Dual Axis Charts
• Calculated Fields
• Calculated Fields in Blended Data Sources
• Exporting Tableau Reports to PowerPoint & Word
• Working with Time Series Data
• Creating Data Extracts
• Aggregation & Granularity
• Level of Detail (LOD) Expressions
• Filters & Quick Filters
• Data Hierarchies
• Dashboard Actions & Highlighting
• Geographical Roles & Maps
• Advanced Data Preparation
• SQL Analytics Project
• Tableau Dashboard Project
• Business Intelligence Case Studies
• Data Visualization Portfolio Development
• Real-Time Industry Scenarios
• Capstone Project Presentation
• Interview Preparation & Mock Assessments







