Discovery of the new Data Query

Why a new version of Data Query?

Data Query is a comprehensive data mining tool that enables the creation of custom reports based on our enhanced data model. This powerful solution features advanced data visualizations and flexible export capabilities. To deliver greater flexibility and functionality, we are introducing a new version that includes expanded data visualization options, an AI-powered query system for building requests using natural language, and additional analytical tools. This documentation provides everything you need to get started.

How to create a report

Upon accessing the homepage, you can click the AI Query button to begin entering your request in natural language.

Alternatively, click the "+" button to open a drawer containing available properties and metrics. You can then drag and drop elements or double-click them to begin building your report.

For clarification on any property or metric, simply hover over the item to display its description.

Your Data Model now supports hundreds of properties, including both our out-of-the-box data model elements and your custom properties. The Tags system allows you to filter relevant items and efficiently navigate your data model through the Tags menu in the properties section.

Once you have added at least one element, you can also click directly within the table header to add additional elements.

Property actions

Clicking on a property reveals several available actions:

• Sort: Arranges property values in ascending or descending order

• Functions: Available functions vary by property type:

  • Approximate count distinct: Counts unique values within a property

  • Max, Min: Returns the maximum or minimum values of the property

  • Sum, Average: Calculates the total or average of all property values

  • Median and Percentile: Returns the median value or your specified percentile

• Filter: Opens the filter panel with the selected property pre-selected

• Breakdown: Creates a breakdown between the current property and the subsequent one. The example below shows a breakdown on the "Page - 1st level" property, displaying grouped values for the first property followed by values for the second property.
  

  

Metric actions

Clicking on a metric provides access to the following actions:

• Sort: Arranges metric values in order. When comparison is enabled, you can also sort by variation

• Functions:

  • Ratio of total: Returns the percentage of your metric value relative to the overall total

  • Difference from total: Calculates the difference between your metric value and the overall total

• Create a metric: Enables creation of basic metrics using operators and two existing metrics
  

  

• Apply segment: Creates a metric using a specific segment (e.g., applying the "Google" segment to the "Visits" metric creates "Visits from Google")
  

  

• Filter: Opens the filter panel for the selected metric

• Cell visualization: Provides access to three visualization tools:
  

  

  • Horizontal bar: The default cell visualization adds a horizontal bar within the metric cell

    

  • Line: Displays metric evolution directly within the cell for quick trend analysis. You can maintain a single color or use trending colors (green for upward trends, red for downward trends)
    

    

  • Conditional formatting: Allows creation of two rules for custom cell coloring

    

AI Reveal

Once you have created a dataset, you can launch the AI Reveal tool to enable our AI system to analyze your data and provide actionable insights.

Query output

Table view

The default query output is a table format, providing clear access to values with optimal readability.

Graphical representations

While tables provide clear data presentation, adding data visualizations enhances context and insight:

You can modify visualizations by clicking the corresponding buttons to access additional options tailored to your needs, including anomaly detection and predictive analytics.

Dataset export

Copy to clipboard

The copy function captures current page or graph content, providing a quick method for sharing data with stakeholders.

This section also provides access to the API body. The Reporting API offers an alternative method for utilizing your dataset outside of Piano Analytics. Please refer to the API documentation for detailed information.

Data export

To export data in CSV format, use the export area located in the top-right corner of your dataset. Clicking the arrow reveals two options:

• Download the first 10,000 rows

• Download the current page in CSV format (visible results in your dataset)

• Note: We are currently developing a solution for scheduled exports