Automated Reporting - Simplified and automated report capabilities – With the ability to change the currency during analysis
Data Visualization - Easier comparison of key assumptions / output across countries (to enable focused review discussions)
Off-Line Usage - Ability for forecasters to utilize the forecasting tools off-line
Restricted Data Access - Users can only see the data relevant to their region / country and / or products
Rockhop started by creating a consolidated data tool, which combined the data from various excel forecasts with different structures and formats – once this was established, we were able to create a custom Power BI dashboard for Sobi which detailed 11 key products and has the ability to add further products when required.
Better data and forecast consistency / transparency – creation of a single source of information, which is comparable across regions through the adoption of a consistent forecasting structure for each product
Improved efficiency – data is accessed by many users during the course of the year, a simple Power BI dashboard has decentralized some key data / assumptions allowing business users to identify insights for their own questions (as opposed to requesting data from a small number of central users)
Clean data - clean, crisp data visualizations detailing; market share, product, volume, and revenue forecasts
Pre-filed assumptions - Pre-filled data assumptions / forecast logic with 10-year forecasting period
