3 Crucial Tips for optimizing Google Analytics with Microsoft Power BI

Background It’s estimated that 55% of all the worlds websites have Google Analytics [GA] installed on them. This number dwarfs the next largest competitor, Adobe. Due to its sheer size, scale, ease of use, and robust API’s – pretty much everyone supports it, including Microsoft PowerBI. PowerBI’s integration with GA is longstanding, pretty solid, and…

Creating simple time series forecasting using Microsoft PowerBI and DAX

Microsoft’s PowerBI platform continues to present itself as a strong competitor to entrenched players like Tableau, Looker, and Qlik. Power BI has strengths with its embedded ETL toolset, very fast Columnar (SSAS) database, powerful DAX programming language, R integration, and its compelling pricepoint. That aside, there are still key areas that are missing when compared to…

Enhancing your Job Search with Applied Analytics

Background I met my good friend, Michael for lunch the other day for input on the analytical approach I had adopted for my job search. Both Michael and I are actively pursuing new opportunities and both of us are looking for something in the Director/VP space. I asked Michael how many resumes He sends out on…

A college student’s guide to choosing a career in Digital Analytics

Take a look at the salary report the Digital Analytics Association just released and you will quickly see why the analytics field is currently very hot and will continue to be so for quite some time. As such, I thought it would be a good idea to write a quick “buyers guide” for college students interested…

Quantifying the engagement impact of Display Advertising

Display Advertising is a normative experiential aspect of web sites nowadays and the majority of site visitors do not take offense to the presence of advertising real-estate. As a mater-of-fact: after reviewing user feedback (UGC), Call-center tickets, and direct customer conversations concerning advertising. Most users stated that they understood and accepted the business necessity as long as it…

How to manage Display Advertising exclusive deals

Background: As the owner of monetization for your companies web property – you have successfully implemented a multi-partner, programmatic Real-Time-Bidding (RTB) waterfall that’s generating impressive yield numbers. Because of your excellent track record, Management is now expecting you to consistently increase your key performance indicators (KPI’s) – traffic and Revenues ($eRPM). Problem: You know the next couple…

Implementing Environmental Dashboards in your workplace

  We’ve all seen them – those big, flat-panel televisions – colorfully beaming with real-time data points. Pure eye-candy! I am a big proponent of environmental dashboards in the office space. Dashboards serve a vital purpose as a communication hub – providing quick access to metrics the whole organization should be aware of. However, they should not over-extend their…

Project 1 – Lifetime value (LTV) introduction

Welcome! As the first official post, I want to take a moment to set the stage for the upcoming collection of work I will be posting. As this site is all about analytics, with a focus on business – I want to discuss some things that are very near and dear to my heart: analytics,…