Barcelona, Spain, wanted better insight into government effectiveness. To achieve this, it needed a solution that could collect and analyze data from its systems and new public sources such as social media, software log files, and GPS signals. Working with Microsoft partner Bismart, the city built a hybrid cloud to store and analyze Big Data using business intelligence (BI) and data services based on Windows Azure, Windows Azure HDInsight Service, Microsoft SQL Server 2012, and Microsoft Excel 2010.
Still in its pilot phase, the solution provides near-real-time insight into structured and unstructured data, and BI access using any Internet-connected device that can enhance services and business opportunities, improve safety, and boost collaboration between Barcelona, its citizens, and businesses. The solution also provides a smart-city template that might be used by other global cities.