๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
Analytics/Tableau Study

11/10 ์ฒซ Tableau ๋ฐ์ดํ„ฐ๋ถ„์„ ์Šคํ„ฐ๋”” ๊ธฐ๋ก

by yun_analytics0 2024. 11. 19.
๋ฐ˜์‘ํ˜•

twbx 8๊ธฐ๊ฐ€ ๋๋‚˜๊ณ  ๋งˆ์Œ๋งž๋Š” ์ˆ˜๋ฃŒ์ž๋“ค๋ผ๋ฆฌ ์Šคํ„ฐ๋”” ์†Œ๋ชจ์ž„์„ ๋งŒ๋“ค๊ธฐ๋กœ ํ–ˆ๋‹ค.
๋น„์Šทํ•œ ๊ณ ๋ฏผ๊ณผ ๋ชฉํ‘œ๋ฅผ ๊ฐ€์ง„ ๋ถ„๋“ค์ด๋ผ ์žฌ๋ฐŒ์„๊ฒƒ ๊ฐ™๊ณ  ์ง๋ฌด์Šคํ‚ฌ์„ ๊พธ์ค€ํžˆ ํ–ฅ์ƒ์‹œํ‚ฌ ์ˆ˜ ์žˆ์„ ๊ฒƒ ๊ฐ™๋‹ค.
 
์•„์ง์€ ๋ฐฉํ–ฅ์„ฑ์ด ๋ชจํ˜ธํ•ด์„œ 1์งธ์ฃผ ์Šคํ„ฐ๋””๋Š” ์บ๊ธ€์˜ ๋ชจ๋ฐ”์ผ ๋””๋ฐ”์ด์Šค ๋ณ„ ์•ฑ ์œ ์ € ํ–‰๋™ ๋ฐ์ดํ„ฐ๋กœ, ์‹œ๊ฐํ™”ํ•ด๋ณด๊ธฐ๋กœ ํ–ˆ๋‹ค.

https://www.kaggle.com/datasets/valakhorasani/mobile-device-usage-and-user-behavior-dataset/code

 

Mobile Device Usage and User Behavior Dataset

Analyzing Mobile Usage Patterns and User Behavior Classification Across Devices

www.kaggle.com

 
๋‚˜์˜ ๋Œ€์‹œ๋ณด๋“œ ์ œ์ž‘๊ณผ์ •์€ ์•„๋ž˜์— ๋‚จ๊ฒจ๋‘์—ˆ๋‹ค..(์ถ”๊ฐ€์˜ˆ์ •..)
https://yun0analytics.tistory.com/entry/Study-1-%EC%A3%BC%EC%B0%A8-%EB%AA%A8%EB%B0%94%EC%9D%BC-%EB%94%94%EB%B0%94%EC%9D%B4%EC%8A%A4-%EC%9C%A0%EC%A0%80-%ED%96%89%EB%8F%99-%EB%B6%84%EC%84%9D-%EB%8C%80%EC%8B%9C%EB%B3%B4%EB%93%9C
 
 

 

Study 1 ์ฃผ์ฐจ - ๋ชจ๋ฐ”์ผ ๋””๋ฐ”์ด์Šค ์œ ์ € ํ–‰๋™ ๋ถ„์„ ๋Œ€์‹œ๋ณด๋“œ

์Šคํ„ฐ๋”” ์ง„ํ–‰์ผ : 24.11.10๐Ÿ’ก ๋Œ€์‹œ๋ณด๋“œ ๋ฐ ํผ๋ธ”๋ฆญ ์ฃผ์†Œhttps://public.tableau.com/views/Mobileusagebehavior_202411/BYGROUP?:language=ko-KR&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link Mobile usage behavior_202411Mobile usage b

yun0analytics.tistory.com

 

โญ๏ธ์˜ค๋Š˜์˜ ์Šคํ„ฐ๋”” ์ •๋ฆฌ 11/10 โญ๏ธ

1.  ์ง€๋‚œ ์‹œ๊ฐํ™” ๊ฒฐ๊ณผ ๊ณต์œ  ๋ฐ ํ”ผ๋“œ๋ฐฑ ์™„๋ฃŒ


2. ๊ฐ์ž์˜ ๋ชฉํ‘œ์™€ ์Šคํ„ฐ๋”” ๋ฐฉํ–ฅ์„ฑ ๋…ผ์˜(2๊ฐ€์ง€์ค‘ ์•„์ง ๋ฏธ์ •๐Ÿฅฒ)
- ๊ฐ™์€ ๋ฐ์ดํ„ฐ๋กœ ์ง„ํ–‰
- ์„œ๋กœ ๋‹ค๋ฅธ ๋ฐ์ดํ„ฐ๋กœ ์ง„ํ–‰
   → ๋ฐ์ดํ„ฐ ํ™œ์šฉ ๋กœํ…Œ์ด์…˜์‹: ์‚ฌ๋žŒ1์˜ ๋ฐ์ดํ„ฐ๋ฅผ ์ฐจ์ฃผ์— ์‚ฌ๋žŒ2๊ฐ€ ์‹œ๊ฐํ™” (์‚ฌ๋žŒ1 ๋Œ€์‹œ๋ณด๋“œ๋ฅผ ๋””๋ฒจ๋กญํ•˜๊ฑฐ๋‚˜ ์•„์˜ˆ ์ƒˆ๋กœ ๋งŒ๋“ค๊ธฐ)
    
    → ์ด๋•Œ, ์‚ฌ๋žŒ1์ด ํ•ด๊ฒฐ ๋ชปํ–ˆ๊ฑฐ๋‚˜ ์ถ”๊ฐ€๋กœ ๊ถ๊ธˆํ–ˆ๋˜ ๊ณผ์ œ ์œ„์ฃผ๋กœ ์‚ฌ๋žŒ2๊ฐ€ ์‹œ๊ฐํ™”


3. 2์ฃผ์ฐจ ๊ณผ์ œ ์„ ์ • ์™„๋ฃŒ
- ์บ๊ธ€, ์Šคํฌํ‹ฐํŒŒ์ด ์œ ์ € ๋ฐ์ดํ„ฐ ์‹œ๊ฐํ™”
Spotify user behavior


4. ๊ธฐํƒ€
  - ๊ฐœ์ธ ๊ธฐ์ˆ ๋ธ”๋กœ๊ทธ, ํƒœ๋ธ”๋กœ ํผ๋ธ”๋ฆญ ๊ณต์œ 
  - ํ•˜๊ณ ์‹ถ์€๊ฒƒ ๊ณต์œ  (๊ณต๋ชจ์ „, ๊ด€์‹ฌ์‚ฌ ๋“ฑ)

 
์Šคํ„ฐ๋””์˜ ๋ชฉํ‘œ์™€ ๋ฐฉํ–ฅ์„ฑ์ด ๊ณ ๋ฏผ๋ผ์„œ ๊ฐ•์‚ฌ๋‹˜๊ป˜ ์กฐ์–ธ์„ ๋ฐ›์•„๋ณด๊ธฐ๋กœ ํ•˜๊ณ  ์ฒซ ์Šคํ„ฐ๋”” ๋งˆ๋ฌด๋ฆฌ!๐Ÿ‘

๋ฐ˜์‘ํ˜•