Skip to main content

Data science projects from our Accelerator and 7th Show & Tell

Posted by: , Posted on: - Categories: Data science, Data Science Accelerator

We’ve recently invited another round of applications to the Data Science Accelerator Programme. This blog gives you a taster of what that involves. It covers recent Accelerator projects and our latest Data Science Show and Tell (where 2 of these projects …

Using relative date formulas in Google Sheets to query Google Analytics data

Posted by: , Posted on: - Categories: Google Analytics, Google Sheets
Calendar dates

I regularly use the Google Analytics add-on in Google Sheets for reporting data to stakeholders. It's a way to obtain data via the API and run queries which are not possible to do within the Google Analytics interface. I find …

How to scrape page data using the ImportXML function in Google Sheets

Posted by: , Posted on: - Categories: Google Sheets

When I’m doing content analysis on GOV.UK, sometimes I need to analyse page level data which is not tracked through analytics software but still represents valuable information. In these circumstances I use the ImportXML feature in Google Sheets which enables …

Big sites in Google Analytics Premium: sharing tips & techniques

Posted by: , Posted on: - Categories: Google Analytics, Google Sheets, Tableau
Photo of group in Autotrader's reception, with a Mini half way up the wall

The practical issues of working with huge volumes of data are similar for both public and private sectors. These are the security of third party tools, the challenges of visualising data and the frustrations of working at scale. I joined colleagues from …

Performance Anxiety

Posted by: , Posted on: - Categories: Data science

How does digital government in the UK compare to other countries? The Organisation for Economic Cooperation and Development (OECD) measures this in Government at a Glance. According to this report, the UK does well at publishing open data and managing …