Training Questions
🏋🏻‍♀️

Training Questions

1. Pre-requisites

Integrate these two datasets in KAWA

2. Sheets

2.a) Presentation

image
  1. KAWA main sections, from left to right:
    • Data Sources: Load and configure data.
    • Sheets: Explore data through grids, charts, and pivot tables.
    • Dashboards: Build presentations and dashboards with existing analysis.
  2. Sheet navigation menu: List of available sheets in the workspace.
  3. View navigation bar: Different views for data exploration: grids, charts, and pivot tables.
  4. Tool bar: Features for grid views:
    • Hide fields: Customize the view by hiding specific columns.
    • Group: Display summary information for each group.
    • Sort: Apply multiple sorts and control their order.
    • Filter: Define criteria to display specific data in the views.

2.b) Training questions

  1. Top 5 customers with the highest Profit [SUM] for last year.
    2. ‣
    Answer
  2. Create a pivot table to display the Sales by Customer name (rows) and Category (columns).
    3. ‣
    Answer
  3. Create a bar chart to visualize the monthly Sales evolution over time.
    4. ‣
    Answer
  4. For each sub-category, display as a stacked bar the proportion of quantity per segment, and filter the data on year-to-date (YTD)
    5. ‣
    Answer
  5. Create an indicator chart to compare the Profit of 2023 with the Profit of 2022.
    6. ‣
    Answer

3. Mapping Tables

3.a) Presentation

With mapping table, you can quickly map values to a specific column:

  • You can manually input the mappings.
  • Alternatively, you can import a CSV file to automatically populate the mappings.

3.b) Training Questions

  1. Create a mapping column for the "Customer name" column:
    1. Manually map Aaron Bergman and Aaron Hawkins to the value CASUAL CUSTOMERS.
    2. Manually map Adam Hart to the value NEW CUSTOMERS.
    3. For unmapped values, use Custom values and enter "OTHER".
    4. Name the mapping column "Customer group".
      5. ‣
      Answer
  2. Perform the same mapping using a CSV file.
    3. Mapping.csv22.8KB
    ‣
    Answer

4. Dashboards

4.a) Presentation

Dashboards are a powerful way to monitor your business, displaying key metrics from multiple sources in one place. They are interactive, providing advanced filtering options for in-depth analysis.

4.b) Training Questions

  1. Create a dashboard with the charts from the SHEETS sections (questions 3, 4, and 5).
    2. ‣
    Answer
  2. Add a "Category = Furniture" filter to the dashboard.
    3. ‣
    Answer
  3. Configure the filter to impact only two out of the three widgets.
    4. ‣
    Answer