페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동

이 페이지의 이전 버전을 보고 있습니다. 현재 버전 보기.

현재와 비교 페이지 이력 보기

« 이전 버전 2 다음 »

Create a performance inquiry screen by product according to regional stores

Goal Screen


Step1.  Basic Practice

Convert the list view created in the previous steps into a pivot view and analyze the data from various perspectives.

Add the product information (Product Category/ Subcategory/ Sub-subcategory/ Product Name) perspective and create an inquiry screen using sales quantity and amount as measures.

“multimedia” 매크로 렌더링 오류

com.atlassian.renderer.v2.macro.MacroException: Cannot find attachment '5. 상품별 매출분석(CrossTab)(기본)_수정.mp4'


Step2.  Applied Practice

Let's analyze the queried data in various ways using functions such as Drilling, Grouping, and Drill To Detail.

Apply

Video

  1. Pivoting
    : Change the row to Product Category (Group), Change the column to Store Type


  2. Drilling
    : Analyze detailed data of Product Category (Group)

  3. Grouping
    : Analyzing data by  Product Category, Product Subcategory, Product Sub-Subcategory, and Product Detailed category.

  4. Sorting
    : Querying data with high sales performance.

  5. Filtering
    : Querying the sales performance of a specific store.

  6. Multi Measure
    : Analyzing Product Category, Region, Quantity by Region, and Sales Cost together.

  7. Drill To Detail
    : Querying detailed data from the analyzed data.

“multimedia” 매크로 렌더링 오류

com.atlassian.renderer.v2.macro.MacroException: Cannot find attachment '6. 상품별 매출분석(CrossTab)(응용)_수정.mp4'

  • 레이블 없음