Google Data Studio and Cloud Dataprep Now GA

Google Data Studio

Source: Official Google Blog 

With Data Studio, you can easily access and analyze data from Google Cloud and Google Marketing Platform sources alongside more than 500 other data sources via more than 100 partner-built connectors. This means you can visualize and interactively explore data in compelling dashboards or reports, easily share insights with others or collaborate in real-time with colleagues, whether you’re sitting across the room or across continents. As a result, it’s now being used by over a million people around the world, every single month.

Continuous investments in Data Studio

Data Studio beta users have influenced the product’s evolution and inspired our vision for its future. We recently introduced Data Studio Explorer, an ad-hoc data exploration component of Data Studio. Its native integration within BigQuery’s UI gives our users the ability to turn their datasets and query results into a visualization, literally in a few clicks.

Data Studio Explorer user interface experience
Example workflow from the BigQuery user interface to Data Studio Explorer

Blending data from disparate sources in a single chart is also now as simple as a right-click inside Data Studio.

Blending data UI example for Data Studio
It’s as easy as a right-click to blend data from disparate sources in the same chart.

In addition to popular Google Cloud data sources like BigQuery, Sheets, Cloud SQL, Cloud Spanner and Cloud Storage, Data Studio works with popular Google advertising and marketing data sources  like Google Analytics, Display & Video 360, YouTube Analytics, and Google Ads. Further, organizations can gain access to over 500 data sources like Salesforce, Facebook, Twitter, and more, through our community connectors partner ecosystem. A custom report template gallery makes getting started fast, with filter-like controls for the data source you’re interested in. And in just a few weeks, we will launch a new community feature to support custom visualizations, allowing you to build your own visualizations for Data Studio using 3rd party libraries like D3.js or custom JavaScript and CSS.

We hope you recognize that the team is just getting started with Data Studio! We’ll continue to release new features and additional enhancements to the product. In the meantime, you can get started by visiting datastudio.google.com, connecting to your data sources, and exploring our template gallery. As always, feel free to ask us questions and send us feature requests. Data Studio is your product as much as it is ours.

Cloud Dataprep

Data processing techniques and tools may have evolved, but one headache in data processing has remained constant: bad input data with anomalies, gaps, and inconsistencies. Taking action on bad data often leads to bad results, but cleaning and preparing data typically requires a lot of time and coding from developers and subject matter experts.

We believe data preparation is important and allows you to unlock the full potential of cloud data analytics tools like BigQuery and Google Cloud Dataflow. We introduced Google Cloud Dataprep to make data preparation easy, fast, and powerful through an intuitive and serverless visual interface, As of today, it is generally available.

We’re launching the general availability of Cloud Dataprep with a number of new features frequently requested by our user community. These new features make it easier to do the core tasks involved in data preparation: exploring, cleaning, and enriching data.

  • A new look: The landing page for Cloud Dataprep has been updated to show recent activity, and new users will get up-to-speed quickly with an improved onboarding experience.
The landing page for Cloud Dataprep with easy onboarding experience
  • Team-based data preparation: Teams can now collaborate on data preparation by sharing flows, collaborate on recipes in real-time, re-using samples, and reviewing an audit trail to see who did what and when.
Team collaboration on recipes interface
  • Powerful features for business analysts: Business analysts can be more productive with Google Sheets-like pivots and unions, improved source:target schema matching, and parameter-based dataset processing.
Business analyst features, including pivots, unions, and schema matching

On any given day, Cloud Dataprep has organizations scheduling thousands of predefined jobs or performing ad-hoc data preparation.

You can easily get started exploring, cleaning, and enriching your data by following one of our how-to guides. Since Cloud Dataprep is serverless, if you’re an existing user, all of these new features are immediately available and existing jobs do not require modification. For more information, you can always review the Cloud Dataprep release notes and use the google-cloud-dataprep tag on Stack Overflow for questions.

Looking ahead, with insight

When combined with BigQuery, our fully-managed and easy-to-use enterprise data warehouse, Data Studio and Cloud Dataprep comprise key components of Google Cloud’s business intelligence and marketing analytics solutions. Keep an eye on this space as we continue building out features and enhancements, based on your experiences and feedback. In the meantime, ready your data for analysis and machine learning with Cloud Dataprep or start exploring and visualizing all your critical data with Data Studio.