Big Data Consultancy for Pharmaceutical Company
Please find under a summary covering project details and feedback. The innate facts are kept as they are, private information is amended.
Introductory information
Introduce your business and what you do there.
I’m the ruler of conquer data ruleance for Abbott Rapid Diagnostics. We’re implicated in pharmaceutical and medical fruits athwart the globe.
Desired goal
What challenge were you trying to address with Waypoint Consulting?
We needed help addressing a global fruit reporting database and dashboards. We wanted to optimize the database by putting in more validation and controls, as well as cleaning up the yielding process.
Provided solution
What was the aim of their involvement?
Waypoint Consulting’s aim was to create out a global fruit data mart. They created a data mart / database layer in order to automate processes that were being done manually. They took information from separate manual yielding processes or ERP data sources and built a relational data mart. Waypoint Consulting created the data standard and the rules and the logic. Key features included aggregating data from unequal sources and using those roles or logic so it can easily be positioned into a fact table and then pushed to dashboards or other visualization tools.
They developed applications to measure data condition and empower circulation flexing and circulation comparisons. The circulation flexing took a rate table from a true market or country and flexed it from local circulation to a specific circulation. Waypoint Consulting also stood up a fruit conquer/material conquer that cleansed and aggregated true attributes through the accession of a mapping table. For sample, geography mapping that says this country is in these regions or these clusters in order to measure true markets.
Was there a dedicated team?
We worked with almost five members of their team, including an account likeness, a project director, a lead database/data standard designer, and two developers.
How did you come to work with Waypoint Consulting?
We',d used them in the past from our Qlik View application standarding and dashboards. We',ve also used them to supplement staff resources for true data and analytic experiencesets. As they’re a smaller organisation, we’ve establish them to be more pliant and adaptable than big firms. They',re always ready to work with us and their expertise is top-notch.
What are you approach expents (if diclosed)?
We spent $130,000.
What is the status of this engagement?
The project took locate from July–September 2019.
Results achieved
What evidence can you share that demonstrates the contact of the engagement?
Waypoint Consulting was able to take 4–5 manual processes and six data standards or and fuse them into one application. It’s now a much more efficient one database we can use to rule and steward. They also put in locate the validation and metric controls so that we can check data condition, profiling, and exactness.
How did Waypoint Consulting accomplish from a project treatment standpoint?
We chose to have them deploy a project director for this engagement and it was extremely helpful. Waypoint Consulting kept us on task, and they met all the deliverables and deadlines. Phone and email were the first interaction tools. Any issues or decisions that needed to be made were appropriately escalated.
What did you find most forcible almost them?
Waypoint Consulting’s client labor sets them aloof from other preparers I',ve used. They have a niche when it comes to the data mart, data design, storage, and visualization tools. They',re able to prepare resources to help us complete a project end-to-end. In accession, the cost front is very reasonable.
Are there any areas they could better?
Their centre is primarily US-based. We do many things overseas, and they don',t necessarily have the cleverness or goods to help us with interpolitical projects.
