Month: July 2018

Web-scraping with Google Sheets and XPath

One of the more advanced features available to Google users, is the user’s ability to scrape data – from the web – directly into a Google spreadsheet through utilizing the ‘=IMPORTXML‘ function, combined with XPath. The script to follow outlines this functionality by scraping a simple data table from a public website and loading the results into a spreadsheet . In practice, …

9 Box Employee Performance Matrix with Google ‘=query’ (Video Series)

This is a 4 part video series on how to create a 9 Box (Employee Performance) Matrix, using Google’s ‘=query’ function in Google Sheets. For an introduction to Google’s Query function, you can jump directly to Video 3 Apologies upfront for the low volume and my weird accent. Still getting used to the new recording equipment. This is a first attempt, …

Interactive Infographics with Power BI – No experience needed (Part 1/2)

If you are familiar with Business Dashboards (via Excel or other business tools), I’m pretty sure that you’ve come across at-least one or two infographics whilst googling creative dashboard designs (because let’s face it, if you build dashboards for a living or even as a hobby, you want them to look stunning – googling is inevitable) So, what …