Welcome to the Business Analytics Project leveraging Power BI and SQL, designed to analyze and cleanse the AdventureWorks database. AdventureWorks is an open-source database provided by Microsoft, and this project harnesses its rich dataset to extract meaningful insights and create compelling visualizations.
The primary objective of this project is to showcase the capabilities of Power BI and SQL in the realm of business analytics. Through this repository, users can delve into the process of data cleansing using SQL queries and witness the power of visual data representation via Power BI.
![image](https://private-user-images.githubusercontent.com/116169969/295477368-1b58cdaf-9e8a-4f2b-be99-e44f2236fa10.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ1Njc5MjksIm5iZiI6MTcyNDU2NzYyOSwicGF0aCI6Ii8xMTYxNjk5NjkvMjk1NDc3MzY4LTFiNThjZGFmLTllOGEtNGYyYi1iZTk5LWU0NGYyMjM2ZmExMC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyNVQwNjMzNDlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02YjlhMWRkOTA2NWVkODUzNmY4NDg2MDc0MTM5NTU2N2ZkZjBmZmJiYWEwZjA2Y2YwOTg5NjE0NTEzYjkzNjc4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.J75Gu43LL6gArVtM6jXCBsQ_ybtRkAnGR7HfpYYqkZ4)
![image](https://private-user-images.githubusercontent.com/116169969/295477537-ede7a888-9d2f-4a8b-8448-1ae3267c8581.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ1Njc5MjksIm5iZiI6MTcyNDU2NzYyOSwicGF0aCI6Ii8xMTYxNjk5NjkvMjk1NDc3NTM3LWVkZTdhODg4LTlkMmYtNGE4Yi04NDQ4LTFhZTMyNjdjODU4MS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyNVQwNjMzNDlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jM2Y0MTg1ZDFlMjMxZWYyNmYxOWYzZDliOGMyNjAyNzc2N2ZiZjcwMGJjZDQyNzdmM2FkZjE3YjRhNjVkMDdmJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.vcRdUvvbIqK8-FmBRh82LRSH_BEr9es5cWRaaXy32AM)
- Data Cleansing: SQL queries are employed to cleanse the AdventureWorks database, ensuring data accuracy and consistency.
- Power BI Visualizations: Comprehensive dashboards and visual representations are created using Power BI to transform data into actionable insights.
- Insightful Analysis: The project provides opportunities to extract valuable business insights and trends from the AdventureWorks dataset.
To engage with this project, make sure you have the following installed:
- Power BI Desktop: Download Link
- SQL Server Management Studio (SSMS): Download Link
- AdventureWorks Database: Download Link
git clone https://github.com/Astrasv/Business_Analytics.git
Follow the detailed instructions provided here to install and configure the AdventureWorks database within your SQL Server instance.
- Open Power BI Desktop.
- Establish a connection to the AdventureWorks database using the SQL Server connection option.
- Import data from AdventureWorks and utilize the provided SQL queries for data cleansing.
Utilize the SQL queries located in the /SQL
directory to perform data cleansing operations on the AdventureWorks database.
Open the Power BI file (Power BI Sales DashBoard.pbix
) to access a variety of visualizations and dashboards that have been generated from the cleansed AdventureWorks data.