endorsedOngoing

BI & Big Data Engineering for Entertainment & Sports Company

Services Covered:

Big Data Analytics and Business Intelligence • Custom Software Development

Industry

Media

Duration

135 months

Budget

Confidential

Start Date

1 May 2015

Team Size

11-15 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

81/100

Strong

Project Capability Score (PCS) estimates how capable Rare Crew is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Endeavor LLC

London, United Kingdom

Project Summary

Rare Crew designed and implemented end-to-end BI and data-integration solutions for an entertainment and sports company, using SSIS and a mix of Databricks, Azure, and Snowflake. They delivered ETL pipelines, data-warehouse solutions and Power BI reports, automated workflows with PySpark and Airflow, and provided documentation. The engagement improved data integration, reduced processing time and enhanced decision-making.

Key Challenges

Build end-to-end business intelligence solutions
Build data applications to support business processes

Project Deliverables

Robust ETL pipelines and data integration solutions
Data warehousing solutions
Interactive Power BI reports and dashboards
Automated data workflows using PySpark and Airflow
Detailed documentation and milestone-based deliverables

Project Solution

Rare Crew delivered a broad set of data-integration and BI services across more than 40 projects, designing and implementing ETL/data integration solutions using SSIS and related tools. They performed data source analysis, mapping and transformation design and leveraged Databricks, Azure and Snowflake for storage and processing. They automated workflows with PySpark and Airflow, built interactive Power BI reports, and provided detailed documentation while meeting critical milestones.

Project Outcome

Significant improvements in data integration and analytics processes, increasing operational efficiency
Deliverables (ETL pipelines, data warehouses, Power BI reports) enabled faster, more accurate data-driven decisions
Consistent on-time delivery and positive feedback on project management and flexibility

Platforms

Cloud

Tech Stack

Azure
Azure DataBricks
Snowflake
PySpark
SQL

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Rare Crew has consistently delivered quality output, notably improving the client's data integration and analytics processes. The client has enhanced decision-making and reduced data-processing times. Rare Crew's project management, communication, flexibility, and professionalism are commendable.”
Marc Scudder
SVP Data Services
Date: 12/18/2023