Building a mobile friendly dashboard in Google Data Studio

Executive Summary

In this article, we’ll be building this mobile product dashboard for the open source web app ‘forecastr’ using Google Data Studio and in the process we’ll learn how to:

  • Organize data into categories such as Acquisition, Engagement, Retention and Growth
  • Build a simple mobile navigation bar to jump to different sections of our report
  • Create modern mobile UI elements such as data cards and product engagement funnels
  • Integrate data from a growth backlog to tell the story about how we are going to improve our app and drive KPIs
  • Join data together using Google’s data blending feature
  • Create a simple web page for an iframe generated by Data Studio so that we can easily view our report on the mobile web.

At the end of this tutorial, you should be able to apply these learnings with your KPIs to build your own product or sales focused mobile dashboard in Google Data Studio.

Now let’s get started and have some fun!

Building mobile dashboards brings me a surprising amount of joy.

Maybe it’s the fact that we use our mobile devices to consume so much information in the world today, it just feels natural to check my phone for a quick business update. Oftentimes, it can feel like work to fire up the laptop and review some data.

But on my phone, something feels different.

What if our business data was easily accessible on a mobile device across the growing number of the platforms we use today? Wouldn’t that be amazing?

Sure, we’d still need our laptops to do the more intensive analysis and build presentations, but at a high level, our mobile devices seem like the ideal medium for us to consume quick business updates. Just enough information to spark an insight or question, to know what is going on, before we flip open our laptops and do that exploratory analysis.

This article is a first in a series designed to help people build better dashboards and organize the business data we use everyday from around the web.

So today, we are going to have some fun and create a mobile product dashboard in Google Data Studio and then embed it into a web page!

Why Data Studio you ask?

Aside from python, it’s my favourite place to explore and visualize data. It’s the canvas I use to not only tell the story of my business performance, but also what I’m doing to actively improve my business and drive my company objectives in order to reach my goals. And it only gets better if you know how to leverage python with BigQuery (but that’s another blog post)

Now, while this dashboard isn’t going to be responsive, it’s “good enough” to start thinking about how we lay out our data so that as we scroll through our dashboard, we’ll be able to fully understand what is happening with our product and identify opportunities to grow its usage. Along the way, we’ll have a few tips and tricks to work with the layout.

So, let’s imagine that we’re working on an open source web app that guides people through the process of creating a baseline forecasts and we want to make it better.

What would a summary KPI report for this app look like on a mobile device?

First up, let’s get our data sources in order

I’m going to assume that you’ve added data sources to Data Studio before, but if you haven’t here is a link.

To keep it simple and relatively brief, this tutorial will be primarily focused on building out the first page in this report. For this, we’ll be using a few data sources in this report sourced from:

  • Google Analytics — forecastr (production data)
  • Google Sheets — retention data, targets, and growth backlog data

Customizing the Canvas Size

Now that we have our data in order, we need to pick a ‘mobile friendly’ screen width for our canvas.

For this dashboard, I chose 393px wide as I’m currently sporting a Pixel 4, but I’d recommend choosing anything around 400px wide in Data Studio. Or you could use a service like statscounter to find the most popular screen widths and start from there. In any event, when we embed this Data Studio report into a webpage and set the width of the iframe to 100%, the Data Studio report should scale within that space.

So, to set the size of your dashboard, right click anywhere in the blank canvas and select:

Current Page Settings

Then open the STYLE tab in the right menu and update the width and height of your canvas. As you can see in the screenshot below, i’ve selected a canvas size of 393 x 2000 px.

How to set a mobile friendly canvas size in google data studio

#data-science #google-analytics #google-data-studio #dashboard-design #analytics

What is GEEK

Buddha Community

Building a mobile friendly dashboard in Google Data Studio
Sid  Schuppe

Sid Schuppe

1617988080

How To Blend Data in Google Data Studio For Better Data Analysis

Using data to inform decisions is essential to product management, or anything really. And thankfully, we aren’t short of it. Any online application generates an abundance of data and it’s up to us to collect it and then make sense of it.

Google Data Studio helps us understand the meaning behind data, enabling us to build beautiful visualizations and dashboards that transform data into stories. If it wasn’t already, data literacy is as much a fundamental skill as learning to read or write. Or it certainly will be.

Nothing is more powerful than data democracy, where anyone in your organization can regularly make decisions informed with data. As part of enabling this, we need to be able to visualize data in a way that brings it to life and makes it more accessible. I’ve recently been learning how to do this and wanted to share some of the cool ways you can do this in Google Data Studio.

#google-data-studio #blending-data #dashboard #data-visualization #creating-visualizations #how-to-visualize-data #data-analysis #data-visualisation

Siphiwe  Nair

Siphiwe Nair

1620466520

Your Data Architecture: Simple Best Practices for Your Data Strategy

If you accumulate data on which you base your decision-making as an organization, you should probably think about your data architecture and possible best practices.

If you accumulate data on which you base your decision-making as an organization, you most probably need to think about your data architecture and consider possible best practices. Gaining a competitive edge, remaining customer-centric to the greatest extent possible, and streamlining processes to get on-the-button outcomes can all be traced back to an organization’s capacity to build a future-ready data architecture.

In what follows, we offer a short overview of the overarching capabilities of data architecture. These include user-centricity, elasticity, robustness, and the capacity to ensure the seamless flow of data at all times. Added to these are automation enablement, plus security and data governance considerations. These points from our checklist for what we perceive to be an anticipatory analytics ecosystem.

#big data #data science #big data analytics #data analysis #data architecture #data transformation #data platform #data strategy #cloud data platform #data acquisition

Building a mobile friendly dashboard in Google Data Studio

Executive Summary

In this article, we’ll be building this mobile product dashboard for the open source web app ‘forecastr’ using Google Data Studio and in the process we’ll learn how to:

  • Organize data into categories such as Acquisition, Engagement, Retention and Growth
  • Build a simple mobile navigation bar to jump to different sections of our report
  • Create modern mobile UI elements such as data cards and product engagement funnels
  • Integrate data from a growth backlog to tell the story about how we are going to improve our app and drive KPIs
  • Join data together using Google’s data blending feature
  • Create a simple web page for an iframe generated by Data Studio so that we can easily view our report on the mobile web.

At the end of this tutorial, you should be able to apply these learnings with your KPIs to build your own product or sales focused mobile dashboard in Google Data Studio.

Now let’s get started and have some fun!

Building mobile dashboards brings me a surprising amount of joy.

Maybe it’s the fact that we use our mobile devices to consume so much information in the world today, it just feels natural to check my phone for a quick business update. Oftentimes, it can feel like work to fire up the laptop and review some data.

But on my phone, something feels different.

What if our business data was easily accessible on a mobile device across the growing number of the platforms we use today? Wouldn’t that be amazing?

Sure, we’d still need our laptops to do the more intensive analysis and build presentations, but at a high level, our mobile devices seem like the ideal medium for us to consume quick business updates. Just enough information to spark an insight or question, to know what is going on, before we flip open our laptops and do that exploratory analysis.

This article is a first in a series designed to help people build better dashboards and organize the business data we use everyday from around the web.

So today, we are going to have some fun and create a mobile product dashboard in Google Data Studio and then embed it into a web page!

Why Data Studio you ask?

Aside from python, it’s my favourite place to explore and visualize data. It’s the canvas I use to not only tell the story of my business performance, but also what I’m doing to actively improve my business and drive my company objectives in order to reach my goals. And it only gets better if you know how to leverage python with BigQuery (but that’s another blog post)

Now, while this dashboard isn’t going to be responsive, it’s “good enough” to start thinking about how we lay out our data so that as we scroll through our dashboard, we’ll be able to fully understand what is happening with our product and identify opportunities to grow its usage. Along the way, we’ll have a few tips and tricks to work with the layout.

So, let’s imagine that we’re working on an open source web app that guides people through the process of creating a baseline forecasts and we want to make it better.

What would a summary KPI report for this app look like on a mobile device?

First up, let’s get our data sources in order

I’m going to assume that you’ve added data sources to Data Studio before, but if you haven’t here is a link.

To keep it simple and relatively brief, this tutorial will be primarily focused on building out the first page in this report. For this, we’ll be using a few data sources in this report sourced from:

  • Google Analytics — forecastr (production data)
  • Google Sheets — retention data, targets, and growth backlog data

Customizing the Canvas Size

Now that we have our data in order, we need to pick a ‘mobile friendly’ screen width for our canvas.

For this dashboard, I chose 393px wide as I’m currently sporting a Pixel 4, but I’d recommend choosing anything around 400px wide in Data Studio. Or you could use a service like statscounter to find the most popular screen widths and start from there. In any event, when we embed this Data Studio report into a webpage and set the width of the iframe to 100%, the Data Studio report should scale within that space.

So, to set the size of your dashboard, right click anywhere in the blank canvas and select:

Current Page Settings

Then open the STYLE tab in the right menu and update the width and height of your canvas. As you can see in the screenshot below, i’ve selected a canvas size of 393 x 2000 px.

How to set a mobile friendly canvas size in google data studio

#data-science #google-analytics #google-data-studio #dashboard-design #analytics

Gerhard  Brink

Gerhard Brink

1620629020

Getting Started With Data Lakes

Frameworks for Efficient Enterprise Analytics

The opportunities big data offers also come with very real challenges that many organizations are facing today. Often, it’s finding the most cost-effective, scalable way to store and process boundless volumes of data in multiple formats that come from a growing number of sources. Then organizations need the analytical capabilities and flexibility to turn this data into insights that can meet their specific business objectives.

This Refcard dives into how a data lake helps tackle these challenges at both ends — from its enhanced architecture that’s designed for efficient data ingestion, storage, and management to its advanced analytics functionality and performance flexibility. You’ll also explore key benefits and common use cases.

Introduction

As technology continues to evolve with new data sources, such as IoT sensors and social media churning out large volumes of data, there has never been a better time to discuss the possibilities and challenges of managing such data for varying analytical insights. In this Refcard, we dig deep into how data lakes solve the problem of storing and processing enormous amounts of data. While doing so, we also explore the benefits of data lakes, their use cases, and how they differ from data warehouses (DWHs).


This is a preview of the Getting Started With Data Lakes Refcard. To read the entire Refcard, please download the PDF from the link above.

#big data #data analytics #data analysis #business analytics #data warehouse #data storage #data lake #data lake architecture #data lake governance #data lake management

Tia  Gottlieb

Tia Gottlieb

1594600740

Google Data Studio in 6 steps — Beginners Guide

“Whatever your message is, data visualization can increase its reach a thousand-fold” — Randy Olson

Google Data Studio is a data visualization, or a reporting tool aimed at converting data into stories, generate insights and curate reports

Out of the many data visualization or reporting tools, Google Data Studio stands out for its FREE and astute service offerings, and while that might be enough to attract storytelling enthusiasts, it has a multitude of other characteristics to offer –

  • Ease of Use — since most users are well versed with google suite’s user interface, deciphering and navigating data studio becomes natural and intuitive
  • 200+ data connectors
  • Drag and Drop functionality
  • Customizable Charts and Visuals
  • Effortless sharing and collaboration options

Step 1 — Getting Started

To use Google data studio, you can use your existing Google account or create a new one, there is no installation of any kind required.

Next up, once you open Google Data Studio, your window would look as below.

This window provides you with some predesigned reports and templates as your guide or reference.

The Blank Report tile with a ‘+’ sign or the ‘+ Create’ option on the left pane, would direct us to a blank canvas to create our reports.

Image for post

The Data Sources tab provides a view on all the data sources used in creating the reports.

Image for post

You can click on the ‘+ Create’ option to add a data source

Image for post

Step 2: Data Preparation

You have an option to pull data from multiple platforms. Scroll down or use the search option in Google Data Studio to find the platform you wish to connect to.

To know more about the data connectors.

Image for post

Select on the platform or connector of your choice, browse the data set you wish to connect to, and hit the ‘Connect’ button.

Image for post
Once you connect to the data set, your window would be divided into

  • Field Names
  • Field Types
  • Field Default Aggregation type
  • Description (if any)

The Blue colored fields are metric based — fields that can be aggregated (sum, average, count, etc.) or indicate quantitative values.

The Green colored fields are dimensional fields — these fields are categorical in nature (Name, Country, etc.)

Image for post

#data-science #google-data-studio #data #data-visualization #data analysis