KEMBAR78
DS PGC Course 2 Assignment 1 | PDF
Scribd
Upload
167 views3 pages

DS PGC Course 2 Assignment 1

The assignment requires analyzing the Espresso Store dataset to derive business insights using Excel's advanced features. Specific analyses include formatting data, sorting orders, retrieving customer information, labeling demand levels, counting orders by demographics, and creating Pivot Tables. All solutions must be submitted in a single workbook with separate sheets for each analysis, and failure to follow guidelines will result in no grading.

Uploaded by

komalgera.01
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
167 views3 pages

DS PGC Course 2 Assignment 1

The assignment requires analyzing the Espresso Store dataset to derive business insights using Excel's advanced features. Specific analyses include formatting data, sorting orders, retrieving customer information, labeling demand levels, counting orders by demographics, and creating Pivot Tables. All solutions must be submitted in a single workbook with separate sheets for each analysis, and failure to follow guidelines will result in no grading.

Uploaded by

komalgera.01
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
You are on page 1/ 3

Assignment Title:

Analysing Espresso Store Sales Data

Problem Statement:
The Espresso Store dataset contains detailed information about orders, customers, and
product details. The objective is to analyse this dataset to gain valuable business
insights, optimise sales strategies, and improve customer satisfaction. You are required
to use Excel's advanced features to perform data analysis and derive actionable insights.

Dataset: Espresso Store Data.xlsx what if data.xlsx


Analyses to be done:
1. Format the 'amount' column to display values as currency up to 2 decimal places
and apply date formatting to the 'date' column to show dates in 'dd m, yy' format
2. Arrange orders sorted by 'ship city' in Z to A order, and by 'amount' in descending
order. Display orders with an amount greater than 500 and status 'Returned'
3. Retrieve the 'ship state' for a given customer id=442660
4. Label orders as “most demanded” that were placed on Myntra channel and have
amount greater than 800 and rest orders as “least demanded”
5. Count the number of orders from men in the '30-40' age group and extract the
middle part of each order id
6. Replace all occurrences of kurta category to kurta sets and top category to tops
7. Calculate the order dates three months after the given dates
8. Create a One-Way Data Table to show how different interest rates from different
banks affect the loan amount of individuals? (Use What if Dataset)
9. Use Goal Seek to find out how much change in administration expenses would be
required to get the goal profit of 400000? (Use What if Dataset)
10. Create a Pivot Table to summarise total sales (amount) by month. And generate a
Pivot table and chart to compare the number of orders across different age groups.
Submission Guidelines:

1) All 10 solutions should be done in separate sheets in a single workbook and rename each
sheet for each solution.
2) Create a zip folder and upload.
3) Failure to comply with submission guidelines will result in no grading/0 marks.

How to ZIP a folder:

● Put all of the documents/sheets you want to compress (or just one) into a new folder.
● Right click on that folder.
● Select the “Compress to ZIP file” option and then click “Compressed (Zipped) folder.”
● A new .ZIP file will be created that contains your document(s).

You might also like