Automating exports from Google Analytics for scheduled reporting

James Standen Analytics Canvas Tool, Automation 9 Comments

While usually the most important and valuable analysis is ad-hoc, and done by an analyst, very often there is the need for scheduled exports and reporting of Google Analytics data. Google Analytics provides some automation capabilities for custom reports, for a limited number of dimensions and metrics, but of course the results are subject to sampling (fast access mode). The …

4 reasons people think analytics data warehouses are super expensive and why they are not

James Standen Analytics, Automation, Data warehousing Leave a Comment

1) Reporting bias Maybe the main reason everyone thinks Data warehouses are expensive is because they’ve heard about a really expensive one. While one would think that you’d hear all about the really successful data warehouse projects, the reality often is that really spectacular failures catch our attention more and therefore get more widely reported/discussed 2) The need to buy …

ETL vs Making a bunch of really hacked together crazy spreadsheets

James Standen Analytics Canvas Tool, Automation Leave a Comment

ETL stands for “Extract, Transform and Load”. ETL is a key process in the business intelligence and data warehousing arena- it’s all about automating data movement and building repeatable, robust processes that take raw data, clean it, fix it, enrich it, and then load it into a location where it can be easily queried and analyzed. The opposite of ETL …