Data Visualization in Looker Studio Training
Catalogue index: IFS/63
product- line 1
Features
Description
InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have supported organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that will accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to develop your employees' competencies in the IT field.
Looker Studio (formerly Google Data Studio) is a tool for data collection and visualization in the form of tables and charts. It allows for the integration of multiple data sources into one report, enhancing convenience during data analysis and saving time. Data is retrieved automatically, and reports do not require refreshing.
- For individuals involved in data processing and analysis who want to automate the reporting process and improve how they communicate information derived from data.
- For specialists working in the Google ecosystem (Marketing Platform, Cloud) who want to enhance their reporting skills.
- For analysts and data engineers.
- We will discuss the main applications and functioning of solutions based on Snowflake.
- You will learn how to create an analytical architecture based on Snowflake.
- You will learn how to create queries to the Snowflake database.
- You will learn how to optimize and analyze data.
Module 1 – Introduction to Data Visualization and Looker Studio
Key concepts of data visualization – what characterizes a good dashboard?
Reports vs dashboards – key differences in creating project assumptions
Interface and layout of the tool – what Looker Studio consists of
Charts that attract attention – good, bad, and ugly
Module 2 – Basic Functions and Working with the Looker Studio Interface
Tables and charts – overview of the main types of charts available in Looker Studio and examples of their use in reporting
Designing dashboard components – working with the Looker Studio interface (dimensions, metrics, filters, comparisons, styling, and appearance of the chart – practical exercises)
Inserting and managing control elements (filters, date ranges, data control)
Images, shapes, and other elements – placing additional components in the dashboard
Filtering data using filters, parameters, and segments in data sources
Exploring data using the data analysis area
Module 3 – Data Sources in Looker Studio
Importing data from Google Sheets and CSV files
Connecting to databases (MySQL, PostgreSQL) and Cloud SQL
Retrieving data from data warehouses using BigQuery and Amazon Redshift
Integrating with data in the Google ecosystem: Analytics, Ads
Using third-party connectors to retrieve data from other sources
Data blending – combining data from different sources into one dataset
Creating custom metrics and dimensions (calculated fields) in data sources
Module 4 – Report Settings in Looker Studio
Configuring the theme and customizing the dashboard layout
Managing page settings in complex dashboards
External tools useful during data visualization
Tracking user interactions with report content using Google Analytics
Module 5 – Sharing Reports with Other Users
Publishing settings and versioning files
Methods for sharing Looker Studio reports
Configuring periodic email report delivery
Embedding reports as objects in external tools
Exporting data to PDF and Google Sheets
16 h/2 days
- Certificate of completion
- Monthly access to the training recording (in case of online format)
- Customization of the training program to client needs