Case Study.

Advised on data strategy, defined the Data Architecture, built the Azure Infrastructure, Data Integration (ETL), Data Warehouse & developed the Power BI Data Model.

EFT

Client
EFT
Company

Hendrerit. Eveniet ultrices maxime

Industry
Debitis natus illum fugit

What we did.

EFT helps build, protect and maintain their client’s property, life safety and security assets.
They heard about The Data Crew through a mutual contact helping them with their Power BI reports.

1.

The Goal and The Challenge

EFT use a finance system that captures their engineers’ time on jobs. They wanted to build around engineer performance which would let them see:
  • how much time do engineers spend on jobs
  • Profitability
  • Overtime
  • Wasted Time
  • Insights on how the business operates

Their current solution had limited reporting and no dashboarding or anything to make it easy to “see” what’s happening.

EFT didn’t have an in-house data or IT team and outsourced these departments to a third party. They were leaning on a Power BI contractor to cover all these requirements.

2.

Solution

We started off working with them in an advisory role. After a few meetings and complimentary consulting sessions, EFT decided they wanted to engage us to build a “Managed Data” solution. The long-term plan was to create an environment that could scale with their future data requirements, eventually moving into Machine Data and the Internet Of Things (IoT) data sources.

The Data Crew stepped in to help. We proposed building on the Microsoft Azure Platform.

The Data Crew’s Azure Data Engineers were to deploy a secure infrastructure and productionise the reports they’d already done in their proof of concept with their contractor. To do this, they’d need:

  • Azure Platform Subscription provided by The Data Crew via their MS Partner
  • Azure Networking & VPN
  • Azure SQL Database for the Data Warehouse
  • Azure Data Factory for ETL and Integration
  • Power BI
  • The engineering between the platform and Power BI that would Extract, Transport and Load (ETL) the data

They’d need to manage this in a secure environment. We created secure links between on-premise servers and the Data Platform so it could send all the data to the Azure-based platform. The system would create the Power BI reports from the Azure SQL Database.

3.

Complete Service Build & Support

ETFs are SME organisations without the need or resources for an in-house data team, and so they took advantage of our excellent value, “Fully Managed Data Platform Service”.

Because EFT Systems opted for the “Fully Managed Data Platform Service”, the infrastructure build, implementation of the secure Azure Data Platform and the ongoing management of the system are all included in the single monthly service cost.

With no upfront costs, this was a significant bouns to EFT Systems.

With all the infrastructure and security taken care of, EFT Systems can focus on creating compelling visualisations and reports for the wider business served by Power BI. The Data Crew deal with everything up to that point.

Instead of needing to hire a full-time Data Engineer, Data Architect and an Azure Architect, they get our knowledge, support and expertise at a fraction of the cost when they need it.

4.

Outcomes & the Future

The outcome is a “Fully Managed Data Platform Service” with access to our fractional expertise at a profound saving than building an internal team. We are just a phone call away for any matter that needs our attention.

EFT Systems continue to experience massive ROI with our cost-effective monthly management and support contract. As a cloud service provider for Microsoft, we can bring significant value with our ongoing support and services.

The plan for the future is to get proactive monitoring up and running with IoT directly live-streamed from each customer site. They’ll be able to detect security and maintenance issues earlier and make effective decisions to save time and resources. EFT Systems now have a Data Platform that can scale with their business.

Say hello and see how
we can help with your next project

Learn More

Partners & Technology

We partner with our suppliers & technology providers to provide a best in class service.

The Data Crew

The Data Crew is a Data Consultancy & Data Technology company.

We are a friendly, knowledgeable & helpful bunch focused on helping our clients manage their data and navigate the complex world of Business Intelligence & Data Analytics.

Documents

Privacy Policy June, 2020
Modern Slavery Statement June, 2020
Data Protection Policy June, 2020
Information Security Policy June, 2020
Terms & Conditions June, 2020
ICO Registration Certificate Jan, 2021

Quick Links

Contact Us

Address

Didsbury Business Centre
137 Barlow Moor Road
Didsbury Manchester
M20 2PW

Phone

UK : 0161 240 1471

INT : +44 161 240 1471

Email

hello@thedatacrew.com

2022 © All Rights Reserved. The Data Crew
Twitter Linkedin Github