|
Day |
Topic |
Details |
Video Link |
|
1 |
Introduction to Excel |
Overview of Excel interface, basic functions, and spreadsheet
setup |
Excel
Basics |
|
2 |
Data Entry and Formatting |
Entering data, cell formatting, number formats |
Data Entry |
|
3 |
Formulas and Functions |
Basic arithmetic, SUM, AVERAGE, COUNT, IF functions |
Formulas |
|
4 |
Charts and Graphs |
Creating and formatting charts, types of charts |
Charts |
|
5 |
Introduction to SQL |
Setting up SQL environment, basic SQL syntax |
SQL Basics |
|
6 |
SQL Data Types and Operators |
Data types, operators (arithmetic, comparison, logical) |
SQL
Operators |
|
7 |
SQL Queries |
SELECT statements, WHERE clause, ORDER BY, GROUP BY |
SQL Queries |
|
8 |
Joins and Subqueries |
INNER JOIN, LEFT JOIN, RIGHT JOIN, subqueries |
Joins and
Subqueries |
|
9 |
Introduction to Power BI |
Overview of Power BI interface, importing data |
Power BI
Intro |
|
10 |
Data Transformation |
Using Power Query for data cleaning and transformation |
Data
Transformation |
|
11 |
Data Visualization |
Creating visualizations, charts, and dashboards |
Visualizations |
|
12 |
DAX Basics |
Introduction to Data Analysis Expressions (DAX) |
DAX Basics |
|
13 |
Advanced DAX |
Advanced calculations and measures using DAX |
Advanced
DAX |
|
14 |
Introduction to Tableau |
Tableau interface, connecting to data sources |
Tableau
Intro |
|
15 |
Tableau Visualizations |
Creating various charts and visualizations in Tableau |
Tableau
Visuals |
|
16 |
Tableau Dashboards |
Building interactive dashboards |
Tableau
Dashboards |
|
17 |
Final Project |
Combining Excel, SQL, Power BI, and Tableau skills in a project |
Final
Project |