45 Days Training
Data Analytics Training (45 Days)
Complete module-wise syllabus for the 45 days training program.
Syllabus
Data Analytics Training (45 Days)
-
01
Excel Basics
- Data Entry
- Formatting
- Sorting & Filtering
- Basic Formulas
- Charts
-
02
Advanced Excel
- Pivot Tables
- Lookup Functions
- Conditional Formatting
- Dashboard Basics
-
03
SQL
- Database Basics
- Tables
- SELECT Queries
- WHERE Clause
- Joins
- Group By
-
04
Python for Analytics
- Python Basics
- Lists & Dictionaries
- Pandas Introduction
- Data Cleaning
-
05
Data Visualization
- Charts
- Business KPIs
- Report Layouts
- Insight Presentation
-
06
Power BI
- Power BI Introduction
- Data Import
- Transform Data
- Visuals
- Dashboard Creation
-
07
Analytics Workflow
- Requirement Understanding
- Data Cleaning
- Analysis
- Reporting
-
08
Live Project
- Sales Dashboard
- Student Performance Dashboard
- Business Report
-
09
Career Support
- Portfolio Dashboard
- Resume Project Points
- LinkedIn Profile Optimization