Data Visualization in Looker Studio Training
Level
IntermediateDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedData Visualization in Looker Studio Training
Looker Studio (formerly Google Data Studio) is a tool for collecting data and visualizing it in the form of tables and charts. It allows you to combine multiple data sources into one report, making data analysis more convenient and saving time. Data is fetched automatically, and reports don’t require manual refreshing.
What You Will Learn
- Understand key concepts of data visualization and what makes a good dashboard
- Learn the Looker Studio interface, features, and best practices for designing clear dashboards
- Work with various data sources, including Google Sheets, CSV files, SQL databases, BigQuery, Redshift, and Google Analytics
- Combine multiple data sources into a single dataset (data blending)
- Create and customize dashboards with interactive elements, filters, and parameters
- Share and publish reports, automate delivery, and embed reports into external tools
Who is this training for?
People working with data processing and analysis who want to automate reporting and improve communication of insights-
Specialists working in the Google ecosystem (Marketing Platform, Cloud) who want to improve their reporting skills
-
Data analysts and data engineers
Training Program
-
Module 1 – Introduction to Data Visualization and Looker Studio
- Key concepts of data visualization – what makes a good dashboard?
- Reports vs dashboards – main differences in design principles
- Looker Studio interface and layout overview
- Charts that catch attention – good, bad, and ugly examples
-
Module 2 – Basic Functions and Working with the Interface
- Tables and charts – overview of key chart types and their use cases
- Designing dashboard components:
- Dimensions and metrics
- Filters
- Styling (practical exercises)
- Adding and managing controls (filters, date ranges, data selectors)
- Adding images, shapes, and other dashboard components
- Filtering data using filters, parameters, and data source segments
- Exploring data in the analysis area
-
Module 3 – Data Sources in Looker Studio
- Importing data from Google Sheets and CSV files
- Connecting to databases:
- MySQL
- PostgreSQL
- Cloud SQL
- Accessing data warehouses:
- BigQuery
- Amazon Redshift
- Integrating with Google Analytics and Google Ads
- Using third-party connectors for additional data sources
- Data blending – combining data from multiple sources
- Creating calculated fields in data sources
-
Module 4 – Report Settings in Looker Studio
- Configuring themes and customizing dashboard layout
- Managing page settings in complex dashboards
- External tools useful for visualization work
- Tracking user interactions with Google Analytics
-
Module 5 – Sharing Reports with Other Users
- Publishing settings and versioning
- Methods for sharing Looker Studio reports
- Scheduling automatic email delivery of reports
- Embedding reports into external tools
- Exporting reports to PDF and Google Sheets
