This repository presents a data analytics pipeline for ride-booking records, integrating PostgreSQL with Power BI through an On-Premises Data Gateway. It demonstrates a production-grade architecture, moving beyond basic flat files to handle complex transactional data.
From the README
End-to-End E-Commerce Analysis Pipeline (PostgreSQL × Power BI) 🚀 Production-Grade BI Architecture with Live Gateway Integration 👉 View my Project Launch Post on LinkedIn 📌 Project Overview This project showcases an industry-level data analytics pipeline built to handle transactional ride-booking records. Moving completely away from basic flat files (like CSVs or Excel), this architecture implements a dynamic connection between a relational database engine (PostgreSQL) and Power BI Cloud Service using an On-Premises Data Gateway infrastructure. 💡 Key Technical Learnings & Breakthroughs Through this project, I moved past basic dashboard design and mastered production-level data...
