Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02)

Master Looker's powerful features to create engaging, insightful reports and dashboards that drive data-driven decision-making.

TTDVLK02

Introductory

2 Days

Course Overview

Overview

Discover the power of data analytics and visualization with our hands-on, two-day introductory course Looker Bootcamp:  Analyzing and Visualizing Data with Looker. Designed for professionals who want to unlock valuable insights from their data, this immersive training experience will guide you through Looker's cutting-edge features and provide you with the essential skills to create engaging, interactive, and insightful reports and dashboards. Our experienced trainers will take you on a journey from the fundamentals of Looker and its unique data modeling language, LookML, to advanced visualization techniques and content organization strategies, ensuring you leave the course equipped to make data-driven decisions with confidence.

Throughout the course, you will have the opportunity to participate in practical exercises and workshops that will help you apply the concepts and techniques learned in real-world scenarios. You will explore the potential of Looker's Explores, dive into LookML's capabilities, and master the art of dashboard design and sharing. Learn how to organize and manage your content with folders and boards and harness the power of advanced visualization techniques to make your data come alive.

NOTE: The Looker Basics (TTDVLK01) is an alternative, one-day course that covers the essential topics with slightly less depth.  Please inquire for details.

Learning Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll explore and gain:

·         Comprehensive understanding of Looker's platform: Gain a solid foundation in Looker's key features, functionality, and interface, enabling you to navigate and utilize the platform effectively for your data analysis and visualization needs.

·         Mastery of LookML and data modeling: Develop proficiency in Looker's unique data modeling language, LookML, to create customized and efficient data models that cater to your organization's specific requirements.

·         Expertise in creating insightful Explores: Learn to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights.

·         Proficiency in dashboard design and sharing: Acquire the skills to design visually appealing and informative dashboards, share them with different user roles, and schedule exports to keep stakeholders informed and up-to-date.

·         Enhanced content organization with folders and boards: Understand how to effectively use folders and boards to organize, manage, and discover content within Looker, making it easily accessible for you and your team.

Optional: Advanced visualization techniques for impactful storytelling: Master advanced visualization techniques, 

Course Objectives

Learning Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll explore and gain:

·         Comprehensive understanding of Looker's platform: Gain a solid foundation in Looker's key features, functionality, and interface, enabling you to navigate and utilize the platform effectively for your data analysis and visualization needs.

·         Mastery of LookML and data modeling: Develop proficiency in Looker's unique data modeling language, LookML, to create customized and efficient data models that cater to your organization's specific requirements.

·         Expertise in creating insightful Explores: Learn to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights.

·         Proficiency in dashboard design and sharing: Acquire the skills to design visually appealing and informative dashboards, share them with different user roles, and schedule exports to keep stakeholders informed and up-to-date.

·         Enhanced content organization with folders and boards: Understand how to effectively use folders and boards to organize, manage, and discover content within Looker, making it easily accessible for you and your team.

Optional: Advanced visualization techniques for impactful storytelling: Master advanced visualization techniques, 

Course Prerequisites

Audience

The audience for this course includes professionals who are new to Looker who are interested in leveraging Looker for data analysis, visualization, and reporting. The course is designed for individuals seeking to gain a comprehensive understanding of Looker's functionalities and apply these skills in their organizations to drive data-driven decision-making.

Ideal attendees for this course come from a wide range of roles, including but not limited to:

  • Data Analysts: Professionals responsible for analyzing data and creating reports to support decision-making processes within an organization.
  • Business Analysts: Individuals who work closely with business stakeholders to understand their requirements, analyze data, and provide insights for strategic decision-making.
  • Data Engineers: Technical professionals who manage and process data and want to expand their skill set to include data visualization and reporting using Looker.
  • Product Managers: Professionals who need to track and analyze product performance metrics and want to utilize Looker to create visually appealing and informative dashboards for better decision-making.
  • Marketing Analysts: Individuals responsible for analyzing marketing data and providing insights to drive marketing strategies and optimize campaigns.
  • Data Science Team Leads: Professionals who oversee data science teams and want to leverage Looker to efficiently communicate results and insights to stakeholders within the organization.
  • Project Managers: Individuals who need to monitor project progress and performance and want to use Looker for creating project-specific dashboards and visualizations.

Pre-Requisites

In order to be successful in this course you should have:

  • Basic computer literacy: Participants should be comfortable using computers and navigating software applications, as well as basic file management and organization.
  • Fundamental understanding of data concepts: Attendees should have a basic understanding of data concepts such as tables, columns, rows, data types, and primary/foreign keys.
  • Familiarity with databases and SQL (helpful, not required): Participants should have a basic understanding of relational databases and some experience with SQL, including SELECT statements, JOINs, and WHERE clauses.
  • Basic spreadsheet skills: Attendees should be comfortable working with spreadsheets (e.g., Microsoft Excel or Google Sheets) for data manipulation, filtering, and sorting.
  • Foundational knowledge of data visualization: Participants should be familiar with common chart types and their use cases (e.g., bar charts, line charts, pie charts, etc.), as well as basic principles of effective data visualization.
  • Basic statistical knowledge (optional): While not required, a basic understanding of descriptive statistics, such as mean, median, and standard deviation, as well as concepts like correlation and regression, can be helpful for grasping some of the more advanced analytical features in Looker.

Course Agenda

Day 1: Introduction to Looker and Data Analysis

  1. Getting Started with Looker
  • Overview of Looker and its key features
  • Navigating the Looker interface
  • Looker terminology and basic concepts
  • Lab: Navigating the Looker Interface - Familiarize yourself with the Looker interface by exploring its various components, menus, and tools.
  1. Connecting to Data Sources
  • Setting up and managing data connections
  • Exploring database schemas
  • Understanding LookML: Looker's data modeling language
  • Lab: Connecting and Exploring Data Sources - Practice setting up data connections, reviewing database schemas, and writing basic LookML code.
  1. Creating and Customizing Explores
  • Building and customizing Explores
  • Adding dimensions, measures, and filters
  • Creating calculated fields
  • Saving and organizing Explores
  • Lab: Create an Explore from scratch, adding dimensions, measures, filters, and calculated fields to generate insights.
  1. Data Visualization
  • Creating visualizations using Looker's visualization library
  • Customizing chart types, colors, and labels
  • Displaying visualizations in dashboards
  • Introduction to Looker's API for custom visualizations
  • Lab: Creating Data Visualizations - Develop a variety of visualizations using Looker's built-in library, customizing chart types, colors, and labels.

Day 2: Advanced Looker Techniques and Applications

  1. Advanced Explores and LookML
  • LookML refresher and best practices
  • Creating derived tables and data transformations
  • Managing access controls and data permissions
  • Lab: Write advanced LookML code to create derived tables, manage data permissions, and optimize your data model.
  1. Organizing and Sharing Content with Folders and Boards
  • Introduction to folders and boards in Looker
  • Creating and managing folders for organizing content
  • Setting up boards for easy content discovery
  • Sharing folders and boards with different user roles and permissions
  • Lab: Set up and manage folders and boards for content organization, sharing, and discoverability.
  1. Dashboard Design and Sharing
  • Best practices for dashboard design
  • Adding, arranging, and resizing visualizations
  • Scheduling and exporting dashboard data
  • Lab: Build an interactive dashboard, arrange visualizations, and practice sharing it with various user roles.
  1. Advanced Visualization Techniques
  • Customizing visualizations with HTML, CSS, and JavaScript
  • Creating interactive visualizations using Looker's API
  • Integrating Looker visualizations with other tools
  • Lab: Lab: Advanced Visualization Techniques - Customize visualizations using HTML, CSS, and JavaScript, and explore interactive visualization options with Looker's API.
  1. Hands-on Workshop and Project
  • Participants work on a guided project to apply the skills learned
  • Trainer provides individual support and guidance

Project Presentations, Q&A, and Training Wrap-up

Course Materials

Setup Made Simple with our robust Learning Experience Platform (LXP)

 

All course software (limited versions, for course use only), knowledge checks, digital courseware files or course notes, labs / data sets and solutions, live coaching support channels (as applicable) and rich extended learning / post training resources are provided for you in our “easy access / no install required” high-speed Learning Experience Platform (LXP) remote lab and content environment. Our tech team works with every student to ensure everyone is set up with working access and ready to go prior to every course start date, ensuring a smooth delivery and great hands-on experience.

 

Every-Course Extras = High-Value & Long-Term Learning Support! All Public Schedule courses include our unique EveryCourse Extras package (Course Recordings, Live Instructor Follow-on Support, Free *Live* Course Refresh Re-Takes, early access to Special Offers, Free Courses & more). Please inquire for details.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Attend a Course

Please see the current upcoming available open enrollment course dates posted below. Please feel free to Register Online below, or call 844-475-4559 toll free to connect with our Registrar for assistance. If you need additional date options, please contact us for scheduling.

Course Title Days Date Time Price
Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02) 2 Days May 20 to May 21 10:00 AM to 06:00 PM EST $1,695.00 Enroll
Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02) 2 Days Jul 15 to Jul 16 10:00 AM to 06:00 PM EST $1,695.00 Enroll
Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02) 2 Days Sep 9 to Sep 10 10:00 AM to 06:00 PM EST $1,695.00 Enroll
Looker Bootcamp: Analyzing and Visualizing Data with Looker (TTDVLK02) 2 Days Nov 4 to Nov 5 10:00 AM to 06:00 PM EST $1,695.00 Enroll

Mix, Match & Master!
2FOR1: Two Courses, One Price!

Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price!  Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More