I leveraged Azure SQL Database to extract and analyze data, enhancing data accessibility for Adventure Works. Using Tableau, I created a comprehensive dashboard showcasing shipping and sales statistics, which revealed key insights. Notably, I identified that bicycle specialist products generated $119.96k in revenue and that London was the highest sales location with $206.74k in sales. These insights are crucial for guiding future expansion strategies.
- Tableau Desktop
- Azure Sql Database
- Data Extraction & Analysis: Leveraged Azure SQL Database to extract and analyze critical data, significantly enhancing data accessibility.
- Insightful Dashboard Creation: Developed a comprehensive Tableau dashboard that visualizes shipping and sales statistics, providing actionable insights.
- Top Customer Actions: Identified that purchases of bicycle specialist products were a major revenue driver, generating an impressive $119.96k. This insight helps in understanding customer preferences and optimizing inventory management.
- Sales Location Analysis: Discovered that London was the highest sales location, with a remarkable $206.74k in sales. This information is crucial for guiding strategic decisions regarding store expansions and marketing efforts.
Dashboard :
- Shipping Stats:
- Sales Stats:
This project not only improved data-driven decision-making but also highlighted areas for future growth and optimization. By using advanced data analytics tools, Adventure Works can now make more informed decisions that align with their business goals.