Business Analytics Internship in Mumbai

Task Objective: Convert a business problem into a structured analytics problem.

Student Activities: 1.

Select a business problem such as declining sales, customer churn, increasing costs, or low employee productivity.

2.

Define the business objective and identify the questions that data should answer.

3.

Identify the required data fields, possible data sources, and important assumptions.

4.

Prepare an analytics plan explaining how the problem will be investigated.

Student Submission: Submit a 3-page Business Problem Framing Report containing the problem statement, objectives, data requirements, assumptions, and analysis plan.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.

Task Objective: Clean a dataset and identify meaningful patterns using basic exploratory data analysis.

Student Activities: 1.

Use a public dataset or create a fictional dataset containing at least 200 records.

2.

Identify and handle missing values, duplicate records, incorrect formats, and inconsistent entries.

3.

Calculate summary statistics and identify important patterns or unusual observations.

4.

Create suitable charts to communicate the main findings from the dataset.

Student Submission: Submit the cleaned Excel/CSV dataset and an exploratory analysis report containing tables, charts, observations, and conclusions.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.

Task Objective: Create a management dashboard that presents important business metrics clearly.

Student Activities: 1.

Select 5–8 business KPIs that are useful for management decision making.

2.

Create calculated metrics and organise the data so the dashboard can be filtered and understood easily.

3.

Build the dashboard using Excel, Google Sheets, Power BI, or another suitable free visualisation tool.

4.

Write a short explanation describing what each KPI means and what business decision it supports.

Student Submission: Submit the dashboard file/screenshots and a 2-page Dashboard Documentation Report explaining the KPIs, charts, filters, and business purpose.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.

Task Objective: Complete an end-to-end business analytics project from problem definition to recommendation.

Student Activities: 1.

Select a realistic business problem and prepare or obtain a suitable dataset.

2.

Perform data cleaning, exploratory analysis, KPI calculation, and dashboard development.

3.

Identify at least five meaningful insights and support every insight with data or visual evidence.

4.

Prepare practical recommendations explaining what management should do based on the analysis.

Student Submission: Submit a complete Final Project containing the dataset, analysis workbook/dashboard, 8–10 page PDF report, and a 8–10 slide management presentation.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.