Skip to content

gramchelle/product_sales

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 

Repository files navigation

This repository includes a Data Analyst Professional Practical Exam Submission jupyter notebook file.

In this project data analytics are made for the given Pens and Printers Company and there is a written report with a presentation includingly. Steps for the project:

  1. Data validation:
  • Describe validation and cleaning steps for every column in the data
  1. Exploratory Analysis:
  • Include two different graphics showing single variables only to demonstrate the characteristics of data
  • Include at least one graphic showing two or more variables to represent the relationship between features
  1. Describe your findings
  2. Definition of a metric for the business to monitor
  • How should the business use the metric to monitor the business problem
  1. Can you estimate initial value(s) for the metric based on the current data
  2. Final summary including recommendations that the business should undertake

Dataset

The Data : product_sales.csv | Column | Data Type | Description |------------|-------------------|-------------------------------------| | 'week' | Numeric | Week sale was made,counted as weeks since product launch. | | 'sales_method' | Character | Which of the three sales methods were used for that customer. | | 'customer_id' | Character | Unique identifier for the customer. | | 'nb_sold' | Numeric | Number of new products sold. | | 'revenue' | Numeric | Revenue from the sales, rounded to 2 decimal places. | | 'years_as_customer' | Numeric | Number of years customer has been buying from the company (founded in 1984). | | 'nb_site_visits' | Numeric | Number of times the customer has visited our website in the last 6 months. | | 'state' | Character | Location of the customer i.e. where orders are shipped. |

About

DataCamp DA601P Practical Exam

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published