About the course

Learn how to build dashboards and reports in Google Data Studio quickly and confidently, using data from Google Analytics and Google Sheets.

After taking this course you will be able to visualize and present data. From importing data through to customizing and sharing your reports.

What will I learn in the course?

  • Working with data from Google Analytics and Google Sheets
  • How to visualize your data to create powerful reports
  • How to build dashboards quickly and confidently
  • How to share and collaborate on your reports

Your instructor

Co-Founder, Loves Data

Benjamin Mangold

Benjamin Mangold co-founded Loves Data and he is an internationally recognized expert in digital analytics and marketing. He has been working with Google Analytics, Google Ads, Google Tag Manager, Google Data Studio, and other Google products for over twelve years. He has trained and consulted for companies like 3M, Fuji Xerox, and Google. As your course instructor, he will teach you practical techniques, from setup and configuration, right through to improving your website and your marketing campaigns.

Course curriculum

  • 1

    Foundations

    • Welcome to the course

    • Introduction to Google Data Studio

    • Interface features

    • Walk-through: interface features

    • Dimensions and metrics

    • Data visualization

    • Exercise: creating a report

    • Quiz: foundations

  • 2

    Creating Reports

    • Walk-through: connecting data sources

    • Walk-through: connecting Google Sheets

    • Walk-through: connecting Google Analytics

    • Embedded data sources

    • Walk-through: adding a custom date range

    • Walk-through: time series

    • Exercise: create a time series - part one

    • Exercise: create a time series - part two

    • Walk-through: bar chart

    • Exercise: create a bar chart - part one

    • Exercise: create a bar chart - part two

    • Walk-through: combination chart

    • Walk-through: pie chart

    • Walk-through: table

    • Walk-through: geographic map

    • Walk-through: scatter chart

    • Walk-through: bullet chart

    • Exercise: create a scorecard and bullet chart - part one

    • Exercise: create a scorecard and bullet chart - part two

    • Walk-through: area chart

    • Walk-through: pivot table

    • Quiz: data sources and charts

  • 3

    Customization

    • Walk-through: adding a date range control

    • Walk-through: adding a filter control

    • Walk-through: chart filters

    • Walk-through: adding a Google Analytics segment

    • Creating Google Analytics segments

    • Walk-through: layout options

    • Walk-through: adding pages

    • Walk-through: styling options

    • Exercise: layout and styling

    • Quiz: customization

  • 4

    Dashboards

    • Walk-through: dashboard examples

    • Marketing dashboard

    • Ecommerce dashboard

    • Goal conversions dashboard

    • Content dashboard

    • Social dashboard

  • 5

    Management

    • Walk-through: sharing reports

    • Summary of user permissions

    • Walk-through: presenting and exporting reports

    • Quiz: management

  • 6

    Advanced

    • Walk-through: calculated fields

    • Walk-through: combining data with Google Sheets

    • Exercise: combining data

    • Walk-through: adding a data control

    • Walk-through: creating a Facebook report

    • Quiz: advanced options

  • 7

    Conclusion

    • Discussion area

    • Final course quiz

    • Thank you