Agile Data N’ Info

In this episode of the Agile Data Podcast, where host Shane Gibson sits down with Patrik Lager, a data integration expert with 25 years of experience and a lead developer of the Focal framework. In this episode, the conversation explores the intricate world of Focal data modeling and identity resolution. Patrik explains how the Focal framework operates as a highly abstract, metadata-driven engine...

Join Shane Gibson as he chats with Marco Wobben about the patterns within Fact-based modeling.   You can get in touch with Marco via LinkedIn or over at Casetalk.com If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/187938526/google-notebooklm-briefing   If you want to download the transcript for the podcast, head over to: https://agiledata.sub...

Join Shane Gibson as he chats with Mayowa Oludoyi about redesigning traditional data systems to better support LLM and AI Agents   You can get in touch with Mayowa via LinkedIn   If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/184771911/google-notebooklm-briefing   If you want to download the transcript for the podcast, head over to: https://...

Join Shane Gibson as he chats with Jason Taylor a former quant researcher who turned towards the light (or dark) side of data, to explore the practicalities and pitfalls of building data services using AI You can get in touch with Jason via LinkedIn   If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/183787179/google-notebooklm-briefing   If yo...

Join Shane Gibson as he chats with Andy Cutler about the art of data modeling and the potential of AI tools to improve the art. You can get in touch with Andy via LinkedIn or over at https://linktr.ee/andycutler If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/182448381/google-notebooklm-briefing   If you want to download the transcript for th...

Join Shane Gibson as he chats with Timo Dechau about the pattern of Metric Trees. You can get in touch with Timo via LinkedIn or over at https://timodechau.com If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/179577155/google-notebooklm-briefing   If you want to download the transcript for the podcast, head over to: https://agiledata.substack....

Join Shane Gibson as he chats with Rob Long about patterns that you can use to document and understand your data estate. You can read the article we discuss in the podcast episode here: https://atlonglastanalytics.substack.com/p/data-producer-consumer-diagrams You can get in touch with Rob via LinkedIn or over at https://atlonglastanalytics.substack.com/ If you want want to read a summary generate...

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern for the Data Match.   The Data Match pattern provides an automated, granular comparison capability to efficiently identify and report discrepancies between two datasets, moving from row counts to specific data values. This 'data diff' solution transforms hours of manual data reconciliation into minute...

Join Shane Gibson as he chats with Nick Zervoudis about patterns that you can use to quickly and easily define the ROI of your data products, before you build them. You can get in touch with Nick via LinkedIn or over at https://blog.valuefromdata.ai If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/172748370/google-notebooklm-briefing   If you...

Join Shane Gibson as he chats with Johnny Winter about the core patterns that make up Dimensional (Star Schema) Modeling. You can get in touch with Johnny via LinkedIn or over at https://greyskullanalytics.com/ If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/171239242/google-notebooklm-briefing   If you want to download the transcript for the...

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern for the AgileData Activity Event Tile.   The Activity Event Tile pattern tracks a sequence of events (e.g., subscription signups, subscription payments) for a core business concept by storing minimal event data and using a hydration layer to automatically generate pre-calculated metrics as views. This...

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern for the AgileData Event Tile.   The Event Tile Data Modeling pattern captures business processes and transactions within AgileData's three-layered data architecture, modeling "who does what" at a specific point in time. It achieves this by storing only a small number of core business keys in insert-on...

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern of Automated Load Patterns based on Source Data Profiles.   The Automated Load Patterns based on Source Data Profiles pattern automatically profiles incoming data to determine its optimal loading method. It classifies data as either event data (immutable, append-only) or change data (evolving records)...

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern of Trust Rules to validate data.   The Trust Rules pattern provides automated data validation to ensure all incoming data is fit for purpose and trustworthy. It bakes in essential checks such as unique business keys and business effective dates, which run automatically upon data load or table refresh....

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern of Unioning two or more tables together automatically.   The Automated Table Unioning pattern automatically combines two or more tables by intelligently looking up column names and data types to generate safe SQL under the covers. It supports disparate data sources, such as those from multiple publish...

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern of Orchestrating Dynamic Data Flows. The Dynamic Data Flow Orchestration pattern dynamically generates and self-heals data flow manifests (DAGs) at runtime from a central context database, enabling adaptive, cost-effective, and low-latency data processing primarily for micro-batching workloads An Agil...

Join Shane Gibson as he chats with Roelant Vos about a number of Data Engine Thinking patterns and his new book Data Engine Thinking. You can get in touch with Roelant via LinkedIn or over at https://roelantvos.com/blog/ Or you can grab a copy of the Data Engine Thinking book on Amazon or at https://dataenginethinking.com/en/ If you want want to read a summary generated with GenAI, head over to: h...

Join Shane Gibson as he chats with Chris Gambill about a number of Data Engineering patterns. You can get in touch with Chris via LinkedIn or view his YouTube channel https://www.youtube.com/@GambillDataEngineering If you want want to read a summary generated with GenAI, head over to: https://agiledata.substack.com/i/165842333/google-notebooklm-briefing   If you want to download the transcript for...

Join Ramona C Truta as she interviews Shane Gibson about the patterns of writing a data book (and they discuss a whole lot of other data things) You can get in touch with Ramona via LinkedIn or read more on substack https://ramonatruta.substack.com/ Or buy a copy of Shanes book "an Agile Data Guide to Information Product Canvas" , and finally fix those data requirement gathering problems. If you w...

Join Shane Gibson as he chats with Andrew Foad on his data modeling pattern "Hook" You can get in touch with Andrew via LinkedIn or read more on substack https://hookcookbook.substack.com If you want to download the transcript for the podcast, head over to: https://agiledata.io/podcast/agiledata-podcast/the-hook-data-modeling-pattern-with-andrew-foad/#read   If you want want to read a summary gene...

Join Shane Gibson as he chats with Aaron Wilkerson on ways data teams can increase the perception of the value they add to their organisation. You can get in touch with Aaron via LinkedIn or read his newsletter on substack https://aaronwilkerson.substack.com If you want to read the transcript for the podcast head over to: https://agiledata.io/podcast/agiledata-podcast/increasing-the-perceived-valu...

Join Shane Gibson as he chats with Remco Broekmans about the pattern templates that are part of the Ensemble Logical Modeling (ELM) patterns. You can find more about ELM and its templates over at: https://www.elmstandards.com/ Find Remco's book on Amazon: https://www.amazon.com/Stories-Solutions-Redefining-Communication-Professionals-ebook/dp/B0DXQ8RR3X/ You can get in touch with Remco via LinkedI...

Join Shane Gibson as he chats with Dylan Anderson about the patterns required to define a Data Operating Model. This conversation was based on this article written by Dylan: https://thedataecosystem.substack.com/p/issue-13-defining-the-data-operating And specifically this pattern diagram: You can get in touch with Dylan via LinkedIn or subscribe to his newsletter at https://thedataecosystem.substa...

Join Shane Gibson as he chats with Chris Bergh on improving your teams way of working by using DataOps patterns. You can get in touch with Chris via LinkedIn or over at https://datakitchen.io If you want to read the transcript for the podcast head over to: https://agiledata.io/podcast/agiledata-podcast/dataops-patterns-with-chris-bergh/#read   Listen to more podcasts on applying AgileData patterns...

Join Shane Gibson as he chats with Patrick Cuba on combining the Data Vault data modeling pattern with the Medallion Architecture pattern. This discussion was based on the patterns described in this article: https://medium.com/the-modern-scientist/the-modern-data-vault-stack-75103102e3d2 You can get in touch with Patrick via LinkedIn or you can read his thoughts on Data Vault patterns over at http...