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
Get step-by-step solutions from verified subject matter experts
