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:
- Data validation:
- Describe validation and cleaning steps for every column in the data
- 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
- Describe your findings
- Definition of a metric for the business to monitor
- How should the business use the metric to monitor the business problem
- Can you estimate initial value(s) for the metric based on the current data
- Final summary including recommendations that the business should undertake
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. |