Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Complete Introduction to Google Data Studio

Name: Complete Introduction to Google Data Studio
Rating: 4.6 (9654 reviews)

Learn how to create powerful data analysis, reports and dashboards with Looker Studio (formerly Google Data Studio)

Bestseller

Role Play

Created byIan Littlejohn

Last updated 8/2025

English

German [Auto],English [Auto],

What you'll learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
Learn from an Instructor with over 10 years teaching Data Analysis and Dashboard Design
Create POWERFUL Interactive Dashboards from Google Sheets Data in Minutes
Analyze Google Sheets in MINUTES using powerful visualizations and reports
Create Year to Date, Month to Date, Week to Date Calculations with the click of the mouse
Learn to SHARE and COLLABORATE using Reports and Dashboards of data
Create powerful SCORECARDS displaying Key Metrics and KPIs
Create TIME SERIES graphs that easily display Month to Date, Previous Month and many more
Display COMPARISONS to Previous Periods
Create FILTERS to easily create interactive dashboards, graphs and reports
Learn powerful VISUALIZATIONS such as Column, Bar, Pie, Scatterplot

Course content

12 sections • 76 lectures • 5h 29m total length

Introduction to the Course1:53
About the Course1:23
Download the Google Sheets Training Data0:03
Loading Data into Google Sheets3:24
Connecting to Google Data Studio4:06
Overview of Google Data Studio5:22
Welcome to Udemy Roleplay0:35
Discuss the data analysis project for the Sales department

Introduction to Tables0:58
Creating Tables5:31
Formatting and Sorting Tables8:25
Explore formatting and styling options for your Looker Studio tables, including font, colors, headers, borders, wrap text, alignment, and pagination; enable cross filtering to make interactive data filters across visuals.
Multiple Measures5:19
Learn how to work with multiple metrics in Looker Studio, adding profit and order quantity, applying heat maps and data bars, and adjusting decimals and targets for cross-filtered insights.
Conditional Formatting6:20
Practical Activity0:16
Completed Practical Activity5:29
Meeting with Ada to discuss using Tables in Looker Studio reports

Introduction to Methods of Aggregation1:08
Methods of Aggregation9:00
Practical Activity - Methods of Aggregation0:40
Completed Practical Activity - Methods of Aggregation6:28
Comparison Calculations4:54
Explore advanced calculations in Looker Studio tables with product subcategory and sales, no decimals, and a summary row. Compute percentage of total, difference from total, and percentage of max.
Running Total Calculations5:34
Drill Down6:09
Working with Dates4:58
Meeting with Ada to discuss Methods of Aggregation

Introduction to Slicers and Visualization Filters1:04
Learn to add slicers and visualization filters using text, numeric, and date controls, and apply filters to individual visualizations to create interactive reports.
Text Controls6:58
Numeric Controls3:51
Date Controls3:41
Additional Controls6:26
Explore how Looker Studio controls work, from input boxes and tick boxes to preset filters and navigation buttons, and learn when each fits your data.
Quick Filters3:23
Learn to use the quick filters on the filter bar in edit mode to filter a report by region, price, date, and channels, then reset or remove as needed.
Text Visualization Filters4:56
Apply text visualization filters in Looker Studio to a single visualization, including region Asia, starts with and or conditions, and product category audio from a field outside the table.
Numeric Visualization Filters4:05
Learn how to create Pivot Tables in Google Data Studio
Date Visualization Filters3:20
Example Filter2:56
Meeting with Ada to discuss controls and filters in the data analysis project

Introduction to Custom Calculations1:20
Create Calculations9:38
Create custom calculations in Looker Studio by adding calculated fields to compute total sales, total profit, and the profit ratio. Build these metrics using sum, division, and percentage formatting.
Practical Activity0:06
Completed Practical Activity5:10
Create calculated fields in Looker Studio to analyze sales by product category, including average sales, highest sale, total sales, and average sale per product. Add country insights with these metrics.
Year Month and Day8:55
Case Statement5:14
Use the case statement in Looker Studio to evaluate sales and create a field. Use when, then, else, and end case to label sales as over 1000 or below 1000.
Practical Activity0:11
Completed Practical Activity4:15
Comparisons4:23
Meeting with Ada to discuss using custom calculations

Introduction to Case Study1:15
Explore the data extraction feature in Looker Studio, embedding selected fields, dimensions, and metrics to speed refreshes using locally stored data. See how the case study demonstrates this approach.
Extract Data Case Study4:49
Learn to create an extract data source in Looker Studio from Google Sheets, select dimensions and metrics, save the extraction, and swap visuals to faster extracted data.

Introduction to Time Series Graphs1:48
Create Time Series Graphs8:04
Using time series graphs, learn how data changes over time and detect trends from year to month to order date. Explore drill-downs, legends, and line or bar options.
Changing Time Periods3:23
Trend and Reference Lines7:00
Explore how to customize graphs in Looker Studio, adding trend lines and reference lines, and using cumulative, moving average, and percentiles to analyze sales data over time.
Time Series Comparisons6:22
Explore time series comparisons by plotting year-month data and comparing it to the previous year or period using custom date ranges and interval options for boundaries.
Area Graph5:18
Explore area graphs in Looker Studio to visualize how data changes over time with stacked and 100% stacked views, using region breakdown and adjustable axes.
Practical Activity0:15
Completed Practical Activity5:06
Meeting to discuss using Time Series visualizations with Ada

Introduction to Other Visualizations2:30
Column and Bar Graphs8:20
Pie Graphs4:29
Explore how pie charts show percentage contributions and how limiting items improves readability, while adjusting donut styling, slice padding, inner radius, colors, labeling, and legend placement to suit data.
Geographical Analysis8:29
TreeMap Graph3:14
Scatterplot Graph6:30
Use scatter plots to explore the correlation between sales and profit, with axis swaps, trend lines, data labels, and drill-down options across product category, subcategory, and name.
Custom Visualization5:00
Meeting with Ada to discuss additional visualizations

Requirements

You will need a Google Account
You will need access to Google Sheets
You will need access to Google Data Studio

Description

In this course we are going to show you how to supercharge your Google Sheets into Interactive Dashboards and incredible reports. Data Studio works seamlessly with your Google Sheets data to create amazing data analysis in minutes.

Data Studio is an incredibly easy to use drag and drop tool that allows a multitude of different visualizations to be created in minutes. The addition of filtering tools produces stunning reports that will take your data analysis to the next level.

Data Studio is available free to people with a Google or Gmail account.

COURSE CONTENT AND OUTCOMES

How to connect Data Studio to Google Sheets
Learn how to calculate Averages, Highest values, Lowest Values and number of Unique Values
Create Scorecards to display key metrics and KPIs
Create powerful trend analysis graphs to help with forecasting
Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button
Learn to gain powerful analysis from Stacked Bar and 100% graphs
Create powerful Time and Category filters to easily create interactive reports
Learn to share your Reports and Dashboards with other users

Google Data Studio is truly an amazing product for creating insight and intelligence from your Google Sheets data.

ABOUT THE TRAINER

I am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.

WHAT STUDENTS ARE SAYING

I was very pleasantly surprised by this course, I just wanted to whip through it to get the gist of data studio, but it's very interesting and there's lots of cool tips and tricks, and perhaps most welcome of all, the lessons are concise - a lot of 'tech' courses on udemy are very long, and I'm not against the creators taking their time and including lots of content, but it is difficult to maintain your concentration across 40 hours, especially with a new subject. This was an excellent course.
Excellent course with a general overview of all the features that Looker Studio has to offer. Concise, simple to understand, great presentation and to the point. Excellent!
Very thorough and concise course. I feel like I've gained all of the knowledge I need to get started with building effective reports in Looker Studio. I especially appreciated the "Sales Manager" hands-on exercises.
Really enjoyed this course - having never worked with Looker it was great and gave me all the information i needed for a new role - highly recommend

DATA ANALYSIS COURSES ROADMAP

The tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.

Microsoft Excel

Introduction to Analyzing Data with Excel Pivot Tables
Complete Introduction to Excel Power Pivot
Complete Introduction to Excel Power Query
Excel Interactive Dashboards and Data Analysis
Complete Introduction to Business Data Analysis
Tables and Formulas with Excel

Microsoft Power BI

Complete Introduction to Microsoft Power BI
Complete Introduction to Power BI Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class - Dashboards and Power BI Service

Google

Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Looker Studio (formerly Google Data Studio)

Amazon QuickSight

Complete Introduction to Amazon QuickSight

ChatGPT

Introduction to Analyzing Data with ChatGPT

Who this course is for:

Google Sheets users and Excel users who want to learn how to use Google Data Studio to analyze and report data

Complete Introduction to Google Data Studio

What you'll learn

Explore related topics

Course content

Introduction8 lectures • 17min

Tables8 lectures • 32min

Methods of Aggregation9 lectures • 39min

Pivot Tables and Card Visualizations7 lectures • 30min

Slicers and Visualization Filters11 lectures • 41min

Custom Calculations10 lectures • 39min

Case Study2 lectures • 6min

Time Series Graphs9 lectures • 37min

Other Visualizations8 lectures • 39min

Publishing and Sharing Interactive Dashboards5 lectures • 23min

Requirements

Description

Who this course is for: