Mexico Sales Toys (Tableau project)

Mexico toys is the company which started toy sales business for about two years. Their owners want to know how company performs within this period in order to correct or adapt their strategy for the future. They are interested in several analysis as follows:

• Toys sales in terms of units sold and revenue per product, and also which products perform best and worst

• Revenue, cost and and overall profit

• Best and worst profitable product

• Revenue per store location(store location is a main part of Mexico toys commercial strategy).

• Revenue per toys category.

• Overall revenue in years and months.

As data analyst, I have to provide the metrics that could measure those elements and provide best answers to Mexico owners requests. In order to achieve this task, I choose to use Mysql database system to clean data provided by Mexico toys and then make analysis with Tableau. To do that, I will follow the process as presented below.

1- Use mysql to create Mexico toys database and import csv files provided by the company.

2- Proceed with data cleaning to ensure that data are safe from errors or incorrect informations.

3- Proceed with data transformation when necessary.

4- Export new cleaned and formatted data obtained into CSV files.

5- Import those data and proceed with Analysis by using Tableau to understand how was Mexico sales business performance.

6. Provide Recommendations.

The interested reader will find the data source in the following link: https://app.mavenanalytics.io/datasets?search=mexi