Your first data exploration

This page shows you how to perform your first data exploration.

Requirements

  • You are logged-in to OB1
  • You have created an OB1 Project

OB1, by connecting to OpenBouquet Server's API, provides a simple way to explore and manipulate your data.

A basic exploration consists of the following actions: Selecting a Domain, choosing Dimensions, selecting Metrics and visualizing the result.

OB1 also provides the ability to apply filters or select a period range to obtain an accurate result-set.

This documentation provides the key elements to explore your data in a fast, efficient way.

There are four steps to explore your data:

  1. Select a Domain
  2. Choose your Dimensions
  3. Select your Metrics
  4. Use filters and period range to adjust your result

Open a domain on OB1 Navigator

Let’s begin by selecting the domain you want to perform your analysis on. On the left panel, select your Project.

A domain allows to define a set of metrics and dimensions associated to a table, it can be considered as a database table.

 

Select a domain and click on the "Open in navigator" icon.

Choose your dimensions

You land on the Navigator page where you configure your analysis. Choose the Dimensions required for your analysis in the two pivot dropdown menus.

A dimension defines the domain structure and also how metrics are computed.

Select your metrics

Then, select the required metrics to compute. A metric is an aggregated operation on the domain. A metric supports the following numerical expressions and aggregate operators  (SUM, COUNT, DISTINCT, AVG, MIN, MAX).

Click the "Refresh" button. Your first analysis result-set will be displayed. It is time to adjust your dataset with filters and period.

Use filters and period range to adjust your result

To get the more efficient analysis, you may want to filter data or apply a period range to adjust your result. Period range filter is only available if a Date or Time type is detected in the schema.

To apply a filter, simply click the "Filters" button, select the dimension you want to filter and set the search criteria:

A new windows will appear, and you'll be able to search and select the filters you need:

Refresh your analysis by clicking the "Refresh" button to reload and displayed the up-to-date results.

That’s it! You can now checkout how to visualize your data.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.