Name: Product Sales Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Product Sales Data

Greetings , fellow analyst !

REC corp LTD. is small-scaled business venture established in India. They have been selling FOUR PRODUCTS for OVER TEN YEARS .
The products are P1, P2, P3 and P4.

They have collected data from their retail centers and organized it into a small csv file , which has been given to you.
**The excel file contains about 8 numerical parameters : **

Q1- Total unit sales of product 1
Q2- Total unit sales of product 2
Q3- Total unit sales of product 3
Q4- Total unit sales of product 4

S1- Total revenue from product 1
S2- Total revenue from product 2
S3- Total revenue from product 3
S4- Total revenue from product 4

Example :
On 13-06-2010 , product 1 had been brought by 5422 people and INR 17187.74 had been generated in revenue from product 1.

**Now , REC corp needs you to solve the following questions : **

Is there any trend in the sales of all four products during certain months?
Out of all four products , which product has seen the highest sales in all the given years?
The company has all it's retail centers closed on the 31st of December every year. Mr: Hariharan , the CEO , would love to get an estimate on no: of units of each product that could be sold on 31st of Dec , every year , if all their retail centers were kept open.
The CEO is considering an idea to drop the production of any one of the products. He wants you to analyze this data and suggest whether his idea would result in a massive setback for the company.
The CEO would also like to predict the sales and revenues for the year 2024. He wants you to give a yearly estimate with the best possible accuracy.

Can you help REC corp with your analytical and data science skills ?

NOTE: This is a hypothetical dataset generated using python for educational purposes. It bears no resemblance to any real firm. Any similarity is a matter of coincidence.

Tables

Statsfinal

@kaggle.ksabishek_product_sales_data.statsfinal

220.12 kB
4,600 rows
10 columns

CREATE TABLE statsfinal (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" VARCHAR,
  "q_p1" BIGINT,
  "q_p2" BIGINT,
  "q_p3" BIGINT,
  "q_p4" BIGINT,
  "s_p1" DOUBLE,
  "s_p2" DOUBLE,
  "s_p3" DOUBLE,
  "s_p4" DOUBLE
);