Google Data Studio 101

Introducing Google Data Studio.

Transcript

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