No-Nonsense Business Data Modeling for Everyone
Proposed session for SQLBits 2026TL; DR
Power BI and Fabric promise easy analytics, but without proper business process modeling, BI projects fail. This session covers the fundamentals of effective modeling - cutting through hype to deliver essentials.
Session Details
According to the marketing, Power BI and Fabric make it easier than ever to ingest, explore, and analyze data across an organization. With its intuitive drag-and-drop interface, often dubbed "PowerPoint for Data," anyone can create stunning reports and answer complex business questions to propel their organization into data-driven bliss. Business Intelligence has never been more accessible - or so they say.
Unfortunately, the reality often falls short of the marketing promise.
Without a deep understanding of business processes and the ability to model them effectively, BI projects risk being inconsistent, difficult to use, and slow—or worse, delivering incorrect information. The adage "garbage in, garbage out" remains as relevant as ever. And in a world increasingly powered by AI, the fundamentals of business process modeling matter more than ever.
This session cuts through the hype and gets back to the essentials. We’ll explore what a business process truly is, the critical questions needed to model it, and - most importantly - how to model it effectively. This might not be the session you want, but it’s absolutely the session you need.
Unfortunately, the reality often falls short of the marketing promise.
Without a deep understanding of business processes and the ability to model them effectively, BI projects risk being inconsistent, difficult to use, and slow—or worse, delivering incorrect information. The adage "garbage in, garbage out" remains as relevant as ever. And in a world increasingly powered by AI, the fundamentals of business process modeling matter more than ever.
This session cuts through the hype and gets back to the essentials. We’ll explore what a business process truly is, the critical questions needed to model it, and - most importantly - how to model it effectively. This might not be the session you want, but it’s absolutely the session you need.
3 things you'll get out of this session
Explain modeling purpose
How to break down a business process
How to model a business process
Speakers
Alexander Arvidsson's other proposed sessions for 2026
Invisible Insights: What Your Data Can't Tell You - 2026
Fabric FinOps - Cost Optimization for Fabric - 2026
Fabric in Perspective - Interfacing Fabric With the World Beyond - 2026
From SQL to Spark and Back Again - Spark and Python for SQL Users - 2026
Knee-Deep In Tech Live @ SQL Bits - 2026
Undoing the Pretzel - Five Tips for Improving Your Body Language - 2026
AI Makes You Faster(?) - What LLMs Actually Are and Why It Matters - 2026
Alexander Arvidsson's previous sessions
Roche's Maxim of Data Transformation - By Example
Roche's Maxim of Data Transformation states that "data should be transformed as far upstream as possible, and as far downstream as necessary". Simple, powerful, and beautiful - but what does it really MEAN? Come find out through example.
Stand Fast - How Governance Can Save You a Fortune
Why is it that cloud projects often end up way more expensive than they should? The answer might surprise you: a lack of governance. Come learn how to turn governance from limitation to enablement.
Knee-Deep In Tech Live @ SQL Bits
Come be a part of the audience for a recording of an episode of Knee-Deep in Tech, a bi-weekly technology podcast!
The topic for this year's recording is:
Agile, DevOps; DataOps and all the other methods - help or hindrance?
The Untruthful Art - Five Ways of Misrepresenting Data
In this age of information it is imperative to be able to be able to clearly, simply and accurately explain and communicate sometimes complex data.
+5 Wisdom - Learn to Ask Better Questions to Solve the Right Problems
By asking the right questions we can solve the actual problem - not only the problem we think we are facing. Take a step back, look further, and ask better questions. We'll show you how.
Spell of Transmutation - Using Debezium to Transfer Realtime Data Changes to Event Hub
Getting changes from SQL Server to Event Hub can be tedious. I'll show you how to set up Debezium to automate SQL Server change data capture into Event Hub and explain why this matters for your serverless architecture!
Knee-Deep In Tech Live @ SQL Bits
Be part of a live audience recording of an episode of Knee-Deep in Tech!
Learning to Listen - Making the Most of Mentoring
Being a mentor or a mentee offer amazing opportunities but come with their own sets of challenges. We'll help you make the most of mentoring!