Projects

  1. Home
  2. Projects

Our projects are generally due to the nature of any commercial data, but here's a few with public datasets or anonymised.

Analysis Services – MDX
Analysis Services – MDX

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

Analysis of Road Accidents
Analysis of Road Accidents

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

On-Prem Licencing
On-Prem Licencing

Provide server systems and licence consultancy to support data solutions.

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.

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

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.

    Cart