Projects

  1. Home
  2. Projects

Our projects are usually confidential due to commercial data, but here’s a few with public datasets or authorised to be anonymised.

Provision Azure VMs & SQL
Provision Azure VMs & SQL

An IoT data collection system was designed, procured and provisioned through a set of VMs

Analysis Services – MDX
Analysis Services – MDX

Data cube designed with MDX to consolidate mass financial data for self-service BI.

Data Integration – SSIS
Data Integration – SSIS

Hundreds of thousands of records need controlled loading - implemented with SSIS.

Power Apps – Site Maintenance
Power Apps – Site Maintenance

We developed a Power Apps Site Maintenance system with a SQL Server backend (SharePoint and Excel not great for more than 100 records).

Pollution Data Analysis
Pollution Data Analysis

Z-Score processing and results visualised to show group data gaps and Ozone inverse dependencies.

Analysis of Road Accidents
Analysis of Road Accidents

Key Requirement: Predict severity of accidents from combinations of road factors.

Power BI Live – Covid-19 Status
Power BI Live – Covid-19 Status

Power BI - Daily Covid-19 Critical Worldwide and Country Status across timeline

Operational Reporting – SSRS
Operational Reporting – SSRS

SQL Server Reporting Services (SSRS) used with database design to generate suite of PDF reports.

IoT Heatmapping
IoT Heatmapping

Key Requirement: Process millions of records into visual dashboards for BI.

Power BI Live – IoT Weather Data
Power BI Live – IoT Weather Data

Live Power BI - interactive dashboard of UK weather at various sites.

    Project Categories
    Cart