Scribd
Upload
9 views2 pages

Data-Driven Business Decisions with Excel

The document outlines a case analysis project for students at Jagannath International Management School, focusing on data-driven business decisions using Advanced Excel. Students will analyze a dataset from ABC Retail to optimize sales performance and inventory management through tasks such as data cleaning, exploratory data analysis, and financial analysis. The project will be evaluated based on criteria including data preparation, exploratory analysis, and statistical analysis, totaling 20 marks.

Uploaded by

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

Data-Driven Business Decisions with Excel

The document outlines a case analysis project for students at Jagannath International Management School, focusing on data-driven business decisions using Advanced Excel. Students will analyze a dataset from ABC Retail to optimize sales performance and inventory management through tasks such as data cleaning, exploratory data analysis, and financial analysis. The project will be evaluated based on criteria including data preparation, exploratory analysis, and statistical analysis, totaling 20 marks.

Uploaded by

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

Jagannath International Management School

Vasant Kunj, New Delhi-110070


(Affiliated to Guru Gobind Singh Indraprastha University, New Delhi)
Recognized u/s 2(f) by UGC & Accredited with ‘A+’ Grade by NAAC
NIRF Rank Band 201-300 under College Category
Participant of UNGC New York and ISO 9001:2015 Quality Certified

Case Analysis Project: Data-Driven Business Decision Using


Advanced Excel
Objective:

Students will analyze a business dataset using Advanced Excel techniques to derive insights
and recommend data-driven decisions.

Case Study Scenario:

ABC Retail, a mid-sized e-commerce company, wants to optimize its sales performance and
inventory management. The company’s sales team suspects that specific product categories
contribute significantly to revenue, while others may cause losses due to excessive stockholding
costs. The management seeks a data-driven recommendation to:

1. Identify the top-performing products and their trends.


2. Optimize inventory levels to reduce overstocking and understocking.
3. Improve sales forecasting using historical data trends.

Project Tasks:

Students must complete the following tasks using Excel functions, Pivot Tables, and Data
Analysis tools:

Task 1: Data Cleaning & Preparation

 Import a given sales dataset (provided in Excel).


 Identify and remove duplicate values.
 Handle missing values using appropriate techniques (e.g., average, interpolation).

Task 2: Exploratory Data Analysis (EDA)


 Create Pivot Tables to analyze sales based on product categories, regions, and time
periods.
 Use Conditional Formatting to highlight high-performing products.

Task 3: Financial & Statistical Analysis

 Use SUMIF, COUNTIF, AVERAGEIF to analyze total revenue per category.


 Perform a Break-Even Analysis to determine the profitability of each product.

Evaluation Criteria:

Criteria Marks Distribution


Data Cleaning & Preparation 5 Marks
Exploratory Analysis (Pivot, Formatting) 10 Marks
Financial & Statistical Analysis 5 Marks
Total 20 Marks

You might also like