{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Humans of Martech","title":"66: A guide to data models and dynamic dashboards for marketers","html":"","width":"100%","height":180,"duration":1578,"description":"What’s up everyone? Today is a bit of a follow-up on the previous episode about building dashboards, check that one out first if you haven’t already.Today we’re taking this a step further and talking about data models and the limits of building dashboards.Here’s a typical stance on dashboard design:It is best to focus on the ideal scenario, and worry about the practicalities of implementation later, Or “let the ops team worry about that” as they call it. Haha yeah… This approach may seem appealing at first, as it allows designers to imagine and create without constraints. However, as a marketing operations person, I’m not a fan of this.Here’s today’s main takeaway: I believe that understanding how a dashboard is powered, and having a sense of what is possible and what is not, is a crucial differentiator.Too often, I have seen dashboard projects built in a vacuum, disconnected from the reality of the data and the systems that support them. In these cases, valuable time and resources are wasted building an idealistic dashboard that cannot be implemented or used effectively.Today we’re going to be breaking down how you can level up your knowledge about data models or the capabilities and limitations of the data and the systems that support the dashboard, and designing solutions that are feasible and effective. By understanding these constraints, designers and marketers can create dashboards that are not only beautiful and engaging, but also practical and useful.I feel like this topic could get hairy pretty fast, so let's break down some definitions for the listeners. Da hell is a data model, let’s start there.What’s a data model?Data modeling is a way to organize and structure data from different sources in a consistent and useful way. It helps to make data more accessible and organized, so it can be easily analyzed and interpreted.Gimme a non marketing example, how would you explain this to your mom?Example: A simple example of a data model is a phone directory....","thumbnail_url":"https://img.transistorcdn.com/4eBcAi2MlxuVPdaWgcnwbeXVYH5naGhZe-qIuSYOdjU/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9hZGE5/NTRiZjYwMDI0NWM5/MmE4MDQ1NWJlODA3/MjUxYy5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}