Informatec strengthens its Data & AI expertise with Databricks With the Databricks Lakehouse Platform, Informatec unifies modern data engineering, BI, and AI capabilities to help companies accelerate innovation and create measurable business value.
Success Story SKAN AG With Informatec, SKAN AG stabilized its Power BI environment, modernized its ETL architecture, and established a future-proof, standardized BI organization.
Informatec strengthens its Data & AI expertise with Databricks With the Databricks Lakehouse Platform, Informatec unifies modern data engineering, BI, and AI capabilities to help companies accelerate innovation and create measurable business value.
Success Story SKAN AG With Informatec, SKAN AG stabilized its Power BI environment, modernized its ETL architecture, and established a future-proof, standardized BI organization.
Success Story - TopPharm Apotheken und Drogerien Genossenschaft KPI as a Service – TopPharm Implements Qlik-based Web Platform for Sell-out Data“With the Qlik-based web platform, we offer our industry partners the ability to access their sales data flexibly and according to their individual needs at any time. This modern service strengthens partner relationships and helps solidify them.”Kim Kläusler, Data Management Analyst, TopPharm Apotheken und Drogerien Genossenschaft. The customerTopPharm Apotheken und Drogerien Genossenschaft, with around 120 independent pharmacies and over 1,800 employees, is the largest independent pharmacy group in German-speaking Switzerland. Founded over 30 years ago, the cooperative emphasizes quality, transparency, fairness, and innovation to strengthen the profession of independent pharmacists in the long term. The focus is always on meeting the needs of partner pharmacies with the highest quality. Thanks to its democratic structure, each member has a clearly defined right to participate. The unique strength of the TopPharm group lies in its employees, who are the first point of contact for all health-related questions—personal, competent, and discreet.The project team from TopPharm consisted of Stefan Dahinden and Kim Kläusler. Solution at a glance Industry: Pharma Function: Providing sales figures for external industry partners Region: Switzerland Data sources: Microsoft SQL Server Utilized technologies: Qlik Sense Client Managed, Qlik Mashup, iVIEW Dataflow, iVIEW Library ROI & Time-to-value: KPIaaS as a service to generate revenue and strengthen customer loyalty Initial situation Key Figures as a Service OfferingTo provide better insights into essential sales metrics to its approximately 85 industry partners, TopPharm wanted to establish a web-based platform that allows external access to customized sell-out data based on master and sales data from a Microsoft SQL Server instance. The goal was to both strengthen relationships and create added value for industry partners.“In the past, we provided our partners who participate in the annual industry discussions with semi-annual static reports on sales figures,” explains Kim Kläusler, Data Management Analyst, TopPharm Apotheken und Drogerien Genossenschaft. “However, we want to offer our industry partners more: the ability to independently access data monthly and tailor it to their specific information needs.”It was crucial for TopPharm that the platform be easily and securely accessible to industry partners through standard browsers, with data stored exclusively in Switzerland. Other essential requirements included limiting data display to products negotiated with each partner, providing monthly evaluations with year-on-year comparisons, and offering filtering and scaling options for different display formats. Additionally, the cooperative desired export options, such as downloading reports in Excel and PDF formats. The design had to align with TopPharm’s corporate identity. Qlik Sense Freedom for the intuitionQlik Sense is a revolutionary application that enables anyone to create self-service data visualisation, personalised reports and dynamic dashboards.QLIK SENSE Solution Informatec Impresses with Qlik and Cloud ExpertiseDue to its long-standing positive experiences with Qlik in the context of data analysis for management and various departments, especially the “Purchasing and Industry” department, TopPharm decided to use Qlik Sense for this project as well.TopPharm entrusted the implementation of the web platform to Informatec, a trusted partner with whom the cooperative has been successfully collaborating for several years. “Their data analytics expertise, particularly in working with Qlik, is outstanding. Their solution-oriented approach has convinced us time and again.”Informatec, as a Managed Services Provider, also brings cloud expertise, offering a Managed-BI-Cloud environment with Swiss BI Cloud on Azure, where clients’ BI infrastructures are hosted in a Swiss data center—a key point for TopPharm, as the operation of Qlik Sense should be cloud-based.IaaS + iVIEWBased on TopPharm’s precise requirements, Informatec developed a tailored BI solution, fine-tuned in close collaboration with TopPharm. TopPharm found the cooperation with Informatec to be extremely professional and cooperative. “Informatec always had an open ear for our needs, and we felt confident in receiving a flexible, customizable solution tailored perfectly to us. We especially appreciated the opportunity for regular exchanges due to their proximity.”Qlik Sense is operated as a Client-Managed installation in the Swiss BI Cloud. Informatec ensures smooth access and operation with an “Infrastructure as a Service (IaaS)” offering, which includes 24/7 operations per Service Level Agreement (SLA), incident management, as well as services such as backup & restore and sizing. The seamless data and distribution process of KPIs is ensured by the iVIEW Data Automation Framework, a Qlik-integrated toolkit developed by Informatec. Application area and users Added Value for Industry PartnersThe web platform was initially made available to ten selected industry partners, providing data on around 940 products. “Each of these partners ultimately uses their own Qlik application, accessible via an individual URL and corresponding two-factor authentication,” explains Kim Kläusler. “Through a dashboard in TopPharm’s design, they can retrieve, filter, and export precise sales data for selected products, gaining valuable insights into sales figures and trends that help optimize their business strategies.”The data can be filtered by time dimensions such as month, quarter, and year, as well as by product lines and pharmacodes, enabling tailored analyses. Available metrics include the cumulative sales values of an article from the start of the calendar year to the current date (YTD sales value) or rolling over the last 12 or 36 months (MAT sales value). Visualization in chart form, for example, allows tracking the sales values of nasal spray over five months or graphically comparing values of different products.The basic package includes a defined number of freely selectable contract products, with options to add more contract and non-contract items if needed.The feedback has been very promising, says Kim Kläusler: “We sent out a survey where partners could also share their wishes for further optimizing the solution. The response has been very positive. Industry partners appreciate the ability to easily access reliable, up-to-date sales data. The introduction of KPIaaS has further solidified our position as an innovative and reliable partner in the pharmaceutical industry.” 0 1 2 Future The hospital won’t be running out of areas where Qlik can serve as a navigator anytime soon: upcoming projects include applications for OR controlling, laboratory analytics, and a budgeting template. Success Story KSA Download (PDF) Download « Qlik is our central tool for providing, interpreting, and visualizing data at the cantonal hospital. It serves as a key foundation for the financial management of the organization and its individual departments, as well as for conducting analyses. » Christian Rittmann Chief Financial Officer, Kantonsspital Aarau AG « With Qlik, individual stakeholders can easily gain insights into topics relevant to them — including finance, patients, and services. And we can be confident that everyone is working with the same consistent data. » Michael Wyss Head of BI and Management Accounting, Kantonsspital Aarau AG « We use Qlik for comprehensive DRG material analysis. Additionally, key figures such as delivery punctuality and completeness, average procurement time, cost per order, and return rate are available. » Thomas Binz Head of Procurement, Kantonsspital Aarau AG 0 1 2 Summary ChallengeProviding a web-based platform to offer KPI (Key Performance Indicators) as a Service (KPIaaS) SolutionQlik Sense as Client Managed Installation, Qlik Mashup, iVIEW Dataflow, iVIEW Library BenefitsWeb access to customized sell-out dataIndividual Qlik applications for industry partners with unique URLs and two-factor authenticationKPIaaS as a service offering for revenue generation and strengthening customer relationshipsStrengthening TopPharm’s position as an innovative and reliable partner in the pharmaceutical industry.