Support
Data Quality Cartoons
Real World vs Data #3
2023-07-20
Piotr Kononow
Data is (is supposed to be) a representation of real world. But is it complete?
United States and the U.S.
2023-05-11
If this seems relevant, you might need Reference Data Management. Simply agreeing on different sets of values, allowed values (or codes) and their meaining.
Do We Trust This Data?
2023-03-09
Have you ever heard of GIGO? Garbage In - Garbage Out? Don't expect to get useful insights and directions from your dashboards if you feed it with garbage data.
Random Data
2022-12-22
Poor quality data can be useless or even dangerous.
Importance of a Where Clause
2022-11-10
It's really important to remember about all the conditions in your WHERE statement. You might get flooded with the results.
Data Cleansing
2022-11-03
Data cleansing sounds like something you could outsource, right? Mostly not the case. Someone from outside can help you but they don't understand your business, processes, etc. That's why organizations assign data owners that are accountable for cleansing, and owners recruit and appoint data stewards from within the organization.
Best Selling Product
2022-10-13
That is a simple report... Select from orders, group by product category, add a bar chart. Looking good. Send.
Data Confidence in Healthcare
2022-03-31
If it's about our health, they better get those numbers right.
Quality Over Quantity
2021-03-04
Having a lot of data doesn't mean you are able to make many data-driven decisions. Maybe you'll just drown in data.
Never made an error
2021-02-25
Sometimes reports seem too good to be true... How much trust do you have in your data?
Data Swamp
2020-07-28
Data Lake is a repository of data stored in raw format (CSV, JSON, XML, text, binary, documents, etc.), in contrast to a traditional (relational) Database that enforces strict predefined schema (where data is arranged in tables and columns).
Data Swamp is a Data Lake is so messy that it is unusable and does not allow you to find or get value from your data.
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.