Data Analytics Internship — Core (1 Month)

About Course

Welcome to the Data Analytics Internship — Core Tier by Synkoc IT Services.

Duration: 1 Month
Projects: 1 Project
Includes: 2 Mentor Sessions + Certificate
Mode: Online (Remote)
Certificate: Yes — issued on successful project evaluation

This internship provides hands-on experience in Data Analytics through a structured, mentor-guided program.

Course Content

Day 1 — What is data analytics

What is data analytics
What is data analytics Lab
What is data analytics Quiz

Day 2 — Excel basics for analysts

Day 3 — What is SQL and databases

Day 4 — SELECT, WHERE and ORDER BY

Day 5 — Why statistics for analysts

Day 6 — Descriptive statistics

Day 8 — Why Python for analysts

Day 9 — Python essentials

Day 10 — What is business intelligence

Day 11 — Power BI Desktop tour

Day 12 — Thinking like a business analyst

Day 13 — Writing an insight report

Day 15 — Essential functions, SUM, AVERAGE, COUNTIFS

Day 16 — Lookup functions, XLOOKUP and VLOOKUP

Day 17 — Aggregations, GROUP BY and HAVING

Day 18 — Joins

Day 19 — Distributions

Day 20 — Correlation

Day 22 — pandas basics

Day 23 — Cleaning with pandas

Day 24 — Power Query in Power BI

Day 25 — Building visuals

Day 26 — Business metrics

Day 27 — Presenting to stakeholders

Final Capstone Projects Submissions
Submit any 1 projects from the 3 given projects,multiple times in the form below until you achieve 100% accuracy. Note: Only submissions scoring 100% will be considered as final capstone projects and will be validated and approved by the mentor.

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

malliksn

2 months ago

Good

About Course

Course Content

Day 1 — What is data analytics

What is data analytics

What is data analytics Lab

What is data analytics Quiz

Day 2 — Excel basics for analysts

Excel basics for analysts

Excel basics for analysts Lab

Excel basics for analysts Quiz

Day 3 — What is SQL and databases

What is SQL and databases

What is SQL and databases Lab

What is SQL and databases Quiz

Day 4 — SELECT, WHERE and ORDER BY

SELECT, WHERE and ORDER BY

SELECT, WHERE and ORDER BY Lab

SELECT, WHERE and ORDER BY Quiz

Day 5 — Why statistics for analysts

Why statistics for analysts

Why statistics for analysts Lab

Why statistics for analysts Quiz

Day 6 — Descriptive statistics

Descriptive statistics

Descriptive statistics Lab

Descriptive statistics Quiz

Day 8 — Why Python for analysts

Why Python for analysts

Why Python for analysts Lab

Why Python for analysts Quiz

Day 9 — Python essentials

Python essentials

Python essentials Lab

Python essentials Quiz

Day 10 — What is business intelligence

What is business intelligence

What is business intelligence Lab

What is business intelligence Quiz

Day 11 — Power BI Desktop tour

Power BI Desktop tour

Power BI Desktop tour Lab

Power BI Desktop tour Quiz

Day 12 — Thinking like a business analyst

Thinking like a business analyst

Thinking like a business analyst Lab

Thinking like a business analyst Quiz

Day 13 — Writing an insight report

Writing an insight report

Writing an insight report Lab

Writing an insight report Quiz

Day 15 — Essential functions, SUM, AVERAGE, COUNTIFS

Essential functions, SUM, AVERAGE, COUNTIFS

Essential functions, SUM, AVERAGE, COUNTIFS Lab

Essential functions, SUM, AVERAGE, COUNTIFS Quiz

Day 16 — Lookup functions, XLOOKUP and VLOOKUP

Lookup functions, XLOOKUP and VLOOKUP

Lookup functions, XLOOKUP and VLOOKUP Lab

Lookup functions, XLOOKUP and VLOOKUP Quiz

Day 17 — Aggregations, GROUP BY and HAVING

Aggregations, GROUP BY and HAVING

Aggregations, GROUP BY and HAVING Lab

Aggregations, GROUP BY and HAVING Quiz

Day 18 — Joins

Joins

Joins Lab

Joins Quiz

Day 19 — Distributions

Distributions

Distributions Lab

Distributions Quiz

Day 20 — Correlation

Correlation

Correlation Lab

Correlation Quiz

Day 22 — pandas basics

pandas basics

pandas basics Lab

pandas basics Quiz

Day 23 — Cleaning with pandas

Cleaning with pandas

Final Capstone Projects Submissions
Submit any 1 projects from the 3 given projects,multiple times in the form below until you achieve 100% accuracy. Note: Only submissions scoring 100% will be considered as final capstone projects and will be validated and approved by the mentor.