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

Finance & Insurance

Government

  • a woman sitting at a desk using a computer

    4 reasons Citrix and Windows Virtual Desktop are better together for government agencies

    Government agencies all over the world experience a huge transformation. Obviously, because of the COVID-19 pandemic the trend of remote work has taken off in ways nobody could have imagined a year ago. Since offices closed and civil servants needed to stay in their homes, remote work collaboration was the only option to continue serving […]

  • Citizen-Experience-Image

    A focus on Citizen Experience drives public sector transformation

    In recent times, providing a responsive and efficient service that meets citizens’ expectations has become a priority for public sectors across the EU. But as citizen experience (CX) – such as improving citizen satisfaction and providing efficient digital services – takes center stage, many national, regional and local government organizations are falling behind. Governments must […]

Healthcare

  • A woman undergoing a scan

    Predictive maintenance is improving quality of life for cancer patients

    With cancer affecting more than 17 million people annually, a figure set to rise dramatically in the coming years, efficient and cost-effective treatment is essential. Since deploying Microsoft Azure IoT, IBA Worldwide, a leading developer of medical equipment for cancer treatment, has been able to reduce the cost of maintenance and improve repair times for […]

  • One nurse is holding a Surface Go 3 and Surface Pen while sharing the screen with another nurse.

    Caring for nurses: How technology can support the frontline of healthcare

    Nurses make up around 70% of the healthcare workforce, providing the vast majority of direct care to patients in the health service. But despite playing such a major role, the job of nursing is becoming more and more challenging and the churn rate is increasing. Demographics show that the population is aging across Europe, with […]

Manufacturing

  • A Volvo car in the snow

    Volvo uses AI to help keep eyes on the road

    Distraction is a leading cause of road accidents. Volvo teamed with Microsoft to better understand driver attention and emotion using AI.

  • a man holding a paint spray

    What we can learn from AkzoNobel’s digital transformation

    Savvy businesses are always on the lookout for ways to improve what they do and differentiate themselves from the competition. From organisational restructure to the development of entirely new business models, the quest for continuous improvement takes many forms. But one common factor in almost all modern business leaders’ plans is an emphasis on technological […]

Retail

  • Shopkeeper tending a customer in a clothing store

    Blending the physical and digital retail experience? Add a splash of data!

    There is a simple truth at the heart of the retail sector – if you don’t look after your customers, someone else will. The fight for customers has intensified in recent years and shows no sign of cooling down. The retail success stories of the future are expected to be a smart and seamless blend […]

  • A woman wearing HoloLens

    Natuzzi: A new way of seeing your home with HoloLens

    In retail, the gift of the sales rep has always been to conjure up a vision for the potential buyer. Transport them to another world, surround them with artefacts – imagined or otherwise – that complete a picture in which the customer can envisage themselves. Because when we buy, we buy into something. The object […]

Discover more related articles per dossier:

Customer Stories

Digital Transformation

Security & Privacy

Tips

  • Male store associate helping female customer in tech shop

    Creating great experiences for employees and the customers they serve

    Retail is experiencing ongoing labor shortages in the aftermath of the pandemic. Many people have retired early, found new jobs, or have simply decided to leave the labor market. As competition for skilled and experienced staff has become fiercer, attracting talent and retaining staff is crucial for survival and success.  While increasing wages and benefits […]