AdventureWorks-SQL-PowerBI

Data cleansing, analysis and dashboard using SQL and PowerBI

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

The project goal was to develop, 2 dashboards with indicators about the company and the clients obtained with the information in the dataset AdvetureWorks2019 updated:

SQL: Joining and Filtering the Tables

PowerBI:

• Data formatting
• Creating Graphs and Dashboards

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

Result: