In Google Data Studio, Explorer is a new tool which helps you in analyzing data faster . The Explorer streamlines the editing, viewing and data visualization experience. Helps apply filters quickly. Export your explorations to new or existing reports. You can even access the Explorer from any report to start exploring your data without modifying your report.
It will help you dig deeper into your data without having to write complicated SQL queries to draw insights. Think of it as your personal sandbox within Data Studio where you can build, test and inspect your charts and tables before adding them to a brand new report or exporting them to an existing report.
How the Explorer works
The Explorer lets you examine your data using a single chart. You can easily switch between the same visualizations available in a report. All of the same styling options available in reporting, are also available in the Explorer.
On the left, click EXPLORER.
Click in the top left , then select Data Source.
Select a data source you’d like to explore.
In the top right, use the toolbar to select different chart types.
To filter your data, drag dimensions and metrics from the Available Fields panel on the right to the filter bar at the top of the Explorer.
In the top right, click SAVE to preserve your work.
To view your exploration in a report:
In the upper right, click .
Select Create new report.
Click ADD TO REPORT.
In the top right, click View.
To return to the Explorer, hover over the chart to display the More menu, then select Explore.
Today, companies on Google Analytics 360 have a quick and easy access to the power of the raw Google Analytics data in BigQuery opening up a plethora of opportunities for data integration with other data sources for advanced analysis and machine learning applications.
As data sets in marketing are seamlessly stitched together and made available in BigQuery, the next big challenge is about exploring that data to draw meaningful conclusions. You can now continue your data exploration by accessing Explorer from within the BigQuery interface as well.
How Does that Work?
Connect to BigQuery using the new URL
Choose the data source, select the table you want to explore.
Select the ‘Explore in Data Studio’ option under the export dropdown in BigQuery.
- You will be directed to an exploration window in Data Studio where you can dive into your data.
How about opening an existing report?
You can do so without altering the chart. Right click on the chart you want to investigate and select Explore.
Differences between Reports & Explorations
1. Explorations are temporary unless you save them
Since the Explorer is a scratch pad, Data Studio doesn’t save your explorations automatically. To preserve your work so that you can revisit it later, click SAVE in the upper right of the exploration.
2. Explorations are private to you
Only you can see the explorations you create. There is currently no option to share explorations directly. However, you can export your explorations to reports and share them indirectly.
3. Explorations are optimized for filters
You can easily apply a filter to your explorations by dragging dimensions and metrics from the properties panel to the filter area at the top of the Explorer.
Explorations unify edit and view mode
The Explorer combines the best of view and edit modes into a single experience. You can customize the chart, add filters, and interact with the data, all in the same interface.
Exploration charts are copies
There is no link between charts in an exploration and charts in reports. If you export a chart from an exploration to a report, you’re exporting a copy of the chart. Similarly, when you open a report chart in the Explorer, you’re making a copy of the chart.
Thus concludes our session on Data Studio latest tool, Explorer. Know more about Regex function in Google DataStudio!.