Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

Self Introduction Role ⎯ LINE Fukuoka / Development Center / Data Labs ⎯ Support data utilization in LINE Fukuoka Company Name ⎯ Harayama Koya

Slide 3

Slide 3 text

There are 9 roles required for data utilization project Today’s take away Project scaling issues can be solved by the team based on roles

Slide 4

Slide 4 text

Agenda - About LINE Fukuoka - Data utilization project in LINE Fukuoka - Roles required for data utilization project - How to solve project scaling issues by roles - Current issue and future planning

Slide 5

Slide 5 text

About LINE Fukuoka

Slide 6

Slide 6 text

Technology Corporate Activities Planning / Marketing Design Operations Second domestic base of LINE

Slide 7

Slide 7 text

Monitoring Operation Direction Localization Reviews Customer Care Operations etc.

Slide 8

Slide 8 text

Data utilization project in LINE Fukuoka

Slide 9

Slide 9 text

No data platform Issues about KPI Management No comprehensiveness No data utilization culture

Slide 10

Slide 10 text

VIIM Project Since Feb. 2020 Visualize / analyze operation data Support KPI management Cross-department project

Slide 11

Slide 11 text

Cross-department project Data Labs Global Operation IT Promotion Value Management

Slide 12

Slide 12 text

Volume Quality Productivity Dashboards

Slide 13

Slide 13 text

Project scaling Since 2020/02 Number of dashboards 300 Number of dashboard users 20 10 25x 30x 500

Slide 14

Slide 14 text

Defined 9 roles for data utilization project Success factors of project scaling Organized project team based on roles Utilized roles to solve issues of project scaling

Slide 15

Slide 15 text

No Roles Value Management IT Promotion Global Operation Data Labs 1 Data Strategy ̋ 2 Data Governance ̋ ̋ 3 Data Architecture ̋ 4 Data Infrastructure ̋ 5 Data Planning ̋ ̋ 6 Data Ingestion ̋ ̋ 7 Data Warehouse / Data Mart ̋ 8 Data Visualization ̋ 9 Data Analysis ̋ ̋ Roles and assignment

Slide 16

Slide 16 text

Roles required for data utilization project

Slide 17

Slide 17 text

Data Collection Data Manipulation Data Visualization / Data Analysis Project Setup Steps of data utilization project Before collecting data After collecting data

Slide 18

Slide 18 text

No1 : Data Strategy Roles: - Set the project goals - Make plans to utilize data to achieve project goals Related job type: - Data strategist As-Is To-Be (Goal) data

Slide 19

Slide 19 text

No2 : Data Governance Roles: - Make rules and policies of data governance - Communicate with info sec & legal depts. Related job type: - Data manager Rules and policies Data governance Info sec / Legal Communication

Slide 20

Slide 20 text

No2 : Data Governance Roles: - Make rules and policies of data governance - Communicate with info sec & legal depts. Related job type: - Data manager Rules and policies Data users Data governance Infosec / Legal Data source Data Communication

Slide 21

Slide 21 text

No3 : Data Architecture Role: - Make a system design of data platform Related job type: - Solution architect

Slide 22

Slide 22 text

System Architecture of VIIM Project Data Lake Data Warehouse tableau VIIM Project DBs airflow workflow tool

Slide 23

Slide 23 text

No4 : Data Infrastructure Role: - Prepare DBs and other tools based on system architecture Related job type: - Data platform engineer

Slide 24

Slide 24 text

No5 : Data Planning Roles: - Make plans of each data utilization - Manage sub-project of each data utilization Related job Type: - Data planner Data What data? How to store? How to visualize/analyze? Data users

Slide 25

Slide 25 text

No6 : Data Ingestion Roles: - Collect and ingest data into Data Lake based on data planning Related job type: - Data Engineer - Analytics Engineer

Slide 26

Slide 26 text

No7 : Data Warehouse / Data Mart Role: - Build data warehouse / data mart following data planning Related Job Type: - Analytics engineer

Slide 27

Slide 27 text

No8 : Data Visualization Role: - Visualize data based on data planning - Support KPI management of users Related job Type: - Data analyst

Slide 28

Slide 28 text

No9 : Data Analysis Role: - Ad-hoc data analysis based on data planning - Support decision making Related job type: - Data analyst - Data scientist Data Analysis

Slide 29

Slide 29 text

Data Collection Data Manipulation Data Visualization / Data Analysis Project Setup 9 roles for data utilization project Before collecting data After collecting data 1 Data Strategy 2 Data Governance 3 Data Architecture 4 Data Infrastructure 5 Data Planning 6 Data Ingestion 7 Data Warehouse / Mart 8 Data Visualization 9 Data Analysis

Slide 30

Slide 30 text

How to solve project scaling issues by roles

Slide 31

Slide 31 text

Issue : how to build the project team X Dept. Y Dept. x1 Team x2 Team y1 Team y2 Team Whom to ask? What to ask? ?

Slide 32

Slide 32 text

No Roles Value Management IT Promotion Global Operation Data Labs 1 Data Strategy ̋ 2 Data Governance ̋ ̋ 3 Data Architecture ̋ 4 Data Infrastructure ̋ 5 Data Planning ̋ ̋ 6 Data Ingestion ̋ ̋ 7 Data Warehouse / Data Mart ̋ 8 Data Visualization ̋ 9 Data Analysis ̋ ̋ Role assignments by mission and skill-set

Slide 33

Slide 33 text

Issue : Scope of data collection Need to check these points - Scope of data collection - Personal information - Permission of data owner ? Data Lake Scope? Personal information? Permission?

Slide 34

Slide 34 text

Check each point by each role 5 Data Planning Current / future usage Scope of data collection

Slide 35

Slide 35 text

Check each point by each role 2 Data governance Information Security Answer Question 5 Data Planning Current / future usage Personal Information Scope of data collection

Slide 36

Slide 36 text

Check each point by each role Personal Information 2 Data governance Information Security Data Owner Permission of data owner 5 Data Planning 2 Data governance Approve Explain 5 Data Planning Scope of data collection Current / future usage Answer Question

Slide 37

Slide 37 text

Issue : Accountability of data Need to answer the questions from internal audit etc. - What data are stored in DBs - Prove there is no high-risk personal information in DBs ? Data Lake Data Warehouse Which table? Which column? Internal audit etc. Question

Slide 38

Slide 38 text

Prepare data catalog 4 Data Infrastructure Data Catalog Request Prepare All roles

Slide 39

Slide 39 text

4 Data Infrastructure Data Catalog Request Prepare All roles 2 Data Governance Internal audit etc. Answer Prepare data catalog

Slide 40

Slide 40 text

Issue : Permission control of dashboard users Need to manage many users - Prepare permission policy - Monitor account usage Users Dashboards OK NG NG OK

Slide 41

Slide 41 text

Make a manual of permission control 2 Data governance Infosec / Legal Permission control manual Communication

Slide 42

Slide 42 text

Delegate permission control to user side 2 Data governance User side manager Dashboard Users delegate permission control

Slide 43

Slide 43 text

Monitor dashboard usage 2 Data governance User side manager Dashboard Users delegate permission control monitor 8 Data Visualization Monitoring dashboard

Slide 44

Slide 44 text

Number of dashboards 300 Number of dashboard users 20 10 25x 30x 500 Issue : Task increase following project scaling

Slide 45

Slide 45 text

Each member’s growth and efficient hiring 10 Number of project members 16 Value Management Data Labs IT Promotion Global Operation

Slide 46

Slide 46 text

Data Collection Data Manipulation Data Visualization / Data Analysis Project Setup Project scaling issues Before collecting data After collecting data Task increase following project scaling How to build project team Scope of data collection Permission control of dashboard users Accountability of data

Slide 47

Slide 47 text

Current issue and future planning

Slide 48

Slide 48 text

Issue : More complicated data governance tasks - Stricter personal information management rules - More complicated discussion required with infosec & legal dept. Rules and policies Data users Data governance Data source Data Communication Infosec & Legal

Slide 49

Slide 49 text

No Roles Value Management IT Promotion Global Operation Data Labs 1 Data Strategy ̋ 2 Data Governance ̋ ̋ 3 Data Architecture ̋ 4 Data Infrastructure ̋ 5 Data Planning ̋ ̋ 6 Data Ingestion ̋ ̋ 7 Data Warehouse / Data Mart ̋ 8 Data Visualization ̋ 9 Data Analysis ̋ ̋ Other roles in each dept.

Slide 50

Slide 50 text

Launch a new dept. for data governance (in LINE Fukuoka) Data Labs Global Operation Value Management IT Promotion Data Governance

Slide 51

Slide 51 text

More data driven company VIIM Project LINE Fukuoka

Slide 52

Slide 52 text

There are 9 roles required for data utilization project Today’s take away Project scaling issues can be solved by the team based on roles

Slide 53

Slide 53 text

Thank you