Support
Bad Data Analysis Cartoons
It could be anything
2023-08-17
Piotr Kononow
Have you encountered resistance to trusting data and data driven decisions?
Funny Story
2021-01-07
When you want to start measuring or analyzing something, quite often you have no idea what kinds of results to expect. Often, you take whatever comes out of your SQL (or BI report) as truth. "OK, so our performance did grow 20000% last month..." (OK, maybe not that extreme). But how can you be sure? There are so many things that could've gone wrong - the quality of data, incorrect assumptions, error in a query... Even such trivial as missing up asc and desc. Be cautious!
Pick your version of reality
2020-12-22
Did you ever see different reports or charts showing same metric (or called the same) that showed completely different values or even trends? I did, quite often. Why is that so? Well, there are many reasons but let me narrow it down to 2:
Lack of common understanding of business concepts - you can solve it with a Business Glossary, a common vocabulary with precise definitions,
Lack of understanding of data and its logic (calculations, relationships, etc.) - and you can solve it with a Data Dictionary.
You can build both artifacts in one catalog and share in one UI - using Dataedo.
2 billion employees?
2020-10-27
Do you always trust the data you get from your data/IT team?
Asc, desc, whatever
2020-01-29
Sometimes you write the most sophisticated query and celebrate the results. Only to find out that you forgot something as trivial as a sort order...
Sum(id)
2019-09-23
If the numbers look too good, check the SQL.
'Do not use' client
2018-11-21
Without good understanding of database schema it is easy to make mistake joining tables which can cause serious error in the results.
This was a good quarter, right?
2018-10-25
Don't always trust what you see on the reports. Even if data is correct, there can always be a bug in a query. Do all your analysts understand the schema of the databases they are querying?
We are number one!
2018-10-23
Do you trust the numbers you get on the reports? Data may be incorrect and there are many pitfalls in querying data.