« CASE STUDIES

A geospatial market intelligence platform

Centralising ‘real-time’ data and insights that facilitates faster decision-making.

Tags

Data PlatformsProduct DevelopmentSnowflakeTechnology

Date

Mar 2024

The Client

A leading mining company undertook a major shift in direction to accelerate growth by investing in greenfields opportunities.

The client chose to partner with Mechanical Rock in order to develop and deploy a "proof of concept" for a dynamic, data intelligence platform.

This platform required fully automated ingestion of industry-specific live and historical data sets to uncover key insights through geospatial data visualisation, mapping and predictive analytics.

Close up of minerals extracted from the ground

The Challenge

In the mining sector, data plays a vital role in staying well-informed and competitive in the market, especially when looking at new strategic exploration opportunities.

However, the effort required to collate up to date competitor analysis, current market data, historical mining data and combine that effectively through a geospatial lens, is a major obstacle.

Mechanical Rock was tasked to build an automated, centralised data platform, ingesting company data, but also broadening the scope to focus on non-traditional data sources, such as social channels like Twitter or financial insights and share pricing via the ASX, all through a geospatial lens.

By reducing manual intervention and surfacing insights faster the client is able to react quicker and be the first to exploit new greenfields opportunities.

Big yellow dump truck on a mining site

The Solution

A centralised ‘real-time’ data platform and dashboard that presents distinct perspectives on differing types of data and visualisation facilitates faster decision-making on potential new terrain or joint venture opportunities.

The work involved ingesting both proprietary company and nominated data sets into a Snowflake warehouse.

Our approach was to run all the compute intensive queries in Snowflake and populate the calculated results in a Postgres Aurora database for faster display and filtering using the power of AWS.

All data is available for visualisation using topographical and geospatial representations. The dashboard enables users to filter the displayed data based on various key metrics and is updated in real time, removing many hours of manual processes while enhancing accessibility to source data and insights.

High level architecture of the geospatial dashboardHigh level architecture of the geospatial dashboard


THINK WE CAN HELP YOU?

Get in Touch

Reach out to us and a member of our team will be in touch right away.

contact@mechanicalrock.io