6 advanced techniques to master in Google Data Studio

Google launched a new business intelligence tool called Data Studio in May 2016. It’s a really smart reporting tool for quickly creating powerful, stunning dashboards from multiple Google data sources.

It’s a great option for small/medium businesses already using Google tools, who want to build bespoke dashboards for that 40,000ft view of their business.

Google Data Studio Example Reports

Here are two example reports for a mid-size website (~500k pageviews a month).

Firstly, a mobile performance dashboard:

Data Studio Mobile Performance Dashboard

Continue reading 6 advanced techniques to master in Google Data Studio

Multi-line chart with custom range banding in Tableau

It’s easy in Excel. So it should be easy in Tableau right? Well, not quite.

There’s a little trickery involved! But we likes that, don’t we my precious…

I have 200 unique regions in my dataset so I wanted the chart to show a range from the min to the max. Then I wanted to overlay an average line and a specific, selected region.

Continue reading Multi-line chart with custom range banding in Tableau

Redesigning the Socialexis Site Using the Corsa Theme for WordPress

Recently, I’ve been busy redesigning the website for Socialexis, my wife’s fantastic content marketing firm. I used the Corsa theme from UpSolution. It’s a modern, single-page parallax theme, which is perfect for the Socialexis brand.

Here’s a screenshot of the new website:

New Socialexis website

The screenshot below shows the old website. Whilst there was nothing wrong with it per se, it wasn’t particularly exciting and didn’t represent the creativity and passion at the core of Lexi’s business. Since this original website was built, the business has also focused more on blog management and content creation, so the message needed tweaking. Hence, it was a good opportunity to also redesign the website.

Continue reading Redesigning the Socialexis Site Using the Corsa Theme for WordPress