Honda Sales Analytics Pipeline

A zero-cost, automated pipeline that feeds a live four-page Power BI dashboard.

n8nPythonPostgreSQLPower BIDAXDirectQuery
Ravinder Gupta

How we built it

  1. Watch: n8n picks up new branch CSV files and starts the pipeline.
  2. Clean: Python fixes column names, ISO dates and empty numbers.
  3. Load: 1,500 rows go into Neon PostgreSQL in five batches with UPSERT.
  4. Model: Power BI composite model with a DirectQuery fact table.
  5. Show: DAX measures and four dashboard pages.
n8n + Pythoningest and clean
batch UPSERT
Neon PostgreSQLhonda_sales, 1,500 rows
DirectQuery
Power BI4 live dashboards
Free tier only

The business problem

Branch CSV files arrived by email. Analysts merged them by hand and leaders waited 24 to 48 hours.

How many orders, and how much sales and profit?Overview
Which models, cities and segments perform best?Sales Details and Segment Analysis
How do customers pay and finance their bikes?Overview
Can leaders see it live, at zero cost?DirectQuery on a free cloud database
Dataset: 1,500 Honda orders, 12 cities, Jan 2025 to Dec 2026

Our answers to the business problem

22.3%

CB350 profit margin: ₹11.84M profit on ₹53.04M sales.

23.8%

of Unicorn sales come from one city, New Delhi (₹6.71M).

₹31.98M

finance amount on CB350, about 60% of its sales value.

5.7x

gap between Unicorn's best city, New Delhi, and its weakest, Pune.

Conclusion

A free, automated pipeline now feeds a live Power BI dashboard: no manual merging, no stale reports.

Four pages take leaders from the showroom to model, city and monthly trend.

DirectQuery means new data shows up on the next click.

Thank you
0:00 / 2:49