LogoLogo
  • About DS Learn
  • Tutorials
    • ¶ Digital Exhibits
      • Getting Started with Digital Exhibits
        • Considerations
        • Basic Steps
          • Site Organization
          • Usability & Accessibility
        • Platforms
    • ¶ Digital Storytelling
      • Introduction to ArcGIS StoryMaps
        • Getting Started
        • Using Content Blocks
        • Importing Maps from David Rumsey
      • Introduction to KnightLab StoryMap JS
      • TimelineJS
    • ¶ 3D Modeling & Immersive Technology
      • Adding 3D Models in Omeka
      • Intro to Photo Processing with Agisoft Metashape for 3D Model Making
      • Tips and Tricks for Taking Photos for 3D Model Creation
      • An Introduction to Apple's Reality Composer AR
      • Importing SketchFab Models into AR for the iPad or iPhone
      • Creating Basic 3D Objects for AR in Blender
      • Introduction to Meshlab
    • ¶ Data Visualization
      • Introduction to Tableau
        • Download and Install Tableau
        • Using Tableau to Visualize COVID-19 Data
        • Tableau DH
        • Resources
      • Beyond Simple Chart in Tableau
        • Beyond Simple chart Examples
      • Google Colab
        • Get Started
        • Data Import
        • Data Wangling
        • Visualization
        • Results Export
      • Out of Box Data Visualization Tools
        • How to use Google Data Studio with Google Sheets
        • Google Data Studio Interface
        • Creating Visualizations in Google Data Studio
    • ¶ Mapping
      • Tiling High-Resolution Images for Knightlab StoryMapJS
      • Hosting and Displaying Zoomable Images on Your Webpage
      • Georectifying Historical Maps using MapWarper
      • Making a Starter Map using Leaflet
    • ¶ REST API
      • How does REST API work?
      • JSON File
      • Get Started with Google Sheets Script Editor
      • Example 1: Extract Data by One Cell
      • Example 2: Extract Data by A Cell Range
    • ¶ Text Analysis
      • Introduction to Text Analysis
        • Step 1: Exercise One
        • Step 2: What is Text Analysis?
        • Step 3: Important Considerations
        • Step 4: Why Voyant and Lexos?
        • Step 5: Exercise Two
      • Text Repositories
      • Text Analysis in JSTOR
        • Overview of Constellate
        • Build A Dataset
        • Create A Stopwords List
        • Word Frequency
  • Digital Scholarship Incubator
    • Schedule
    • Getting Started
    • People
    • Project Guidelines
    • Topics
      • 3D Modeling and Immersive Technologies
        • Part 1: 3D Photogrammetry & Laser Scanning
          • Exercise: Experiment with 3D creation tools
        • Part 2: An Introduction to Apple's Reality Composer AR
          • Exercise: Experiment with Apple RealityComposer AR
      • Anatomy of a DS Project
        • Parts of a DS Project
        • Some DS Project Examples
        • Exercise: Evaluating a DS Project
      • Pedagogy
      • Data and Data Visualization
        • Introduction to Data
        • Introduction to Data Visualization
        • Introduction to Tableau
          • Download and Install Tableau
        • Introduction to Network Visualization
      • Digital Exhibits
        • Exercise 1: Exploring Exhibits
        • Exercise 2: Exhibit.so
      • DS Intro & Methodologies
      • User Experience
        • Usability Exercise
      • Mapping and GIS
        • An Introduction to Mapping, GIS and Vector Data
          • Workshop: Exploring and Creating Vector Data
          • Quick Review: Spatial Data
        • An Introduction to Raster Data and Georeferencing Historical Maps
          • Workshop: Finding and Georeferencing an Historical Map
          • Tutorial: Georectifying Historical Maps using MapWarper
        • Presentation + Workshop: Putting it together in ArcGIS Online
        • Workshop: A Brief Introduction to QGIS
          • Adding Base-maps and Raster Data
          • Adding and Creating Basic Vector Data
          • Styling your data and preparing it for exporting
      • Story Maps
        • Story Map Exercise
      • Text Analysis
        • Exercise 1: Voyant
        • Exercise 2: Python
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Tutorials
  2. ¶ Data Visualization
  3. Out of Box Data Visualization Tools

Creating Visualizations in Google Data Studio

PreviousGoogle Data Studio InterfaceNext¶ Mapping

Last updated 4 years ago

Was this helpful?

Create New report on Airbnb Boston reviews

To create a new report from scratch, a portion of the has been uploaded into a to be used as data source for Google Data Studio.

  • the full Kaggle dataset of the Airbnb reviews in Boston is available at

  • the Google Sheets, with approximately 10k reviews, to be used as data source is available at

  • Spend some time to understand the data by reading their description on Kaggle and looking at the table on Google Sheets.

  • The data-source table has been created by joining the “Listings” and “Reviews” original tables provided by Kaggle, and exporting the first 10k joined rows sorted by ascending “listing_id”.

Create a new report

  • Go to the Data Studio home page

  • Click on “Start a new report” (Blank)

  • Rename the “Untitled Report” with a name of your choice by clicking on the name itself

  • Create a new data source by clicking on the blue button on the bottom right, or select the Airbnb data source if it is already present in the right-pane list

Connect to the Google Sheet data source by using its URL:

  • Choose the “Google Sheets” connector in the list of connectors on the left

  • Choose the “URL” option in the first column

  • Choose the “Reviews Query DW” worksheet in the next column

  • Tick the option to “use the first row as headers” if it is not ticked yet

  • Click on the “Connect” button to execute the connection to the data source

Dimensions, metrics, and transformations

  • Check the type and aggregation of each field and that all the fields are correctly interpreted as either dimension or metric.

    • CONCAT(latitude, CONCAT(', ', longitude)) → to generate a (lat, long) field useful for map charts; before generating this new field, set “Aggregation=None” for latitude and longitude fields, so that they become dimensions (by default, Data Studio considers them as metrics)

After creating new fields and updating the existing ones, click on “Add to report”

Analyze the data

Analyze the data by building the following visualizations. Then, explore and create new visualizations to find interesting insights on your own.

  • Analysis (1): Number of Records over time

Analysis (2):

  • analyzing the number of different reviewers for each (lat, long) locationnote that the Kaggle dataset of the Airbnb reviews is in Boston, Massachusetts, US

Allow end-users to filter the data under analysis by selecting a date range and city name.

Paste the Airbnb-data Google Sheet URL in the specific field:

Create new useful fields (dimensions or metrics) from the existing ones by exploiting formulas, such as in the following (click on the “+” and “fx” placeholders). For details on this step, see:

https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/
edit#gid=285360760
https://support.google.com/datastudio/answer/6299685?hl=en
Kaggle
dataset of the Airbnb reviews in Boston
shared Google Sheets
https://www.kaggle.com/airbnb/boston
https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/
edit#gid=285360760