Romain Guery-OdelinConsulting · Social housing provider · overseas · 2023 · BI consultant, within the project team
Reporting applications for a social housing provider
Steering an overseas rental market from a distance calls for indicators you can trust. Four months of data analysis, from the database to the dashboard, for around 300 users.
Context
National social housing provider, for its overseas activity, in 2023: a four-month assignment. My role: BI consultant within the project team, from defining the indicators through to training the users.
The problem
Steering a rental market thousands of kilometres from head office needs figures that are reliable, up to date and understood the same way by everyone. Without that, every meeting starts with an argument about the data instead of a decision.
What I did
- Defined the KPIs with the business teams: what to measure, how, and what each indicator means.
- Day-to-day data analysis: database queries, consistency checks, building the applications in QlikView and Qlik Sense.
- Fed the databases through ETL flows, so dashboards refresh without anyone touching them.
- Acceptance testing with users, indicator by indicator, before each release.
- Enhancements as usage grew, whenever a need surfaced in a meeting.
- Trained the teams so they could own the applications and keep them alive after the assignment.
The result
Around twenty dashboard applications on the rental market, used by around 300 staff to steer the activity, delivered in four months by the team I was part of. This was my first consulting assignment, the one where I got my hands into the data (databases, ETL, QlikView, Qlik Sense), and the foundation of how I have worked ever since: start from the business need, deliver a tool that runs on its own, then hand it over.
Around twenty dashboard applications used by some 300 staff, indicators defined with the business, and hands-on data work: databases, ETL, QlikView and Qlik Sense.