...
Add the product information (Product Category/ Subcategory/ Sub-subcategory/ Detailed category) perspective and create an inquiry screen using sales quantity and amount as measures.
|
Multimedia |
---|
name | 5. 상품별 매출분석(CrossTab)(기본)_수정.mp4 |
---|
width | 920 |
---|
autostart | true |
---|
height | 100% 위젯 연결기 |
---|
width | 800 |
---|
url | https://www.youtube.com/watch?v=zXhs8BPAX40 |
---|
height | 600 |
---|
|
|
Step2. Advanced Practice
...
Apply | Video |
---|
- Pivoting
: Change the row to Product Category (Group), Change the column to Store Type
- Drilling
: Analyze detailed data of Product Category (Group)
- Grouping
: Analyzing data by Product Category, Product Subcategory, Product Sub-Subcategory, and Product Detailed category.
- Sorting
: Querying data with high sales performance.
- Filtering
: Querying the sales performance of a specific store.
- Multi Measure
: Analyzing Product Category, Region, Quantity by Region, and Sales Cost together.
- Drill To Detail
: Querying detailed data from the analyzed data.
| Multimedia |
---|
name | 6. 상품별 매출분석(CrossTab)(응용)_수정.mp4 |
---|
위젯 연결기 |
---|
width | 650 | autostart | true
---|
url | https://www.youtube.com/watch?v=sZoEKJrIHmQ |
---|
height | 100%600 |
---|
|
|