How Versilia Achieved Future-Proof Reliable Business Reporting with Power BI

Transparity delivered a self service reporting solution for Polyco Healthline, enabling the business to move away from slow, manual reporting processes. By introducing an optimised Analysis Services model, report refresh times were reduced from hours to minutes or even seconds, improving efficiency and accuracy across the organisation.

This project highlights our Data Consultancy Services, including Data Engineering and Power BI Consultancy, helping organisations unlock trusted insights and scale their analytics capabilities.

Created a data warehouse

to provide a single source of truth

Delivered Power BI dashboards

dashboards with accurate and trusted insights

Enabled self-service analytics

analytics to drive confident decision-making

Our mentality was that while we're young and agile, let's implement the right infrastructure as early as possible. It was all about finding the right partnership to get this in place. What we've achieved is a really robust and stable data model that gives us the ability to provide retail insights across all of our customers.

Trent Powell
Project and Product Manager, Versilia

The challenge

Versilia was starting to realise the full potential of their data. Alongside this, they were seeking to infuse their culture with innovative processes and had begun to understand the many advantages that Power BI and other Business Intelligence tools could bring to their services.

Enhancing the insights for both their clients and streamlining operations, optimised Business Intelligence tools enabled Versilia to drive greater revenue than ever before for their customers. However, working with a wide range of data sources and client-specific structures, they wanted to ensure their reports and architecture included all datasets and integrated all sources correctly.

This would allow them to avoid introducing unwanted biases, and guarantee that their reports and architecture were built on solid foundations for a future-proofed approach.

The Solution

After carefully examining Versilia’s architecture, data sources, and current processes, we created a Data Warehouse with a single source of truth that accompanied all data used across the business and reports.

With this single source of truth in play, users were able to interact with reports while being secure in the knowledge that results could be trusted. This is critical when reports are investigating vital elements like profit/loss margins and total spend to date.

Any variation in reports not only pushes users away due to a lack of trust, but also increases the chances of users adopting error-prone and lengthy manual processes instead.

With reports made interactive and accessible, it also empowered internal teams and customers to get under their data’s hood, examining metrics in more detail to understand hidden trends and areas for efficiency without the fear that results may vary over time.

The Outcome

A trusted ongoing partnership

“What really warms me about our partnership with Transparity is that, when I’ve asked for some training in a particular area, they’ve equipped us with the necessary tools without an issue. It represents our great partnership: they’re not holding the keys to their chest at all and are always willing to help us learn.”

Just as streamlined reports empower teams to understand and examine data, our work in sharing skillsets and training materials allowed the Versilia team to harness their architecture and data for greater independence, self-sufficiency, and confidence in BI processes.

Throughout our multi-year partnership with Versilia, one of the core concepts we’ve operated on, and continue to pride ourselves on, is the focus on not just implementing projects on-demand to enhance data intelligence, but imparting our knowledge through collaborative working, skill-sharing, and training material.

From understanding the intricacies of different data sources and how to integrate them within the same report to building bespoke reporting capabilities, this knowledge sharing is emblematic of the wider Transparity mission that aims to help businesses realise, and harness, their data’s full potential.

A value-led approach we are proud of

“In Power BI we’ve been able to automate a wide range of analysis processes. For us, from a retail perspective, this has been extremely meaningful and valuable. Being able to benchmark ourselves against milestones is great for visibility and distilling performance down, as well as being infinitely quicker.”

We are incredibly proud of what we have achieved in partnership with Versilia. From ensuring that varied and complex data sources interacting with Power BI are reliable and secure from client to client, to maintaining a thorough understanding of their future goals, we have been able to add continuous value and work on an exciting range of projects.

What’s more, with a collaborative focus on team training and retained engagement, we continue to empower the Versilia team to better utilise and optimise their current processes. We look forward to seeing what the future of our involvement holds.

Facing a wide range of challenges native to the airline industry, as well as the complications generated by the recent pandemic, our partnership with Versilia continues to enable an advanced, data-driven approach that provides industry-leading services.

About Versilia

Providing world-class onboard retail and catering experiences within the airline industry, Versilia Solutions deliver a wide range of services. From integrating digital solutions to enhancing and managing supply chains, their end-to-end methodology aims to optimise cost, limit shrinkage, offer creative crew training, and maximise profits.

Always looking for innovations to strengthen their services and empower their customers, Versilia approached DataShapa with a view to increase the value, security, and efficiency of their data-driven intelligence.

“Our mentality was that while we’re young and agile, let’s implement the right infrastructure as early as possible. It was all about finding the right partnership to get this in place.”

With a strong partnership forged, we have created and streamlined reporting capabilities for Versilia. More than three years after our original introduction, we’re still developing new and exciting projects.