AssurTous BI

Client
Atlantique Assurance - Insurance
Services
Business Intelligence
Date
Feburary 25th, 2022
Technologies
PowerBI, MySQL, Django

Our
Challenge

  • Lack of visibility into the adoption and usage of the new digital insurance product
  • Raw data in MySQL lacked structure for effective analysis
  • Poorly maintained and inconsistent dimension tables (e.g., partners, products, locations)
  • Manual data correction processes causing delays and errors
  • Limited data governance and update traceability

Solution &
Result

We delivered a two-part solution:
 1. A reporting and dashboarding system in Power BI for executives and analysts.
 2. A robust Django-based platform for managing and enriching raw dimension data to ensure clean and trusted analytics inputs.
MySQL data integration and transformation
Django-based platform for data cleaning and dimension management
Power BI dashboards for claims, policies, product performance, and customer insights
Star schema modeling for analytical consistency
Automated ETL workflows and scheduling
Role-based access control for dashboard users and data editors
Audit logs and version tracking on critical dimension changes
Export-ready views for advanced analytics or regulatory reporting,
Next Project
DisHub

Related Projects

We have an experienced team of production and inspection personnel to ensure quality.

Maviance BI
Business IntelligenceSaaS Solution
End to end Business Intelligence Project to product dashboard for teams.
PowerBIMySQLToolJet
Ecobank Training
Business Intelligence
Training Project: Data Manipulation Techniques with Excel & Power BI at Ecobank
PowerBIExcel