Looker Studio

Last updated
Looker Studio
Developer(s) Google
Initial releaseMarch 15, 2016;8 years ago (2016-03-15)
Type Web analytics, Data visualization
Website lookerstudio.google.com OOjs UI icon edit-ltr-progressive.svg

Looker Studio, [1] formerly Google Data Studio, [2] [3] [4] [5] is an online tool for converting data into customizable, informative reports and dashboards. [6] Looker Studio was announced by Google on March 15, 2016 [7] as part of the enterprise Google Analytics 360 suite, and a free version was made available for individuals and small teams in May 2016. [8]

Contents

Rebrand from Google Data Studio

In June 2019, Google acquired data analytics company Looker for $2.6 billion to "help its customers analyze their data in a consistent way". [9] The acquisition was completed in February 2020. [10]

Initially, Google Data Studio and Looker operated as separate products within Google. Google Data Studio's offering was a simple, low-cost, and easy way to connect data sources and create dashboards, [11] while Looker offered a more enterprise-focused solution with robust support for transformations and permissions. [12]

In October 2022, however, Google announced the rebranding of Google Data Studio to Looker Studio. [13] This announcement was made at Cloud Next 2022, Google's virtual user conference. [13] At the conference, Google stated that Looker is set to become the name for all Google Cloud Business Intelligence products. [13] This name change was also accompanied by more updates including key security and management services, integration with Google Sheets, and more visualization tools. [13] Google also launched a new tier offering, Looker Studio Pro, with enhanced features for enterprise team collaboration and management. [14]

Plan offerings

Google continues to offer both Looker Studio and Looker Studio Pro plans. Looker Studio is available for free, while Looker Studio Pro requires an upgrade to a paid plan. [15]

Basic operation

In Looker Studio, users have the option to create a report from scratch or to use a report template from the Looker Studio Report Gallery. [6] Similar to templates available on other Google applications, these templates are created to make it easier for users to build their reports while still allowing for customization of design elements and other alterations. [6] Once a user has created a report, they will be prompted to then add a data connector to their report. [6] These connectors connect with their data, allowing for Looker Studio to automatically retrieve this data instead of requiring the user to upload exports of data to create reports. [16] Looker Studio offers over 600 partner connectors for users to choose from. [16] Connectors for Google platforms such as Google Analytics or Google Ads are free to use, while others require a subscription from an outside platform. [16] Users are also able to create their own connectors to any "internet accessible data source". Individuals can learn how to do this within Google Codelabs with this step-by-step tutorial. [17]

Customization and interactivity

Along with offering many template options for users, Looker Studio also has customization controls for users. For example, users can edit the layout, color options, font, and canvas size of a dashboard so that it showcases their data more effectively, and corresponds with the company's branding. [18] Users can also app up to 10 widgets per page and up to 20 pages to a Looker Studio report depending on their needs. [19]

Additionally, Looker Studio reports are interactive not only for those who create them but also with whoever you share the report with. [19] This means that everyone will have access to change dynamic control features such as date ranges or sorting options without the report setup needing to be updated. [18]

Charts and tables

When deciding how to visualize data, users can choose from 36 different chart types and variations. [20] These charts are organized under the following categories: Table, Pivot table, Scorecard, Gauge, Time series, Line, Area, Scatter, Bar, Pie, Google Maps, Geo chart, Bullet, and Treemap. [20] After choosing the visualization method, individuals will then define dimensions and metrics for the chart or table to generate. [20] Google explains dimensions as "a set of unaggregated values by which you can group your data". [21] Dimensions within a data source will appear in the color green. [21] Metrics, however, are "a specific aggregation that can apply to a set of values". [21] Metrics can be identified by their blue colored fields. [21]

Looker Studio dashboard with various chart types Data Studio - Mobile Friendly Scoreboard.png
Looker Studio dashboard with various chart types

Table charts

Tables in Looker Studio use rows and columns to organize metrics. [16] Tables are utilized to show "granular data, a large number of fields, or multiple metrics with very different units and scales aggregated for one or more dimension fields". [20] There are three ways to utilize tables and pivot table charts in Looker. Users can display data with numbers, bars, or heatmaps. [20] Users can then sort the data within these tables by two fields to allow for data to be displayed in a specific order. [20] Along with sorting data, data can also be filtered using various condition statements in the SETUP tab. [20]

Scorecard and gauge charts

When reporting on core objectives or high-level numbers, scorecard charts can display data in an attention-catching way. [16] These scorecard charts showcase a single metric on the report, showing it as text. [22] Scorecards can also communicate how a metric has changed over time using a comparison metric. [20] The scorecard then shows this change as a percentage under the displayed metric. [20] Another way users can call attention to a specific metric is by using a Gauge Chart. This type of chart monitors the performance of a single metric against a target, showing the progress similar to that of a car dashboard display. [20]

Line, time series, area, and scatter charts

Line charts help show trends in data and compare metrics along an ordinal axis. [20] Users can add multiple metrics to the chart to show their values over time displayed as lines, bars, or a combination of the two. [22]

Another way to show how a metric changes over time is to utilize a time series chart. [16] Time Series charts display a date or time dimension on the X-axis and a chosen metric on the Y-axis. [20] Users can also add 3 types of trendlines to a time series chart in Looker Studio. [20] These trendlines can be linear, exponential, or polynomial. [20] In addition, a version of time series charts without lines, called sparklines, can be showcased on scorecard charts. [20]

Area charts are similar to time series charts as users can only set a date or time on the chart's X-axis. [20] The Area Chart, however, has a shaded area under the line to highlight the difference in values between lines. [20] In addition, Line charts, Time series charts, and Area charts also have the ability to show cumulative sum values on the X-axis using the Cumulative option under the STYLE tab in Looker Studio. [20]

Unlike line or time series charts, scatter charts showcase the relationship between two metrics as separate data points on a graph. [20] Trendlines, however, can be added within Looker Studio to indicate the type of relationship these data points have including linear, exponential, or polynomial. [20]

Bar charts

Bar charts are used to display "a few metrics against one or two dimensions". [20] To be more specific, "one axis of the chart shows the specific categories (dimensions) being compared, and the other axis represents a discrete value (metric)". [22] Like other table and chart options in Looker Studio, users can configure their bar chart in any of the following ways: horizontal bars, vertical bars, clustered bars, stacked bars, and 100% stacked bars. [20]

Pie charts

Another way to display data in Looker Studio is with a Pie or Donut Chart. [22] These charts show data as parts of a whole, with Looker Studio allowing up to 20 slices in a single pie chart. [20] These slices showcase the dimensions that were defined by the user, and they are sorted in decreasing order according to the defined metric. [20]

Google Maps

The Google Maps chart within Looker Studio behaves similarly to that within the Google Maps application, allowing users to interact with the chart to zoom in/out and move around the map. [20] The variations offered for Google Maps charts are bubble maps, filled maps, line maps, and heat maps. [22]

Geo chart

Similar to Google Maps charts, users can utilize the geo chart within Looker Studio to visualize "how a measurement varies across a geographic area". [22] The zoom area property of geo charts also allows users to change the level of the geographical area depicted from world down to region. [20] Geo charts can be used to display up to 5,000 data points, which are chosen by Looker Studio. [20]

Bullet charts

Similar to the comparison options for Scorecard charts and Gauge charts, Bullet Charts are widely used to represent key performance indicators. [20] These charts display a single metric benchmarked against target values, but also show different thresholds so users can easily see how far ahead or behind a metric is from its goal. [20]

Treemap charts

Treemap charts are also offered within Looker Studio to display data in hierarchies based on defined dimensions. [22] In this type of chart, each branch represents a dimension value, with its size based on the defined metric for the entire chart. [20] This chart allows users to breakdown dimensions within Subtopics and Levels. [20]

See also

Related Research Articles

<span class="mw-page-title-main">Chart</span> Graphical representation of data

A chart is a graphical representation for data visualization, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can represent tabular numeric data, functions or some kinds of quality structure and provides different info.

<span class="mw-page-title-main">Bar chart</span> Type of chart

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a column chart and has been identified as the prototype of charts.

<span class="mw-page-title-main">Scatter plot</span> Plot using the dispersal of scattered dots to show the relationship between variables

A scatter plot, also called a scatterplot, scatter graph, scatter chart, scattergram, or scatter diagram, is a type of plot or mathematical diagram using Cartesian coordinates to display values for typically two variables for a set of data. If the points are coded (color/shape/size), one additional variable can be displayed. The data are displayed as a collection of points, each having the value of one variable determining the position on the horizontal axis and the value of the other variable determining the position on the vertical axis.

<span class="mw-page-title-main">Infographic</span> Graphic visual representation of information

Infographic are graphic visual representations of information, data, or knowledge intended to present information quickly and clearly. They can improve cognition by using graphics to enhance the human visual system's ability to see patterns and trends. Similar pursuits are information visualization, data visualization, statistical graphics, information design, or information architecture. Infographics have evolved in recent years to be for mass communication, and thus are designed with fewer assumptions about the readers' knowledge base than other types of visualizations. Isotypes are an early example of infographics conveying information quickly and easily to the masses.

Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation acquired Hyperion Solutions Corporation in 2007. Until late 2005 IBM also marketed an OEM version of Essbase as DB2 OLAP Server.

A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table within one or more discrete categories. The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics. A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.

<span class="mw-page-title-main">Google Analytics</span> Web analytics service from Google

Google Analytics is a web analytics service offered by Google that tracks and reports website traffic and also mobile app traffic and events, currently as a platform inside the Google Marketing Platform brand. Google launched the service in November 2005 after acquiring Urchin.

<span class="mw-page-title-main">Data and information visualization</span> Visual representation of data

Data and information visualization is the practice of designing and creating easy-to-communicate and easy-to-understand graphic or visual representations of a large amount of complex quantitative and qualitative data and information with the help of static, dynamic or interactive visual items. Typically based on data and information collected from a certain domain of expertise, these visualizations are intended for a broader audience to help them visually explore and discover, quickly understand, interpret and gain important insights into otherwise difficult-to-identify structures, relationships, correlations, local and global patterns, trends, variations, constancy, clusters, outliers and unusual groupings within data. When intended for the general public to convey a concise version of known, specific information in a clear and engaging manner, it is typically called information graphics.

<span class="mw-page-title-main">Heat map</span> Data visualization technique

A heat map is a 2-dimensional data visualization technique that represents the magnitude of individual values within a dataset as a color. The variation in color may be by hue or intensity.

In computer information systems, a dashboard is a type of graphical user interface which often provides at-a-glance views of data relevant to a particular objective or process through a combination of visualizations and summary information. In other usage, "dashboard" is another name for "progress report" or "report" and is considered a form of data visualization.

<span class="mw-page-title-main">Line chart</span> Chart type

A line chart or line graph, also known as curve chart, is a type of chart that displays information as a series of data points called 'markers' connected by straight line segments. It is a basic type of chart common in many fields. It is similar to a scatter plot except that the measurement points are ordered and joined with straight line segments. A line chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically. In these cases they are known as run charts.

<span class="mw-page-title-main">Radar chart</span> Type of chart

A radar chart is a graphical method of displaying multivariate data in the form of a two-dimensional chart of three or more quantitative variables represented on axes starting from the same point. The relative position and angle of the axes is typically uninformative, but various heuristics, such as algorithms that plot data as the maximal total area, can be applied to sort the variables (axes) into relative positions that reveal distinct correlations, trade-offs, and a multitude of other comparative measures.

FAME is a time series database released in 1981 and owned by FIS Global.

Tableau Software, LLC is an American interactive data visualization software company focused on business intelligence. It was founded in 2003 in Mountain View, California, and is currently headquartered in Seattle, Washington. In 2019, the company was acquired by Salesforce for $15.7 billion. At the time, this was the largest acquisition by Salesforce since its foundation. It was later surpassed by Salesforce's acquisition of Slack.

<span class="mw-page-title-main">Google Fusion Tables</span> Data management web service

Google Fusion Tables was a web service provided by Google for data management. Fusion tables was used for gathering, visualising and sharing data tables. Data are stored in multiple tables that Internet users can view and download.

<span class="mw-page-title-main">IBM Cognos Analytics</span> Business intelligence suite

IBM Cognos Analytics with Watson is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics. The software consists of several components designed to meet the different information requirements in a company. IBM Cognos Analytics has components such as IBM Cognos Framework Manager, IBM Cognos Cube Designer, IBM Cognos Transformer.

The World Integrated Trade Solution (WITS) is a trade software provided by the World Bank for users to query several international trade databases.

<span class="mw-page-title-main">Carto (company)</span> Cloud computing platform

CARTO is a software as a service (SaaS) spatial analysis platform that provides GIS, web mapping, data visualization, spatial analytics, and spatial data science features. The company is positioned as a Location Intelligence platform due to its tools for geospatial data analysis and visualization that do not require advanced GIS or development experience. As a cloud-native platform, CARTO runs natively on cloud data warehouse platforms overcoming any previous limits on data scale for spatial workloads.

Cloud analytics is a marketing term for businesses to carry out analysis using cloud computing. It uses a range of analytical tools and techniques to help companies extract information from massive data and present it in a way that is easily categorised and readily available via a web browser.

Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence (BI). It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn various sources of data into static and interactive data visualizations. Data may be input by reading directly from a database, webpage, PDF, or structured files such as spreadsheets, CSV, XML, JSON, XLSX, and SharePoint.

References

  1. Lardinois, Frederic (2022-10-11). "Google unifies its BI services under the Looker brand". TechCrunch. Retrieved 2022-10-13.
  2. "Welcome to Data Studio! - Data Studio Help".
  3. Grant Kemp; Gerry White (2020). Google Data Studio for Beginners. Apress. ISBN   978-1-4842-5155-3.
  4. Hurst, Lee (2019). Hands On With Google Data Studio. Wiley. ISBN   978-1-119-61608-5.
  5. Lakshmanan, Valliappa (2017). Data Science on the Google Cloud Platform. O'Reilly Media. ISBN   978-1-4919-7453-7.
  6. 1 2 3 4 Bonelli, Sherry (2022-10-15). "What is Google's Looker Studio and how you can use it". Search Engine Land. Retrieved 2023-10-19.
  7. "Introducing the Google Analytics 360 suite". 2016-03-15.
  8. "Announcing Data Studio: our free, new, Data Visualization Product". 2016-05-25.
  9. Novet, Lauren Feiner,Jordan (2019-06-06). "Google cloud boss Thomas Kurian makes his first big move — buys Looker for $2.6 billion". CNBC. Retrieved 2023-12-10.{{cite web}}: CS1 maint: multiple names: authors list (link)
  10. Ingals, Elaine (February 14, 2020). "Google completes $2.6 billion acquisition of Santa Cruz company Looker". The Mercury News. Retrieved July 24, 2023.
  11. Meeks, Travis (2023-05-16). "Why Data Enrichment Should Be Every Marketers New Best Friend". AnalyticsIQ. Retrieved 2023-10-02.
  12. Vivaldelli, Dan (17 June 2021). "How Does Google Data Studio Compare to Looker?". InfoTrust. Retrieved 25 July 2023.
  13. 1 2 3 4 Frederick, Brian (2022-10-11). "Google Cloud Rebrands Data Studio As "Looker Studio"". Search Engine Journal. Retrieved 2023-12-10.
  14. Lardinois, Frederic (11 October 2022). "Google unifies its BI services under the Looker brand" . Retrieved 25 July 2023.
  15. "Looker Studio: Pricing". Google Cloud. Retrieved 25 July 2023.
  16. 1 2 3 4 5 6 "Getting started with Google Looker Studio". Digital Culture Network. Retrieved 2023-10-19.
  17. "Connect and visualize all your data in Looker Studio". Google Codelabs. Retrieved 2023-10-19.
  18. 1 2 "Leveraging Snapchat Ads: Types and Usage Guide | Seer Interactive Insights". www.seerinteractive.com. Retrieved 2023-10-23.
  19. 1 2 Stouffer, Austin (2021-06-07). "What Is Google Data Studio? (And Why Data Studio Is a Marketer's Dream)". WebFX. Retrieved 2023-10-23.
  20. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Pulipati, Sireesha; Kelly, Nicholas (October 27, 2022). Data Storytelling with Google Looker Studio (1 ed.). Packt Publishing, Limited. ISBN   9781800561953.
  21. 1 2 3 4 "Dimension and metric improvements - Looker Studio Help". support.google.com. Retrieved 2023-10-19.
  22. 1 2 3 4 5 6 7 "[Sample] Data Studio Charts". Looker Studio. Retrieved 2023-10-24.