Data Analysis Using Google Cloud Data Studio

Introduction

Google Cloud Data Studio is a tool for transforming data into useful reports and data dashboards. As of now, Google Data Studio has 22 inbuilt Google Connectors and 571 different Partner connectors which help in connecting data from BigQuery, Google Ads, Google Sheets, Cloud Spanner, Facebook Ads Data, Adobe Analytics, and many more. 

Google Connectors 22
Partner Connectors 571

Once the data is imported, reports and dashboards can be created by a simple drag and drop and using various filter options. Google Cloud Data Studio is out of the Google Cloud Platform, which is why it is completely free. 

Accessing Data Studio

Since Data Studio is out of GCP, simply search "Google Cloud Data Studio" and open the first link or directly open the link “datastudio.google.com” on the browser.

Google Data Studio

This article focuses on analyzing the employee data with 5,000 records downloaded from here

A few important columns in the sample data are:

  • Name Prefix 
  • Age
  • Gender
  • Salary
  • Place Name
  • County
  • State
  • Region
  • Year of Joining
  • DOB
  • Date of Joining

Analyzing Data

First, the data needs to be uploaded to Google Cloud Data Studio by clicking on the “Blank Report” option. Next, select the “File Upload” option, as the data exists on the local machine which requires an Upload to Data Studio. 

File Upload

As soon as the file is uploaded, the Data Studio gives a default view on a random column and “Record Count” as a default metric. The sheet can be renamed and the default view can be removed. Data Studio gives us various chart options such as “Scoreboard,” “Table,” “Time Series,” “Bar,” and “Pie." To begin, the simplest chart can be selected, which is the “Scoreboard,” and by default, the “Scoreboard” returns the total number of records in a sheet.

Employee Data Analysis Record Count

Any column can be selected from the sheet in the right panel “DATA,” and the style can be modified using the “STYLE” option on the right panel.  

DATA panel

Changing the metric “State” will return the total number of distinct States in the Employee Data.

Changing the "State" metric

Just like with Scoreboard, "Pie Chart" can be used for showcasing percentages like profits from different countries, the number of employees from different countries, etc. In the Employee Data Analysis, we can use a pie chart to display the percent of employees belonging to different regions in the USA. In the Dimension section select “Region.”

Pie chart showcasing percentages

Pivot Table

Pivot tables help in organizing the data by multiple categories, such as breaking down regional "Gender/Record Count." Data Studio provides Row Dimension and Column Dimension options for data distribution. In the example below, the row dimension is "Region" and the column dimension is "Gender." 

Gender/Record Count breakdown

The grand total can be done both via rows and columns in Data Studio. The "Totals" section provides the option of displaying the grand total.

Row/Columns Grand Total

Data in the pivot table can be sorted in ascending/descending order.

Pivot table data - ascending/descendingAdding Controls

Advance Filter

The Controls allow for filtering of the data or changing the display of the data in the report. The most important control is the “Advance Filter.” This filter helps in filtering the data based on fields and conditions. In the example of the Pie Chart where the chart is created based on the “Region” attribute, this data can be further filtered based on only the “South and West” region.

Pie chart with further filtering

Another example below is filtering based on numeric columns, finding employees with Salaries greater than 150K.

Another example of pie chart using further filtering, with salary

List

Data Studio provides two List Options: “Fixed Size List” and “Drop Down List.” Drop Down displays the control in a drop-down combo box and Fixed Size control displays the data as a fixed-size box. 

Drop Down 

Drop Down List

Fixed Size 

Fixed Size list

Styling 

Data Studio exclusively provides the option of adding styles to the charts/tables, users can add Headers/Title, or style them as well. Data Studio also provides conditional styling options such as showing the row in red if the number is greater than the "x" value. 

Let’s add some style to the pivot table example breaking down regional gender data distribution. To add style to the components, the user needs to change the defaults from the "STYLE" section. 

Example of styling addition to pivot table

In the example, we will show the Record Count value in red color when the value is less than 500. 

Setting Record Count text tyle to red

Which results in the following:

Gender/Record Count results with red font styling

Summary

Google Data Studio is a complete tool for proper data analysis by simple drag and drop, where no code data can be analyzed. It supports 571 partner connections and 22 Google connectors from which data can be imported easily and analyzed. The Dashboard updates in Data Studio are real-time, and above all, it’s a free tool for the most part. In order to integrate with some other external apps like Shopify or Coupler.io, use needs licensing. Reports prepared in Data Studio can be imported as PDF, and also it provides the option of adding themes and layouts.

文章来源于互联网:Data Analysis Using Google Cloud Data Studio

发布者:小站,转转请注明出处:http://blog.gzcity.top/4200.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022年5月3日 02:49
下一篇 2022年5月3日 18:08

相关推荐

  • React 18 – 新功能和改进策略

    3 月 8 日,React 团队发布了 React 18 RC(Release Candidate )。最新版本带来了许多新功能,这些功能将改变许多应用程序中的编码模式。它带来了一些性能改进,我将在本博客中介绍这些改进。 并发 并发性是多个进程同时执行,并且可能相互交互也可能不交互的系统的属性。太复杂了?让我们分解一下。假设有一场比赛正在进行中。现在,并发性…

    2022年4月23日
    50220
  • Explaining How Kafka Works With Robin Moffatt

    In this episode of Cocktails, we talk to a senior developer advocate from Confluent about Apache Kafka, the advantages that Kafka’s distributed pub-sub model offers, and how an eve…

    2022年5月3日
    973240
  • The Comprehensive IT Guide to Diagnosing and Fixing Packet Loss

    The internet runs on data. Every day, humans create at least 2.5 quintillion bytes of digital data and share a significant portion of that with the world via the internet. Whether …

    大数据 2022年5月3日
    885160
  • The Lakehouse: An Uplift of Data Warehouse Architecture

    In short, the initial architecture of the data warehouse was designed to provide analytical insights by collecting data from various heterogeneous data sources into the centralized…

    2022年5月3日
    623130
  • WIN10 控制台cmd乱码及永久修改编码的解决办法

    WIN10 cmd控制台本来的编码是ANSI的,所以要求执行的批处理脚本编码格式也是ANSI才行,要不就两边统一都改成UTF-8处理(作为一个程序员,一般我都会统一成UTF-8编码格式),下面就介绍如何统一改成UTF-8编码格式   一、修改控制台CMD编码格式为UTF-8 我本机的系统环境: OS Name: Microsoft Windows 10 企业…

    2022年12月6日
    657350

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

评论列表(7条)