Question: My Path to Becoming a Business Analyst https://www.youtube.com/watch?v=d6CsguRSk_I Given a dataset called week 2 dataset.xlsx, as a business analyst, you are asked an initial analysis.

My Path to Becoming a Business Analyst https://www.youtube.com/watch?v=d6CsguRSk_I Given a dataset called "week 2 dataset.xlsx", as a business analyst, you are asked an initial analysis. This dataset records sale transactions in a supermarket. Each row is a transaction. The columns are the products sold in the supermarket. "Y" means the certain product was purchased. Task 1: Understand the dataset - Read through the dataset, try to answer the following questions: How many sale transactions are in the dataset? How many product items are in the dataset? What are they? How many purchases are made for each product? Which product has the most purchase? Which product has the least purchase? Is there any product that has no purchase? Is there any interesting finding can you get from the dataset? List your findings

Visualize the dataset Try to represent dataset using a visualization tool Try to represent your findings using a visualization tool Hint: you can pick a visualization tool from your answer in week 1, or any available tool you can use.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Computer Network Questions!