So why is that we bring data together? What is the benefit in the end?
I'm asking these questions because with the advent of the digital age, and rapid development cycles, much of many companies data sources are left stranded, on their own, floating off into the ether and never to be seen again - unless you are directly concerned with that particular data source.
So what are these data sources and why should I care?
Well they could be your website and product page traffic data locked up in a third party analytics tool. It could be your app user data again locked up in a third party app solutions company. Maybe it's your media spend data? Is it your e-commerce data? Email marketing data? Facebook app data?
Whatever it is, centralising it into your data warehouse can add value and visibility across the business!
So what could I get out of centralising my data?
Firstly, it will provide a one stop shop for all your company data. This means whatever you are looking for you can find it in the Data Warehouse. Ask many an executive, business analyst, marketing manager, etc., of the times they have wanted visibility over specific activities and their cross-functional influence and the answer has been Too Hard? It's usually many, many times! It's also quite frustrating for those involved; especially when KPI's are riding hard on them.
Secondly, it gives a vast array of data for your analysts to mine and extrapolate insights from all at their fingertips. It is literally the equivalent of laying down water pipes to your house to save you from fetching your drinking water from the local well! It is of course absolutely doable to go and fetch water from the well but it is hardly the ideal situation and it will be much quicker in the long term to have everything at hand.
Thirdly, and most importantly, it's all about measurement! It's being able to know how many of your highest paying customers are using the app you created. Or whether the advertising you are conducting in certain media markets are producing a greater increase in sales versus those that are not receiving the activity.
So how does one actually bring it all together?
Well that's where you pick up the phone and bring in a Business Intelligence and Data Warehousing team in to create a data strategy and then begin the process of creating the connections between these far distant islands of data and your data warehouse.
I'm asking these questions because with the advent of the digital age, and rapid development cycles, much of many companies data sources are left stranded, on their own, floating off into the ether and never to be seen again - unless you are directly concerned with that particular data source.
So what are these data sources and why should I care?
Well they could be your website and product page traffic data locked up in a third party analytics tool. It could be your app user data again locked up in a third party app solutions company. Maybe it's your media spend data? Is it your e-commerce data? Email marketing data? Facebook app data?
Whatever it is, centralising it into your data warehouse can add value and visibility across the business!
So what could I get out of centralising my data?
Firstly, it will provide a one stop shop for all your company data. This means whatever you are looking for you can find it in the Data Warehouse. Ask many an executive, business analyst, marketing manager, etc., of the times they have wanted visibility over specific activities and their cross-functional influence and the answer has been Too Hard? It's usually many, many times! It's also quite frustrating for those involved; especially when KPI's are riding hard on them.
Secondly, it gives a vast array of data for your analysts to mine and extrapolate insights from all at their fingertips. It is literally the equivalent of laying down water pipes to your house to save you from fetching your drinking water from the local well! It is of course absolutely doable to go and fetch water from the well but it is hardly the ideal situation and it will be much quicker in the long term to have everything at hand.
Thirdly, and most importantly, it's all about measurement! It's being able to know how many of your highest paying customers are using the app you created. Or whether the advertising you are conducting in certain media markets are producing a greater increase in sales versus those that are not receiving the activity.
So how does one actually bring it all together?
Well that's where you pick up the phone and bring in a Business Intelligence and Data Warehousing team in to create a data strategy and then begin the process of creating the connections between these far distant islands of data and your data warehouse.
