Improving data management and data governance with Microsoft Fabric

The client: the case of IQS

IQS (Institut Químic de Sarrià) is an academic institution of reference in Barcelona, specialized in training, research and technology transfer in the fields of engineering, chemistry, business management and bioengineering, with more than 2,000 national and international students each year.

Founded in 1905 and linked to the Society of Jesus, IQS is part of the Universitat Ramon Llull (URL) and is distinguished by its focus on academic excellence, practical training and strong connection with industry.

The challenge

Heterogeneous information system

IQS had information scattered in different databases, Sigma, PGA, PGP, Cezanne, external APIs and other databases. This implied a great effort for data management and governance.

Multiple redudant dashboards

There were multiple Dashboards for the same thing, which confused users and increased maintenance costs.

Data quality

The discordance of data generated mistrust.

“The implementation of Fabric and OneLake technology has made it possible to: Simplify the University’s architecture to the essential model, Centralize data flows in a single point. Thanks to a single semantic model, it has been possible to redefine the data-driven architecture. Now the data portal provides a scalable and efficient service, supporting all areas of the University.”

Francesc Teixidó Navarro, Head of Projects & Data Unit – Digital Transformation Committee member

Implementación de Onelake en Microsoft Fabric para gestión centralizada de todos los datos

Microsoft Fabric is a comprehensive data analytics platform designed to unify all the tools needed to manage, process and analyze data in the cloud. Fabric brings together data integration, storage, analytics and governance capabilities in a single solution, simplifying the work of data scientists, analysts and business teams.

Microsoft Fabric is based on Azure and leverages the scalability of the cloud to deliver an integrated environment that encompasses:

Data Engineering

Data Factory

Data Science

IQS Advantages

Unify data silos

A single point of storage instead of multiple dispersed databases managed independently.

Unified governance

By creating a single data warehouse, we can cross-reference, shape, process and structure data in a convenient and automated way.

Scalable environment

IQS has a modern and scalable data architecture.

Facility to analyze data

Data can be consumed directly from Power BI without the need for data extraction or data movement.

Data Portal

We have all dashboards unified and easily accessible.

Simplification of the architecture

We have simplified the data architecture, making it easier to manage.

Why Raona?

Our company differentiates itself by its close, specialized and results-oriented approach, ensuring that each solution is tailored to the real needs of the client.

Customer proximity and understanding of the business. We work hand in hand with our clients, understanding their specific challenges. Nos involucramos desde el análisis inicial hasta la implementación y soporte, asegurando una experiencia fluida y sin complicaciones. Personalizamos cada solución para que realmente impacte en el rendimiento del negocio

Long-term relationships and ongoing support. We not only deliver a solution, but we accompany our clients in their digital evolution. We provide ongoing support and maintenance, ensuring that the systems grow with the needs of the business.

Specialized Knowledge. Aplicamos las mejores prácticas del sector para garantizar eficiencia, escalabilidad y seguridad. Nos mantenemos actualizados con las últimas tendencias y novedades tecnológicas, asegurando que nuestros clientes siempre tengan acceso a las soluciones más innovadoras.