Data Analytics Course

About the Program
This Data Analytics course covers Excel, SQL, Power BI, statistics, dashboards, business insights, and real-world analytics workflows.
Week 1: Introduction to Data Analytics
- What is Data Analytics?
- Types of Data
- Analytical Thinking
Week 2: Excel for Data Analysis
- Functions & Formulas
- Pivot Tables
- Data Cleaning
Week 3: Statistics for Data
- Descriptive Statistics
- Correlation
- Probability Basics
Week 4: SQL for Data
- Basic Queries
- Joins & Subqueries
- Aggregations
Week 5: Power BI Dashboards
- Data Modeling
- DAX Formulas
- Interactive Dashboards
Week 6: Python for Data (Optional)
- Pandas Basics
- Visualization with Matplotlib
- Jupyter Notebook
Week 7: Real-World Data Projects
- Sales Dashboard
- Customer Insights
- Forecasting
Week 8: Interview & Job Preparation
- Analytics Portfolio
- Mock Interviews
- Resume Building