How Adobe Advertising Uses Presto for Adhoc Querying, Custom Reporting, and Internal Pipelines

Overview

Discover how Adobe Advertising leverages Presto to handle massive data operations, enabling custom reporting, ad-hoc queries, and internal data pipelines across their digital advertising platform.

Syllabus

• Introduction to Adobe Advertising Platform
Overview of Adobe's digital advertising ecosystem
Importance of data operations in digital advertising
• Introduction to Presto
What is Presto?
Advantages of using Presto for big data processing
Presto's role in modern data infrastructure
• Data Architecture in Adobe Advertising
Existing data architecture overview
Integration of Presto into Adobe's data ecosystem
Data sources and data flow
• Adhoc Querying with Presto
Setting up an environment for adhoc queries
Using SQL in Presto for custom queries
Performance optimization techniques for Presto queries
• Custom Reporting using Presto
Building custom reports with Presto SQL
Integrating Presto with reporting tools
Real-world examples of custom reporting solutions
• Internal Data Pipelines with Presto
Designing data pipelines using Presto
Automating data workflows
Case studies of internal pipeline implementations
• Performance and Scalability
Techniques for optimizing Presto performance
Scaling Presto to handle massive data operations
Monitoring and troubleshooting Presto workloads
• Security and Compliance
Ensuring data security with Presto
Compliance considerations for data handling
• Future Directions and Innovations
Emerging trends in data querying and reporting
Potential advancements in Presto technology
• Conclusion
Recap of key learnings
Discussion on the impact of Presto on Adobe Advertising's operations
• Assessment and Evaluation
Practical exercises and assignments
Final project involving real-world application of Presto in a digital advertising scenario

---

Subjects

Data Science