22-25 April 2026 
Average Fail - Why Averages Can Be a Terrible Idea in Data Analysis
Short 20 minute session for SQLBits 2026Saturday - 25 Apr 2026 - 14:40 - 15:00 Room 1BTL; DR
Averages can bite you - repeatedly. Come see how and why, and have a laugh and a cry at the same time!
Session Details
What is the easiest way of getting a number controlled for various factors? An average.
Most people stop thinking about the consequences right about here, but the harsh reality is that in many cases, an average is a terrible idea - especially if you don't know the data you're working with in the first place!
Consider what would happen if you start using averages to fill in missing data. or the potential for disasters with trying to average qualitative data expressed as numbers.
I'll spend 20 minutes raking the concept of averages over the coals. Bring marshmallows.
Most people stop thinking about the consequences right about here, but the harsh reality is that in many cases, an average is a terrible idea - especially if you don't know the data you're working with in the first place!
Consider what would happen if you start using averages to fill in missing data. or the potential for disasters with trying to average qualitative data expressed as numbers.
I'll spend 20 minutes raking the concept of averages over the coals. Bring marshmallows.
3 things you'll get out of this session
Why averages are bad
How averages can skew results
What Chicago adds to the story
How averages can skew results
What Chicago adds to the story
Speakers
Alexander Arvidsson's other proposed sessions for 2026
Turning insights into action: The art of data communication - 2026
Fabric FinOps - Cost Optimization for Fabric - 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.