Pharma Co CFO+ Power BI
Our customers frequently find themselves under pressure to improve customer service and satisfaction in an environment where operational complexity is on the rise. This story is about how the CFO and the Controller office of a multinational pharmaceutical company to partnered with save on digital to design an end-to-end solution that will manage the their monthly Bi Financial Reporting and Sales reporting.
The company was collecting profitability data from 15 different office locations. Once the profitability Excel sheets were prepared by the entities and shared for further processing, data was manually reconciled (using Excel) with the figures from SAP-BO-FC and then fed into MIK, a standalone desktop app installed on each user’s PC to populate the cubes for Profit & Loss, Balance Sheet and Cost of Sales Statements. Using the MIK-Functions, Excel reports would then be prepared and shared with Management. Each round of data consolidation took about 2 weeks and was very error prone.
They needed an end-to-end solution that would provide massive savings in both time and infrastructure costs while optimizing processing time with less errors and with increased satisfaction of internal and external users.
The team at save on digital came up with a simple yet powerful solution of 3 future-proof functional, scalable and secure layers that will handle web login and data reporting interface, data storage and data visualization. These replace any local clients users are running on their desktops and ensures all users have a single view of the data. Cubes are defined on top of the sales/cost data
Microsoft PowerBI Dashboards and reports that connect to the data warehouse are used for multi-perspective views and actionable insights, based on management roles.
As a secondary reporting mechanism, Excel reports were configured to connect directly to the Data Warehouse cubes and generate reports.
Mision-Critical Business Process Automation
Data Warehouse: SQL Server for the setup of Data Warehouse. Use of SSIS to transform and load the data from Web-Application Transaction Database into Data Warehouse. Use of SSAS to define, Process and access Cube Data.
Data visualization & reporting: Power Bi Financial Reporting and Excel
- Monthly saving of ½ FTE to run the process
- Yearly saving of 1 Month FTE in modifying the reports
- Overall solution deployed over cloud, providing lot of saving in infrastructure costs.
- Faster delivery of consolidated data <1 day
- Enhanced decision making capability and high availability of data
- WebApp & Reports compatible with Mobile and PDA.
The company now has Its sales reporting and data retrieval from 15+ offices, consolidation and profit elimination on multiple grouping at Entity/Market level. Followed by consolidation of P&L, BS and CF with their accounting system.