Google Data Studio vs. Power BI

***TIP: Subscribe to our newsletter. Don’t miss any new content.*** Google Data Studio has been public for a while. It has already changed PPC reporting routines of many people. But how does Google Data studio compare with Microsoft’s Power BI which has been on the market for few years? Read more to find out. This article will […]

Using Google Sheets as Data Source in Power Query

***TIP: Subscribe to our newsletter. Don’t miss any new content.** Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query? Actually pretty well. Sample scenario: You store reference sheets via Google Sheets files where multiple people can work at the same time. You would like […]

How To Build Excel Refreshable Reports in 5 Minutes Without Macros

***TIP: Subscribe to our newsletter. Don’t miss any new content.*** In today’s post, we will look at building simple Excel refreshable reports WITHOUT using any macros. Typical scenario: You get files with performance data on a regular basis (daily, weekly). E. g. CSVs, TXTs, XLSs, XLSXs… You just want to take these files, drop them into […]