Data Modelling: The Lost Art of Turning Inputs into Insights
Proposed session for SQLBits 2026TL; DR
Organizations invest heavily in data engineering but neglect modelling the key to turning raw data into insights. This session explores Kimball, Corr, and Inmon principles to restore the lost art of data modelling for real business value.
Session Details
In today’s data-driven world, business pour vast resources into data engineering pipelines, platforms, and processing often overlooking the true value driver in the solution, data modelling. Without well-defined models, data remains a raw asset rather than a business intelligence enabler. In this session, we will remind ourselves of the foundational principles of dimensional modelling and agile data warehouse development, drawing on the timeless work of Ralph Kimball, Lawrence Corr, and Bill Inmon.
From a data architect’s perspective, we’ll explore why modelling is not just a technical step but a business-critical discipline that transforms inputs into actionable outputs. You’ll learn how robust data entities bridge the gap between engineering and analytics, enabling clarity, consistency, and scalability in delivering valuable insights.
We’ll also discuss practical approaches for embedding modelling into modern data strategies whether you’re building a data warehouse, a Lakehouse, or a semantic layer.
From a data architect’s perspective, we’ll explore why modelling is not just a technical step but a business-critical discipline that transforms inputs into actionable outputs. You’ll learn how robust data entities bridge the gap between engineering and analytics, enabling clarity, consistency, and scalability in delivering valuable insights.
We’ll also discuss practical approaches for embedding modelling into modern data strategies whether you’re building a data warehouse, a Lakehouse, or a semantic layer.
3 things you'll get out of this session
• Understand the value of data modelling. Explaining why modelling is critical for transforming raw data into actionable insights and how it complements engineering investments.
• Explore Proven Methodologies. Introduce key principles from Kimball, Corr, and Inmon to design dimensional and agile models that deliver business value.
• Apply Modelling in Data Architectures. Demonstrate practical approaches for embedding modelling into data warehouses, Lakehouses, and semantic layers.
Speakers
Paul Andrew's other proposed sessions for 2026
An Evolution of Cloud Data Architectures - Lambda, Kappa, Delta, Mesh & Fabric - 2026
An Introduction to Delta Lake and The Lakehouse - 2026
Building Near Real-time Data Solutions in Microsoft Azure & Fabric - 2026
Data & Community: An Amazing Network Of Peers Supporting Innovation & Growth - 2026
Designing & Delivering Data Products: From Mesh Principles to Data Fabric Automation - 2026
Fabric Data Activator: Real-Time Data Feeds, Automated Alerts & Stock Intelligence - 2026
Fast-Track Your Lakehouse Build with a Metadata Framework - 2026
Microsoft Fabric Platform Governance - Where To Start - 2026
Paul Andrew's previous sessions
An Evolution of Data Architectures - Lambda, Kappa, Delta, Mesh & Fabric
How has advancements in highly scalable cloud technology influenced the design principals we apply when building data platform solutions?
Building an Azure Data Analytics Platform End-to-End
Based on real world experience let’s think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Analytics solution.
Creating a Metadata Driven Orchestration Framework Using Azure Data Integration Pipelines
We'll explore delivering this framework within an enterprise and consider an architect’s perspective on a wider platform of ingestion/transformation workloads with multiple batches and execution stages.
ETL in Azure Made Easy with Data Factory Data Flows
What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a feature rich, graphical, scalable data flow environment to rival any ETL tech we’ve previously had available in Azure.
Using Azure DevOps for Azure Data Factory
DevOps as a concept does not always translate to the technology when implemented. In this session we'll explore that problem when working with Azure Data Factory and what the different cloud only CI/CD options are.
Complex Azure Orchestration w Dynamic Data Factory Pipelines
If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you.
Building an End to End IoT Solution Using Pi Sensors & Azure
Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.