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.

IoT Heatmapping
IoT Heatmapping

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

Data Integration – SSIS
Data Integration – SSIS

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

Remote Desktop Applications
Remote Desktop Applications

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

Operational Reporting – SSRS
Operational Reporting – SSRS

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

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

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.

On-Prem Licencing
On-Prem Licencing

Provide server systems and licence consultancy to support data solutions.

Pollution Data Analysis
Pollution Data Analysis

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

Provision Azure VMs & SQL
Provision Azure VMs & SQL

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

    Project Categories
    Cart