Analytical data warehouse for the Neolombard pawnshop chain
About the client
Neolombard is a valuation department that has been operating successfully in the financial sector and the pawnshop industry for more than 10 years. Over this time the company has built a network of financial branches in Moscow and the major cities of the Moscow region.
The task
The client's main goal was to ensure transparent management and to measure the effectiveness of sales, of call-center specialists, and of the business as a whole.
Goals
- →Build a dashboard with real-time updates
- →Create dashboards for call-center analytics and an NPS dashboard
- →Implement end-to-end analytics to measure advertising effectiveness
What was built
- 01
Exporting data from Bitrix24
Exporting deal data from Bitrix24 into MySQL using an off-the-shelf connector.
- 02
Retrieving marketing data via API
Pulling advertising spend from Yandex Direct (Russian ad platform) and sessions from Yandex Metrica into MySQL using online connectors and Python scripts.
- 03
Building dashboards
An online dashboard refreshing once a minute was delivered, along with analytical dashboards for the sales and marketing teams.
Result
A single MySQL-based data warehouse and the required dashboards were delivered. I provide both technical support for the existing integrations and on-request enhancements to the dashboards.