태블로 데스크탑 자격증(Tableau Desktop Specialist) 공부 정리 파일

목차

1. Create live connection and extracts
1) create a live connection to a data source
2) Explain the differences between using live connection versus extracts
3) Create an extract
4) Save metadata properties in a TDS
5) Create a data source that uses multiple connection

2. Create and manage the data model
1) Add relationships to a data source
2) Add joins and unions
3) Add a blend
4) Manage data properties

3. Exploring and Analyzing Data
1) Create a bar chart
2) Create a line chart
3) Create a scatterplot
4) Create a combined axis chart
5) Create a dual axis chart
6) Create a chart to show specific values (crosstab, highlight table)
7) Create a map using geographic data
8) Create a Visual Group, Sets & Hierarchies
9) Add a filter (to a view, Context, Date)
10) Sorting
11) Add a reference line or trend
12) Use a table calculation
13) Use bins and histogram
14) Created a calculated field Tableau Specialist 자격증 엑기스 모음
15) Add a parameter

4. Sharing Insight
1) Format view for presentation
2) Viz animations
3) Create and modify a dashboard

5. Understanding Tableau Concepts
1) Dimensions and Measures
2) Discrete and continuous fields
3) Aggregation

6. Supplement
1) 집계함수
2) 표현방식
3) 영어단어
4) 디스플레이
5) 암기목록

본문내용

Live Connection 차이점
- when you create a live connection, when you refresh a Tableau view it will update based on changes to the underlying data.
(라이브 상태에서 태블로 뷰를 새로 고침하면 원본 데이터의 변화에 따라 업데이트 된다.)
-Your Tableau workbook will not work if you are unable to connect to the data source
(데이터 원본에 연결할 수 없는 경우, 태블로 통합 문서가 작동하지 않는다.)
- if your live connection is to a database, you will need to enter credential to access the data (특정 DB에 라이브 상태라면, 데이터에 접근하기 위해서 접근 권한이 필요하다)
- slow down operational queries too much (작동 쿼리가 너무 오래 걸린다.)
- aggregation that takes too long (너무 오래 걸리는 집계)

Extracts 차이점
- when you create an extract, the Tableau view will use the same underlying data unless you choose to refresh the extract.
(추출 상태에서 굳이 업데이트를 하지 않는다면, 태블로 뷰는 동일한 데이터 원본을 사용한다.)
- if you create an extract, your Tableau workbook will continue to work even if you are not able to connect to the original data source

참고자료

· 없음