A national broadcast, digital media, and marketing services company needed a way to ensure that contractual obligations for ordered impressions were being met. The client also showed a desire for automated, accurate forecasting abilities.
Infinitive built an affordable and scalable video and impression analytics BI platform using Amazon QuickSight. Highly structured, transactional log data was ingested into Snowflake, along with supplemental ad server management system information via API, which was connected directly to create QuickSight data sets. Master Data Management and Data Governance were managed between the ad server and Snowflake. To save time and costs, only new information was pulled instead of the entire table, which would have been terabytes of data. Data visualizations were created using Amazon QuickSight (SPICE). Future ad impressions were forecasted using Amazon Forecast’s built-in machine learning capabilities. Authentication to platform was controlled through AWS Cognito and IAM and access was permitted with unique accounts and AWS CloudFront URLs.
- Speed of development and implementation: 3.5 months
- Ability to provide ongoing expertise (SMEs using QuickSight) to Oil and Gas customers
- Rapid scalability using CloudFormation templates which resulted in low-LOE rollout to a global infrastructure
- Ability to perform preventative maintenance on industrial equipment via information displayed in Amazon QuickSight dashboards
Why AWS & Why Infinitive
As an AWS Consulting Partner, Infinitive was able to pair our own experts in data Extract, Transform, and Loading operations with AWS’ world class professional services team to achieve tight customer requirements. AWS’ global reach with newly released Amazon QuickSight services, ensured the customer’s IT operations team would not be burdened with licensing or server maintenance costs, choosing then to focus resources on their own customers. Prototyping with a single environment, the customer is able to rely on infrastructure-as-code to multiply their operation footprint and revenue steam with ease and less overhead.