1. How to Become Data Analyst
2. Career in Data Analytics
3. What is Data Analytics
4. Types of Data Analytics
5. Data Analytics Process
6. Data Analyst Responsibilities
7. Course Structure
8. Setting Up the Tools and Environment

1. What is Prompt Engineering
2. AI Tools

1. Introduction to Statistics
2. What is Statistics
3. Types of Statistics
4. Population vs Sample vs Sample Size
5. Variables
6. Types of Variables

1. Measure of Central Tendency – Mean, Median & Mode
2. Measure of Dispersion – Range & Variance & Standard Deviation
3. Measure of Dispersion – IQR & Outliners
4. All About Graphs & Charts

1. Percentage & Percentile
2. 5 Number Summary
3. Probability
4. Union & Intersection in Probability
5. Rules of Probability
6. Permutations & Combinations
7. Gaussian – Normal Distribution
8. Z score
9. Log Normal Distribution
10. Central Limit theorem
11. Pearson & Spearman Correlation
12. Hypothesis Testing & P Value
13. Type 1 & Type 2 Errors
14. Confidence Level & Interval

1. Introduction to Excel

2. Excel Interface and Basics

3. Data Entry and Formatting

4. Basic Formulas and Functions

5. Logical Functions (IF, AND, OR)

6. Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

7. Data Validation

8. Conditional Formatting

9. Text Functions

10. Date and Time Functions

11. Math and Statistical Functions

12. PivotTables and PivotCharts

13. Data Sorting and Filtering

14. Chart Creation and Formatting

15. Data Import and Export

16. Excel for Data Analysis

17. Data Tables and Scenarios

18. Power Query

19. Creating Dashboards in Excel

20. Finalizing Excel Skills

1. Introduction to SQL

2. SQL Basics and Syntax

3. Database Concepts

4. Data Types in SQL

5. Creating and Modifying Tables

6. Inserting Data into Tables

7. Basic SELECT Statements

8. Filtering Data with WHERE Clause

9. Using Logical Operators

10. Sorting Data with ORDER BY

11. Aggregate Functions (COUNT, SUM, AVG, MAX, MIN)

12. Grouping Data with GROUP BY

13. Filtering Groups with HAVING

14. Joining Tables (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)

15. Subqueries and Nested Queries

16. Using UNION and UNION ALL

17. Working with NULL Values

18. String Functions

19. Date and Time Functions

20. Numeric Functions

21. Updating Data

22. Deleting Data

23. Indexes and Performance Tuning

24. Views in SQL

25. Stored Procedures

26. Triggers

27. Transactions and Concurrency

28. Data Security and Permissions

29. Advanced Query Techniques

30. Window Functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE)

31. Common Table Expressions (CTEs)

32. Data Merging Techniques (MERGE, JOINs)

33. Finalizing SQL Skills

1. Introduction to Power BI
2. Power Query Editor
3. Visualizations
4. Data Modeling
5. DAX Basics
6. Relationships
7. Tables
8. Measures
9. Calculated Columns
10. Connectivity
11. Creating Reports
12. Publishing, Sharing & Scheduling a Refresh

1. Tableau Introduction

2. Tableau Download and Installation

3. How to Connect Tableau with Different Data Sources

4. Tableau Architecture & Products

5. In-built Charts

6. Advanced Charts

7. Reference Types

8. Filters

9. Tableau Calculations Using Functions

10. Dashboarding

11. Tableau Story

12. Sharing Reports

13. Scheduling

1. Why Python
2. Installation, Environment & Basics
3. Python Object & Data Structure Basics
4. Python Comparison Operators
5. Python Statements
6. Methods & Functions
7. Object Oriented Programming – Oops
8. Error & Exception Handling
9. Built in Functions
10.  Decorators & Generators
11. Web Scraping
12. PDF & Spreadsheets
13. Advanced Objects Usage
14. Numpy
15. Matplotlib
16. Seaborn
17. Pandas

1. What is Azure Data Factory
2. Data Factory Environment
3. Data Factory Components – Use Case
4. Data Pipeline Activities
5. Storage, Linked Services & Dataset
6. Integration Run Time
7. Triggers
8. Copy Data Activity
9. Secure input & Output Property
10. User Properties
11. Parameters

Provided all resources

1. Excel

2. SQL

3. PowerBi

4. Tableau

5. Python

1. Udemy Paid Courses [Free]
2. Professional Notes

1. Resume Templates
2. Linkedin Account Setup
3. Extra Certifications

1. Interview Questions PDF’S

2. Interview Guide

1. Self Introduction

2. Project Explanation – Q &A

1. What are the platforms

2. How to search

3. How to connect and ask referrals

In this Section i will add some extra materials for business analyst role as the skillset is same, just that they dont use python and azure and will do the business analysis.