Since the portal would be fed by data from all 18 municipalities in the Lisbon Metropolitan Area, we had to ensure that all entities involved with the project were following the same data standards before starting any work on the platform. Each municipality used its protocol and tools to gather data, and none worked in partnership, not even with its neighbors. Data formats and features varied greatly so, to ensure data uniformity, Lusófona introduced an Excel spreadsheet model with all the indicators they wished to see in the portal. Lisbon was picked as the model municipality for this project, not only because Lusófona had previously done some data gathering and analysis work with it, but because it accounts for 30-40% of all data in the entire metropolitan area.
Not all municipalities could immediately adapt to Lusófona’s model in its entirety, but while they kept working towards collecting the necessary data to fill all indicators, we started working on the portal with the data at hand.

The portal was developed in Umbraco 8, an Open Source ASP.NET CMS and a favorite at DevScope, and its highlight is a Power BI report, featuring a breakdown of entities and equipment by each municipality, the number of athletes in each sport, and a cluster map with both.
Given its ETL capabilities and proven record at DevScope, Power BI was the tool of choice to connect and transform all Excel data files flowing from each municipality in the Lisbon Metropolitan Area. In addition, the portal is home to news and reports that, along with the Power BI report, will highlight asymmetric differences and paint a clearer picture of the needs of each municipality and each sport in the Lisbon Metropolitan Area.
“The map allows us to spot imbalances: many infrastructures serving small populations, and larger populations lacking any services.”
– Mário Guimarães, Physical Education and Sports Teacher at Lusófona

There’s still some polishing to do, particularly when in the collection and treatment of data. To make it more reliable and easier to collect, Lusófona hopes to introduce automation in the future.