Two people working in Healthcare with a Windows device

Medical device provider builds an Azure data estate for any future

Leentje Chavatte

Leentje Chavatte

Microsoft, Data & AI and Digital Transformation

Read Time, 4 min.

Danish med-tech company Coloplast makes innovative care products for people with intimate health challenges. To help maintain productive customer relationships and better understand the needs of patients, Coloplast migrated from an on-premises data warehouse and business intelligence (BI) solution to Microsoft Power BI, Azure SQL Data Warehouse, and other Azure services. The migration is part of a general modernization of the BI capabilities at Coloplast and is expected to provide benefits across the entire organization.

Instead of trying to predict the future, we used Azure to build a platform powerful and agile enough to be ready for any future.

Data-driven care

People with intimate health challenges need products that are clinically effective, convenient, and discreet. They want to maintain their mobility, independence, privacy, and dignity. They want to live their lives, love their families, and do their jobs. They want to be themselves. So, they need to feel understood by their healthcare providers.
Headquartered in Humlebaek, Denmark, Coloplast develops innovative ostomy, continence, urology, and wound and skin care products that make life easier for people with intimate healthcare needs. The company works to build close, meaningful relationships with care providers and patients, so it can work with them to find new ways to deliver the care products people deserve.
Building that level of business intelligence (BI) can be complex for a manufacturer with eight production facilities, a diverse range of regional reimbursement processes, and a customer base that includes distributors, insurers, providers, and millions of patients in 138 countries. That’s why Coloplast uses Microsoft Azure to drive its decision making—and business performance—with data.

Ready for any future

With a high usage of spreadsheet- and PDF-based reporting, Coloplast business users struggled to find information and generate actionable insights. The company needed more agility and usability to accommodate a higher scale and more diverse types of data, and to efficiently serve a growing BI user base across the enterprise. It wanted powerful but cost-efficient analytics and adaptable data models, from dashboards for executives to predictive modeling for financial analysts. Most important, the company wanted a flexible platform it could use as a foundation for future growth and innovation.
“Instead of trying to predict the future,” says Anders Reinhardt, Director of Business Intelligence in the Global IT Organization at Coloplast, “we used Azure to build a platform powerful and agile enough to be ready for any future.”

Performance, versatility, insight, and value

The company used several Azure platform as a service (PaaS) components to develop a cloud-based enterprise data warehouse for BI and reporting that ensures continual relevance, elastic scalability, robust back-end performance, and a versatile, simple user experience. The solution draws data from the company’s customer relationship management, enterprise resource planning, and other systems. Azure Data Factory is used to extract data, and then it is stored and modeled in Azure SQL Database. Finally, data is processed in Azure Analysis Services and presented with Microsoft Power BI Premium. For more advanced reporting, data is staged in Azure Data Lake and then populated into Azure SQL Data Warehouse for additional processing.

“With SQL Data Warehouse and Power BI, we can provide powerful, customizable, self-service data analytics,” says Reinhardt. “This helps people move from fixed PDFs to interactive data visualizations that deliver more insights and better answers, leading to improved business results.”

According to Reinhardt, the Microsoft Partner Network member Kapacity was instrumental in helping Coloplast build the data platform, accelerate the migration, and successfully start its BI journey. Moving forward, Coloplast expects to introduce automation, machine learning, Internet of Things, and connected-product solutions throughout its operations.

“We want to make every aspect of our business much more data driven,” says Reinhardt. “Migrating to SQL Data Warehouse will help us to generate more value by managing data in a different and more modern way.”

Better analytics, better experiences, better outcomes

By upgrading from its on-premises systems to Azure data services and Power BI, Coloplast has shifted the focus from software maintenance tasks to development and architecture—and better analytics. Coloplast is building a significantly better experience for its BI analysts and consumers alike, replacing thousands of fixed PDF reports with a fully interactive BI experience. And with more and faster insight into consumer histories, behavior, and requirements, Coloplast can continue to drive process and product innovation.

“We’ve used SQL Data Warehouse and Data Lake to build a platform with more flexibility and transparency, along with the capacity to turn data into valuable insights throughout the organization and help drive better outcomes for people with intimate healthcare needs,” says Reinhardt.

Find out more about Coloplast on Facebook, LinkedIn, and YouTube.

We’ve used SQL Data Warehouse and Data Lake to build a platform with more flexibility and transparency, along with the capacity to turn data into valuable insights throughout the organization and help drive better outcomes for people with intimate healthcare needs.

Free webinar: Learn how Coloplast delivers insight-driven care with modern data warehouse

Discover more on how Coloplast migrated from legacy data warehouse and BI tools to a modular, cloud-based BI platform

Discover more related articles per industry:

Education

  • Unlock the potential of your students with Microsoft’s new Learning Accelerators

    Unlock the potential of your students with Microsoft’s new Learning Accelerators

    Personalized learning is a goal that educators everywhere have been trying to achieve for years. But the pandemic shone a light on the complexity of that challenge for teachers, who face a more diverse set of student needs than ever before.  Because delivering a truly personalized learning experience for every student has traditionally required lots […]

  • Northern Ireland moves to cloud-first education

    Northern Ireland moves to cloud-first education

    Northern Ireland moves to cloud-first education All teachers in the region now being equipped with Surface Pro laptops Transforming how education is provided in Northern Ireland over the next decade is a crucial goal for the region’s Education Authority.  To meet digital skills needs over that period and beyond, the authority is implementing a versatile […]

Finance & Insurance

Government

  • Two people inside using Surface Go in office

    How technology is transforming the work of governments

    Governments have the ultimate responsibility to their citizens. People depend on the services they provide like no other institution. Whether in healthcare, education, business, roads, railways, water – it’s essential that government institutions are always at the forefront of social and digital trends. Cloud-powered technologies are playing a critical role in helping government agencies to […]

Healthcare

Manufacturing

  • 9 ways to turn your field service centre into a profit centre

    9 ways to turn your field service centre into a profit centre

    A service that generates more profit than cost: it’s the ultimate goal for any organisation. We’ve listed a few tips below to help you make this dream a reality. 1. Know what you’ve got to offer Knowing what you’ve got to offer and knowing how (potential) customers view your story are important elements in marketing […]

  • a group of people in a pool of water

    Overcoming a sea of data with Microsoft Azure

    With 12,000 ships certified, DNV GL’s job of ensuring they’re built safely and remain safe should be overwhelming, especially with the more than 50,000 inspections it must carry out each year. However, by making use of machine learning algorithms in Microsoft Azure, the company is not only increasing efficiency and satisfying its customers, but it’s […]

Retail

Discover more related articles per dossier:

Customer Stories

  • Sacred Heart Tullamore achieving sustainability through reimagined learning

    Sacred Heart Tullamore achieving sustainability through reimagined learning

    Irish rural secondary school has boosted sustainability and increased collaboration, while building a deep culture of trust through its innovative approach to education.  Sustainability and promoting collaboration are vital goals in education today. Sacred Heart Secondary School in Tullamore, Co Offaly is achieving both by harnessing the transformative power of digital tools in education.   “We […]

Digital Transformation

  • Female CEO leading a business meeting

    Pain-free business modernisation

    Digital transformation. You’ve heard the phrase a million times. But what does it actually mean? A quick search will bring up 519 million results. So, it’s fair to say there’s no shortage of info out there – much of it useless, overcomplicated and adding to the noise. So, how about we think of it this […]

Press

  • Image of a man and woman smiling

    Microsoft and Connect at Catalyst Inc

    Microsoft and Connect at Catalyst Inc It’s an exciting time to be working in the technology sector in Northern Ireland. More than ever before we’re seeing increased numbers of entrepreneurs, start-up businesses, and indeed multinationals setting up in the North. Working together and learning from each other encourages a strong technology ecosystem and ultimately yields […]

Security & Privacy

Tips

  • Group of two female and one male office workers brainstorming in informal office setting. Both women are using laptops while the man is writing. Large screen shown in background.

    2019 Modern Selling Trends in 5 webinars

    The relationship between buyers and sellers grows more complicated each day. Every potential partnership requires finding the right buyer, fully understanding their business, tracking progress through the buying cycle, and engaging them with the right content—when and how they want it. These shifting dynamics underscore the artistry of modern selling. When the time is right, […]