Google Looker Studio online course

During this section, we will cover the key components of a dashboard. We will discuss how to identify and define report specifications, and delve into the concepts of layout and grids. Essentially, this section will provide the theoretical foundation for the hands-on practice that will follow.

• 4 lectures
• 12 minutes

Section 3 will delve into the two types of data sources available in Looker Studio. We will guide you through the process of creating a blank report and connecting it to your first Google Analytics (4 or Universal) data source. Furthermore, we will demonstrate how to customize the appearance of the dashboard by setting up its theme.

• 7 lectures
• 46 minutes
• Homework
• Knowledge Check

In this section, we will cover the following topics:

• Setting up a date range
• Working with shapes and lines, images, and text elements
• Positioning elements and aligning them
• Adding page or report-level elements

By the end of this section, you will have a good understanding of how to use these features in Looker Studio.

• 5 lectures
• 35 minutes
• Homework
• Knowledge Check

Following section is  focused on presenting key performance indicators (KPIs). We will begin by identifying which metrics are relevant as KPIs for our use case. We will then proceed to create scorecards and bar charts to display them. Additionally, we will cover the importance of setting a report date range and how to effectively utilize the align and distribute features in Looker Studio. By the end of this section, you will have a solid understanding of how to present your KPIs in an effective and visually appealing manner.

• 5 lectures
• 34 minutes
• Homework
• Knowledge Check

In this section, we will delve into the creation of tables in Looker Studio. We will cover the following topics:

• Creating a simple table and reviewing all the available settings and style options.
• Utilizing custom date range and drilling down into the details.
• Resizing columns and using row numbers to show data in a specific order.
• Exploring simple and advanced table sorting options.
• Applying different rules to style the table, such as using heatmaps and bar charts for better visualization.
• Creating a new section in your report and adding and stylizing a table with your key performance indicators (KPIs) by month. By the end of this section, you will have a solid understanding of how to create and customize tables in Looker Studio to effectively present your data in a clear and visually appealing way.

• 9 lectures
• 41 minutes
• Homework
• Knowledge Check

In this section, we will focus on working with user metrics. Specifically, we will:

• Set up a time series chart and customize its appearance.
• Explore the use cases for lines and bar charts and the benefits of a double y-axis.
• Provide design advice for creating effective visualizations.
• Create a section title and select appropriate metrics to describe our users.
• Create a time series chart and review the available settings.

By the end of this section, you will have a good understanding of how to effectively visualize user metrics using time series charts in Looker Studio.

• 5 lectures
• 28 minutes
• Homework
• Knowledge Check

In this section, we will focus on understanding and utilizing individual page settings in Looker Studio to effectively present data from a tech website. We will cover the following topics:

• Using pie charts, stacked bar charts, and pivot tables to present data.
• Reviewing metrics and dimensions available in both Google Analytics 4 (GA4) and Universal Analytics, and determining which are the best fit for our goals.
• Emphasizing the importance of understanding the data you work with and how to choose the appropriate metrics and dimensions, as well as the correct chart type to effectively present the data.

By the end of this section, you will have a solid understanding of how to effectively present data from a tech website using various chart types and metrics in Looker Studio.

• 9 lectures
• 45 minutes
• Homework
• Knowledge Check

In this section, we will delve into creating and customizing a geo chart in Looker Studio. We will cover the following topics:

• Creating a new geo chart and discussing its settings and logic.
• Configuring metrics and dimensions for the chart.
• Updating the styles of the chart, including different color scales and legends.
• Creating a supporting table for the geo chart to better understand the data.
• Exploring options for designing Google maps and comparing them to geo charts.
• Examining different styles of bubble maps and selecting the best option for our report.

By the end of this section, you will have a good understanding of how to create and customize geo charts in Looker Studio and how to make use of Google maps to enhance your data visualization.

• 6 lectures
• 26 minutes
• Homework
• Knowledge Check

In this section, we will use a bubble chart to provide an overview of channels data. We will cover the following topics:

• Reviewing the settings available for bubble charts.
• Explaining how to interpret and read bubble charts.
• Customizing the legend and color of bubbles.
• Creating a simple table to review the data and make decisions about the most appropriate chart type to present the data.

By the end of this section, you will have a good understanding of how to use bubble charts in Looker Studio to present channels data and how to customize the chart to improve its visual appeal.

• 4 lectures
• 23 minutes
• Homework
• Knowledge Check

In this section, we will focus on creating a product breakdown using a TreeMap graph. We will cover the following topics:

• Creating a table with product data and adding relevant metrics for this section.
• Creating a TreeMap chart and reviewing its settings and styles.
• Exploring the different types of control elements available in Looker Studio.
• Demonstrating how control elements can be used to apply filters to specific charts and tables.
• Adding a footer to the dashboard and providing a quick overview of the entire dashboard.

By the end of this section, you will have a good understanding of how to create a product breakdown using a TreeMap graph in Looker Studio and how to utilize control elements to filter and manage data.

• 6 lectures
• 37 minutes
• Homework
• Knowledge Check

In this section, we will explore advanced functionality and data management techniques in Looker Studio. We will cover the following topics:

• Creating a new page for experimentation and experimenting with different comparison calculation options.
• Reviewing filters based on the “medium” traffic source filter, with the condition of ‘cpc’ or ‘cpm’.
• Adding custom metric and dimension fields, using the CASE function as an example.
• Creating calculated fields on the report level and comparing it with the chart level.
• Introducing the concept of blended data sources and reviewing different types of joins.
• Testing blends on a simple example by creating a new blended data source based on Universal Analytics and Paid traffic filter, and creating a table and chart based on the new blend.
• Overview of partner connector services and providing recommendations for their use.
• Copying the dashboard and changing the data source. By the end of this section, you will have a good understanding of how to use advanced calculations and data management techniques in Looker Studio, and how to effectively blend data sources to create powerful and informative visualizations.

• 9 lectures
• 61 minutes
• Homework
• Knowledge Check