Welcome to the Sales Dashboard Project repository! This project showcases a comprehensive sales dashboard built using Tableau, designed to analyze year-over-year sales performance and understand sales trends. As a Data Analyst, I've created this dashboard to provide clear insights into various sales metrics and trends, aiding in strategic decision-making.
Overview Project Structure Key Features Installation Usage Contributing License Contact Overview
The purpose of this sales dashboard is to present an overview of key sales metrics and trends. It includes the following components:
Summary of total sales and quantity for the current and previous year. Sales & Quantity Trends: Monthly KPI analysis for the current and previous year, highlighting the months with the highest and lowest sales. Subcategory Comparison: Comparison of sales performance by different subcategories for the current and previous year, including sales and profit comparison. Weekly Trends: Weekly sales and profit data for the current year, highlighting weeks that are above and below average. Project Structure The repository contains the following files and directories:
This readme file. Sales_Dashboard.twbx: The Tableau workbook file containing the sales dashboard. data/: Directory containing the dataset used for the dashboard. images/: Directory containing screenshots of the dashboard for reference.
KPI Overview: Utilizes BANS and Calculated Fields to display total sales and quantity metrics. Sales & Quantity Trends: Sparkline Chart to visualize monthly sales and quantity trends. Subcategory Comparison: Bar-in-Bar Chart for comparing sales and profit by subcategories. Weekly Trends: Line Chart to show weekly sales and profit data, with highlights for above and below-average weeks.
Clone the repository: bash Copy code git clone https://github.com/your-username/sales-dashboard.git Ensure you have Tableau installed to open and explore the Tableau workbook.
Open Sales_Dashboard.twbx in Tableau. Explore the different components of the dashboard: KPI Overview: Review the summary of total sales and quantity. Sales & Quantity Trends: Analyze monthly sales and quantity trends. Subcategory Comparison: Compare sales performance across different subcategories. Weekly Trends: Examine weekly sales and profit data to identify trends.
Contributions are welcome! If you have any suggestions or improvements, please open an issue or create a pull request. For major changes, please discuss them with me first to ensure they align with the project goals.
This project is licensed under the MIT License. See the LICENSE file for details.
Contact If you have any questions or want to discuss this project further, feel free to reach out:
GitHub: shishirvarun LinkedIn: Shishir Varun Thank you for checking out the Sales Dashboard Project! I hope you find it insightful and useful for your data analysis needs.