I recently visited California to meet with one of our clients the Golden State Warriors to talk about the analytics we ran for them. Dennis is at the top of the field. He drew the diagram above out for the head of analytics at the Warriors while I tagged along.
Their head Analyst was talking about wanting to set up a “data warehouse”. After a long discussion on this, like really long, I learned that data warehouses may seem like a good idea, but for most companies it is not really needed.
Let’s look at the diagram. Dennis drew this out because he could see that their discussion about whether a data warehouse was necessary or not wasn’t hitting through. So we went into a conference room and he drew it out.
There are three columns, and although they’re labeled in the drawing, they’re kind of hard to see so I have labeled them down below the drawing. These three steps are MAA: Metrics, analysis, and action.
In the left column is a visual of how information flows in a business with a data warehouse. A data warehouse is put in place so that when someone needs information (such as the number of tickets sold last year, how many per game. Or the number of ice-cream cones bought. Whatever the business and the need is) they can pull it from a location or “data warehouse”.
This information is our Metrics, or the numbers. This way they don’t have to go to different sources for information but can pull it out from one spot. This can be helpful to keep data reliable. If you have no data warehouse the risk is that in people will come up to the source for information and with a number of people asking for this information, numbers can be skewed.
This is the Metrics of this process. With a data warehouse Information is more dependable and more easily accessible.One can take this information and do some analysis on the numbers received (middle column). Then one can make special offers based on analytics ran for example to receive greater business.
For example, we can see what Golden State Warrior fans are commenting on and what their similar interests are in order to know which market to target. Targeted marketing done right can lead to greater conversion or greater sales and results in lower acquisition rates. When this special offer is made or something is done based off the numbers evaluated, this is action.
So why shouldn’t every business pay to have a data warehouse? Doesn’t it sound great? Well if the objective is to boost sales then the more powerful route would be to take the information, analyze, and do something with the change in numbers that will lead to conversion (someone acts on the offer), a data warehouse may not really be needed.
After this log discussion I could see that Brandon, the head Analyst was really stressing over this. His bosses wanted the warehouse of data, but he was starting to see that it was expensive and not really needed. The companies that seek data warehouses usually don’t need one. Perhaps large companies dealing with huge amount of information might direly need one but in most cases- it probably isn’t necessary.
It costs a lot to set one up and can be a lot more trouble than its worth. If one can take the information and immediately convert it to sales through measuring, analyzing, and acting then that is the ideal process.
About the Author
He is the host of the CoachYu show, a digital marketing certification program that partners together with industry professionals just like doctors, engineers, and teachers where people can get trained and have a job at the same time.
He has been building brands and teaching marketing for over 13 years.
Specializes in helping young adults to grow into the leaders of tomorrow, by confidently developing their marketing skills through training programs and seminars with enterprise clients like The Golden State Warriors, Nike, and Rosetta Stone.
He developed the Technology Partner for Digital Marketing Agencies and Personal Brands. A RevShare Partnership Program that enables growing companies to stay competitive.
None of this would be possible without the generous support of partners such as DigitalMarketer, Social Media Examiner, Fiverr, GoDaddy, Keap, OmniConvert, Onlinejobs.ph, Tom Ferry, Barry Habib, and others who believe in training up millions of digital marketing professionals.
Dennis has been featured in The Wall Street Journal, New York Times, LA Times, National Public Radio, TechCrunch, Fox News, CNN, CBS Evening News and co-authored “Facebook Nation” – a textbook taught in over 700 colleges and universities.
Dennis is an internationally acclaimed speaker in Facebook Marketing who has spoken countless times in 17 countries, spanning five continents including keynote events at L2E, PubCon, Digital Agency Expo, Marketo Summit, and B2C Growth & Innovation Virtual Summit.
Besides being a data and ad connoisseur, Dennis enjoys eating spicy buffalo wings or might just spot him playing Ultimate Frisbee under the sun.
You can contact him at email@example.com or on one of his social accounts below.