How often have you queried your data and come back with garbage? You know the question you are trying to answer, whether it’s how many bills of sale went through a particular silo or maybe how come that vendor is on this list and not another? How many are duplicates? You think these investigations are easy to answer, you plot and work on your query; and then the dataset that comes back isn’t remotely what you thought it would be. Then you have to go back and do the whole process again.
A common problem found today inside data is what you think you are asking the data isn’t how it was entered, so you are asking an impossibility. If it was never mapped or built to find the answer you are looking for; it will fail or bring back what can be taken as misinformation. In our current era of data democratization where the definition of data science is still being formed, tech and audit become disseminators of information that are not traditionally in their wheelhouse. Every business wants strategic planning information to be digestible and visual. We all jump through hoops to make that happen, but in most cases, you are dragging information in and out of legacy systems, and losing pieces along the way.
Do you have your end result in mind? Are your query and focus strict enough to bring back that answer?
Here are some tips on how to structure your ideas into smarter queries that deliver the answers you are looking for:
Data queries can be fun and even addictive in the right environments. Getting ideas from people with different skill sets is another good tip for finding new ways to use your data for your competitive advantage. Data Oceans, Data Warehousing, Sourced Data, Free Data, Paid Outsourced Data, Lions, Tigers and Bears, Oh My! There is a lot of fun to be had in data. Don’t let the hoops you may have to go through block your imagination in what you can find and do. Happy hunting!