Data Studio & Data Visualization - Our Work

The Power of Data Visulizations

Take a look at these data visualizations...


They help show the power of data visualisation to convey drab or complex data in powerful and instinctive ways. As beautiful as they are - handcrafted and neatly put together - they are not merely a "convenient" way of communication.


They were hugely influential in changing policy, ideas, ignorant views and dramatically helping society move forward in a positive way.


Florence Nightingales' Polar Maps (also known as Coxcombs) from the Crimean War (1853-1856)

Courtesy: of University of Houston

W.E.B. Du Bois Data Visualization series at the Exposition Universelle in Paris 1900.

Courtesy: of Tableau


Take another look at those dates: 1850s and 1900... these visualizations would look cutting edge in any dashboard today! They show that Data Visualization isnt about the latest technical tool or wizbang data plugin. It is about the data. It is about the story you can tell. Once you have interesting data and an interesting story to tell, you can get extremely creative.. and possibly even change the world! 😀

Data Studio

Google Data Studio is a free Data visualization tool that connects natively to the Google stack. This includes a very large group of google tools, eg Search Console, Google Analytics, Google Adwords, BigQery etc see image below. Data studio is our preferred data visualization tool – for most reports (except very large ones).


It works particularly well connecting to the Google stack. We are one of the few Melbourne & Sydney based consultancies/agencies working across the cutting edge of Data Studio. In the connector image below you will see there are 18 native google connectors but a whopping 256 partner connectors (as of September 2020). There is an entire community of Data Studio developers developing various connectors to the platform which are really taking out of the “free tool” realm into enterprise worthy reporting tool.

Data Studio Connectors

The Native Data Studio Connectors and 256! (as at Sep 2020) partner connectors


Note: we also work with various other data visualization tools as well including Tableau, Power BI and Infogram.

Our Data Studio Dashboards

We have worked on tonnes of dashboards. Most of our clients use them. From program participation dashboards, to SEO dashboards to the lastest in custom visualizations and dashboarding with shape/map files. We are pushing the boundaries. Read on for more, including downloadable templates!



SEO - SERP POSITION BY BAND DASHBOARD - DOWNLOADABLE TEMPLATE

This clever SEO dashboard allows you to circumvent the dreaded "cant mix metrics and dimensions in case statements" issue by making use of the Extract Data function in data studio, applying this to search console and then applying the transformations to the resultant data. The result is an awesome data set that splits down your Keywords by Position band - eg 1-5, 5-10 etc..

Data Studio - Covid Melbourne/Sydney

COVID-19 SYMPTOMS DASHBOARD - USING ADWORDS SEARCH DATA

In light of COVID, we created a dashboard that predicts COVID outbreaks. It uses Adwords search data on well known COVID symptoms such as "loss of smell". For more information on what we did here - check out our blog post Side note! Interestingly - you cant embed Data Studio dashboards that have the new Google maps functionality in them. You just cant :-( Hence we have used an image link above 😀




Data Studio - Non Google Data

STORE OWNERS (SALES DATA)

Here is an example of mixing offline sales data and online marketing data. We achieve this by storing/blending data sources in Google Cloud Storage and BigQuery. Sales files are automatically captured and moved from gmail using Google Apps scripts. Finally sending the information off to Google Data for easy executive level reporting

image

PUBLISHERS & BLOGGERS EXAMPLE TEMPLATE

Publishers are under increasing scrutiny to show the value of their audience. Advertisers want to see the detail of what they are investing their dollars in! The above is a scaled down version of a publisher dashboard we have built that can help you grow Affiliate & Ad revenue, increase blog traffic & understand your audience.

Contact Us

Send us a message and let us know what you are trying to accomplish. We’d love to help and will get back to you within 1 hr.

let’s talk