- visvero
- October 9, 2024
Data integration and business intelligence using Power BI, Azure for Atricure
About the Client:
Atricure is a leading provider of innovative technologies for thetreatment of Atrial Fibrillation (Afib) and related conditions. TheirIsolator® Synergy™ Ablation System is the first medical device toreceive FDA approval for the treatment of persistent Afib.
Other devices e.g., AtriClip Left Atrial Appendage Exclusion System products are the most widely used LAA management devices worldwide.
Industry
Life Sciences, Medical Devices
The Project Challenges:
Under the scope of the project, Atricure sought to implement BI dashboards to provide top management the tools toeffectively make decisions based on their data.
The application was required to integrate internal data from Microsoft Dynamics GP applications, public data, partnermanufacturing data, and various localized structured and non-structured data.
The current manual process was labor-intens ive requiring several hours of data collection and creation activity requiredfrom regional sales analysts and sales professionals. Additionally, with several manual processes required to make dataavailable, the accuracy and timeliness of the information was not reliable.
Visvero’s Solutions Approach:
Visvero leveraged our Agile Analytics Success Framework to provide executive management a near-real time visibility ofall sales operations. The application has a potential to be expanded to include various other operations as well.
Visvero built applications to
-
Deploy the SQL Server SSAS sales analytics data model
-
Implement the pre-configured GP Sales Analytics Cube and the develop required ETL to source data from Dynamics GP.
-
Design and develop strategic sales analytics applications
-
Overall Performance & Results:
After implementing Visvero’s proposed solution, the client quickly overcame the hurdles that resulted in below outcomes:
-
Reduced the overall effort to make the applications available by over 14000 hours each year
-
Reduced the lag in sales data availability from 15 days to 4 hours
-
I implemented a company wide data governance method for sales data,