Portfolio Project: H Plus Sport Order Summary Dashboard

Overview

Welcome to my personal portfolio project showcasing the H Plus Sport Order Summary Dashboard. This project demonstrates my proficiency in data analysis, visualization, and web-based dashboard development using Python, SQL, and web frameworks such as Dash.

Project Highlights

• Data Source: Utilized the HPlusSport database, connecting to it using SQLAlchemy to extract data from the V_CustomerOrderSummary view.

• Data Analysis: Employed the pandas library for data manipulation and exploration, gaining insights into key metrics such as total sales, average due amounts, minimum due amounts, and maximum due amounts for different states.

• Visualization: Leveraged Plotly Express and Plotly Graph Objects to create an interactive bar chart representing total sales by state. The visualization is integrated into a dynamic dashboard developed with Dash.

• Web-Based Dashboard: Developed a responsive web-based dashboard using Dash, allowing users to explore different aspects of the H Plus Sport Order Summary data, including the ability to switch between total sales, average sales, minimum sales, and maximum sales.

• This is the data visualized, check it out here! https://upgraded-invention-p759xxrrwqvh9r79-8050.app.github.dev/

Project Structure

• main.py: Python script containing the code for connecting to the database, performing data analysis, creating visualizations, and building the Dash dashboard.

• images/: Directory containing screenshots of the dashboard and other relevant images.

• README.md: Documentation providing an overview of the project, setup instructions, and an explanation of the code.

Usage

Setup

1. Clone or download the repository to your local machine.
2. Install the required Python libraries by running:

   pip install pandas sqlalchemy plotly dash

Viewing the Dashboard

1. Open Visual Studio Code (VSCode).
2. Navigate to the Main Menu icon, go to Terminal, and choose New Terminal.
3. In the Terminal Window, go to the Ports tab.
4. Find Port 8080, right-click, and choose "Open In Browser" to view the dashboard.

Feedback and Contact

I welcome any feedback or inquiries related to this project. Feel free to reach out if you have questions, suggestions, or if you'd like to discuss collaborations or opportunities.

Thank you for exploring my H Plus Sport Order Summary Dashboard project!

Happy coding!