Certificate in Data Analytics

Tools Covered

• Excel
• SQL
• Python
• Power BI
• Statistics & visualization tools

1. Introduction to Data Analytics

• What is Data Analytics
• Types of analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
• Role of Data Analyst
• Applications of analytics in business
• Data sources and data types

2. Advanced Excel for Data Analysis

• Excel formulas & functions
• Pivot tables and charts
• Data cleaning and formatting
• Lookup functions (VLOOKUP / XLOOKUP / INDEX-MATCH)
• Dashboard creation

3. SQL for Data Analytics

• Introduction to databases
• SELECT, WHERE, GROUP BY
• Joins and subqueries
• Data filtering and aggregation
• Working with large datasets

4. Statistics for Data Analysis

• Mean, Median, Mode
• Variance & Standard Deviation
• Probability concepts
• Correlation & regression
• Hypothesis testing

5. Python for Data Analytics

• Python basics
• Libraries: NumPy, Pandas
• Data cleaning
• Exploratory Data Analysis (EDA)
• Data visualization (Matplotlib / Seaborn)

6. Data Visualization

• Power BI
• Dashboard design
• Charts & graphs
• Data storytelling

7. Projects & Case Studies

• Sales data analysis
• Marketing campaign analysis
• Dashboard development
• Real-world datasets