Combine and manage your data

Data warehousing

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.

  • An engineering firm wants to work out the most efficient process for servicing the most amount of power poles in a day.
  • A savvy marketer wants to better understand customer needs and preferences.
  • A telco wants to monitor usage so it can alert travellers that they’re about to exceed their data-roaming limit.
  • An elite athlete wants to improve their time, the accuracy of their kick into a strong wind or the speed of their serve.

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!

 

Moving and combining your data

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:

  • moving data in and out of your warehouse, data lake, or any other source
  • moving a company from one computer system to another, e.g., Siebel or SAP
  • merging the data of two different companies after a takeover
  • helping a savvy marketer to join-the-dots on an individual customer from across different systems inside and outside their organisation.

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.

 

Single view

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.

 

Data governance and security

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!