[STARTERS 4๊ธฐ TIL] #44์ผ์ฐจ(23.04.07)


๐Ÿ’ก Domain 3 : Exploring and Analyzing Data
  • 3.1 Format view for presentation
    • ์–‘์ˆ˜ ์Œ์ˆ˜๊ฐ€ ๋ชจ๋‘ ํฌํ•จ๋œ ํ•„๋“œ๊ฐ€ ์žˆ์„ ๋•Œ, ๊ธฐ๋ณธ์œผ๋กœ ๋‘ ๊ฐœ์˜ ์ƒ‰์ƒ ๋ฒ”์œ„๊ฐ€ ์‚ฌ์šฉ๋œ๋‹ค : diverging palette *reversed : ์ƒ‰ ๋ฐ˜์ „
    • ์ƒ‰์ƒ ์ปจํ…Œ์ด๋„ˆ ํŽœ : Toggle the highlighting on/off
    • Tooltip font ๋ณ€๊ฒฝ
      • Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option
      • Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font
      • Click on Tooltip in the Marks card, select the text, and then use the italics option
      • Right click > format > default worksheet formatting > Tooltip
    • View์— ๊ธฐ๋ณธ์œผ๋กœ ํ‘œํ˜„ํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐ์ดํ„ฐ๋Š” ์ตœ๋Œ€ 10000๊ฐœ
    • ๋งˆํฌ ๋ ˆ์ด๋ธ”
      • Click on Analysis in the Menu bar and choose Show mark Labels
      • Click on the Show mark labels icon in the Toolbar
      • Drag the measure to the Text label in the Marks Card
    • ์ฐจ์› ๋งˆํฌ ๊ฐœ์ˆ˜ * ๋ฐ˜๋Œ€ ์ถ• ํ•„๋“œ์˜ ๊ฐœ์ˆ˜ = view์— ๋‚˜์˜จ ๋งˆํฌ ๊ฐœ์ˆ˜
  • 3.2 Viz animations
    • ์„œ์‹ > ์• ๋‹ˆ๋ฉ”์ด์…˜
    • workbook default
    • Separate sheet ๋”ฐ๋กœ ์ ์šฉ ๊ฐ€๋Šฅ
    • Unsupported browsers and features
    • ์ธํ„ฐ๋„ท ์ต์Šคํ”Œ๋กœ์–ด ๋นผ๊ณ  ๋‚˜๋จธ์ง€ ๋ชจ๋“  ์›น๋ธŒ๋ผ์šฐ์ €์—์„œ ์ž‘๋™ํ•จ
    • map, polygon, and density marks in web browser !!
    • pie and text mark
    • axes and header
    • forecast, trends, and reference line
    • ์• ๋‹ˆ๋ฉ”์ด์…˜ ๊ธฐ๋ณธ ์ง€์† ์‹œ๊ฐ„ : 0.3์ดˆ
    • ๋Œ€์‹œ๋ณด๋“œ ๋ ˆ์ด์•„์›ƒ
      1. ๋ชจ๋“  ์‹œํŠธ๋ฅผ ์‹ฑ๊ธ€ ๋ทฐ๋กœ ๋ณด์ด๊ธฐ ์œ„ํ–„ ๋งŒ๋“ฆ
      2. ํƒ€์ผ๋“œ, ํ”Œ๋กฏํŒ…
      3. ํ”ฝ์Šค๋“œ ์‚ฌ์ด์ฆˆ, ๋ ˆ์ธ์ง€, ์ž๋™ ๋ฐฐ์น˜
    • ๋Œ€์‹œ๋ณด๋“œ ์•ก์…˜
      1. ํ—ˆ๋ฒ„, ๋ฉ”๋‰ด, ์…€๋ ‰ํŠธ
      2. ๊ณ  ํˆฌ ์œ ์•Œ์—˜๋™์ž‘ - URL - URL: ํ•„๋“œ, ๋งค๊ฐœ๋ณ€์ˆ˜, ํ•„ํ„ฐ
      3. ํ•˜์ดํผ๋งํฌ
    • ์Šคํ† ๋ฆฌ ์ƒ์„ฑ
      • ํ•˜๋‚˜์˜ ์Šคํ† ๋ฆฌ์—๋Š” ํ•˜๋‚˜์˜ ์‹œํŠธ ์˜ฌ ๋Œ€์‹œ๋ณด๋“œ๋งŒ ๊ฐ€๋Šฅ
      • Each individual sheet in a story is called a story point
    • Floating items : ๋ถ€๋™
    • Tiled items : ๋ฐ”๋‘‘ํŒ
    • padding : precisely space items ๊ณต๊ฐ„ ํ• ๋‹น
    • ๋Œ€์‹œ๋ณด๋“œ ํฌ๊ธฐ ์„ค์ • ์˜ต์…˜ : ์ž๋™ , ๊ณ ์ •๋œ ํฌ๊ธฐ , ๋ฒ”์œ„
    • ์• ๋‹ˆ๋ฉ”์ด์…˜
      • ๋™์‹œ ์• ๋‹ˆ๋ฉ”์ด์…˜ : ์†๋„๊ฐ€ ๋น ๋ฅด๋ฉฐ ๋‹จ์ˆœํ•œ ๊ฐ’ ๋ณ€ํ™” ํ‘œํ˜„์— ์ข‹์Œ
      • ์ˆœ์ฐจ์  ์• ๋‹ˆ๋ฉ”์ด์…˜ : ๋” ์˜ค๋žœ ์‹œ๊ฐ„ ๊ฑธ๋ฆผ, ๋ณต์žกํ•œ ๋ณ€ํ™”๋ฅผ ๋‹จ๊ณ„๋ณ„๋กœ ๋ช…ํ™•ํ•˜๊ฒŒ ํ‘œํ˜„3.3 Create and modify a dashboard

    • ๋Œ€์‹œ๋ณด๋“œ ๋ ˆ์ด์•„์›ƒ
      1. ๋ชจ๋“  ์‹œํŠธ๋ฅผ ์‹ฑ๊ธ€ ๋ทฐ๋กœ ๋ณด์ด๊ธฐ ์œ„ํ–„ ๋งŒ๋“ฆ
      2. ํƒ€์ผ๋“œ, ํ”Œ๋กฏํŒ…
      3. ํ”ฝ์Šค๋“œ ์‚ฌ์ด์ฆˆ, ๋ ˆ์ธ์ง€, ์ž๋™ ๋ฐฐ์น˜
       
    • ๋Œ€์‹œ๋ณด๋“œ ์•ก์…˜
      1. ํ—ˆ๋ฒ„, ๋ฉ”๋‰ด, ์…€๋ ‰ํŠธ
      2. ๊ณ  ํˆฌ ์œ ์•Œ์—˜๋™์ž‘ - URL - URL: ํ•„๋“œ, ๋งค๊ฐœ๋ณ€์ˆ˜, ํ•„ํ„ฐ
      3. ํ•˜์ดํผ๋งํฌ
    • ์Šคํ† ๋ฆฌ ์ƒ์„ฑ
      • ํ•˜๋‚˜์˜ ์Šคํ† ๋ฆฌ์—๋Š” ํ•˜๋‚˜์˜ ์‹œํŠธ ์˜ฌ ๋Œ€์‹œ๋ณด๋“œ๋งŒ ๊ฐ€๋Šฅ
      • Each individual sheet in a story is called a story point
    • Floating items : ๋ถ€๋™
    • Tiled items : ๋ฐ”๋‘‘ํŒ
    • padding : precisely space items ๊ณต๊ฐ„ ํ• ๋‹น
    • ๋Œ€์‹œ๋ณด๋“œ ํฌ๊ธฐ ์„ค์ • ์˜ต์…˜ : ์ž๋™ , ๊ณ ์ •๋œ ํฌ๊ธฐ , ๋ฒ”์œ„
    • ์• ๋‹ˆ๋ฉ”์ด์…˜
      • ๋™์‹œ ์• ๋‹ˆ๋ฉ”์ด์…˜ : ์†๋„๊ฐ€ ๋น ๋ฅด๋ฉฐ ๋‹จ์ˆœํ•œ ๊ฐ’ ๋ณ€ํ™” ํ‘œํ˜„์— ์ข‹์Œ
      • ์ˆœ์ฐจ์  ์• ๋‹ˆ๋ฉ”์ด์…˜ : ๋” ์˜ค๋žœ ์‹œ๊ฐ„ ๊ฑธ๋ฆผ, ๋ณต์žกํ•œ ๋ณ€ํ™”๋ฅผ ๋‹จ๊ณ„๋ณ„๋กœ ๋ช…ํ™•ํ•˜๊ฒŒ ํ‘œํ˜„3.3 Create and modify a dashboard

๐Ÿ’ก Domain 4 : Tableau Server
  • ํƒœ๋ธ”๋กœ ์˜จ๋ผ์ธ

Tableau Server enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

 

 

change the formatting at a workbook(ํ†ตํ•ฉ๋ฌธ์„œ) level :

Choose Format from the menu on top and then specify the formatting in the new Format workbook pane

 

Tableau Reader : a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop ๋‚จ์ด ๋งŒ๋“ค์–ด ๋‘” ๊ฑฐ ํ”„๋กœ๊ทธ๋žจ ์‹คํ–‰ ์—†์ด ๋ณผ ์ˆ˜ ์žˆ์Œ

 

Tableau Support case can be opened by using the support option on the Tableau website

 

Data interpreter : clean / organize data

 

the options to export the data used to build the view / visualizations : MS Access Database, CSV file

 

manage metadata : ๋ฐ์ดํ„ฐ ์›๋ณธ

 

๋Œ€์‹œ๋ณด๋“œ์—์„œ ๊ฐ€๋Šฅํ•œ ์ด๋ฏธ์ง€ ํŒŒ์ผ ํ˜•์‹ : jpg, bmp, png

 

ํƒœ๋ธ”๋กœ ๋ฐ์Šคํฌํƒ‘์—์„œ ๊ฐ€๋Šฅํ•œ ๋ฐ์ดํ„ฐ ์›๋ณธ : SQL , SAP HANA, AMazon Redshift

 

all supporting files, data sources, icons, logs : Documents > My Tableau Repository

 

 

๐Ÿ’ก Domain 5 : Understanding Tableau Concepts
  • Dimensions and Measures

ํƒœ๋ธ”๋กœ๋Š” ์ž๋™์œผ๋กœ 1๊ฐœ์˜ ์ฐจ์›, 4๊ฐœ์˜ ์ธก์ •๊ฐ’์„ ์ƒ์„ฑํ•จ

๋ณ„์นญ ์ƒ์„ฑ : ์ฐจ์›

  • Discrete and continuous fields

ํƒœ๋ธ”๋กœ์—์„œ ์—†์•จ ์ˆ˜ ์—†๋Š” ํ•„๋“œ : ์ธก์ •๊ฐ’, ์ธก์ •๊ฐ’ ์ด๋ฆ„

  • Aggregationdata

granuality → level of detail

By default, measures placed in a view are aggregated. The type of aggregation applied depends on the context of the view