CUSTOMER STORY | PUBLIC SECTOR
DIJIN cuts data update times from more than 24 hours to under 6 hours
In projects for the Colombian Ministry of Defence and Interior (DIJIN / GICRi), hundreds of SQL processes were migrated to a modern BI platform. Data updates now take less than 6 hours.
Data updates, from more than 24 h
<6 h
SQL processes migrated
100s
Processing time cut
70%+
OVERVIEW
The challenge.
A slow platform blocked the daily analysis.
Updates above 24 hours
Data updates took more than 24 hours.
Analysis blocked
The daily analysis was blocked by the slowness of the old platform.
SOLUTION
What was done.
A migration supported by experts, and a data lake.
Migration
TIMi experts supported the migration of hundreds of SQL processes to a modern BI platform.
Data lakes
Data lakes were implemented to facilitate reporting.
QlikSense
Native integration with QlikSense.
RESULTS
What changed.
Fresh data, quick reports, and analysis beyond reporting.
Data updates
Less than 6 hours, from more than 24 hours.
Reporting
Direct access to column archives and quick report generation.
Predictive intelligence
Text mining to detect criminal patterns across national databases, predictive models to prioritize interventions by location and time slot, and temporal analysis of thefts by police district.
USE CASES BEHIND THIS STORY
Read the method.
SEE FOR YOURSELF
Test it on your own data.
Run TIMi on your own data with a free trial, or talk to us about your case.
