Headquartered in LAGOS, Kultra Mega Stores (KMS) specializes in office supplies and furniture. The company's customers range from individual consumers and small businesses (retail), to corporate organizations (wholesale) located in the LAGOS, Nigeria. I am contracted as a Business Intelligence Analyst to help the Abuja division of KMS. The Business Manager has given me data from 2009-2012 and he would like me to analyse and present my insights from the analysis.
CASE SCENARIO
Case 1: Which product category had the highest sales?
Case 2: What are the Top 3 and Bottom 3 Regions with regards to sales?
Case 3: What was the total sales of appliances in Ontario?
Case 4: Advise the management of KMS on what to to do to increase the revenue from the bottom 10 customers
Case 5: KMS incurred the most shipping cost using which shipping method?
Case 6:Who are the most valuable customers and what do they purchase?
Case 7:If the delivery truck is the most economical but the slowest shipping method and Express Air is the fastest but the most expensive one, do you think the company appropriately spent shipping costs based on the Order Priority? Explain your answer
Case 8: Which small business customer had the highest sales?
Case 9: Which Corporate Customer placed the most number of orders in 2009 – 2012? How many orders were placed by the Corporate customer?
Case 10: Which consumer customer was the most profitable one?
Case 11: Which customer returned items and what segment do they belong?