Multi-client contact centerDMS · Glue · Iceberg · QuickSight
From four disconnected databases to a single source of truth, always up to date.
They had no shared place to analyze their four databases. Today, all four are copied in real time to a single platform that refreshes every day and sets aside questionable data before it reaches a report. It's documented so another team can run it.
4 → 1separate databases, now one up-to-date platform
Global pharmaceutical company · our team's experienceDatabricks · EMR · Airflow · Redshift
Clinical data organized to an international standard, term by term.
The team built and migrated the platforms where clinical data is processed, with automated processes that take it from raw to analysis-ready. It also aligned a 41-table model with an international clinical standard.
4,023clinical terms aligned with the standard, across 53 catalogs
B2B e-commerceDMS · AppFlow · Glue · Lake Formation
From reports built in Excel to data consolidated in one place.
Their reports were built in spreadsheets. Today, their databases and applications feed a single platform, with a catalog of what it holds and permissions that define what each person sees.
99.9%data platform availability
Lending fintechGlue Data Quality · Lake Formation
Data that checks itself, and the right access for each person.
Finding an inconsistency in their data took time. Today, automated rules check the quality of every table, and access to each piece of data is controlled.
−80%in the time it takes to find an inconsistency, compared with the previous process
Multi-client contact centerDocumentDB (MongoDB) · DMS · Glue · Athena
Their NoSQL data, replicated to SQL and analyzed alongside everything else.
Part of their operation lived in a NoSQL database (MongoDB) that couldn't be cross-referenced with the rest of their data. We replicated it in real time to SQL tables, alongside their relational databases, and today it flows into their reports and dashboards.
NoSQL → SQLreal-time replication, ready for reports and dashboards