Rishi Sapra

Hawaii Tourism Analysis

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).
  • May 21, 2017

This report is a submission for the Data Preparation Challenge as part of the Microsoft Data Insights Summit in Seattle 12-13 June 2017 which I attended.

The brief was to take a set of messy and onerously formatted spreadsheets from the Hawaii Tourist Authority (HTA) – files linked to below – to clean/transform them and develop a visually appealing set of dashboards in Power BI.

This analysis report was a winner of the Data Insights Summit Analytics Challenge 2017.

This report was a winner in the Complex Data Preparation category!

A video highlighting the report is at

I have also outlined my approach to the data preparation activity in a separate video:

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