Technical skills in analytics are the magic behind the curtain. They are what produces the results. Even if you are mediocre at most of them, you’re better off than most marketers. Therefore, I decided to share the free our list of data analytics basic tutorials that will surely get you started. Free Data Analytics Basic Tutorials for Beginners In order of importance, here are the skills you need to learn.
The Vlookup Have you ever had to compare two lists of email addresses? How about flag a certain set of products out of a large transaction list? Or maybe mash up a few lists of ugly-looking customer IDs? This function will allow you to do all of it! Lets take the example of two lists of customer IDs that you need to mash up to see which customers are members
We are now ready, having performed a historical analysis in part 1 of this post, to create a useful system for pricing. Depending on how comfortable you are with statistics and mathematical operations with standard deviations, you may or may not understand why the excel formulas are set up the way that they are. A full explanation of the mathematics is not our purpose here, however; we just want to
Pricing is perhaps one of the hardest aspects of marketing to get right. And even though it’s impossible to keep control over and measure all of the variables involved, using analytics can help you track and predict enough of those variables so you can set the price where it needs to be. Here, we will outline an example of how to set up a pricing model for a service –