Introducing the Data-Explorer
Astrato's Data Explorer enables users to answer business questions using the data model in the data view.
Users can combine any field from the data model in one table, exploring and validating the data.
The Data-Explorer enables users to test and create measures and dimensions in the data view for later usage in workbooks.
The Data-Explorer enables users who don't have SQL knowledge to explore any data set and also share and reuse the query generated by their selected fields.
The Data-Explorer is a powerful self-service data and analytics tool.
Entering the Data-Explorer
Click on the Data Explorer tab in the Dataview Editor.
Using The Data Explorer
Adding Fields and Measures
Click on the blue plus icon to add a field to the explorer as dimension.
Other options to add a dimension to the explorer are checking the box near the table name if you want to add all the fields from the table or click on the plus icon near a pre-defined dimension.
Click on the Green Fx icon, and select an aggregation to add a measure using the field.
Alternatively, you can click the green plus icon near the predefined measure.
Exploring the Data
Filter the data in Data Explorer by clicking on the filter icon in the table header.
Different filed types have different types of filtering.
To learn more about using special characters in search, check out this article
Sort the table by clicking on the sort icon in the table. Header.
Change fields order by dragging and dropping the fields header.
Remove a column with right-click on the column header.
Add totals to the tables by activating the total switch in the toolbar.
Using the Data (toolbar actions)
Query insights- see the underlying SQL query of the data in a readable form.
Jump into the source system to learn about the query performance.
Measure- Check the box in a measure header in the table, then click the Measure button to save the measure in the dataview for future usage.
*The button is active only when one measure check box is checked.
Dimension- Check the box in a dimension header in the table, then click the
Dimension button to save the dimension in the dataview for future usage.
*The button is active only when one dimension check box is checked.
Export- Click the Download icon (↓) to export the data to Excel or CSV File.