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

11/17 ๋‘๋ฒˆ์งธ Tableau ๋ฐ์ดํ„ฐ๋ถ„์„ ์Šคํ„ฐ๋”” ๊ธฐ๋ก

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



 2์ฃผ์ฐจ ์Šคํ„ฐ๋””๋Š” ๊ฐ•์‚ฌ๋‹˜์ด ํŠน๋ณ„ ์ฒญ์ž์ด์ž ์กฐ์–ธ์ž๋กœ ์ฐธ์„ํ•˜์…”์„œ ์บ๊ธ€์˜ Spotify ์œ ์ € ๋ฐ์ดํ„ฐ ๋Œ€์‹œ๋ณด๋“œ์— ๋Œ€ํ•ด ๋ฐœํ‘œํ•˜๊ณ  ํ”ผ๋“œ๋ฐฑ์„ ๋ฐ›์•˜๋‹ค.


https://www.kaggle.com/datasets/meeraajayakumar/spotify-user-behavior-dataset?resource=download

Spotify User Behavior Dataset

A Comprehensive Spotify Dataset for User Analysis

www.kaggle.com

 

 
 
 
2์ฃผ์ฐจ ์Šคํ„ฐ๋”” ๊ณผ์ œ ๋Œ€์‹œ๋ณด๋“œ ์™„์„ฑ๋ณธ์€ ์•„๋ž˜์— ์žˆ๋‹ค.
https://yun0analytics.tistory.com/entry/Study-2-%EC%A3%BC%EC%B0%A8-%ED%83%9C%EB%B8%94%EB%A1%9C-Tableau-%EC%8A%A4%ED%8F%AC%ED%8B%B0%ED%8C%8C%EC%9D%B4-%EC%9C%A0%EC%A0%80-%ED%8A%B9%EC%84%B1-%EB%B6%84%EC%84%9D-%EB%8C%80%EC%8B%9C%EB%B3%B4%EB%93%9C

Study 2 ์ฃผ์ฐจ  - [ํƒœ๋ธ”๋กœ] Tableau ์Šคํฌํ‹ฐํŒŒ์ด ์œ ์ € ํŠน์„ฑ ๋ถ„์„  ๋Œ€์‹œ๋ณด๋“œ

์Šคํ„ฐ๋”” ์ง„ํ–‰์ผ : 24.11.17๐Ÿ’ก ๋Œ€์‹œ๋ณด๋“œ ๋ฐ ํผ๋ธ”๋ฆญ ์ฃผ์†Œhttps://public.tableau.com/app/profile/.68541509/viz/Spotify_20241118_FIN/useranalysis Spotify_20241118_FINSpotify_20241118_FINpublic.tableau.com๐Ÿ’ก ๋ฐ์ดํ„ฐ์Šคํฌํ‹ฐํŒŒ์ด ์œ ์ € ์„ค

yun0analytics.tistory.com

 

 
 
โญ๏ธ์˜ค๋Š˜ ์Šคํ„ฐ๋”” ์ฃผ์š”๋‚ด์šฉโญ๏ธ

  1. ์Šคํฌํ‹ฐํŒŒ์ด ๋Œ€์‹œ๋ณด๋“œ ๊ณต์œ  ๋ฐ ํ”ผ๋“œ๋ฐฑ

  2. ์•ž์œผ๋กœ ์Šคํ„ฐ๋”” ๋ฐฉํ–ฅ์„ฑ
    - ์ž์œ ์ฃผ์ œ (ํŠธ๋žœ๋“œ, ์ง๋ฌด ๋ฐ˜์˜ ๋“ฑ)๋กœ ์™„์„ฑ๋„ ์žˆ๋Š” ๋Œ€์‹œ๋ณด๋“œ 2๊ฑด ์ œ์ž‘
    - ๋ฐ์ดํ„ฐ ํฌ๋กค๋ง, ๋ถ„์„, ๋ชจ๋ธ๋ง ๋“ฑ๋“ฑ ์›ํ•˜๋Š” ๋ฐฉํ–ฅ์„ฑ๋Œ€๋กœok
    - ์ด 2๋‹ฌ ์ •๋„ ์†Œ์š” ์˜ˆ์ƒ

  3.   ์Šคํ„ฐ๋”” ์ง„ํ–‰๋ฐฉ์‹   
    - ๋Œ€์‹œ๋ณด๋“œ ์„œ๋กœ ๋ฐœํ‘œํ•˜๋ฉด์„œ ํ”ผ๋“œ๋ฐฑ ๋ฐ›๊ธฐ
    - ํ™œ์šฉ๊ธฐ์ˆ , ๋ถ„์„์— ์ฐธ๊ณ ํ•œ ๋ฐ์ดํ„ฐ ๋ฐฐ๊ฒฝ์ง€์‹ ๊ณต์œ 
    - ๋งํ•˜๊ณ ํ”ˆ ์ธ์‚ฌ์ดํŠธ ๋ช…ํ™•์„ฑ ํ‰๊ฐ€

  4.    ๊ธฐํƒ€
    - ๐Ÿ€์Šคํ„ฐ๋”” ๋ชจ์ž„ ๋‚ด์šฉ๊ธฐ๋ก์€ ๋…ธ์…˜์ด๋‚˜ ๊ธฐ์ˆ ๋ธ”๋กœ๊ทธ์— ์ •๋ฆฌํ•ด์„œ ๊ณต์œ .๐Ÿ€
    -  ํผ๋ธ”๋ฆญ์—๋Š” ๋˜๋„๋ก ์˜์–ด๋กœ ๊ธฐ์žฌ
    -  ์Šคํ† ๋ฆฌํ…”๋ง์— ๋งž๋Š” ๋Œ€์‹œ๋ณด๋“œ ๊ตฌ์„ฑ ํ•„์š”

 

์ด๋ฒˆ์—๋„ ๋ฐ์ดํ„ฐ์— ๋Œ€ํ•œ ์•„์‰ฌ์›€๊ณผ ๋ถ„์„๋Œ€์ƒ (์Šคํฌํ‹ฐํŒŒ์ด)์— ๋Œ€ํ•œ ์ดํ•ด๋ถ€์กฑ์œผ๋กœ ์ธํ•œ ์ฃผ์ œ์˜ ๋ชจํ˜ธ์„ฑ์„ ๋А๊ผˆ๊ณ , ๋ณด๋Š” ์‚ฌ๋žŒ๋“ค๋„ ๊ทธ๋ ‡๊ฒŒ ๋А๊ปด์ง€์‹ ๋“ฏ ํ–ˆ๋‹ค..


๋ ˆ์ด์•„์›ƒ์— ๋Œ€์‹œ๋ณด๋“œ๋‚˜ ๋ถ„์„๊ฒฐ๊ณผ๋ฅผ ๋งž์ถ”์ง€๋ง๊ณ  ๋ช…ํ™•ํ•œ ์ฃผ์ œ์™€ ๋‚˜์˜ ์Šคํ† ๋ฆฌํ…”๋ง์— ๋งž๋Š” ์›Œํฌ์‹œํŠธ ๋ฐ  ๋Œ€์‹œ๋ณด๋“œ ๊ตฌ์„ฑ์„ ์œ„ํ•ด ๋…ธ๋ ฅํ•ด์•ผ๊ฒ ๋‹ค.

๊ทธ๋ฆฌ๊ณ  ๊ฐ•์‚ฌ๋‹˜์˜ ํ”ผ๋“œ๋ฐฑ ๋•๋ถ„์— ์šฐ๋ฆฌ ์Šคํ„ฐ๋””์˜ ๋ฐฉ์‹๊ณผ ๋ฐฉํ–ฅ์„ฑ์ด ์ •ํ•ด์ง€๊ฒŒ ๋˜์–ด ๊ฐ์‚ฌ๋“œ๋ฆฐ๋‹ค๐Ÿ‘


 

๋ฐ˜์‘ํ˜•