Aircall is a French cloud-based call center and phone system and the option of choice for many modern businesses. Their voice platform integrates seamlessly with popular productivity and helpdesk tools for sales and support teams, improving the customer experience through quality telephony.
The Client wanted to build data infrastructure to deliver meaningful insights into the telephony services they provide their customers.
The Client looked for a qualified partner to build a pipeline to convert raw data from the S3 bucket into the Amazon Redshift database and visualize the data in Looker.
Python scripts and AWS Glue jobs run on a daily basis
Working data marts are updated regularly for real-time insights
Aircall customers can use flexible Looker dashboards for enhanced data analysis and improved decision-making to enhance the customer experience
You need custom analytics if
We studied the Client’s sector, in this case, telephony. We interviewed key employees to obtain raw data storage parameters and investigated the Client’s cloud environment in which its AWS environment and S3 Data Lake Structures are hosted.
As a result, the raw data from the AWS S3 bucket was converted into an Amazon Redshift database. We tuned AWS Glue to work with S3 Datalake and built a data pipeline on Python and AWS Glue to transform the data into Redshift. Then, the data was sent to Looker, which was selected as a BI tool.
To build a pipeline to convert raw data from the S3 bucket into the Amazon Redshift database, we came up with the following data transformation structure:
To enable real-time inbound analytics in Looker and build tables, we set up SQL Runner for the RedShift data model.
This allows Aircall customers to access flexible dashboards in Looker that cover the following data:
The view of the Looker dashboards is customizable and can be adjusted according to the Client’s preference or needs.
That's how Eyas K. , Aircall Product Manager, described our work together on this project:
We’ve worked directly with Nikolay on multiple long and short-term projects. The results were outstanding! Nikolay and his team delivered fantastic results in a professional manner for a global SaaS company based in Europe with +800 employees. They possess technical skills that are extremely hard to find in the tech market today. Valiotti helped us build our global data platform to empower customer-facing analytics products that excelled. Documentations, code-quality and cross-communications were very professional. I’m looking forward to my next project with Nikolay and his team!
If you need help with selecting or creating data analytics tools, feel free to contact us.
You can write directly to our CEO or submit a request on the site. We are looking forward to our collaboration!
Learn more about our case studies
Lifestyle, USARead case study
iGaming, CyprusRead case study
FinTech, SpainRead case study
Ukraine, EdTechRead case study
Betting, AfricaRead case study
EdTech, FranceRead case study