Bike Stores

Project Description

This project aims to develop a dynamic sales dashboard for the executive team of a retail company, specifically focusing on a fictional bike store dataset. The primary approach involves leveraging relevant data from the company's database using SQL and designing a well-structured, dynamic dashboard using Tableau..

The first step involves querying the company's relational database using SQL scripts to generate detailed datasets from the bike store's sales, inventory, and customer data. These datasets will provide all the necessary information required to compile a dynamic sales dashboard for the executive team.

Subsequently, I will import the generated datasets from SQL. These datasets will be linked to Tableau using Excel sheets containing SQL output data. Utilizing this data, the goal is to create a visually appealing and dynamic dashboard that effectively communicates sales performance metrics, inventory insights, customer trends, and other key metrics specific to the bike store.

This project is expected to provide added value by enhancing understanding of the bike store's sales performance and operational efficiency, supporting more informed decision-making by the executive team.