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.<\/p>\n
Instead of trying to predict the future, we used Azure to build a platform powerful and agile enough to be ready for any future.<\/p><\/blockquote>\n
Data-driven care<\/h2>\n
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.
\nHeadquartered 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.
\nBuilding 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\u2019s why Coloplast uses Microsoft Azure<\/a> to drive its decision making\u2014and business performance\u2014with data.<\/p>\nReady for any future<\/h2>\n
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.
\n\u201cInstead of trying to predict the future,\u201d says Anders Reinhardt, Director of Business Intelligence in the Global IT Organization at Coloplast, \u201cwe used Azure to build a platform powerful and agile enough to be ready for any future.\u201d<\/p>\nPerformance, versatility, insight, and value<\/h2>\n
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\u2019s customer relationship management, enterprise resource planning, and other systems. Azure Data Factory<\/a> is used to extract data, and then it is stored and modeled in Azure SQL Database<\/a>. Finally, data is processed in Azure Analysis Services<\/a> and presented with Microsoft Power BI Premium<\/a>. For more advanced reporting, data is staged in Azure Data Lake<\/a> and then populated into Azure SQL Data Warehouse<\/a> for additional processing.<\/p>\n
\u201cWith SQL Data Warehouse and Power BI, we can provide powerful, customizable, self-service data analytics,\u201d says Reinhardt. \u201cThis helps people move from fixed PDFs to interactive data visualizations that deliver more insights and better answers, leading to improved business results.\u201d<\/p>\n
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.<\/p>\n
\u201cWe want to make every aspect of our business much more data driven,\u201d says Reinhardt. \u201cMigrating to SQL Data Warehouse will help us to generate more value by managing data in a different and more modern way.\u201d<\/p>\n
Better analytics, better experiences, better outcomes<\/h2>\n
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\u2014and 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.<\/p>\n
\u201cWe\u2019ve 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,\u201d says Reinhardt.<\/p>\n
Find out more about Coloplast<\/a> on Facebook<\/a>, LinkedIn<\/a>, and YouTube<\/a>.<\/p>\n
We\u2019ve 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.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":523,"featured_media":154254,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1805],"class_list":["post-154267","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-customer-stories-en-ie","specials-transform-en-ie","verticalIndustries-healthcare-en-ie","stories-data-insights-intelligence-en-ie","stories-how-can-i-get-insights-from-my-data-en-ie-data-insights-intelligence-en-ie","businessPriorities-data-ai-en-ie"],"_links":{"self":[{"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/posts\/154267"}],"collection":[{"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/users\/523"}],"replies":[{"embeddable":true,"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/comments?post=154267"}],"version-history":[{"count":2,"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/posts\/154267\/revisions"}],"predecessor-version":[{"id":154270,"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/posts\/154267\/revisions\/154270"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/media\/154254"}],"wp:attachment":[{"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/media?parent=154267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pulse.microsoft.com\/en-ie\/wp-json\/wp\/v2\/categories?post=154267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}