Contact

Improvement of a dashboard in direct connection for a Business Unit of a multinational

5

Context

  • A dashboard previously developed in two phases to analyze performance (in volume) that has become too slow and time-consuming
  • Need for iteration after the second phase on a new more efficient model and highlighting the industry vision

Objectives

  • Improved performance and simplified user interface through several key steps

 

Step 1: Design

  • Review of the structure of the current report
  • Facilitation of workshops with users to review needs and expectations
  • Submit to finance and IT the results of the workshops to translate them technically

 

Step 2 : Development

  • Development of visuals
  • Coordination of the data scope with a partner

 

Step 3: UAT and roll out (test)

  • Coordination of tests with the partner and users
  • Training

Deliverables achieved

  • Collection of user needs
  • Review of the structure and content of the existing dashboard
  • Simplification of the dashboard (Model + Navigation)
  • Training and support

Key success factors

  • Knowledge of the industrial sector
  • Technical knowledge (data) for effective coordination with IT
  • Knowledge of the Power BI tool

Tools used

  • Power BI

Our other customer cases

Equity investment of fund

Analysis of the profitability of a fund’s investment

Analysing the profitability of an investment. Modelling and performance analysis | Profitability analyses | Fund
Read
Business plan

Development of a standard business plan template to support a five-year development plan

Automated business plan modelling. Support for growth operations | Modeling of growth operations | Start-up and SME
Read
Target audit

Financial due diligence of SME targets on behalf of an engineering group

Target audit in the context of an acquisition. Audit and internal control | Financial audit | Start-up and SME
Read
Power App

Creating a Power App with a validation workflow to manage requests for annual restatements

Development of an application with a validation workflow for managing annual restatements. Finance transformation | Transformation of the finance function | Mid-cap and large group
Read
Optimisation of investor reporting

Optimisation of investor reporting and creation of a valuation monitoring dashboard on behalf of a mid-cap investment fund

Creation of investor reports and monitoring of valuations using Power BI. Development of Power BI dashboards | Modelling and performance analysis | Funds
Read
BU Management

Support for the financial management of a business unit within a multinational company

Long-term support with the financial management of a business unit. Financial and operational management | Outsourced FP&A | Mid-cap and large group
Read