Final-Project-Transforming-and-Analyzing-Data-with-SQL

Project/Goals

Able to perform all data cleaning steps, transforming and analyzing data. And Developing and implementing a QA process.

Process

1- Data Cleaning. 2- Analyzing Data.

Results

This database provides data on revenue by product. The correlation between the visitor who the site interacted with the products are discussed. We figure out

• the impact of revenue generated from each city/country
• the top-selling product from each city/country
• the pattern in the types (product categories) of products ordered from visitors in each city and country
• the average number of products ordered from visitors in each city and country
• the highest level of transaction revenues on the site in each city and country

Challenges

The time and to review huge information in short time.

Future Goals

Reading and Practicing to write advanced codes using SQL. Practicing and Performing varity projects.