Infection Control Dashboard

data

Objective

A client in the healthcare industry needed to record, analyse and report clinical audit results for several metrics across several different clinical areas.

Key challenges:

  • Creating an intuitive, user-friendly interface for non-technical users
  • Dynamically generating a variable number of performance graphs for analysis
  • Tailoring report packs and producing them at the click of a button.
2

Technical solution

Using standard Microsoft Office components (Excel, Access), data2impact was able to build a data repository and reporting tool over a very short time span. The solution provides:

  • Easy-to-use user interface including data validation to minimize entry errors and support users
  • Report generator providing several types of charts and filters selected from drop-down lists
  • Dynamic reports allowing on-the-fly browsing of results across clinical areas
impact

Result

  • Interactive dynamic charts allow users to identify poorly performing clinical areas and metrics
  • Report pack generator allows users to quickly define and produce chart based reports for distribution throughout the organisation

Daily fleet performance monitoring

data

Objective

2

Technical solution

impact

Result

Industry
Logistics
Tool type
Dashboards & heatmaps
Project duration
d2i effort
Data volume
Tools involved
Excel

Scorecard for national healthcare performance

data

Objective

An international health organization wanted a tool to track Health KPIs for countries. Each country requires a specific configuration, supporting up to 35 KPIs and 40 regions.

2

Technical solution

  • Excel-based tool, providing individual input sheets for each KPI
  • Aggregation to high-level heatmap and breakdown to the regional level
  • Export to PDF and Word
  • Support "Read-only mode" for distribution and "Admin mode" for data entry and tool configuration
impact

Result

  • Scorecard by now rolled out to 4 countries
  • Central heatmap to highlight the most important and promising health areas in countries, thus supporting the prioritization of resources allocated
Industry
Public Services
Tool type
Dashboards & heatmaps
Project duration
3 weeks
d2i effort
12 MD
Data volume
up to 35 KPIs
up to 40 regions
Tools involved
Excel
Word

P&L dashboard with rapid implementation

data

Objective

The client wanted the ability to visualize P&L data in an intuitive dashboard without having to rely on manual spreadsheet work every time. The dashboard was required in the shortest time possible.

2

Technical solution

Within a single working day, data2impact constructed an Excel-based P&L Dashboard tool capable of loading the client's data files and producing the desired dashboard.

impact

Result

The charting tool has a user friendly menu structure with “one click to create a dashboard” functionality. The combination of standard Excel charts and additional dynamically placed objects gives the flexibility to create information rich outputs.

Industry
Other industries
Tool type
Dashboards & heatmaps
Project duration
1 day
Tools involved
Excel

Project portfolio monitoring for national ministry

data

Objective

A national ministry of roads wants to track the progress and quality of all federal road building projects.

Requirements:

  • Bi-weekly aggregation of data from multiple sources (decentral project status reports, time sheets, budget and spending from central IT systems, lab results from web service)
  • Multiple reports/analyses with individual filters to provide both high level overviews and drill-down to projects/suppliers
2

Technical solution

  • Small Excel-based survey distributed to project manager for bi-weekly completion
  • Central Excel tool to consolidate data from all sources and provide reporting
impact

Result

  • Ministry achieved full transparency of all on-going projects
  • The tool facilitates stakeholder involvement across all levels, especially between vendor and project management
  • Powerful reporting functionality allows for cross-vendor comparison, supporting vendor assessment for future projects
Industry
Public Services
Tool type
Dashboards & heatmaps
Project duration
3 months
d2i effort
10 MD
Data volume
120 projects
Biweekly reporting
15 KPIs
Tools involved
Excel
No images found.
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok