Rishi Sapra

New York City Taxi Report (2.4bn rows)

Rishi Sapra
Technical Community leader, speaker, trainer and evangelist specialising in Power BI and Azure. Formally recognised by Microsoft as a Most Valuable Professional (MVP), Fast Track Recognised Solution Architect (FTRSA) and Microsoft Certified Trainer (MCT).
  • July 21, 2022

This report takes a 2.4 billion row dataset on New York City taxis and looks at how to build a complete end-to-end solution using Azure Synapse and Power BI.

In the session linked to below, we cover everything from designing an data model with an aggregated fact table, ingesting data from Azure SQL DW into a Delta lakehouse in Azure Synapse as well as Datamarts, Aggregations and visual interactions in Power BI!

Latest Solutions

Grow CFO Show- The Future of Finance: How Power BI and AI Are Redefining the CFO Role

Grow CFO Show- The Future of Finance: How Power BI and AI Are Redefining the CFO Role

In this podcast episode I discussed the Power BI training course I have been delivering for GrowCFO along with the…
Continue Reading →
ChatGPT and Excel Copilot on Invoice Data

ChatGPT and Excel Copilot on Invoice Data

At this Gen AI for Startup founders event held in London in Feb 2025, I ran an exercise of putting…
Continue Reading →
Credit Risk Modelling in Excel, Power BI and Fabric

Credit Risk Modelling in Excel, Power BI and Fabric

This solution explores how to transform an Excel-based credit rating model for government authorities into an interactive and scalable report…
Continue Reading →
Power BI for Financial Data e-learning course (Beginner/Intermediate)

Power BI for Financial Data e-learning course (Beginner/Intermediate)

Using a realistic accounting dataset, this course empowers you to automate your month-end reports using the built-in data transformation, logic…
Continue Reading →
E-learning course: Fabric and Power BI Governance

E-learning course: Fabric and Power BI Governance

This free e-learning course is a fun and interactive way for participants to learn about Fabric Governance with role-play avatar…
Continue Reading →
Power BI and Fabric Copilot course

Power BI and Fabric Copilot course

In this 1 hour e-learning course which uses a Finance dataset (the same I use on the Financial Reporting with…
Continue Reading →
Grow CFO Webinar – Interactive Financial Statements in Power BI

Grow CFO Webinar – Interactive Financial Statements in Power BI

Event Description: If you’ve tried using Power BI for financial analysis or reporting, you’ve likely found that simple things like subtotals, sorting and mixed formats…
Continue Reading →
The Great Debate on AI, Excel, and the Future of Financial Modeling

The Great Debate on AI, Excel, and the Future of Financial Modeling

In this special debate episode, host Paul Barnhurst aka The FP&A Guy is joined by an all-star panel of modeling…
Continue Reading →
DP600 Exam Prep session – Power BI User Group Turkey

DP600 Exam Prep session – Power BI User Group Turkey

A marathon 2.5 hour session with me and 6 other community leaders (Halil Gungormus, Heini Ilmarinen, Will Needham, Andy Cutler, Kevin Chant, Abu Bakar N. Alvi…
Continue Reading →
Rishi Sapra