🚀 Data Analyst Career Booster Course (45 Days | 6.5 Weeks)
📘 Program Overview
A career-focused, fast-track data analyst program designed for beginners and aspiring professionals. The course covers core Excel, SQL, data cleaning, visualization, and mini projects, preparing learners for entry-level data analyst roles.
📚 45-Day Detailed Syllabus (6.5 Weeks)
🔹 Week 1 – Introduction to Data Analysis
-
Overview of Data Analytics & Career Opportunities
-
Introduction to Data, Types & Sources
-
Basic Excel Skills & Functions
-
Mini Project: Simple Data Entry & Cleaning
🔹 Week 2 – Advanced Excel Basics
-
Excel Formulas & Functions (SUM, IF, VLOOKUP, etc.)
-
Conditional Formatting & Data Validation
-
Charts & Graphs
-
Mini Project: Sales / Performance Dashboard
🔹 Week 3 – SQL Basics
-
Introduction to Databases & SQL
-
SELECT, WHERE, ORDER BY Clauses
-
Aggregate Functions (COUNT, SUM, AVG)
-
Mini Project: Simple Database Queries
🔹 Week 4 – Data Cleaning & Manipulation
-
Handling Missing Data & Duplicates
-
Text Functions & Date Functions in Excel
-
Filtering, Sorting & Pivot Tables
-
Mini Project: Clean & Analyze Sales Dataset
🔹 Week 5 – Data Visualization
-
Charts, Graphs & Dashboards in Excel
-
Introduction to Data Visualization Tools (Tableau / Power BI Basics)
-
Storytelling with Data
-
Mini Project: Visual Dashboard Creation
🔹 Week 6 – Final Project & Career Preparation
-
Integrating Excel & SQL Skills
-
Data Analysis & Visualization Project
-
Resume Building & Interview Preparation
-
Final Assessment & Presentation
🎁 Benefits
🎓 Data Analyst Career Booster Certificate
💼 Hands-On Mini Projects & Dashboard Creation
🛠️ Core Excel, SQL & Visualization Skills
