{"id":2453,"date":"2026-05-21T13:19:42","date_gmt":"2026-05-21T13:19:42","guid":{"rendered":"https:\/\/solutionsreview.com\/thought-leaders\/?p=2453"},"modified":"2026-05-21T15:16:49","modified_gmt":"2026-05-21T15:16:49","slug":"the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/","title":{"rendered":"The Cathedral of Data (Understanding Scale and Perspective in Analytics)"},"content":{"rendered":"

\"\"<\/p>\n

When my wife, Dianna, and I visited Vilnius in November 2024, we made our way to the famous cathedral that anchors the city\u2019s old town. She\u2019s a little over five-foot-three, and watching her tilt her head back to take in the front fa\u00e7ade reminded me just how enormous that building really is. Photographs never quite prepare you for the feeling of standing at the foot of something that large. The neoclassical front stretches more than fifty meters across, and the bell tower rises even taller, shooting upward with the confidence of a structure that has dominated its square for centuries.<\/p>\n

As we walked around the grounds, the details kept revealing themselves. A statue on the roof, an element that seems modest from a distance, measures four full meters, taller than two adults standing shoulder to shoulder. Inside, the main nave reaches a height most of us only experience in downtown skyscrapers; it could easily fit a six-story building. And the row of Doric columns at the entrance feels almost oversized until you realize this style was meant to impress and steady the eye. Each column is as wide as a sofa, and together they shape the entire tone of the cathedral\u2019s exterior long before anyone steps inside.<\/p>\n

\"20241116_105222\"<\/div>\n

The building has been through fires, wars, reconstructions, and shifting architectural tastes since the 13th century, and yet it retains an identity that is unmistakably its own. But what struck me most on that visit wasn\u2019t so much the structure itself; it was how seeing a familiar person standing in front of it instantly clarified its scale. Without that reference point, the brain registers \u201cbig,\u201d but with it, you understand the magnitude in a way that feels grounded and personal.<\/p>\n

That small moment, my wife dwarfed by a centuries-old structure, captures a principle that comes up repeatedly in analytics. Data without context can be technically accurate but practically unhelpful. Add a relatable frame of reference, and suddenly patterns, risks, and opportunities emerge. Working with data is often less about the numbers themselves and more about how those numbers connect to the world we recognize.<\/p>\n

Over the years, I\u2019ve come to rely on a handful of core practices when merging or comparing multiple datasets. These habits have saved countless hours and avoided mistakes that would have undermined entire analytical projects. Much like the builders who had to think ahead about weight distribution and materials, we have to think carefully about the structure that holds our information together.<\/p>\n

The first principle is\u00a0standardization<\/strong>. Before you can bring datasets together, they must speak the same language. A date field using slashes in one place and hyphens in another seems harmless, but it only takes one inconsistent format to break an entire workflow. I often think of it like mixing building materials: stones need to be cut consistently, or the wall won\u2019t stand straight. Modern ETL tools help, but the responsibility to ensure uniformity ultimately falls on the analyst.<\/p>\n

Next is ongoing\u00a0quality control<\/strong>. The Vilnius Cathedral has survived because people cared enough to maintain it, examine its surfaces, and repair damage long before it became dangerous. Data works the same way. Missing values, duplicate entries, and odd outliers may look small, but they can distort averages, inflate totals, or send an analyst chasing explanations that don\u2019t reflect reality. It\u2019s worth asking early whether an unexpected number is a meaningful event or simply an error waiting to be corrected.<\/p>\n

Identifiers<\/strong>\u00a0form another essential pillar. Think of employee IDs, customer numbers, or product codes as the architectural vocabulary of a dataset. If one table uses \u201c00123\u201d and another uses \u201c123\u201d for the same item, you end up with mismatched records and fractured analysis. Consistent identifiers keep everything aligned and prevent the analytical equivalent of trying to bolt together beams that were cut in different units of measurement.<\/p>\n

Scale<\/strong>\u00a0also plays a large role. Just as you wouldn\u2019t compare a massive cathedral to a small neighborhood chapel without acknowledging their different purposes and sizes, you shouldn\u2019t combine datasets without understanding what each represents. A decade-long global report and a single year of regional data can be combined, but not blindly. Their scopes differ, their timeframes differ, and their relevance must be weighed accordingly. Part of our job is to ensure that the comparisons we make are fair and meaningful.<\/p>\n

\"image.png\"<\/div>\n

The tools available today (i.e., analytics platforms, scripting languages, powerful integration software) make it easy to work at a scale that was unthinkable not long ago. But tools only amplify the principles we bring to them. Good habits lead to clear, trustworthy insights; sloppy ones simply allow mistakes to spread faster.<\/p>\n

And then there is\u00a0documentation<\/strong>. It may not be glamorous, but it\u2019s the backbone of any reliable process. Builders recorded their methods not only for their own reference, but so later generations could understand how to repair, maintain, or extend what already existed. Proper documentation in analytics serves the same purpose. It preserves the reasoning behind each transformation, the assumptions considered, and the decisions made.<\/p>\n

All of this came to mind as we stepped back to take one last look at the cathedral. In the same way that centuries of architects, laborers, and caretakers contributed to the building that stands today, every dataset we work with carries traces of choices made long before we open the file. The value lies not only in the raw materials but in the care we take to assemble them into something coherent.<\/p>\n

\"image.png\"<\/div>\n

Bring those core practices into your daily work. Start with cleanly shaped data, anchor everything to identifiers that stay true, protect the integrity of each value, and keep the larger context in view; and the analysis you build becomes something others can rely on without hesitation. When each choice fits the next, the entire structure gains a clarity that doesn\u2019t fade with time. In that moment, your data stops behaving like a loose collection of figures and stands instead like a finished cathedral: intentional, coherent, and strong enough to guide the decisions that follow.<\/p>\n","protected":false},"excerpt":{"rendered":"

When my wife, Dianna, and I visited Vilnius in November 2024, we made our way to the famous cathedral that anchors the city\u2019s old town. She\u2019s a little over five-foot-three, and watching her tilt her head back to take in the front fa\u00e7ade reminded me just how enormous that building really is. Photographs never quite […]<\/p>\n","protected":false},"author":1048,"featured_media":2454,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[10],"tags":[],"acf":[],"yoast_head":"\nThe Cathedral of Data (Understanding Scale and Perspective in Analytics)<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Cathedral of Data (Understanding Scale and Perspective in Analytics)\" \/>\n<meta property=\"og:description\" content=\"When my wife, Dianna, and I visited Vilnius in November 2024, we made our way to the famous cathedral that anchors the city\u2019s old town. She\u2019s a little over five-foot-three, and watching her tilt her head back to take in the front fa\u00e7ade reminded me just how enormous that building really is. Photographs never quite […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Solutions Review Thought Leaders\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-21T13:19:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-21T15:16:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dr. Joe Perez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. Joe Perez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/\",\"name\":\"The Cathedral of Data (Understanding Scale and Perspective in Analytics)\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg\",\"datePublished\":\"2026-05-21T13:19:42+00:00\",\"dateModified\":\"2026-05-21T15:16:49+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/c28a6283594a5660e937e10be80eb124\"},\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/thought-leaders\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Cathedral of Data (Understanding Scale and Perspective in Analytics)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#website\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/\",\"name\":\"Solutions Review Thought Leaders\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/thought-leaders\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/c28a6283594a5660e937e10be80eb124\",\"name\":\"Dr. Joe Perez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2024\/02\/Perez_500_Ink.png\",\"contentUrl\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2024\/02\/Perez_500_Ink.png\",\"caption\":\"Dr. Joe Perez\"},\"description\":\"Dr. Joe Perez, award-winning thought-leader, prolific international keynote speaker, and Amazon best-selling author with 40+ years in IT\/education, has amassed an impressive portfolio. From Business Intelligence Specialist to Senior Systems Specialist and fractional CTO, he's an authority in data viz\/analytics and process improvement. Featured on multiple Times Square billboards, he's a powerhouse of expertise, integrity, and excellence. Recognized as a LinkedIn Top Voice with 20,000+ LinkedIn followers, Perez sparks innovation, captivating audiences at conferences across the globe.\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/author\/dr-joe-perez\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Cathedral of Data (Understanding Scale and Perspective in Analytics)","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"The Cathedral of Data (Understanding Scale and Perspective in Analytics)","og_description":"When my wife, Dianna, and I visited Vilnius in November 2024, we made our way to the famous cathedral that anchors the city\u2019s old town. She\u2019s a little over five-foot-three, and watching her tilt her head back to take in the front fa\u00e7ade reminded me just how enormous that building really is. Photographs never quite […]","og_url":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/","og_site_name":"Solutions Review Thought Leaders","article_published_time":"2026-05-21T13:19:42+00:00","article_modified_time":"2026-05-21T15:16:49+00:00","og_image":[{"url":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg","width":1,"height":1,"type":"image\/jpeg"}],"author":"Dr. Joe Perez","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dr. Joe Perez","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/","url":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/","name":"The Cathedral of Data (Understanding Scale and Perspective in Analytics)","isPartOf":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg","datePublished":"2026-05-21T13:19:42+00:00","dateModified":"2026-05-21T15:16:49+00:00","author":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/c28a6283594a5660e937e10be80eb124"},"breadcrumb":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#primaryimage","url":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg","contentUrl":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2026\/05\/JP.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/thought-leaders\/the-cathedral-of-data-understanding-scale-and-perspective-in-analytics-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/thought-leaders\/"},{"@type":"ListItem","position":2,"name":"The Cathedral of Data (Understanding Scale and Perspective in Analytics)"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/thought-leaders\/#website","url":"https:\/\/solutionsreview.com\/thought-leaders\/","name":"Solutions Review Thought Leaders","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/thought-leaders\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/c28a6283594a5660e937e10be80eb124","name":"Dr. Joe Perez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2024\/02\/Perez_500_Ink.png","contentUrl":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2024\/02\/Perez_500_Ink.png","caption":"Dr. Joe Perez"},"description":"Dr. Joe Perez, award-winning thought-leader, prolific international keynote speaker, and Amazon best-selling author with 40+ years in IT\/education, has amassed an impressive portfolio. From Business Intelligence Specialist to Senior Systems Specialist and fractional CTO, he's an authority in data viz\/analytics and process improvement. Featured on multiple Times Square billboards, he's a powerhouse of expertise, integrity, and excellence. Recognized as a LinkedIn Top Voice with 20,000+ LinkedIn followers, Perez sparks innovation, captivating audiences at conferences across the globe.","url":"https:\/\/solutionsreview.com\/thought-leaders\/author\/dr-joe-perez\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/posts\/2453"}],"collection":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/users\/1048"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/comments?post=2453"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/posts\/2453\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/media\/2454"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/media?parent=2453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/categories?post=2453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/tags?post=2453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}