Free templates are my favorite part of Google Data Studio. You can spin up a professional level report with your own data in no time. Here are my 6 favorite free templates covering AdWords, Google Analytics, Search Console, Facebook, and others.
The way you structure your dashboards is intrinsically tied to your users and how you plan on informing or improving their actions.
In our last exercise we thought about the persona of our users and the hierarchy of the data we’d be using. We’re going to take that information and use it to help us start structuring our pages.
If you found that you needed lots…
This is the first of several articles in my Data Studio design series. You can find links to the other articles here.
So you’ve got a new project and need to decide what direction take it. We’re going to do two exercises to get started:
This is the most frequently overlooked step in building a dashboard. But I’d argue it’s the most important. Know your audience and understand their needs.
Before we get started:
These articles are not going to please data science purists. If you’re the kind of person that thinks there is never a good place to use a pie chart, then these articles are not for you.
I strongly adhere to the philosophy that great data visualization is 50% core data principles and 50% visual design.
Getting started on Data Studio can take a bit of time. There’s no question that it’s easier to use than most data visualization tools, but there is still a learning curve. I put together this list to help you get started with minimal effort and maximum ‘wow’ factor.
These dashboards include data from social media, google analytics, google ads, and several other sources. You can copy paste all the visual elements and then rewire them to use your own data.
Data Studio is a free data visualization tool that connects to almost any data source including ad platforms, CRM tools, spreadsheet tools, payment processors, social media platforms, google tools, data warehousing systems & much more. It allows you to build dynamic & actionable dashboards in minutes.
Take a look at these embedded reports. These are real live dashboards so try interacting with them, clicking, etc.
This report uses data about airlines and travelers at SFO airport. …
Anybody dealing with tech products and data-focused services runs into the same fundamental problem: what you do is technical but non-technical people control the budget. In other words:
Social reporting, analytics data, paid media performance, eCommerce, heck even just your AdWords performance… having to manually export and build reports like this is tough and time consuming. It doesn’t need to be.
You can save all those wasted hours every month. I’m going to explain how using two methods: Google Data Studio and Excel->PPT linking.
But first, let me set the scene.
Building data-focused products. Startups acquired=1. Hobby = making Google Data Studio & Excel beautiful.