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

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

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

« 이전 버전 5 다음 »

Create a performance inquiry screen by product according to regional stores

Target 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/ Detailed category) perspective and create an inquiry screen using sales quantity and amount as measures.


Step2.  Advanced 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.

  • 레이블 없음