📊 Pricing & Financial Performance Analytics Dashboard
🚀 Project Summary
This project delivers an executive-level pricing and financial performance dashboard built to analyze revenue, profit, margins, categories, regions, and product-level profitability. It is designed as a single-page decision dashboard that allows stakeholders to instantly identify growth drivers, profit concentration, and optimization opportunities.
The project follows a full analytics lifecycle — from data preparation to SQL validation and Tableau-based storytelling.
🖼️ Dashboard Snapshot
Single-page Tableau dashboard presenting KPIs, trends, category & regional performance, and top profit-generating products.
🎯 Business Goals
Understand overall sales and profit performance
Track monthly revenue and profit trends
Identify high- and low-performing product categories
Compare regional contribution to sales and profit
Highlight top products driving profitability
Support pricing strategy and portfolio decisions
📁 Dataset Overview
Domain: Pricing & Financial Transactions
Granularity: Order-level data
Records: ~9,800 rows after cleaning
Key Attributes:
Order Date
Product Name
Category & Sub-Category
Region
Sales
Cost
Profit
Profit Margin (%)
🛠️ Tools & Workflow
🐍 Python
Data cleaning and preprocessing
Handling missing and inconsistent values
Profit and margin calculations
Feature preparation for SQL & Tableau
Exporting clean datasets for visualization
🗄️ SQL (SQLite)
Data validation checks
Aggregations for sales, profit, and margins
Category, region, and product-level analysis
Ensuring metric consistency before visualization
📊 Tableau Public
KPI card creation and formatting
Monthly trend analysis (Sales & Profit)
Comparative bar charts (Category & Region)
Top-N product profitability analysis
Custom dashboard background & layout
Executive-style storytelling in a single view
📐 Core KPIs
Total Sales
Total Profit
Average Profit Margin (%)
Monthly Sales Trend
Monthly Profit Trend
Category-wise Sales & Profit
Region-wise Sales & Profit
Top 5 Products by Profit
🔍 Key Insights & Findings
The business maintains a healthy average profit margin (~30%)
Sales and profit show clear seasonal patterns
Technology category is the strongest revenue and profit contributor
West and East regions outperform other regions consistently
A small subset of products contributes a disproportionate share of total profit
Profitability varies widely across categories, indicating pricing optimization potential
🎛️ Dashboard Capabilities
One-page executive dashboard (Power BI–style layout)
KPI-focused design for quick decision-making
Trend comparison using dual-line charts
Category and region performance benchmarking
Product-level profit visibility
Clean, professional UI with custom background
📁 Project Structure
Project-3_Pricing-Financial-Analytics/ ├── data/ │ ├── raw/ │ └── processed/ ├── python/ │ └── pricing_financial_analysis.ipynb ├── sql/ │ └── pricing_analysis.db ├── tableau/ │ └── Pricing_Financial_Performance_Dashboard.twbx ├── images/ │ └── Dashboard.png └── README.md
📈 Business Impact
This dashboard empowers stakeholders to:
Monitor financial performance at a glance
Identify revenue and profit concentration areas
Support pricing and category strategy
Focus on high-impact products and regions
Communicate insights clearly to leadership