In cooperation with:
About marpinion:
As the No. 1 in digital pharmacy communication, marpinion® ensuresthat relevant information about your products (OTC, Rx) reaches your target group in the community pharmacy precisely via the ApoChannel®. Product, indication, and consultation knowledge is presented in a didactically sound, sophisticated, and engaging manner. One in four pharmacies regularly uses marpinion's ApoChannel® forcontinuing education. In concise videos, marpinion conveys relevant pharmaceutical expertise to the pharmacy team.
The services
- Documentation and solution of the instability of the existing reporting solution
- Creating a replication to mirror the production data
- Provisioning of a new data warehouse by setting up a data loading pipeline using SQL Server Integration Services (SSIS)
- Revision of existing reports in SQL Server Reporting Services (SSRS)
The project
began with a team of Telekom and q.beyond experts analyzing and documenting the problem in the existing data loading process. They found a short-term solution, allowing for faster availability of reports. Following this, the medium-term approach was planned in close consultation with marpinion®. The
urgent need to implement changes and enhancements to customer reports was paramount, so no changes to the tools used were desired in the medium term. Therefore, a new on-premises data warehouse solution, utilizing the existing SQL Server with SSIS and SSRS, was deployed within a few weeks.
The team replaced cube generation in SSAS with the creation of data marts based on the already calculated aggregations. No pre-built tasks were used in SSIS; instead, only SQL scripts were executed to ensure easier future portability of the data loading process to another tool. Finally, the experts expanded the reporting capabilities with new functions and content. The results from the surveys are presented in a valid manner according to the cockpit of our own platform ApoChannel ®
Customer requirements
- No changes to existing tools
- Expansion of reporting to include additional functions and content
- Optimized use of IT resources
- Ensuring the long-term flexibility of the tool landscape is a priority
Project goals
- Automated and future-proof data loading
- Improvement and expansion of direct customer reporting
- Ensuring the operation and service quality
- Preparation for the long-term transformation and flexible design of the tool landscape
From idea to implementation: Our project highlights
"Simple, fast, and trouble-free cooperation: The collaboration with Telekom and q.beyond was consistently efficient. All processes were implemented quickly and without problems. We were particularly impressed by the professional and smooth handling – from the first contact to the successful completion of the project."
Joscha Sielemann, Managing Director of marpinion®
Sounds exciting?
Do you have any questions about the reference or our data intelligence solutions? Then please feel free to contact me. I look forward to discussing it with you.
Philipp Wehmschulte