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

相关推荐

  • 2 Billion MySQL Records

    Yesterday Gary Gray, a friend of mine sent me the following screenshot. He’s got a database table with 2 billion records he intends to use Magic on, and he wanted to show it …

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

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

    2022年12月6日
    1.1K360
  • 什么是Web3?

    什么是Web3? “什么是Web3?为什么它越来越受欢迎?它与元界有什么关系? Web3(或Web 3.0)是指依赖区块链技术和加密的分散式互联网服务的万维网的新方法。第三代互联网融合了去中心化,基于令牌的经济学和基于机器的数据理解的概念,以提供更自由,更智能,更具吸引力的网络浏览体验。 Web3遵循Web 1.0和Web 2.0的概念,Web 1.0指的是…

    2022年4月23日
    2.2K2730
  • How Does Kafka Perform When You Need Low Latency?

    Most Kafka benchmarks appear to test high throughput but not low latency. Apache Kafka was traditionally used for high throughput rather than latency-sensitive messaging, but it do…

    2022年5月3日
    6.2K14790
  • React 18 – 新功能和改进策略

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

    2022年4月23日
    61860

回复 Binance注册

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

评论列表(24条)

  • Claudevox
    Claudevox 2024年6月16日 08:39

    квартира от застройщика Санкт-Петербург в новостройках Санкт-Петербурга. Цены и фотографии квартир от застройщика в готовых и строящихся ЖК. Подбор жилья, ипотечные программы, сопровождение сделок и выгодные предложения.

  • Robertmeece
    Robertmeece 2024年6月16日 08:39

    квартиры в новостройках Санкт-Петербурге купить квартиру в Санкт-Петербурге от застройщика

  • StanleyPrift
    StanleyPrift 2024年6月17日 23:43

    Драгон Мани Казино https://krpb.ru – ваше место для азартных приключений! Наслаждайтесь широким выбором игр, щедрыми бонусами и захватывающими турнирами. Безопасность и честная игра гарантированы. Присоединяйтесь к нам и испытайте удачу в самом захватывающем онлайн-казино!

  • Patricktus
    Patricktus 2024年6月19日 22:29

    купить квартиру в казани https://nedvizhimost47.ru

  • invodiuri
    invodiuri 2024年8月27日 07:36

    buy priligy in uae Even then, they don t immediately go riding off into the sunset without a care in the world

  • Игорь Тальков Я Вернусь

    Поклонникам творчества Игоря Талькова, не пропустите!
    По ссылке вы найдете легендарную композицию “Я Вернусь” Игоря Талькова Игорь Тальков Я Вернусь.

    Переживите момент ностальгии прямо сейчас!

    PKm Ome

  • Binance注册
    Binance注册 2024年12月27日 17:36

    Your article helped me a lot, is there any more related content? Thanks!

  • rimskie shtori s elektroprivodom_slml

    римские шторы на карнизе [url=https://prokarniz24.ru/]римские шторы на карнизе[/url] .

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月21日 04:52

    Very good write-up. I definitely love this website.
    Keep writing!

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月21日 13:51

    Having read this I believed it was rather informative.

    I appreciate you taking the time and energy to put this
    article together. I once again find myself spending
    way too much time both reading and leaving comments. But so what, it was still worthwhile!

  • SITUS PENIPU
    SITUS PENIPU 2025年2月23日 06:40

    Heya i am for the primary time here. I came across this
    board and I in finding It truly useful & it helped me out a lot.
    I am hoping to offer one thing again and help others such
    as you aided me.

  • SITUS PENIPU
    SITUS PENIPU 2025年2月23日 14:36

    Hello There. I discovered your blog using msn. This
    is an extremely well written article. I will be sure
    to bookmark it and come back to learn more of your useful information. Thanks for the post.
    I will certainly comeback.

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月27日 07:59

    Greetings! Very helpful advice within this
    article! It is the little changes that produce the most significant changes.
    Many thanks for sharing!

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月27日 13:51

    I have been exploring for a bit for any high
    quality articles or weblog posts on this kind of area . Exploring in Yahoo I ultimately stumbled upon this website.
    Studying this info So i’m satisfied to show that I’ve an incredibly good uncanny feeling I discovered just what I needed.

    I so much indisputably will make sure to do not omit this site and give it
    a look regularly.

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月27日 22:09

    excellent submit, very informative. I wonder why the
    other experts of this sector do not notice this. You should continue your writing.
    I am confident, you have a great readers’ base already!

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月27日 22:33

    You actually make it appear really easy along with your presentation but I to
    find this matter to be really something that I feel I would
    by no means understand. It seems too complex and very large for me.
    I’m having a look forward for your subsequent put up, I’ll try to
    get the hang of it!

  • PENIPU ONLINE
    PENIPU ONLINE 2025年2月28日 06:30

    I like the valuable information you provide in your
    articles. I will bookmark your blog and check again here frequently.
    I am quite certain I’ll learn a lot of new stuff right here!
    Good luck for the next!

  • PENIPU ONLINE
    PENIPU ONLINE 2025年3月1日 07:20

    Do you have a spam problem on this site; I also am a blogger, and I was wanting to
    know your situation; we have created some nice procedures and we are looking
    to swap solutions with other folks, why not shoot me an e-mail if interested.

  • Bokep Indonesia
    Bokep Indonesia 2025年3月4日 05:16

    My partner and I stumbled over here from a different website and thought I should check things
    out. I like what I see so i am just following you. Look
    forward to going over your web page for a second time.

  • video mesum anak kecil
    video mesum anak kecil 2025年3月7日 07:55

    If you would like to increase your knowledge simply keep
    visiting this site and be updated with the most up-to-date gossip posted here.

  • BOKEP INDONESIA
    BOKEP INDONESIA 2025年3月12日 14:07

    Attractive section of content. I just stumbled upon your
    weblog and in accession capital to claim that
    I get in fact enjoyed account your weblog posts. Anyway I will be subscribing in your
    augment or even I achievement you get right of entry to
    constantly rapidly.

  • oformit propysk v Moskvy_emsi
    oformit propysk v Moskvy_emsi 2025年3月12日 23:53

    москва рекламное агентство продвижение сайта [url=http://aktivnoe.forum24.ru/?1-3-0-00000154-000-0-0]москва рекламное агентство продвижение сайта[/url] .

  • BOKEP TERBARU 2025
    BOKEP TERBARU 2025 2025年3月13日 13:17

    Good post. I’m experiencing many of these issues as well..

  • Bokep Terbaru 2025
    Bokep Terbaru 2025 2025年3月14日 05:22

    I think the admin of this website is really working hard in favor of his site, because here every data is quality based material.