Sales Analysis & Dashboard

This repository contains a Power BI & Tableau dashboards designed to analyze and visualize sales performance across multiple regions and products. The dashboard provides actionable insights to support business decision-making and strategy optimization. The dashboard offers visual insights into sales trends, seasonal patterns, and future sales predictions.

Project Overview

• Tools Used: Python, SQL, Power BI Desktop, Tableau
• Goal: Analyze 150,000+ sales transactions to identify trends, profitability gaps, and regional performance insights.
• Key Features:
  • Product-level and regional sales analysis
  • Profitability analysis across 17 regions using a dynamic profit threshold parameter
  • Interactive dashboards for marketing and customer retention strategy
  • Exportable PDF reports and visual snapshots

Impact

• Guided business strategy adjustments, resulting in a 20% increase in sales efficiency.
• Identified underperforming regions and revenue gaps, enabling targeted interventions.

Files in this Repository

• Sales_Analysis_Dashboard.pbix: Power BI dashboard file
• Sales Forecasting Analysis.twbx: Tableau workbook file
• Dashboard Images: Screenshots of dashboards for quick viewing
• README.md: Project documentation

Live Dashboard

You can view the interactive version of the dashboard on Tableau Public here:c
(https://public.tableau.com/app/profile/om4032/viz/SalseForecastingAnalysis/Dashboard1) Or see the embedded version in the index.html file.

Getting Started

To view the dashboard locally:

1. Open the SalesForecasting.twbx file using Tableau Desktop or Tableau Public.
2. Alternatively, open index.html in your browser to view the embedded dashboard.

Author

Mukund Patel