EndorsedendorsedOngoing

ELT Pipeline & Dashboard Development for Education Company

Services Covered:

Big Data Analytics and Business IntelligenceData Engineering
Project hero — replace with case study imagery
Industry
Industry

Education

Duration
Duration

2 months

Budget
Budget

Confidential

Start Date
Start Date

1 October 2023

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
77/100
Good

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

Confidential

mapCincinnati, United States of America

Project Summary

Sigma Software Group built ELT data pipelines, configured a ClickHouse database, and developed dashboards for an education company. The dashboards were delivered on time and received positive user feedback, reducing support tasks for data requests.

Key Challenges

  • Build internal dashboards to track, evaluate, and act on business status
  • Provide customer-facing dashboards for direct access to insights about product usage and impact

Project Deliverables

  • ELT data pipeline architecture and implementation
  • ClickHouse database configuration
  • Dashboards for internal analytics, sales demos, and external customer self-service
  • Row-level security for multi-tenant data privacy
  • Documentation of data models, charts, and filters

Project Solution

Sigma advised on architecture for ELT data pipelines and ClickHouse configurations, built dashboards for internal analytics, sales demos, and customer self-service, implemented row-level security for multi-tenant data privacy, documented data models and reports, and assisted with technical implementation challenges.

Project Outcome

  • Dashboards delivered on time
  • Increased user satisfaction and excitement
  • Reduction in support tasks for retrieving data insights

Platforms

  • WebWeb

Tech Stack

  • ClickHouseClickHouse

Client Endorsement

Overall Review Rating

5star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

Sigma Software Group has delivered the dashboards on time, which has received positive feedback from users. The team goes above and beyond to ensure the project's success through a communicative process. The team is committed to the engagement through an amicable approach.

Anonymous

Head of Engineering

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Sigma Software Group