I’ve covered the enrichment topic in one of my Data Diva blogs – the requirement business analytic teams have to supplement their core system data with data that we buy or rent from third parties. Sometimes it’s the Census data, sometimes it’s Dun & Bradstreet, sometimes it is Nielsen information…and it’s all sitting in spreadsheets. I had to vent... Read More
Have you ever spent hours handcrafting an Excel spreadsheet? If so, this problem will be very familiar to you.
After you feel really good about your data set and you spit out a report or dashboard, you get asked a simple question: “where did we get this data?” Your easy answer is that you combined data from the CRM and... Read More
Sometimes I work with data that I am not familiar with – either it is unstructured or came from a source that does not follow our naming conventions or data standards. In Excel, I would spend hours staring into the abyss, looking at data sets, columns and values just trying to locate things that were going to screw up... Read More
The Divas recently interviewed our colleague and good friend, Rebecca Wong and talked about Hadoop. For those of you that don’t know the big yellow elephant that has taken over the data room, meet Hadoop. It has completely disrupted the data management world. Hadoop makes it possible to collect and store more raw data than we ever imagined, at... Read More
Have you ever spent hours creating a dashboard or report only to discover a bunch of spelling mistakes in the results? In my younger days, I remember standing in front of my management team, trying to explain that data quality was not really my job. Truth be told, the minute someone spots errors in the data, every decision you... Read More
This is an easy one. How many times do you create a chart only to see that the biggest slice is “Blank?” Now you have to stop what you are doing and go back into your source data to fix those fields.
In Excel, you start with the VBA macro editor, a filter to find the blanks, and then spend... Read More
I have a confession to make. I am really not a Data Diva. I am a Marketing Diva who just has to rely on data to improve what I do every day. When I started my career twenty years ago (I was only seven years old but highly advanced), I really only dealt with a few data sets. The... Read More
The Divas recently “interviewed” Joseph di Paolantonio, Principal Analyst of Data Archon and overall cool guy. The topic was around decisions being made with big data, and the serious pitfalls that happen when data is either not clean or complete.
The webcast started with how we have spent the last twenty years coming up with better ways to handle data,... Read More
Back in January 2014, Scott Brinker posted this Marketing Technology Landscape to his blog on ChiefMartec.com. If anyone ever wonders why Marketing people have a hard time being metrics-driven, let’s take a quick look at this supergraphic. My head hurts when I think about the massive companies who invest in three or four tools in each of these categories… and... Read More
A few months ago, I was having a lively conversation with Lilia Gutnik, our Director of Product Marketing. It was around the idea that we both came to Paxata with unique experiences – specifically around data. I am the classic marketing person who has to constantly rely on data to justify my budget (and sometimes, my very existence) while Lilia had... Read More