...
Create a performance inquiry screen by product according to regional stores
| Goal Target Screen |
|---|
 Image Removed Image Added
|
Step1. Basic Practice
...
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
|---|
| url | https://www.youtube.com/watch?v=zXhs8BPAX40 |
|---|
| height | 100%600 |
|---|
|
|
Step2.
...
Advanced Practice
Let's analyze the queried data in various ways using functions such as Drilling, Grouping, and Drill To Detail.
| 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 |
|---|
|
|
