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.

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).

Provision Azure VMs & SQL
Provision Azure VMs & SQL

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

Remote Desktop Applications
Remote Desktop Applications

Minimising hardware and licencing costs, Remote Desktop was used to connect users to inexpensive dedicated servers.

Analysis of Road Accidents
Analysis of Road Accidents

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

Data Integration – SSIS
Data Integration – SSIS

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

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

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

Analysis Services – MDX
Analysis Services – MDX

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

IoT Heatmapping
IoT Heatmapping

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

Operational Reporting – SSRS
Operational Reporting – SSRS

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

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

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

    Project Categories
    Cart