AssurTous BI

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

Nos
Défi

  • 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 &
Résultat

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,
Projet Suivant
DisHub

Connexes Projets

Nous disposons d'une équipe expérimentée de personnel de production et d'inspection afin de garantir la qualité.

Maviance BI
Business IntelligenceSolution Saas
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