Skip to content

shishirvarun/Sales-Dashboard-Tableau-

Repository files navigation

Sales Dashboard Project

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.

Table of Contents

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:

KPI Overview:

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:

README.md:

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.

Key Features

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.

Installation

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.

Usage

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.

Contributing

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.

License

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.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published