# Creating Visualizations in Google Data Studio

**Create New report on Airbnb Boston reviews**

To create a new report from scratch, a portion of the [Kaggle](https://www.kaggle.com/airbnb/boston) [dataset of the Airbnb reviews in Boston](https://www.kaggle.com/airbnb/boston) has been uploaded into a [shared Google Sheets](https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/edit#gid=285360760) to be used as data source for Google Data Studio.

* the full Kaggle dataset of the Airbnb reviews in Boston is available at [https://www.kaggle.com/airbnb/boston](https://www.kaggle.com/airbnb/boston)
* the Google Sheets, with approximately 10k reviews, to be used as data source is available at [https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/](https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/edit#gid=285360760) [edit#gid=285360760](https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/edit#gid=285360760)

![](https://4055173823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2Flearn%2F-MVKZOudn7RrMJdwvB8T%2F-MVMA2QTwlFmw7LjtMKc%2F10.jpeg?generation=1615296478553076\&alt=media)

* 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)

![](https://4055173823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2Flearn%2F-MVKZOudn7RrMJdwvB8T%2F-MVMA2QUBGFybMDx8Ncp%2F11.jpeg?generation=1615296478531158\&alt=media)

* 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
* Paste the Airbnb-data Google Sheet URL in the specific field: [https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/](https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/edit#gid=285360760) [edit#gid=285360760](https://docs.google.com/spreadsheets/d/1a2c9vCMFFfDXmhjoEoX2EwS2lYTbqE4WfZY72TXW9co/edit#gid=285360760)
* 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

![](https://4055173823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2Flearn%2F-MVKZOudn7RrMJdwvB8T%2F-MVMA2QXWzzonZdadAwS%2F14.jpeg?generation=1615296478536006\&alt=media)

**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**.
*   **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://support.google.com/datastudio/answer/6299685?hl=en](https://support.google.com/datastudio/answer/6299685?hl=en)

    * **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.&#x20;

* **Analysis (1)**: Number of Records over time

![](https://4055173823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LgXtIWpHMikxGQHLU5T%2F-MVMe7ms2StVbNg1D3Iu%2F-MVMeotS_UA2BriMRBkS%2FScreen%20Shot%202021-03-09%20at%2010.45.57%20AM.png?alt=media\&token=3be526af-10c3-43f2-870f-983242859e42)

**Analysis (2)**:&#x20;

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

![](https://4055173823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LgXtIWpHMikxGQHLU5T%2F-MVMe7ms2StVbNg1D3Iu%2F-MVMfGIlwu05v7PDaGnG%2FScreen%20Shot%202021-03-09%20at%2010.48.15%20AM.png?alt=media\&token=063d9c2e-6b6c-445a-b79f-47a5c9223b2e)

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

![](https://4055173823-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LgXtIWpHMikxGQHLU5T%2F-MVMe7ms2StVbNg1D3Iu%2F-MVMfpAtN-2PqUuAsdO3%2FScreen%20Shot%202021-03-09%20at%2010.50.25%20AM.png?alt=media\&token=c4ed4fdf-9ba0-4ab2-9733-faafaf70fb3b)

