electroCore

electroCore

Management Reporting Platform powered by Alteryx

electroCore, Inc. is a commercial-stage bioelectronic medicine company, focused on the treatment of multiple conditions in neurology, including: • Preventative treatment of cluster headache and migraine and, • Acute treatment of migraine and episodic cluster headache. Their flagship product gammaCore is a non-invasive, hand-held medical therapy applied at the neck, to treat migraine and cluster headache through the utilization of a mild electrical stimulation to the vagus nerve that passes through the skin.

Business Need

As electroCore obtained its approval from FDA and started commercially selling gammaCore, it became clear that a Management Reporting Dashboard was needed to track and frequently and reliably report performance on key metrics such as:

  • Sales vs Budget
  • Inventory Levels
  • Channel &Sales team Performance
  • Year-End Projections
  • Prescriber Activity
  • Rebate Utilization

… and more

Evaluation

Primary considerations in evaluating alternatives for the solution to be selected were:

• Rapid Deployment Shortest possible time from selection of the solution until the first report/dashboard is designed, developed, and published

• Connectivity Integration and data extraction capability with existing data sources • Agility Ability to easily incorporate changing requirements as the business grows/evolves

• Scalability Capacity to increase number of reports/dashboards and consumers/users without additional cost

• Affordability Low initial investment amount

Solution

Alteryx was selected because not only it met the initial criteria set forth, but also provided the following added features & capabilities that were fully leveraged:

  • Robust Automation & Scheduling
  • Forecasting & Predictive Analytics
  • Role Based Reports
  • Cloud Deployment providing 24/7 system availability
  • Proven solution, Leader in Gartner Magic Quadrant
  • Active user community and quality customer support

Achivement

electroCore Reporting Platform is the sole system used by Management today to track Key Performance Metrics on a daily basis, providing the capability to observe and respond to the changes in the business landscape in real time. It is deployed on a Cloud environment, and quickly expanded to support multiple departments and their reporting needs.

• 2 Weeks: Duration to publish first report

• 50+ Reports & Executive Dashboards

• 40+ Users / Reports Consumers

• 20+ Data Quality/Data Integrity verification processes

• 5 Departments Supported (Management, Sales, Finance, Compliance, Warehouse)

• 4 Data sources/System Interfaces (PostgreSQL, NetSuite, Text files, Google Sheets)

• 1 Developer License!

"Ereteam's talented BI team picked up our requirements with speed and converted them to initially a fast prototype and soon after a daily live dashboard package, delivered to key management and other decision makers via email every morning. They developed not only a package that met the requirements but developed in a manner that assured very high levels of data quality among these key reports -- a must for any management reports."
Basit Qari
VP, IT & Digital Technologies - electroCore, Inc.