MRMC Bringing insurer data into a consolidated reporting view.
MRMC, an insurance consulting company based in Malaysia, needed a way to bring insurer information together for reporting. Datavrex built data preparation workflows in Databricks and connected the refined data to a Power BI dashboard shaped around MRMC’s requirements.
Raw insurer files, no common shape.
Insurer data was stored in raw Excel files on the company’s AWS environment. File structures and available fields varied by insurer and reporting period. Some files had missing or inconsistent information, and MRMC had specific calculation and dashboard requirements.
What the team needed
- Prepare source data with differing layouts for reporting.
- Account for insurer-specific fields and agreed reporting rules.
- Present the refined information in a Power BI dashboard.
What Datavrex delivered
Datavrex took the raw insurer files from the AWS environment, created data preparation workflows in Databricks, and connected the refined data to Power BI. The dashboard included custom calculations based on the requirements agreed with MRMC.
- Reviewed insurer source files and dashboard requirements.
- Prepared and refined data through Databricks workflows.
- Connected the refined data to a Power BI dashboard.
- Applied the requested custom calculations.
How the workflow is structured
AWS
Raw insurer Excel files held in MRMC’s AWS environment.
Databricks
Workflows standardise layouts, handle missing fields, and refine the data.
Power BI
A dashboard with MRMC’s agreed custom calculations.
The outcome
The project established a consolidated Power BI reporting view using data prepared through Databricks, giving MRMC one place to review insurer information that previously arrived in many different shapes.
Working with data in many different shapes?
Tell us where your data lives and what you need to see. We’ll help you plan the cleanest path to one reporting view.