Google Data Studio Training

Formatting & Themes

Formatting & Themes

Introduction We all used spreadsheets once in our lives. Most of us use them still. Sure, they are very efficient and right to the point. But aren't they boring? A little color and a touch of art, might create wonders. And by wonders, we mean easier to read and appealing dashboards! Themes Themes are a set of predefined color and style combinations you can apply to your reports. Applying a theme updates the style settings of your charts, tables, background color, and text, helping to ensure your reports are visually attractive and stylistically coherent. Default Theme All new reports start...

Parameters

Parameters

Introduction We mentioned dimensions and metrics here. They are main segments of data which we use on charts and reports. But they are bringing values from the data sources. What is you want to input a unique or custom variable which is not in the data source but relevant to your reports. For example, while making reports for Google Ads, you might want to add your monthly target budget as a variable. ūüí° Parameters let you interact with user-provided data and they pass user-supplied data to calculated fields and connectors. How parameters work Parameters act like variables in a programming...

Date & Time Calculations

Date & Time Calculations

Introduction You can use functions in calculated fields to create new columns of date and time data in your data source or directly in components on the report. Where to use them? For example, you can construct a complete date from separate numeric day, month, and year fields using the DATE function. Or you can extract date and time parts from a date with functions like YEAR, DAY, and HOUR. You can even calculate the difference between 2 dates using DATETIME_DIFF, or add a certain number of time parts using DATETIME_ADD. Date and Date & Time literals To use literal date and time values in a calculated...

CASE statements

CASE statements

Introduction Case statements are conditional expressions used in calculated fields. They define one or more conditions and returns a result when a condition is met. You can define a default result if none of the conditions is met. Case statements are most often used to create new categories or groupings of data. Before proceeding, you might want to check previous training on calculated fields here. How to create CASE statements? CASE statements are boolean values, and they return the value you specify. A common use for CASE is to create new categories or groupings of data. For example, to group...

Basic Metric Calculations

Basic Metric Calculations

Introduction Google Data Studio, comes with calculated fields which are here to transform, categorize, and do math with your data. Calculated fields let you create new metrics and dimensions derived from your data. Calculated fields let you extend and transform the information flowing from your data sources and see the results in reports. For example, you might want to get the value of total revenues. You multiply the unit price field (Price) by a quantity sold field (Qty Sold). This fields will give you value of your total revenues. How do they work? A calculated field is a formula that...

Basic Principles Of Joining Data

Basic Principles Of Joining Data

Introduction Data blending tools let you combine multiple datasets into a single, new dataset, which you can then visualize in a dashboard or other visualization. Enterprises collect data from a variety of sources, and they may want to temporarily bring together different datasets to compare data relationships or answer a specific question. Why it is useful? The amount of data available in any business is increasing. Blending data sources can enable you to discover insights faster and use that information to make better decisions. ūüí°Data blending is typically used for ad hoc reporting and rapid analysis. Data blending tools let...

Blending Data in Data Studio

Blending Data in Data Studio

  Introduction Data Blending is one of the marvels of Google Data Studio. This function helps you join information from multiple sources and gives you a unified view. By default, charts in Data Studio get their information from a single data source. Blending lets you create charts based on multiple data sources, called a blended data source. Examples; You can blend two different Google Analytics data sources to measure the performance of your app and website in a single visualization. You can blend Google Ads and Facebook Ads data into one blended data source and you can see combined ad impressions,...