You need to enable JavaScript to run this app.
Intelligent Data Insight

Intelligent Data Insight

Copy page
Download PDF
First Case Study
1. Learning Overview
Copy page
Download PDF
1. Learning Overview

This section uses the following "sales GMV analysis case" to help users who are new to DataWind master the product's common features, enabling new users to independently complete the corresponding reports and improve their data analysis capabilities.

1. Case introduction and objectives

Data analyst A from a business retail department needs to create a sales report. The manager wants to see the month-over-month and year-over-year changes and trends in the sales data through this report, and also be able to view the composition of sales revenue from different dimensions.

  • Target report style:

Image

  • Data download example:
Sale GMV Analysis_V3.xlsx
Unknown size
  • Data overview:

Image

  • Data definitions:

Field name

Field definition

order_date

Transaction date

sale_province

Province

order_count

Order count

price

List price

sale_price

Sale price

customer_id

Customer ID

product_id

Product ID

product_type

Product type

2. Case analysis

The report in this case focuses on GMV analysis and includes two tabs: Page 1: Data overview and Page 2: Comparative analysis. First, the report is broken down as follows to form the report outline:
Image

  • Page 1: Data overview - GMV trend
    『Indicator card』GMV summary analysis, which needs to display the GMV value and the month-over-month growth rate.
    『Text』Trend analysis, providing a description of GMV.
    『Line chart』Monthly GMV fluctuation trend, which needs to display GMV values by month and add an "average" reference line.
    『Text』Dimension comparison analysis, summarizing GMV by "province" and "product type".
    『Bar chart』Multi-dimensional GMV analysis, displaying the top 10 GMV values in descending order by "province" and "product type" dimensions, and adding an "average" reference line.
  • Page 2: Comparative analysis table
    『Table』GMV comparative analysis, which needs to display, by month, the current month's GMV, month-over-month GMV growth rate, last year's GMV, year-over-year GMV growth rate, total GMV for the current year, and the current year's GMV proportion. Among these, the month-over-month and year-over-year growth rates are displayed using data bars, and the current year's GMV proportion is displayed using a color scale.

3. Preparation
  • Log in to DataWind platform.
  • Create or enter a "project space".
  • This case involves the following modules: data connection, dataset, visual query, dashboard.
    Next, we will explain the operation process step by step according to the menu functions shown below. You can also go to Volcano Engine Intelligent Platform (VeDI) Learning Center to access the course.

Image

Last updated: 2026.06.11 17:26:58