Slide 1
Slide 1 text
Google Data Studio 101
Yoko Hato
Slide 2
Slide 2 text
● 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
Slide 3
Slide 3 text
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
Slide 4
Slide 4 text
Introduction of Overview
I expected that
we would
aggregate the
data weekly and
not monthly for
our analysis !!
Me
Slide 5
Slide 5 text
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のまま
理由はググっても分からなかった。
Slide 6
Slide 6 text
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
Slide 7
Slide 7 text
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
Slide 8
Slide 8 text
Show Google Analytics data beautifully
Slide 9
Slide 9 text
Effective use cases in general office work
Only Allowed
Person can see
data with
Personal
Information
Slide 10
Slide 10 text
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 !!!
Slide 11
Slide 11 text
Let me describe a sample workflow
1. Download the csv data from a third party system
Slide 12
Slide 12 text
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
Slide 13
Slide 13 text
Let me describe a sample workflow
3. Use the data source to make a report
Slide 14
Slide 14 text
How to update old data to new data
Slide 15
Slide 15 text
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
Slide 16
Slide 16 text
Important information for the audience
WE ARE HIRING !!!
Recruitment Information
on Github
https://tech.andpad.co.jp/
https://github.com/andpad-dev/recruit