Case Study | Spanish City Council

City Festivals Big Data Analytics 

"We try to understand where and at what times citizens will need to use the underground and buses and where parking spaces need to be added by analysing Big Data with MS Azure HD Insight".
Director of Base Information and Cartography

bismart-business-intelligence-ayuntamiento-ciudad-power-bi

GOAL

More than 2 million people move around the city during the local festivities. The goal is to turn the chaos of data generated during these few days into a source of information to optimise the service to citizens.

STRATEGY

Data Management with:

  • MS Azure HDInsight Services
  • SQL Server
  • Power BI
  • Bismart bigov
  • BCN Open Data
The wide variety of data coming from social media, mobility, incident detection, credit card transactions, website visits, direct citizen queries, traffic, weather...

RESULTS

  • More efficient service
  • Responding to citizen feedback on social media
  • Optimised availability of public service vehicles
  • Rapid reaction to emergencies

01-bismart-business-intelligence-ayuntamiento-ciudad-power-bi-2

More than 8 external data sources

 

bismart-business-intelligence-cine-power-bi-data-warehouse-icon

More than 2 million citizens

bismart-business-intelligence-icon-velocimetro

Real-time KPI update

Other Case Studies

 

Discover what we can do for your business