Day 1

• Our Founder’s Note to you – [Must Read]
• What is Data Analytics ?
• Data Life cycle (VIDEO)

Day 2

• Types of Data Analytics
• Introduction to Excel and its overview
• Sorting, Filtering and Conditional Formatting (VIDEO)

Day 3

• Functions and Formulas (VIDEO)
• Pivot Tables, Slicers and Pivot Charts (VIDEO)

Day 4

• Data cleaning in Excel (VIDEO)
• Dashboarding in Excel (VIDEO)

Day 5

• Module 2: Assignments
• Introduction to Microsoft Power BI
• Power BI Components: The Complete Ecosystem

Day 6

• Data Sources in Power BI: Where Your Data Lives
• How to Choose the Right Data Source
• Power BI Licensing: What You Need to Know

Day 7

• Importing and Cleaning Data in PowerBi (VIDEO)
• Data Visualization and Story Telling in PowerBi (VIDEO)

Day 8

• Introduction to Data modeling and its implementations in PowerBi.
• Implementing Data Modeling in Power BI
• Common Data Modeling Challenges and Solutions

Day 9

• PowerBi Assignment
• What are SQL Databases and their Relational data concepts
• Key Relational Database Concepts

Day 10

• Normalization, Database Schema, SQL Database Management Systems (DBMS)
• Advantages of Relational Databases, Real-World Applications, Database Design Best Practices, Common Database Challenges and Solutions

Day 11

• Creating an SQL Database, Creating and Importing of Tables, Retrieving data from SQL Database. (VIDEO)
• Introduction To Data Query in SQL

Day 12

• Introduction To Data Query in SQL – Page 2
• SQL Joins and Unions (VIDEO)

Day 13

• Select Statements, Where Clause and Filtering in SQL (VIDEO)
• SQL CTE’s and Aggregate Functions (VIDEO)

Day 14

• What are Subqueries ?
• Common Subquery Patterns, Subqueries vs Other Approaches, Real-World Business Examples
• Step-by-Step Subquery Writing Process / Common Mistakes and How to Avoid Them / Performance Tips for Subqueries / Practice Exercises

Day 15

• SQL Subqueries (VIDEO)
• SQL Assignment

---