Theo Reddy, AWS Business Unit Manager.
In today’s world, consumers are increasingly drawn to the “digital lifestyle”, and the country’s major telecommunications providers have recognized this, as evidenced by their willingness to serve advertisements to targeted consumer segments on modern digital channels.
The challenge faced by one of these vendors was that in order to reach customers across different digital channels – website, mobile, and video – they needed multiple tools and systems to achieve their campaign goals.
The problem here explains Theo Reddy, AWS Business Unit Manager at BlueSky is that by using these multiple tools and systems, they quickly found that it negatively affected their reporting dashboards, resulting in fractured data. This, in turn, created challenges around consolidation, and – since manual intervention was required for this – led to excessive report run times, which meant that the value of reports was diminished. .
“The telecom provider needed a single, consolidated view of their advertising data for reporting purposes if they wanted to get the most out of their various advertising campaigns,” Reddy explains.
“BlueSky worked closely with the client throughout the process, assisting in the execution of a data architecture model designed to convert data acquired from multiple different sources into a consolidated and insightful set of views. . Ultimately, AWS was chosen as the cloud platform that was to be used to store and model these consolidated data views.
Giving a brief overview of the client’s data modernization journey, Reddy notes that the data flow solution implemented by BlueSky essentially allowed data from any campaign source to be ingested into S3 storage buckets for staging.
“From that point on, we used a combination of world-class AWS Cloud features. These included Lambda and CloudWatch, solutions that were then used to transform ingested data into consistent S3 datasets. Once at this point, these datasets can then be transformed, using Glue Crawler, into Athena tables. Once done, the tables are made available, securely, to all visualization tools – such as QlikSense – allowing users to create insightful presentations.
“Ultimately, BlueSky was able to help the customer leverage the hyperautomation capabilities of AWS. By doing so, they were able to significantly reduce the time it takes to present insightful dashboards to business stakeholders. Additionally, the existing data architecture also allows the customer to use additional campaign sources, without the need for additional data transformation flows,” concludes Reddy.