Step by step demo - From data insertion to query

Follow this quick 4-step guide to learn how SlicingDice works using SQL or our API.

In order to start the live demo, select below how you would like to try SlicingDice, using SQL or API (JSON).

In order to have a better and personalized experience on this guide, select below the use case that looks like more similar to yours.

As you selected the {{ }} use case, consider you have this data on the spreadsheet below and that you want to insert it on SlicingDice.

Spreadsheet's Rows

The rows are identifying the entities. An entity is basically to "whom" the data will be associated and stored on SlicingDice. They are like a primary key in relational databases.

Attribute Columns

Column storing data not associated to a date/time.
Example: storing the value Jeff for the Name attribute column. In this case the column and its value is not associated to a specific date/time.

Event Columns

Column storing data associated to a date/time.
Example: storing the value Add to Cart on the date 2017-06-01 for the Clicks event column. In this case we must know when the event happened.

If you add a new column or a new row on the spreadsheet above, it will automatically update this JSON request below.
Before moving forward and clicking on the Insert Data button, add some values on the spreadsheet or change what is there.

JSON Representation

As you can see below, the data in the spreadsheet is now represented as a JSON request, that is the format we use to insert data on SlicingDice.

SQL Representation

As you can see below, the data in the spreadsheet is now represented as a SQL request, that is the format we use to insert data on SlicingDice.

Now that your data was inserted on SlicingDice, click on any of the questions below to see the query example.
If you prefer, you can use this information below to make queries using any SQL client, like Workbench/J, as you can learn more on this link.

URL / Connection String: jdbc:slicingdice:APIKeys={{ apiKey }};
User: Leave it blank
Pass: Leave it blank

{{ useCase.resultQueryQuestion }}

In order to answer this question, we will use the result data extraction query type.

As you can see below, when using the result data extraction query, you select the entities that will be retrieved with the query parameter and next you define which columns you want to retrieve data from with the columns parameter.

{{ useCase.countEntitiesQuestion }}

In order to answer this question, you should use count entities query type, so you can know how many unique (distinct) entities you have satisfies the query conditions.

{{ useCase.countEventsQuestion }}

This question above is basically asking how many times a specific event happened within a certain period of time, so you should use count events query to answer it, as this type of query will show the number of times some data was inserted for event columns.

{{ useCase.singleLevelAggregationQuestion }}

In order to answer this question above we will use one of the most powerful query types supported by SlicingDice, aggregations.

Aggregations is really powerful for generating insights from the data by calculating metrics, such as maximum, minimum, sum and average, as well as crossing data from different columns to generate pivot tables.

We will use the single level aggregation query to answer this question above.

{{ useCase.multiLevelAggregationQuestion }}

We will use the multi-level aggregation for answering this question (query) above. This query will basically take all the Top X values for the column A and cross it with all the available values of the column B, in order to find the final Top Z values and its quantity of entities.

{{ useCase.filteredAggregationQuestion }}

This is a really powerful analytical query and in order to answer it we will be using a filter and a metric on a date histogram aggregation. This basically means that, we will first filter the entities that we want to perform the aggregation on, then we will define the metric we want to see and finally for which period of time we want this metric to be calculated.

{{ useCase.resultWithMetricsQuestion }}

On this question above you are requesting to retrieve the data you stored on SlicingDice, but now also calculating some metrics for it. In order to do that, you can use the result data extraction query, like in the first question, but now adding some additional parameters, that will allow you to also perform calculations (metrics) while retrieving data.

Check these really cool dynamic tools we prepared and play a bit more to consolidate the knowledge on how to insert and query data on SlicingDice.

If you want to review the data insertion and querying flows in a more detailed way, we recommend you to read the how to insert data and how to make queries pages from our documentation.

Let's talk about your data challenge?

SlicingDice Control Panel

We know how boring it is to create an account in every new service that appears and we don't want you to go through this hassle just to check our service.

By clicking the button below you can get full access to our control panel demonstration using a demo account and data. No sign up needed.

Check our Demo Control Panel

Ready to get started?

Get in touch, or create an account.