Courses

• What is Data Analytics?
• Types of Data Analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
• Overview of Data Analytics Tools & Workflow
• Career Paths in Data Analytics

• Excel Basics and Functions
• Data Cleaning and Transformation
• Pivot Tables and Charts
• Conditional Formatting and Lookup Functions

• SQL Basics and Syntax
• Filtering, Sorting, and Joins
• Aggregations and Group By
• Subqueries and Window Functions

• Descriptive Statistics
• Probability Basics
• Distributions (Normal, Binomial, etc.)
• Hypothesis Testing and Confidence Intervals

• Principles of Effective Visualization
• Creating Charts in Excel and Python
• Intro to Power BI / Tableau (optional)
• Telling Stories with Data

• Real-world Dataset Analysis
• Business Decision Reporting
• KPI Dashboards and Presentations
• End-to-End Analytical Workflow