Forecasting in Excel 2016 made simple

Forecasting is one of the most common business challenges an analyst can face. So far the toolsin Excel were not very simple when it came to more complex tasks. Linear forecast functions have always been there though. But once you needed to start dealing with seasonality or confidence intervals there was no simple answer. This ...

AB test calculator Excel web app

AB test calculator Excel web app
A/B testing is one of the most common tecniques when it comes to optimizing marketing materials and funnels. I have also already written about 7 key points to make sure that you nail your tests. This time though I thought of creating a “web application” to help you validate the results of your tests. This ...

Bond rate tracking with Power Query

26. April 2016 Excel, Projects 0
Bond rate tracking with Power Query
I was always curious how I could get Power Query useful. In the same time I was struggling with tracking some bonds I was interested in, I\'m a visual guy and I was not satisfied with the type of charts my bank could provide. So these 2 needs met and I have created an automated ...

Who does what in Data Science? [Infographic]

12. April 2016 Big Data 0
Who does what in Data Science? [Infographic]
Who does what in Data Science is confusing, but luckily there are resources to help you figure things out. Last time I shared the distinction between¬†analytics and data science, this time there is a more detailed approach to data workers, originally pusblished on the the Datacamp Blog. In this infographic we compare the roles of ...