Case Study

Health Care

Penumbra, Inc., headquartered in Alameda, California, is a global healthcare company focused on innovative therapies.

Penumbra sells its products to hospitals and clinics primarily through its direct sales organization in the United States, most of Europe, Canada and Australia, and through distributors in select international markets.

Implement Business Intelligence solution using Tableau & SQL Server. Developed dashboards and reports for the client services team which will be used by Management as Enterprise Information System

Solution

Datawarehouse Solution is developed which extracts data from ERP QAD and push to data warehouse residing in SQL Server . ETL process developed using SSIS

Reporting layer developed in Tableau which provides comprehensive analysis of Daily Sales , Inventory , GL information to different teams .

Sales Hierarchy level data Security is implemented in Tableau reports.

Impact

60+ reports are developed which are consumed by 500+ users through Tableau Mobile , Tableau Online

Automated PDF generated reports which are sent through email developed using Tableau web services

End to End solution implemented from data extraction , data cleaning , data warehouse and report visualization which enables client better analysis of Sales , Finance & Marketing KPIs