The Rockhop logo in the navigation bar
The Rockhop logo in the navigation bar

Otsuka Saves 4 Days of Manual Processing with Power BI

Healthcare
Predictive Analytics • Process Automation
Power BI
"Power BI has made us more efficient, overnight."
Kim Leung, Regional Business Manager
Otsuka Holdings Logo

About the Project

The Company

Otsuka Pharmaceutical is a global healthcare company with the corporate philosophy ‘Otsuka-people creating new products for better health worldwide.’ Otsuka research, develop, manufacture and market innovative and original products, with a focus on pharmaceutical products for the treatment of diseases and nutraceutical products for the maintenance of everyday health.

The Challenge

“Using Power BI has made us more efficient, overnight. We now have four days a month which can be spent on concentrating on business growth, rather than manually creating reports. The best thing for me though, is being able to access information instantly and knowing it is pulled directly from our various systems, so the integrity of the data is never in question.”

The Solution

Rockhop developed and deployed a Power BI dashboard for Otsuka, which consisted of two key views – one for Finance, the other for Operations. The dashboard extracts Otsuka’s data and presents back their performance vs targets for each of the key metrics they identified.

The Results

Through the adoption of Power BI for their reporting, Otsuka UK have saved 4 days per month of manual work in pulling the reporting together. They now benefit from increased data accuracy and are able to rely on the information in front of them without question. The entire business now has increased transparency of performance and are able to view and consume the numbers whenever, wherever – meaning they can quickly identify areas they are hitting targets and those which need more focus.

Drill down features allow Otsuka to see the detail behind the top-level metrics – so, if a metric looks odd for any reason, it’s simple and easy to investigate why it looks odd. It essentially steers them to the right place makes them look in places they might not previously have considered and access business insights instantly. In addition, the Managing Director now has a live holistic view of business performance, so he can make much more informed decisions, faster. Something they weren’t able to do previously.

You have a vision.
Our experts will help you achieve it.

Speak with a Rocker today
Microsoft Power Platform Logo
Microsoft Power BI logo
Microsoft Copilot Logo
Power Apps logo
Microsoft Dataverse Logo
Microsoft Power Automate Logo
chevron-down