페이지 트리

버전 비교

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

...

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

100%
Multimedia
name5. 상품별 매출분석(CrossTab)(기본)_수정.mp4
width920
autostarttrue
height
위젯 연결기
width800
urlhttps://www.youtube.com/watch?v=zXhs8BPAX40
height600


Step2.  Advanced Practice

...

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
name6. 상품별 매출분석(CrossTab)(응용)_수정.mp4
위젯 연결기
true
width650autostart
urlhttps://www.youtube.com/watch?v=sZoEKJrIHmQ
height100%600