• Home
  • Success story
  • Bologna Welcome Foundation: Data Architecture for the Attractiveness and Development of the Metropolitan Area.
SUCCESS STORY

Fondazione Bologna Welcome: The Architecture of Data for the Attractiveness and Development of the Metropolitan Territory

Project partner

CHALLENGE

Transforming massive databases into strategic decisions

The Bologna Welcome Foundation is a publicly owned entity (Municipality, Metropolitan City, and Chamber of Commerce of Bologna) with the mission to increase the attractiveness of the Bologna-Modena territory. The Business Intelligence enhancement project was launched in 2022 to support the Foundation in promoting culture, tourism, and sport, and in attracting investment and talent.

The main challenge lay in the need to manage complex and large data flows (over 50 million records) to monitor the economic impact of metropolitan tourism. The Foundation required an advanced Marketing Intelligence system that would allow for demand segmentation by nationality and the elimination of informational redundancies, making data navigation fluid and intuitive for its analysts.

SOLUTION

A tailored Power BI ecosystem

HBenchmark has designed a bespoke Business Intelligence model, based on Microsoft Power BI and Azure technologies, managing the entire data lifecycle. The technical intervention involved:

Creating an Azure SQL structure optimized to handle over 50 million records, ensuring lightning-fast loading and response times, even for complex queries.
Development of interactive dashboards with a user-centric design, enabling navigation between KPIs segmented by sales channels, origin markets, and hospitality types without information redundancy.
Implementation of Row Level Security (RLS) protocols to securely manage access and specific training for the Foundation's internal team to ensure autonomy in report management.
RESULT

Bologna Welcome Foundation as a Territorial Intelligence Hub

Today, the Bologna Welcome Foundation has an excellent tool that has radically transformed the management of the metropolitan territory. 

This new “data architecture” represents not just a technological milestone, but a fundamental strategic asset, capable of guiding the economic and social development of the Bologna-Modena destination. 

Thanks to the synergy with HBenchmark, the Foundation can scientifically measure the impact of every cultural or sporting event, optimising resources and guiding future planning through decisions based on objective evidence. 

The system also allows for the authoritative communication of the destination's value to national and international stakeholders, confirming Bologna as a leading model in the use of Big Data for tourism promotion and the global attraction of talent.

MORE REAL GROWTH STORIES

Who decided to transform data into successful strategies

Trentino: Forward-Looking Vision and System Strategy to Accelerate the Competitiveness of the Provincial Tourism Ecosystem

Trentino Marketing, in collaboration with HBenchmark, uses the platform to collect, integrate, and analyse tourism data, supporting the monitoring of flows, territorial performance, and market trends to inform strategic decisions.

Ticino Turismo: The Scientific Method in Support of the Cantonal Destination

Ticino Turismo, in collaboration with HBenchmark, uses the platform to transform tourist data into operational insights, facilitating demand analysis, results monitoring, and the definition of more effective strategies for the promotion of...