Google Data Studio Training

Column & Bar Charts

Column & Bar Charts

Introduction A bar chart uses horizontal or vertical bars to show comparisons among categories. The longer the bar, the greater the value it represents. One axis of the chart shows the specific categories being compared, and the other axis represents a discrete value. Example: Here are 2 bar charts from Google Analytics data source. The base dimension for both charts is Medium. The left hand chart uses stacked bars to show several metrics (Sessions, Users, and Exits) for medium. The right hand chart uses a second dimension, Country ISO Code, to breakdown each medium How to add a column or...

Scorecards

Scorecards

Introduction A scorecard is a way to track a single metric that measures the relative health or performance of your business or area of activity. For example, a scorecard tracks total sales, average bounce rate, count of ad impressions, maximum hold time, minimum failure rate and more. Scorecards in Data Studio appear as numbers, and, optionally, the name of the metric being summarized. The format of the displayed number depends on how the metric is configured in your data source. Example: Let's imagine this is our data source; We can have below scorecards from this data source; How to add...

Report Builder First Look

Report Builder First Look

Introduction In this tutorial, we will have a first look to the main report building elements. Main Sections Toolbar On the top of the page is a toolbar, and on the right upper corner is a share button and a “View” button. By default you are in “Edit” mode. Add a page: You can add several pages to each report. Undo and Redo: Also possible with the keyboard shortcuts Ctrl+Z (undo) and Ctrl+Y (redo). Selection Mode: This pointer icon allows you to select a chart or other elements in your canvas. When you select an element, a configuration tab will open on the right side. Add...

Adding Pages in Google Data Studio

Adding Pages in Google Data Studio

One of the brilliant functions of Google Data Studio is to be able to create several pages. You can consider different data sources for each page or sometimes you might want to break down elements in less number of chart to increase readablity. How to add a new page? Click on "edit" while you are in the report. In the menu, select Page > New Page. When you want to add a new page and your report has more than one page, then: Click the Page __ of __ drop-down menu. Select ** Add a new page.** How to navigate between pages? Use the page...

Creating Your First Data Source

Creating Your First Data Source

What is a data source? There are 2 types of data sources and they are connected by "connectors" |  A connector is the mechanism by which Data Studio accesses a specific data platform, system, or product. Google Connectors (aka. free connectors) Partner Connectors (aka. community connectors) There are free connectors built by Google to access data such as Google Sheets..., you can also use connectors built by Data Studio partners via the Community Connectors developer program. Community connectors may cost money to use. How to create a data source? 1. Creating universal data source from "Create" button. When on the main...

Dashboard Building Outline

Dashboard Building Outline

Google Data Studio allows you to build beautiful dashboards for various analytics and data sources. Creating your first dashboard to step into this new world can look challenging. That's why prepared this outline as a step-by-step tutorial which we simplify your beginning. Steps: Login to your Google Data Studio with your Google account. As mentioned in the Introduction, Google Data Studio is one of the Google Marketing Platform products. Likewise Google Analytics or Google Ads, you just use your existing Google account or create a new one. Every creator must have a Google account to access, edit and share Google Data...