Aditya Shinde

End-to-End Retail Business Data Analysis

(2025-12 - 2026-01)

Architected a complete ETL data pipeline processing 5 raw business datasets (Customer, Sales, Products, Inventory, Finance) — cleaning, transforming, and modeling data for BI consumption, ensuring data accuracy, integrity, and consistency throughout.
Wrote 15+ complex SQL queries (multi-table joins, window functions, aggregations) to extract actionable KPIs including revenue trends, inventory turnover, and customer churn patterns.
Built a multi-page Power BI dashboard with advanced DAX measures (YoY Growth, Profit Margin %, Customer LTV), replacing hours of manual Excel work and significantly reducing reporting time for stakeholders.
Delivered data visualizations identifying top 10% revenue-driving products and flagging underperforming inventory segments — enabling data-backed decisions aligned with business KPIs.

Live Weather Analytics Dashboard — Power BI + REST API

(2025-01 - 2025-12)

Engineered a fully automated real-time data pipeline connecting Power BI to REST API — eliminating manual data exports and enabling live dashboard refresh with up-to-date metrics.
Built dynamic KPI cards tracking 8 weather metrics (Temperature, Humidity, Wind Speed, UV Index, Visibility, Pressure, Precipitation) with multi-city switcher across Delhi, Mumbai, and Pune.
Integrated Air Quality Index (AQI) with pollutant breakdowns (PM2.5, PM10, SO2, CO, O3, NO2) and a color-coded Good / Moderate / Poor gauge — improving stakeholder readability and decision support.
Authored custom M Language transformations in Power Query to parse and normalize complex nested JSON API responses into clean tabular format ready for DAX calculations.

Sales Analytics Dashboard — Sample Superstore

(2025-01 - 2025-12)

Designed a professional 3-page Sales Analytics report (Sales Overview, Product Analysis, Customer Analysis) mimicking real-world enterprise BI deliverables for executive stakeholder reporting.
Built a Star Schema data model with 5 tables (1 Fact + 4 Dimensions) and created 10+ DAX measures including Total Sales, Total Profit, Profit Margin %, and Order Frequency — aligned with business KPI requirements.
Implemented Row Level Security (RLS) for region-based access control, demonstrating enterprise data governance and security practices for multi-user BI deployments.
Deployed 7 visual types (KPI Cards, Line/Bar Charts, Donut, Map, Treemap) to communicate trends across product categories and customer segments in a clear, concise manner.

About