Scribd
Upload
11 views2 pages

Data Analyst Course

The Certificate Data Analyst Course spans 3-4 months and consists of 120-150 hours of instruction, available in online, offline, or hybrid formats. It covers various modules including data analytics introduction, Excel, SQL, Python, data visualization with Power BI, statistics, data cleaning, business analytics, and culminates in capstone projects. The course is designed for beginners to advanced learners, providing practical skills and industry applications.

Uploaded by

bn03
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views2 pages

Data Analyst Course

The Certificate Data Analyst Course spans 3-4 months and consists of 120-150 hours of instruction, available in online, offline, or hybrid formats. It covers various modules including data analytics introduction, Excel, SQL, Python, data visualization with Power BI, statistics, data cleaning, business analytics, and culminates in capstone projects. The course is designed for beginners to advanced learners, providing practical skills and industry applications.

Uploaded by

bn03
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Certificate Data Analyst Course – Modules & Explanation (Duration: 3–4 Months)

Course Duration: 3–4 Months

Total Hours: 120–150 hours

Mode: Online / Offline / Hybrid

Skill Level: Beginner to Advanced

Module 1: Introduction to Data Analytics (1 Week)

- What is Data Analytics?

- Types of Analytics

- Data Lifecycle

- Industry Use Cases

Module 2: Excel for Data Analysis (2 Weeks)

- Advanced Excel

- Pivot Tables, Charts

- Lookup Functions

- Dashboards

Module 3: SQL for Data Extraction (2 Weeks)

- Databases

- Joins, Subqueries

- Aggregations

- Real SQL Project

Module 4: Python for Data Analysis (3 Weeks)

- Python Basics

- Pandas, NumPy, Matplotlib

- EDA

- Mini Projects
Module 5: Data Visualization with Power BI (2 Weeks)

- Dashboards

- DAX

- Live Reports

Module 6: Statistics (1 Week)

- Mean, Median, Mode

- Probability

- Hypothesis Testing

Module 7: Data Cleaning (1 Week)

- Missing Data

- Outliers

- Formatting

Module 8: Business Analytics (1 Week)

- KPIs

- Sales/Marketing/Finance Analytics

Module 9: Capstone Projects (2 Weeks)

- Sales Forecasting

- E-commerce Analysis

You might also like