Target Audience: 

Business analysts, data analysts, report creators, and anyone who needs to extract insights from data using Google Looker.

Course Objectives:

• Understand the core concepts of Google Looker.

• Learn to navigate the Looker interface and create Explores.

• Develop skills in building dashboards and visualizations.

• Master LookML basics for data modeling.

• Explore advanced Looker features for data analysis and collaboration.

Training Materials:

• Presentation slides with key concepts and examples

• Step-by-step guides for hands-on exercises

• Sample datasets for practice

• Looker documentation and resources

Delivery Method:

• Instructor-led training with interactive demonstrations

• Hands-on exercises and practical applications

• Q&A sessions and discussions

Note:

• This outline can be adjusted based on the specific needs and skill levels of the participants.

• It is assumed that the students have general data analysis knowledge.

• Access to a Google Looker instance is required for the hands-on exercises.

Hour 1: Introduction to Google Looker & Data Modeling Principles

• Introduction to Business Intelligence and Data Visualization

• Overview of Google Looker and its architecture

• Key components: Explores, Looks, Dashboards, LookML

• Understanding data modeling principles and best practices

• Hands-on: Navigating the Looker interface

Hour 2: Exploring Data with Looker Explores

• Creating and customizing Explores

• Selecting dimensions and measures

• Applying filters and sorting

• Using pivot tables and table calculations

• Hands-on: Building Explores to answer business questions

Hour 3: Creating Powerful Visualizations

• Introduction to Looker's visualization types

• Choosing the right visualization for your data

• Customizing visualizations for clarity and impact

• Saving Looks and sharing insights

• Hands-on: Building various visualizations from Explores

Hour 4: Building Interactive Dashboards

• Creating and managing dashboards

• Adding Looks and filters to dashboards

• Using dashboard filters and cross-filtering

• Designing dashboards for specific audiences

• Hands on: creating a dashboard with multiple looks, and filters.

Hour 5: Introduction to LookML (Part 1)

• Understanding LookML structure and syntax

• Exploring projects, models, and views

• Defining dimensions and measures in LookML

• Understanding relationships between views

• Hands on: Simple LookML view creation.

Hour 6: Introduction to LookML (Part 2) & Advanced Features

• LookML derived tables and templated filters.

• Using LookML parameters and liquid variables.

• Exploring Looker's scheduling and alerting features

• Collaborating with teams using Looker's features.

• Hands on: Creating a derived table.

Hour 7: Practical Application & Q&A

• Real-world use cases and examples

• Troubleshooting common Looker challenges

• Best practices for data governance and security

• Q&A session and course wrap-up

• Practical exercise: Build a dashboard based on a provided business scenario.