Do I need a Data Warehouse?+
Not everybody needs a Data Warehouse. If your organisation has a single application that runs your entire business for you, e.g. good quality ERP system, and you have confidence in the data then you probably don’t need a Data Warehouse, particularly if you generate less than a million rows of transactions a year. But if you have multiple data sources, such as ERP, CRM, Manufacturing Execution Systems or third party Sales/Ordering data or you generate large amounts of data, then you probably do require a Data Warehouse.
A Data Warehouse can be great resource for getting insights across an organisation such as:
- For manufacturing, identify impact of absenteeism on product quality,
- For Retail / sales & distribution, uncover sales patterns or product combinations that could be exploited to boost revenue, maybe understand social media sentiment on new products
- For professional services, understand profitable customers and lifetime value
- For Utilities/Telcos, understand customers better to introduce new services/products, reduce churn
Can I get a single view of A Customer?+
- … Product, Depot, Truck, etc. This brings together all the data you have on an customer (or other entities) into one single view. It can include things like their phone and email interactions; purchase history; their social media comments. But to achieve this you will need to manage the data to ensure data quality. Master data management provides a way of doing this if this capability is not already built into your existing applications. 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.
Can I trust my data?+
- Getting access to all the data available from internal systems, data from trading partners, social media and machine sensors is great but trusted data sources are critical to how we make decisions. We cannot effectively collaborate around information we do not understand and trust. Data Quality is a challenge as it requires input and effort from a number of business functions including IT functions. The problems are more significant as organisations get larger. Common definitions around data is a good place to start but depending on your size and complexity data quality management software may be required.
What We Do
Good data management requires specialist skills and knowledge – we know because we’ve being doing it for a while!+
- We can help from developing a data strategy, to identifying solutions and architecture right through to helping you analyse the data.
- We’ll do this with a small group of people that have the right skills and business experience.
Products For You
Get in Touch with Analytics