https://public.tableau.com/app/profile/sachin.dahatonde/viz/Tableau_Sachin_WIP/Dashboard2
This project presents a fully interactive Tableau dashboard built to perform advanced sales performance analysis using structured business data.
The solution focuses on trend analysis, Year-over-Year (YoY) comparison, profitability evaluation, and dimensional performance breakdown, enabling data-driven strategic decision-making.
The dashboard is designed using best practices in data modeling, calculated metrics, KPI engineering, and visual storytelling.
Organizations require real-time visibility into:
- Revenue trends over time
- Profitability fluctuations
- Year-over-Year growth performance
- Regional and categorical contribution
- Underperforming business segments
This dashboard addresses these analytical requirements by converting raw transactional data into actionable intelligence.
- Tableau Desktop
- Data Modeling (Relationships / Joins)
- Calculated Fields & Aggregations
- Level of Detail (LOD) Expressions
- Parameter Controls
- Interactive Filters
- KPI Design & Visual Encoding Principles
-
Imported structured transactional dataset
-
Validated data types and hierarchies
-
Created custom date hierarchies (Year → Quarter → Month)
-
Handled null values and aggregation inconsistencies
-
Engineered calculated metrics including:
- Total Sales =
SUM([Sales]) - Total Profit =
SUM([Profit]) - YoY Growth %
- Profit Ratio =
SUM([Profit]) / SUM([Sales]) - Conditional KPI Indicators
- Total Sales =
-
Ensured correct aggregation logic to avoid double counting
- Total Revenue
- Total Profit
- YoY Growth %
- Profitability Ratio
- Dynamic KPI color indicators based on performance thresholds
- Line Chart: Sales trend over time
- YoY comparison using dual-axis or comparative visualization
- Seasonal pattern observation
- Trend fluctuation analysis
- Clustered Column Chart
- Current Year vs Previous Year Sales
- Growth % annotation
- Contribution Analysis
- Region-wise performance
- Category & Sub-Category contribution
- Segment-level profitability
- Drill-down enabled using hierarchy navigation
✔ Year-over-Year Growth Calculation ✔ Time Intelligence Implementation ✔ Aggregation Control ✔ Dynamic Filtering ✔ Drill-Down & Drill-Up Navigation ✔ Business KPI Engineering ✔ Performance Benchmarking
- Identified seasonal revenue spikes and declines
- Highlighted profit leakage areas
- Evaluated region-wise profitability variance
- Detected high-revenue but low-margin categories
- Enabled management-level decision support
- Descriptive Analytics
- Comparative Analysis
- Trend Analysis
- Ratio Analysis
- Performance Benchmarking
- Business Intelligence Visualization Standards
- Minimized redundant calculated fields
- Optimized visual density for readability
- Maintained consistent aggregation granularity
- Applied structured layout for executive consumption
- Ensured scalability for additional data integration
- Forecasting using Tableau predictive modeling
- Integration with SQL data source
- Deployment on Tableau Server / Tableau Public
- Incorporation of parameter-driven scenario analysis
- Advanced LOD-based profitability segmentation
Sachin Dahatonde M.Sc Data Science
Technical Skills: Python | SQL | Tableau | Power BI | Machine Learning | Data Modeling | Business Analytics
This project demonstrates my ability to:
- Engineer analytical metrics from raw business data
- Implement time intelligence logic
- Design executive-ready BI dashboards
- Translate data into measurable business insights
- Apply structured analytical thinking in real-world scenarios
I am actively seeking roles in:
Data Analyst | Business Intelligence Analyst | Analytics Consultant