Everyone in business has data. We collect data on our customers, our products, our support and much more. Often the data that we want to use and understand is in disparate sources making it hard to create reports and connections. These connections are often what can drive innovation and growth.
There are lots of services on the Internet and tools that companies like Denver DataMan build to bring data together. But the questions is always, why can I not just see this data in the tools I use?
The challenge is that data comes in lots of different shapes, sizes, and organizational patterns, or as we geeks call it, schemas. If I want to compare data from two sources, I need to make sure I am comparing the same attributes. Hence, a new schema must be born that can account for the data that I am comparing. For example, if one source has data separated by hours and another by days, I will combine the hours so that they can be shown as days.