Google Data Studio 101

Introducing Google Data Studio.

Transcript

1. Google Data Studio 101
   Yoko Hato
   

   View Slide

2. ● Software Engineer
   ● Lead of recruitment marketing
   team for devs.
   ● Joined ANDPAD in April 2021 🎉
   I LOVE K-POP and Korean Drama!!
   最近のおすすめはNetflixの”マイネーム”
   Yoko Hato
   Self Introduce
   

   View Slide

3. 1. What kind of tool is it ?
   2. Effective use cases in general office
   work
   3. Benefits of using Google Data Studio
   Presenting the structure of my presentation
   

   View Slide

4. Introduction of Overview
   I expected that
   we would
   aggregate the
   data weekly and
   not monthly for
   our analysis !!
   Me
   

   View Slide

5. What kind of tool is Google Data Studio
   2016 The beta version was released
   2018 The official version was released
   Google Data Studio is a free BI tool made by Google
   日本でのプロダクト名はデータポータ
   ルに名称変更されたが
   グローバルなプロダクト名はGoogle
   Data Studioのまま
   理由はググっても分からなかった。
   

   View Slide

6. What is a BI tool ?
   Tableau is a well known BI tool
   Business Intelligence
   A tool that can visualize data from various sources and helps analysis
   and decision making in business.
   Also called
   ● Dashboard tool
   ● Reporting tool
   

   View Slide

7. Types of data sources that can be used
   Easily access a wide
   variety of data with
   built-in and partner
   connectors.
   ● Google Analytics
   ● Google Ads
   ● Search Console
   ● BigQuery
   ● Google Spreadsheet
   ● Cloud SQL
   ● MySQL, PostgreSQL
   ● and so on… + Partner Connectors
   

   View Slide

8. Show Google Analytics data beautifully
   

   View Slide

9. Effective use cases in general office work
   Only Allowed
   Person can see
   data with
   Personal
   Information
   

   View Slide

10. Effective use cases in general office work
    Extracted data
    can be seen by
    Any Person
    But, the allowed person has to
    extract data every time !!!
    

    View Slide

11. Let me describe a sample workflow
    1. Download the csv data from a third party system
    

    View Slide

12. Let me describe a sample workflow
    2. Upload it in a private limited directory on Google Drive
    Set auto transform
    option in the
    Google Drive config
    

    View Slide

13. Let me describe a sample workflow
    3. Use the data source to make a report
    

    View Slide

14. How to update old data to new data
    

    View Slide

15. Benefits of using GDS
    1. Viewer users can export data
    to Google spreadsheets and
    PDF
    2. Able to give customizations to
    data sources by custom
    calculated fields
    3. “Functions” similar to BigQuery
    SQL are provided
    4. Viewer users can change
    aggregation range dynamically
    5. Various data sources can be
    displayed in one report
    

    View Slide

16. Important information for the audience
    WE ARE HIRING !!!
    Recruitment Information
    on Github
    https://tech.andpad.co.jp/
    https://github.com/andpad-dev/recruit
    

    View Slide