Training cum Internship: Training plus hands-on internship work, with an internship experience letter.
Instructor: joy
Learn how to collect, clean, analyse, and present data through practical exercises and a hands-on analytics project.
This beginner-friendly 1-month Training cum Internship introduces learners to the fundamentals of data analytics. Learners will work with spreadsheets and CSV files, practise basic SQL queries, use Python with pandas to explore and clean datasets, create charts, and communicate useful insights through a final mini project.
CURRICULUM
• Introduction to Data Analytics: What data analytics is, the analytics workflow, types of data, and examples of data-driven decisions.
• Spreadsheet Fundamentals: Organising tabular data, sorting, filtering, formulas, basic functions, and pivot tables.
• SQL Basics: Tables, SELECT, WHERE, ORDER BY, GROUP BY, aggregate functions, and simple joins.
• Python for Analytics: Python basics, notebooks, variables, lists, dictionaries, and working with pandas.
• Data Cleaning and Preparation: Missing values, duplicates, data types, inconsistent values, and preparing data for analysis.
• Exploratory Data Analysis: Summary statistics, grouping, trends, and asking useful questions of a dataset.
• Data Visualization: Create clear charts using spreadsheet tools or Python libraries and choose suitable chart types.
• Final Project: Analyse a small dataset, document the process, present findings, and submit a report with charts and recommendations.
PROGRAM HIGHLIGHTS
• Beginner-friendly practical data analytics training.
• Spreadsheet and SQL exercises.
• Hands-on Python and pandas practice.
• Data cleaning and exploratory analysis.
• Charts, reporting, and insight communication.
• Final mini project with notebook, dataset source, and report.
• Training cum Internship completion certificate, subject to program requirements.
DURATION: 1 Month
FEE: ₹799
MODE: Online
WHO CAN APPLY: Students, freshers, and beginners interested in data analysis and reporting.
PREREQUISITES: Basic computer knowledge. No prior professional analytics experience is required. Basic mathematics familiarity is helpful.
4 phases · 14 tasks
Understand the analytics workflow and practice organizing, sorting, filtering, and summarizing data using spreadsheets
Tasks