Multi-Source BI Analytics Platform
Built at an enterprise consulting firm
Overview
Built multiple Power BI dashboards with advanced ETL pipelines using Dataflow Gen 1 and Gen 2. Pulled data from diverse enterprise sources including Accountmate, Netsuite, and Acumatica. Designed data models, performed complex transformations, and created interactive visualizations for executive reporting and operational insights.
The Problem
Data was siloed across multiple ERP and accounting systems. Executives lacked unified visibility into business performance, and analysts spent hours manually consolidating data for reports.
My Approach
Designed Dataflow Gen 1 and Gen 2 pipelines in Power BI to extract, transform, and load data from Accountmate, Netsuite, and Acumatica. Wrote SQL for pre-processing transformations. Built interactive dashboards with drill-through, cross-filtering, and scheduled refresh for real-time executive reporting.