개인 프로젝트/데이터 분석 프로젝트12 [BI] Tableau Specialist Exam 1 - 차원(Dimension) vs. 측정값(Measure) 비교,- 불연속형(Discrete) vs. 연속형 (Continuous) 비교 문제는 단골손님으로 등장 1. In Tableau, a discrete field is shown in which color?- BlueTableau에서 이산 필드(discrete field)는 파란색(blue)으로 표시 2. Which of the following is true for Measures in Tableau?- Measures contain numeric, quantitative values - Measures- Measures contain qualitative values (such as names, dates, or geographical dat.. 2025. 1. 10. [BI] Tableau Specialist Exam 2 1. While file types preserve connection properties such as file locations and database server addresses? [select two]Answer Provided:twb, tdsxCorrect Answer: tds, tdsx 2. Which of the following can be configured when creating an extract? [select three]Answer Provided:No Answer ProvidedCorrect Answer: Whether to store logical or physical tables, Whether to limit the data extracted using filters, .. 2025. 1. 10. [BI] Tableau Desktop Specialist Study https://youtu.be/xUTo-Dp5dFE?si=MR5zbilCX9H88ZZy MetadataRenaming fields and Changing the defaults for formatting or aggregation are metadata management tasks that can be handled in TableauCannot change the data type, the number of rows in the dataTo see the table a field belong toTo view all alises and hidden fieldsTo see ther field name in the original data source1. Renaming fields and Chang.. 2024. 12. 22. [계산식] 구매전환율 retention(%) * 구매주기 = 최근 구매일 - 최초 구매일 / 구매횟수 - 1 -- 그 밖의 쿼리-- 브랜드 및 모델별 성장률 분석(+각 브랜드별 모델 성장률 순위)select * from ( SELECT * , ROW_NUMBER() OVER(PARTITION BY brand ORDER BY growth DESC) as rnk from ( select brand , model , SUM(tot_amt_2021) / SUM(tot_amt_2020) -1 as growth from PRODUCT_GROWTH_BASE group by brand, model ) A) Bwhere rnk 2024. 12. 22. 이전 1 2 3 다음
