AGI Data Expo 2024

Transcript

2. Survive boring sessions/meetings • Step 1: Strategic nodding • Step 2: Situational awareness • Step 3: Know who to bribe
3. Leonie Chaudron DPG Product Owner Jordy Vercammen Agiliz Lead Analytics Who’s in front of you
4. Introduction • Agiliz: Who we are • DPG Media: Introduction of the client • Purpose of the presentation: Insight into the migration from Tableau (and others) to Looker • What to expect: Process, challenges, solutions, and results • Q&A
5. OUR MISSION, YOUR VALUE Our mission is to empower everyone within an organisation with the right data, tools and capabilities. Agiliz brings the unique combination of deep domain expertise, data-driven culture and harmonious collaboration with the ambition to realise top- & bottom-line impact. Our customers thrive through the combined strength of holistic strategic thinkers and top domain experts to implement projects that create a lasting impact on the business and organisation. Together we are unstoppable
6. Agiliz Ingestion Processing AI/ML Activation Insights 1st Party data 2nd party data 3rd Party data Str ea mi ng Bat ch Landing zone Data Lakehouse Tri gg er ed Analytics Paid Owned Str ea mi ng AI Platform Data Governance Data Infrastructure Data Security Data activation Martech Orchestration Foundation Layer Presentation Layer Customer Insights Sharing Earned Products Channel activation CDC Ad placement logs Web logs Mobile app logs Social data POS data CRM data Customer survey E-commerce User demographics
7. DPG Media
9. Before situation
10. Before situation • Fragmented logic and data • Challenges with integration and self-service • No control over query's being generated • No control over consumption costs going to Snowflake
11. Optimize Activate Build Technology Discovery Strategy Ideate Care Knowledge Kick-off workshop Meetings to align current situation vs long term goals Create demo portal for internal promotion Negotiate pricing to provide a data monetization platform Build views and tables to support 24/7 data availability Implementation of the Looker platform and dashboards Management of pipelines and dashboards Provide trainings for internal stakeholders, business analysts, developers and admins DPG’s seamless transition to Next-Gen Analytics Steps taken @ DPG Discovery Get to know the current situation Strategy Set clear goals and define succes factors for improvement Build Start building the LookML layer and improve the new dashboards vs the old ones Activate After testing we put everything in production ready for use Care Monitor how everything is being used and iterate on that information Kwowledge Provide trainings for all types of users
13. Looker Trusted. Informed. Data Experiences.
14. Data-driven workflows Integrated insights Modern BI & analytics Custom applications Serve up real-time reports and dashboards that inspire more in-depth analysis. Infuse relevant data with your existing tools for an enhanced experience and more effective results. Super-charge operational workflows with complete, near-real time data. Provide a data tool built to deliver the results you need, as needed. API-first and cloud native for integrating into existing workflows Semantic modeling layer for enterprise-wide governance In-database architecture for access to real-time data Auto-generated SQL Results Your Data Any SQL Database Git integration for version-control
15. Why Looker? Consistent, governed metrics | LookML Trusted platform Write smarter SQL with LookML • Abstracted SQL for defining data relationships and business metrics • Model any data to support wide-ranging analysis use cases • Run flexible, reusable, and extendable SQL queries • Robust data permissions o Row-level o Column-level o Content • Standardize metrics centrally using a single source of truth model • Stay agile with repeatable, reusable LookML code • Metric definitions differ across reports and dashboards • Difficult to iterate on analysis or update business logic vs.
16. How are we going to do this? • Analysis of Current Environment • Inventory of Existing Reports • Usage Analysis • Improvement Strategy • Enhanced Report Design • Caching Strategy • Cost Reduction • Performance Optimization • Stakeholder Training
17. Before
18. After
19. Ok cool, we can improve the dashboards, but how can we improve the generated costs?
20. Reduce consumption cost
21. Reduce consumption cost
22. As a result
23. What now? We did the technical part of the migration...
25. After situation • Cost savings on Snowflake consumption • Improvement in Self-Service usage and error reduction • Efficiency in data reporting and analysis • Governance • Faster data to insight process
26. Thanks for your attention If you have questions, please shoot!
27. Pay us a visit at our booth!