Question: i having this problem on data analytic and i need to solve before this weekend. please help. This is a transnational data set which contains
i having this problem on data analytic and i need to solve before this weekend. please help. This is a transnational data set which contains all the transactions occurring between 01/12/2020 and 09/12/2021 for a UK based and registered non-store online retail. The company mainly sells unique all-occasion gifts. Many customers of the company are wholesalers. Information is a main asset of businesses nowadays. The success of a business in a competitive environment depends on its ability to acquire, store, and utilize information. Data is one of the main sources of information. Therefore, data analysis is an important activity for acquiring new and useful information. Analyze this dataset and try to answer the following questions. The following is the description of each column: 1. InvoiceNo: a six-digit unique number that defines each transaction. 2. StockCode (categorical): a five or six-digit unique character used to identify a specific product. 3. Description(categorical): product/item name. 4. Quantity (numeric): the quantity of each product per transaction. Negative values related to cancelled transactions. 5. InvoiceDate: the date when each transaction was generated. 6. UnitPrice: the price of each product per unit in pound sterling (). 7. CustomerNo (categorical): a five-digit unique number that defines each customer. Requirement: Connect the data into PowerBI and build a simple analysis dashboard (2 points) Analysis recommendation: (3 points) Highlight Cards: Total Sales, Total Quantity, Total Number of Customer Visualization: Sales by Country, Trending sales by Month, Sales by Customer Slicer: Year The question suggest (5 points) 1. How was the sales trend over the months? 2. What are the most frequently purchased products? 3. How many products does the customer purchase in each transaction? 4. What are the most profitable segment customers? 5. Based on your findings, what strategy could you recommend to the business to gain more profit?
Link stated as below :
1. Topic :
https://docs.google.com/presentation/d/1yjtK5ErWA8JiwwwK_uDgVLhD3fNp9NIn/edit?usp=sharing&ouid=106860522322155609886&rtpof=true&sd=true
2. Data sheet:
https://docs.google.com/spreadsheets/d/1TVXQzPOJEII0Tk1S5vKKBQI-RYf8DBYi/edit#gid=1434833067
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
