For companies

Client case · Cogas

A first dashboard combining financial data and asset data

For Cogas, Student Consultant linked financial data to asset data to provide strategic insight into project progress. The result: a first Power BI dashboard and a handover and advisory report.

Student Consultant Cogas

Situation

Network operator in Twente

Cogas is the regional network operator in a large part of Twente and the Salland municipality of Hardenberg. It is responsible for developing, constructing, maintaining and managing the networks for gas, electricity, (sustainable) heat and telecommunications. Accurate insight into project progress is a prerequisite for strategic decisions on continuity and expansion.

Cogas tracked project progress mainly on the basis of financial data. Reports on quantities were not linked to it. Because down payments and costs are made before tasks are carried out, a project could appear further along than it was in practice.

The question was therefore whether Student Consultant could link the financial data to asset data, to gain insight into project progress at a strategic level. Cogas wanted to see this in the form of a dashboard.

Approach

From data assessment to dashboard

  1. Project planOur student consultants started with a project plan that mapped out deliverables, activities, stakeholders, risks and mitigating measures.
  2. Data assessmentA dashboard requires structured and reliable datasets. A data assessment mapped and evaluated the relevant datasets, so that the data in the dashboard is actually correct.
  3. Dummy dashboardStudent Consultant then created a dummy dashboard to map out the desired situation. This made clear which visualisations were wanted.
  4. First version in Power BIA first version of the functional dashboard was then built in Power BI. Due to limitations in the available data, it could not yet be built in full, as Cogas had already expected. Obstacles and next steps were recorded in a handover and advisory report.

Result

Next steps towards a full dashboard

  • DashboardFirst version of the functional dashboard in Power BI
  • Advisory reportHandover and advisory report with next steps towards the desired situation

At a glance

  • DashboardFirst version of the functional dashboard in Power BI
  • Advisory reportHandover and advisory report with next steps towards the desired situation
Client case
Cogas
Published
10 September 2024

Curious what we can do for your organisation?

Choose what suits you. Prefer email? info@student-consultant.nl

Four student consultants of Student Consultant

  • Prefer to talk to someone?

    Schedule a call with one of our student consultants right away.

    Schedule an introduction

  • Free tailored proposal

    Tell us what you are facing and receive a proposal within five working days, guaranteed.

    Request a proposal

  • Find out in 2 minutes whether we are a good fit?

    Answer 6 short questions and receive a personal fit check.

    Take the check

Curious about our rates? Download the brochure

Receive the brochure with our rates

Read about our approach, rates and previous projects. Enter your email address and we will send the brochure straight to your inbox.

We handle your data with care, see our privacy statement (in Dutch).