City Sustainability Scorecard

Abstract

1. Introduction

Grab City Sustainability Scorecard (World Champs 26).pbix.pbix) and open it in Power BI Desktop. Everything ships inside: model, data, theme, HTML components, navigation and the embedded tutorial. No external data source to connect, the data is held in the model.

This is the championship report, adapted for public sharing. The full model, the extracted source, every DAX measure and the curated HTML components are all here for you to study and reuse.

2. Objective

My Power BI World Championship 2026 Round I report, open source. Full pbix, TMDL model, 223 DAX measures organised into folders, 74 HTML components and the theme.

This project demonstrates how TMDL can be applied to a real-world Data Science problem.

4. Technology Stack

• Open any template in html-components/ next to its stylesheet in html-components/css/
• Replace each marker with your own value, colour token or measure output
• In Power BI, feed the assembled string to an HTML rendering visual sized to the same container proportions

5. System Requirements

General requirements for this technology stack — check the README for exact versions.

• See the project README for exact requirements
• Git (to clone the repository)

6. Installation & Setup

git clone https://github.com/gusbavia/city-sustainability-scorecard.git
cd city-sustainability-scorecard

Full setup instructions are in the project README.

7. Future Enhancements

Suggested extensions you can add to make this your own project.

• Turn the analysis into an interactive dashboard
• Automate data refresh with a scheduled job
• Add a predictive model on top of the analysis

8. Viva / Review Questions

Common questions examiners ask for projects in this domain.

1. What is the source of the dataset and how was missing data handled?
2. Which exploratory analysis steps revealed the most useful insight?
3. Why were these particular charts chosen to present the data?
4. Which statistical or ML technique supports the conclusions?
5. How could the analysis be automated or refreshed with new data?

9. Source Code & License

This project is developed by gusbavia and published on GitHub under the MIT License. Please follow the license terms and credit the original author when you use or modify this code.