Rishi Sapra

Case Study: Environment Agency Project Report

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).
  • August 22, 2016

This report was for my (fictional) interview case study at Altius in August 2016 and was later published into the community.

The slide images below show the full thought process of this as a project from Requirements gathering to Power BI Report build to future architecture design with “Real-time” insights driven from the Environment Agency APIs called from Azure Logic Apps.


Click on the button below to download the PBIX and supporting PowerPoint presentation

Environment AgencyDownload

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