Data integration and business intelligence using Power BI, Azure for Atricure

TRACKING THE PULSE OF BUSINESS USING POWER BI

CUSTOM APPLICATIONS HELP SAVE OVER 14000 SALES HOURS A YEAR

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 belowoutcomes:

  • Reduced the overall effort to make the applications available by over 14000 hours each year
  • Re duced the lag in sales data availability from 15 days to 4 hours
  • I mplemented a company wide data governance method for sales data,
Technologies Used:
    Contact Us

    Technology consulting and IT outsourcing does not have to mean the same thing.

    Our mission is to be a reliable long term partner to make your organization self reliant.

    Our methodology is based on Agile principles, focused on strategic incremental success steps en-route to the project delivery.

    PITTSBURGH ADDRESS

    2121 Noblestown Rd. Pittsburgh, PA 15205, USA

    PHONE

    +1 (412) 539 0800

    EMAIL

    info@visvero.com