endorsedOngoing

Data Warehouse for Higher Education Consulting Company

Services Covered:

Big Data Analytics and Business Intelligence

Industry

Advertising & Marketing

Duration

83 months

Budget

200K - 999K

Start Date

1 September 2019

Team Size

11-15 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

74/100

Good

Project Capability Score (PCS) estimates how capable Britenet 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

TEB Akademia

Poland

Project Summary

Britenet built a data warehouse and analytical structures for a higher-education consulting client (TEB Akademia), using Microsoft and Pentaho technologies. The engagement included ETL with Pentaho Data Integration, a SQL Server database, and production of Power BI reports and documentation. The client launched BI reports from the warehouse and praised Britenet's high-level project management and close partnership.

Key Challenges

Prepare a Data Warehouse and analytical structures to build the Retention Report
Enable re-writing of existing reports and support ad-hoc analysis
Provide presentation and analysis capabilities across data sources

Project Deliverables

Data warehouse built on Microsoft and Pentaho platforms
ETL implemented using Pentaho Data Integration
Data integration layer and relational data warehouse structures
Power BI retention report and analytical structures
Analytical and technical documentation

Project Solution

Britenet designed and implemented a data warehouse architecture and analytical structures using Microsoft SQL Server (SQL Server Database 2017) and Pentaho Data Integration as the ETL tool. The scope included analytical work, preparation of the data integration layer, building the relational data warehouse and analytical structures in Power BI, creating a Retention Report, and producing analytical and technical documentation. Data sources included CRM, SKS, and Excel dictionary files.

Project Outcome

Launched BI reports based on the new Data Warehouse
Delivered strong project management and a flexible, committed partnership
Enabled ad-hoc analysis and rewriting of existing reports for the client

Platforms

Cloud

Tech Stack

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Thanks to Britenet's efforts, the client was able to launch their BI Raports based on their data warehouse. The team's project management was at a very high level. They were flexible and committed to the organization's goals.”
Dawid Pawlak
Head of Marketing Research & Analysis Dept
Date: 03/27/2023