Course Description

Course Overview

The Analyzing and Visualizing Data with Looker (AVDL) course is designed to equip individuals with the knowledge and skills needed to effectively analyze and visualize data using Looker, a powerful business intelligence and data exploration platform. This course covers the core concepts of Looker, including data modeling, creating visualizations, and generating insights from data.

Prerequisites

To enroll in the AVDL course, participants should have a basic understanding of data analysis concepts and familiarity with SQL. Prior experience with business intelligence tools or data visualization platforms would be beneficial but is not mandatory. Participants should also have access to a Looker instance or demo environment to practice the concepts covered in the course.

Methodology

The AVDL course follows a blended learning approach, combining theoretical instruction, demonstrations, and hands-on labs. Participants will engage in instructor-led sessions where Looker concepts and best practices are explained. They will also have access to a Looker instance or demo environment to gain hands-on experience in working with Looker’s features. The course encourages active participation, discussions, and collaborative problem-solving to reinforce learning.

Course Outline

Introduction to Looker

Overview of Looker and its features

Understanding Looker’s data modeling and exploration capabilities

Introduction to Looker’s interface and navigation

Data Modeling in Looker

LookML: Looker’s modeling language

Creating LookML projects and files

Defining models, explores, and views in LookML

Creating and Customizing Visualizations

Looker’s visualization options and chart types

Building and customizing dashboards

Applying filters and parameters to visualizations

Data Exploration and Analysis

Using Looker to explore data and answer business questions

Performing ad hoc queries and analyses

Applying advanced analytics functions in Looker

Collaborative Data Sharing and Reporting

Sharing and collaborating on Looker content

Creating scheduled reports and data alerts

Embedding Looker visualizations in other applications

Looker Administration and Best Practices

Managing users, roles, and permissions in Looker

Configuring Looker settings and options

Implementing Looker best practices for data modeling and performance

Outcome

By the end of the AVDL course, participants will have:

• Developed a comprehensive understanding of Looker and its capabilities
• Acquired practical knowledge in data modeling and exploration using Looker’s LookML language
• Gained expertise in creating and customizing visualizations in Looker
• Learned best practices for data analysis, collaboration, and reporting in Looker
• Gained hands-on experience through practical labs and exercises
• Prepared to utilize Looker effectively for data analysis and visualization tasks in their organizations

Labs

The AVDL course includes hands-on labs that provide participants with practical experience in working with Looker and performing data analysis and visualization tasks. Some examples of lab exercises include:

• Setting up a Looker project and connecting to a data source
• Creating LookML models, explores, and views
• Designing and customizing dashboards and visualizations
• Performing ad hoc queries and analyses in Looker
• Sharing and collaborating on Looker content
• Creating scheduled reports and data alerts in Looker
• Embedding Looker visualizations in external applications

These labs enable participants to apply the concepts learned in the course and gain hands-on experience in utilizing Looker for data analysis and visualization tasks, allowing them to develop practical skills in leveraging Looker’s features to derive insights from data.