Getting Started

KAWA contains 4 main sections:

  • Connect your data in the Data Source section
  • Build your models and explore in the Sheet section
  • Publish in the Dashboard and Applications sections

Starting

1. Create your first Data Source

Loading data into KAWA is the first step, and it is done via the Data Source section.

If the data that you want to explore is already loaded in KAWA, go to the next paragraph.

Let’s create one from a simple CSV file. This example will use a sample CSV file you can download - but feel free to bring in your own.

  • ➡️ Step 1: Go to the Data Source section (Top icon in the left bar), and click on the (+ Data Source) button. Choose: (Upload a file).

Starting

  • ➡️ Step 2: Drag and Drop your file in the drop zone and once your data is displayed, click on (Next)

Starting

  • ➡️ Step 3: Click directly on (Save). In the form, choose a good name for your new Data Source, then click on (Save and run).

Starting

🚀 Your first Data Source has been created. The system will take a few seconds to process the entire file. Once it is done, you will see a green SUCCESS badge that indicates that the data has been successfully loaded.

Before going to the next paragraph, go ahead and click on the Data tab, next to overview. There, you will see the profile of your uploaded dataset.

Starting

You can click on the various columns to get detailed information about them.

2. Create your first Sheet

There are two ways to create a Sheet on top of a Data Source.

  • From the Data Source section, click on your Data Source and click on the (Explore) button at the top. You will be redirected it the new sheet.

  • From the Sheet section (Second icon from the top in the left bar), click on the (+ Sheet) button, and select your Data Source. Click on (Next), pick a name for your Sheet and (Create).

A Sheet works like an Excel Workbook. When created, it has only one tab, which is the default Grid. This is the ideal tool to explore your data in KAWA.

2.1 Manipulate your data in the grid

Feel free to explore the main actions by using the buttons on the top right of the Grid.

Starting

A good starting point is Grouping. Click on the (Group) button (on the top right), and on the (+) button. Choose the State field (Or any other dimension of your dataset), and click on (Apply).

Starting

🔎 Feel free to explore: Sorting, Hide field, Filtering. All the options of the grid view are documented in details in the Grid View section. There is a special section about Filtering.

2.2 Create a new simple formula

The (Enrich Data) button is the way to add data in your sheet to complement the one coming from your data source. It lets you join with other data sources (Lookup column), create ad-hoc mapping tables, create your own formulas and even connect to Python scripts.

Let’s create a simple formula to compute the unit profit by dividing the Profit by the Quantity.

This is based on the example file from the first paragraph, feel free to adapt to your own business logic.

  • ➡️ Step 1: Click on the (Enrich Data) button, then (Formula).

Starting

  • ➡️ Step 2: If AI is enabled on your platform, you can just type: “Calculate unit profit”. If it is not, just type Profit / Quantity (Do not copy paste, type in the formula). KAWA will assist you on the way.

  • ➡️ Step 3: Type in a name for your formula and (Create). The new column will be added in your grid, at the last position.

Starting

2.3 Create a first simple chart

In order to explore your data in a more visual way, let’s now create a chart. In our example, let’s have a look at a profit trend over the years.

  • ➡️ Step 1: On the top left, click on (Create View), and pick (Graph/Chart).

Starting

  • ➡️ Step 2: In the configuration panel, search for the Profit column and drag and drop it in the Series Zone.

  • ➡️ Step 3: In the configuration panel, search for the Order Date column and drag and drop it in the Group by Zone.

  • ➡️ Step 4: Next to the Order Date in the Group By Zone, click on the small Calendar and pick: (Year/Month). This will sample the data by month.

  • ➡️ Step 5: Click on the line chart icon.

Starting

Please refer to the complete Chart Documentation to learn how to customize your charts.

2.4 Create a Pivot Table

Pivot tables in KAWA work like in any spreadsheet software, except that they can scale on billions of rows.

  • ➡️ Step 1: On the top left, click on (Create View), and pick (Pivot Table).

Starting

  • ➡️ Step 2: In the Rows section, add the State column. This can be done either by drag and drop or by clicking on the (+) and selecting the State column.
  • ➡️ Step 3: In the Columns section, add the Segment column.
  • ➡️ Step 4: In the Values section, add the Sales column.

Starting

To know what is possible with the pivot tables, go to the Pivot Documentation.

3. Put it together in a Dashboard

Go to the Dashboard section (Third icon from the top in the left bar). Click on (+ Dashboard), then (Dashboard).

You will be redirected to a new empty dashboard. Pick your sheet from the (Add Widgets) panel and add the view you created in the previous steps.

Widgets can then be arranged in the layout of your choice. Dashboard are a powerful tool to bring data from all your sheets in one place.

Starting

4. What’s next?

Those three paragraphs: Data Source, Sheet and Dashboard are giving a good overview of the central structure of the KAWA platform. It is the base on which you can start building and sharing your data applications.

Objective Link
Connect your Python libraries to KAWA Python integration
Build and share data applications Publishing
Connect KAWA to your Jupyter notebook to load and query data Python SDK
Automate your workflows Automations
Use AI to chat with your data AI Integration
Build and share data models Data Modeling
Build impactful visualizations Visualizations