To understand data warehousing it helps to (literally) think in terms of a warehouse. We collect data from different sources (get stock in) and put it into categories (load it onto shelves). All the while, we’ll make changes to it so it’s alive and dynamic (stock refreshment). You tell us what your problems/challenges/ambitions are (approach a member of our friendly sales staff), and we’ll look at what data we have and if we need to get more in (stock analysis). You take a copy of the data you need (load it into the truck) and we keep a copy secure on our server (smile at the security camera!). You can then make informed, data-driven decisions to drive growth and efficiencies.
Here are some real-world examples of how data warehousing can help.
And if there is an unknown link between any of these things, we can find that too. Mind you, working out how many power poles an elite athlete can service in one day may be a little beyond us!
This is about moving data from one place to another in an efficient, cost-effective way that has minimal impact on your operations. Here are some typical examples:
We can do this in real time, or batch it all together. And we’ll make sure your data arrives on time, because you don’t want to be late.
This is the holy grail of data management. Basically, single view takes all available data about a person, product or asset and puts it in one spot.
SINGLE CUSTOMER VIEW
This brings together all the data you have on an individual into one single view. It can include things like their interactions with your call centre; what, when and how they bought something from you; and even the wonderful/not-so-wonderful things they said about you on Twitter afterwards. Analysing all this past behaviour gives you a deeper understanding of future behaviour so you can better target your marketing and importantly give your customers what they want when they want it.
SINGLE ASSET VIEW
Let’s take a delivery truck as an example. From previously disparate sources you can bring together the service history, depreciation schedule, kilometres covered, driver performance, time on the road, and even the last time the tyres were changed. With all this data and more, just imagine how you can make better decisions and dramatically improve the efficiency of your company’s assets.
SINGLE PRODUCT VIEW
A single product view allows you to track a product’s performance at a granular level by bringing together supply-chain statistics, sales data, shelf time, customer demographics, your web traffic/conversions ratio and much more. You can use this data to better understand and predict the product’s behaviour and performance. This will increase sales, lower costs, allow you to weed out unprofitable ranges and much more.
Good data governance and security ensures your data is readily available, accurate, understood, up-to-date, well catalogued and, most importantly, secure. The governance part involves creating a set of procedures to determine when your data can be accessed, who can access it, what actions they can take with it, and under what circumstances and how. This means you’ll have current, secure, and understood data that can lead to more revenue, lower costs, less risk, and the confidence that comes with knowing you’ve always got good, available data on-hand!