Topics:

• What is a Database? RDBMS vs NoSQL

• Understanding SQL and its importance in data analytics

• Installing MySQL / SQL Server & Workbench

• Creating and managing databases & tables

• Basic CRUD operations (SELECT, INSERT, UPDATE, DELETE)

Practice:

• Create a sample “Sales_DB” database and insert records.

• Run simple SELECT queries with WHERE & ORDER BY.

Topics:

• Constraints: Primary Key, Foreign Key, Unique, Not Null

• Data Types overview (INT, VARCHAR, DATE, DECIMAL)

• Relationships: One-to-Many & Many-to-Many

• Joins (INNER, LEFT, RIGHT, FULL)

• Aggregations: COUNT, SUM, AVG, GROUP BY, HAVING

Practice:

• Join multiple tables (sales, customers, products).

• Find total revenue by region or product category.

Topics:

• Subqueries and Nested Queries

• Views & Indexes

• Stored Procedures and Triggers

• Window Functions (ROW_NUMBER, RANK, PARTITION BY)

• Case Statements and Conditional Logic

Practice:

• Write a query to rank top 5 products by sales.

• Create a view for “Active Customers”.

Topics:

• What is Power BI and Why It’s Used

• Installing Power BI Desktop

• Power BI Interface & Components Overview

• Connecting to Data Sources (Excel, SQL, CSV)

• Understanding Data Refresh & Auto Updates

Practice:

• Connect Power BI to your SQL “Sales_DB”.

• Load tables and explore basic visuals.

Topics:

• Introduction to Power Query Editor

• Data Cleaning: Remove Duplicates, Nulls, Replace Values

• Column Splitting, Merging, and Data Type Conversion

• Append vs Merge Queries

• Applying Filters & Conditional Columns

Practice:

• Clean and prepare sales and customer datasets.

• Merge two data tables and transform for reporting.

Topics:

• Understanding Data Models (Star & Snowflake Schema)

• Creating Relationships between Tables

• Hierarchies (Year → Quarter → Month)

• Handling Many-to-Many relationships

• Using the Manage Relationships tool

Practice:

• Build a proper model for sales and region tables.

• Verify relationships using Model View.

Topics:

• Introduction to DAX

• Calculated Columns vs Measures

• Basic Functions: SUM, AVERAGE, COUNTROWS, DISTINCTCOUNT

• Conditional DAX (IF, SWITCH)

• Time Intelligence Functions (YTD, MTD, LY)

Practice:

• Create DAX measures for Profit, Profit %, and Total Sales.

• Calculate YoY Sales growth.

Project Title:
📊 “Regional Sales Performance Dashboard”

Objective:
Use SQL (for data extraction) + Power BI (for visualization) to create a regional sales analysis dashboard.

Tasks:

• Clean and merge multiple tables in Power Query

• Build DAX measures for KPIs

• Create visuals for top products, regions, and monthly growth

• Add slicers and filters

Topics:

• Custom Visuals from Marketplace

• Bookmarks, Drill-through, and Tooltips

• Dynamic Visuals with Parameters

• Row-Level Security (RLS)

• Power BI Service – Publish, Share, and Schedule Refresh

Practice:

• Publish dashboard to Power BI Service.

• Apply role-based access control for managers vs analysts.

Topics:

• Integrating Power BI with Excel & Power Automate

• Connecting to APIs for real-time data

• Using Power BI Gateway for scheduled refresh

• Data Alerts and Notifications

Practice:

• Automate report refresh with Power Automate.

• Set up a Power BI alert when sales drop below target.

Project Title:
💼 “Company-Wide Sales & Operations Dashboard”

Objective:
Build a full-stack BI solution using SQL, Power Query, DAX, and Power BI Service.

Tasks:

• Design & normalize database structure (SQL)

• Build model & relationships (Power BI)

• Create KPIs: Revenue, Profit, Targets, Region performance

• Add interactivity & publish report to Power BI Cloud

Outcome:
A professional-grade, end-to-end BI solution ready for real-world analytics portfolios.

Topics:

• Resume Building for BI Roles

• Preparing for Power BI & SQL Interview Questions

• Portfolio Presentation Tips

• Optional Microsoft PL-300 Certification Overview