개인 프로젝트/데이터 분석 프로젝트14 [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 4 다음
