Pivot tables first steps [video]

28. March 2016 Excel 0
Pivot tables first steps [video]
If you ever needed to create summaries of raw data, but had no time you have most probably heard of pivot tables before. They are glorious when it comes to solving many of your usual excel tasks, though still not all of us know how to use them, despite them being pretty straightforward. What pivot ...

7 cool Excel tricks to rock at work [Infographic]

06. March 2016 Excel 0
7 cool Excel tricks to rock at work [Infographic]
Do you ever wonder what extra skills you can apply in¬†Excel to speed your work up? Do you ever get tired of always getting the same Excel tricks as advice, meaning actually some VLOOKUP? So do I. This is why I was happy to find a Hubspot blog post which actually shows you some not ...

Cohort analysis for retention

Cohort analysis for retention
Though I already wrote a bit about cohort analysis beforehand, luckily the web is full of new material popping up all the time. This time I found some visualizations created in R through the AnalyzeCore blog of Sergey Bryl¬†covering the retention aspect of the story. There is a different approach to this very same topic ...

Analytics vs. Data Science [Infographic]

Analytics vs. Data Science [Infographic]
It is an ongoing discussion what the difference between analytics and data science exactly is. It is a blurry line, but I think the infographic from the American University pretty much nails it. The key opinion it reflects is that a data scientist should spend most of its time creating and programing new algorithms, while ...

Machine Learning for Marketing explained

24. November 2015 Big Data 0
Machine Learning for Marketing explained
Machine Learning as a term can sound alien and slightly difficult to grasp. The first thing actually coming to my mind talking of machine learning is something like Skynet from the terminator movies. The concept migh also sound like covering something very complecated, while it does not necessarily have to be. I have bumped into ...

New SQL course on Codeacademy

New SQL course on Codeacademy
Since I have published my latest collection on SQL resources for marketers Codeacademy.com has published a new SQL course and graduated the program from beta. Back in July I have already mentioned why taking an SQL course is beneficial to any marketer: Gaining independence from IT Speed to analysis on basic inquiries significantly improves When ...