AdventureWorks-SQL-Excel

Data cleansing, analysis and dashboard using SQL and Excel

This project was developed as assignment of the SQL Impressionador course from HashtagTreinamentos.

The project goal was to present, on a dashboard, 4 indicators obtained with the dataset AdvetureWorks2019 updated:

1. Total Internet Sales by Category
2. Total Internet Sales by OrderDate Month
3. Total Internet Sales Amount vs Cost by Country
4. Total Internet Sales by Gender

SQL: Joining and Filtering the Tables

Excel:

• Data formatting
• Creating PivotTables
• Creating Graphs and Dashboard

Datasets used:

Dataset: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms

Data Update code: https://github.com/techtalkcorner/SampleDemoFiles/blob/master/Database/AdventureWorks/Update_AdventureWorksDW_Data.sql