EIEIOTECHNOVATION
← Training programmes

EIEIO / AUTOMATION & EMERGING TECHNOLOGY

GOOGLE SHEETS & LOOKER STUDIO TRAINING (3 days)

Course outline

3 days
Discuss this programme →

Duration

GOOGLE SHEETS & LOOKER STUDIO TRAINING

3 days

Overview

In today's data-driven world, effective data management and visualization are essential skills for professionals across various industries. This module is designed to provide you with a comprehensive understanding of Google Sheets data management techniques and introduce you to Looker Studio, a powerful data visualization tool.

Throughout this module, we will explore the fundamental concepts and techniques of Google Sheets data management, starting from the basics and gradually progressing to more advanced topics. You will learn how to efficiently organize, analyze, and manipulate data using Excel's powerful features, such as formulas, functions, and pivot tables. We will also cover data validation, conditional formatting, and data cleaning techniques to ensure the accuracy and integrity of your data.

Once you have mastered Google Sheets data management, we will delve into Looker Studio, a cutting-edge data visualization platform. Looker Studio allows you to transform raw data into visually compelling and interactive dashboards, providing valuable insights to support decision-making processes. You will learn how to connect Looker Studio to various data sources, build customized dashboards, and create visually appealing charts and graphs.

By the end of this module, you will have gained the skills necessary to effectively manage and analyze data using Google Sheets, as well as the ability to visualize data using Looker Studio. These skills will not only enhance your productivity but also enable you to make informed decisions based on data-driven insight.

Day 1: Introduction to Google Sheets

Morning Session: Getting Started with Google Sheets

  • Introduction to Google Sheets and its interface
  • Creating, sharing, and managing spreadsheets
  • Basic operations: entering data, formatting cells, sorting, and filtering
  • Introduction to formulas and functions: SUM, AVERAGE, MIN, MAX

Afternoon Session: Intermediate Google Sheets

  • Advanced formulas and functions: VLOOKUP, HLOOKUP, INDEX, MATCH
  • Data validation and conditional formatting for data integrity and visualization
  • Introduction to Pivot Tables for summarizing data
  • Practice exercises: Creating a monthly budget, analyzing sales data

Day 2: Advanced Google Sheets Techniques & Introduction to Looker Studio

Morning Session: Mastering Google Sheets

  • Automating tasks with Google Sheets Macros
  • Introduction to Google Apps Script for custom functions and automation
  • Collaborating in Google Sheets: Comments, Suggestions, Version History
  • Practice exercises: Automating a reporting task, setting up a project management tracker

Afternoon Session: Introduction to Looker Studio

  • Overview of Looker Studio and its place in data visualization and business intelligence
  • Connecting data sources to Looker Studio (including Google Sheets)
  • Creating your first report: understanding the interface and basic components (charts, tables, and controls)
  • Basic visualizations: Time series, Bar charts, Pie charts, Tables

Day 3: Looker Studio Deep Dive

Morning Session: Advanced Looker Studio Techniques

  • Advanced data sources: Combining multiple sources, SQL connections
  • Advanced visualizations: Geo maps, Scatter plots, Bullet charts
  • Filtering, sorting, and aggregating data in reports
  • Introduction to calculated fields and parameters for dynamic reporting

Afternoon Session: Publishing and Sharing Reports

  • Best practices for designing effective and interactive reports
  • Sharing and collaborating on reports
  • Embedding reports in websites
  • Final project: Create a comprehensive dashboard integrating Google Sheets data into Looker Studio, focusing on a real-world business scenario
  • Q&A, course feedback, and next steps for further learning

Learning Outcome

  • Understand the basics of Google Sheets data management, including data types, importing/exporting, sorting/filtering, and using formulas/functions.
  • Gain proficiency in organizing and analyzing data using pivot tables, conditional formatting, and advanced functions.
  • Learn data validation and cleaning techniques to ensure data integrity and accuracy.
  • Explore Looker Studio as a powerful data visualization tool, including connecting to data sources, creating dashboards, and utilizing visualization options.
  • Apply advanced techniques in Looker Studio, such as interactive filters, advanced calculations, and visually appealing chart design.
  • Develop the skills necessary to effectively manage, analyze, and visualize data, enabling informed decision-making based on datadriven insights.
  • Visualize Data Effectively: Learn how to leverage Looker Studio to transform raw data into visually compelling and interactive dashboards, enabling participants to communicate insights and findings more effectively.
  • Expand Data-Driven Proficiency: Gain a comprehensive understanding of Google Sheets data management and Looker Studio, enabling participants to apply these skills across various industries and professional roles, enhancing their overall data-driven proficiency.

Learning Method

  • Interactive Lectures
  • Hands-on Labs
  • Group Discussions
  • Q&A Sessions
  • Practical Projects
  • Code Reviews
  • Online Learning Platforms
  • Collaborative Learning

Programme scope, delivery arrangements and suitability are confirmed during enquiry.