Mastering Looker and LookML - Complete Looker Guide for Users

Mastering Looker and LookML - Complete Looker Guide for Users

by HHN Automate Book Inc.
Released August 2024
Publisher(s): Packt Publishing
ISBN: 9781836649595

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Embark on a comprehensive journey through Google Looker with this expertly designed course. Starting with an introduction to Looker, you will learn about its features, advantages over competitors, and the reasons why mastering Looker is beneficial. The course begins with setting up the environment, including sample data walkthroughs and sandbox setups, ensuring you have a solid foundation.

As you progress, you will delve into beginner-level skills such as navigating menus, creating Explores, and visualizing data through various types of charts. Intermediate sections will enhance your capabilities with filters, custom fields, and data sharing techniques. Each module builds on the previous, gradually advancing your knowledge and expertise.

The expert sections are designed to push your skills to new heights, covering advanced visualizations, dashboards, and data manipulation. You will learn to create complex visual representations, utilize advanced filters, and manage dashboards effectively. By the end of the course, you will be proficient in using Looker to analyze and visualize data, making informed decisions based on your insights.

What you will learn

  • Navigate and utilize Google Looker efficiently.
  • Create and customize data visualizations
  • Apply filters and custom fields to refine data analysis
  • Share, organize, and manage data reports and dashboards
  • Perform advanced data manipulations and create complex visualizations
  • Integrate Looker with other data sources for comprehensive analytics

Audience

This course is ideal for data analysts, business intelligence professionals, and anyone looking to improve their data analytics skills. A basic understanding of data concepts and familiarity with BI tools is recommended but not required.

About the Author

HHN Automate Book Inc.: Henry Habib, a top instructor with 200K students, is a manager at a leading management consulting firm, advising Fortune 500 companies on growth strategy, operations, and analytics. With extensive experience in data-driven solutions for both large and small organizations, Henry is a champion of Generative AI and No-Code application development. He integrates these technologies to deliver efficient, comprehensible business applications. As a professor, Henry is dedicated to student success, creating engaging courses and offering continuous support on topics like case interviews, no-code development, and automation.

Table of contents

  1. Chapter 1 : Introduction
    1. What is Looker
    2. Features of Looker
    3. Looker vs. Competitors
    4. Reasons to Learn Looker
    5. Course Overview
    6. How to Succeed
    7. Instructor Overview
  2. Chapter 2 : Environment
    1. Sample Data Walkthrough
    2. Sandbox Environment Setup 1
    3. Sandbox Environment Setup 2
    4. Loading Sample Data into Your Looker Instance 1
    5. Loading Sample Data into Your Looker Instance 2
    6. Looker Terminology 1
    7. Looker Terminology 2
    8. Looker Terminology 3
    9. Looker Terminology 4
  3. Chapter 3 : Beginner - Explores
    1. Menu Navigation
    2. Create an Explore
    3. Dimensions and Fields
    4. Removing Fields
    5. Sorting and Adding Totals
    6. Quick Start Analysis
    7. Pivot a Field
  4. Chapter 4 : Beginner - Visualizations
    1. Introduction to Visualization
    2. Table Visualization
    3. Freezing a Table
    4. Bar and Column Visualization
    5. Scatter Visualization
    6. Sizing Dots in Scatter Visualization
    7. Line and Area Visualizations
    8. Pie Chart Visualizations
  5. Chapter 5 : Beginner - Looks
    1. Create a Look
    2. Creating Another Look and Organize It
    3. Organize Looks
    4. Edit Looks and Look Settings
    5. Looks Drill Downs and Explorations
  6. Chapter 6 : Intermediate - Filters
    1. Introduction to Filters
    2. Add Values in Filter Box
    3. Filters in Dimensions and Measures
    4. Operator Statements
    5. Advanced Matches and Filter Expressions
    6. Custom Filters 1
    7. Custom Filters 2
  7. Chapter 7 : Intermediate - Custom Fields
    1. Table Calculations
    2. Percent of Total
    3. Using Quick Calculations in Visualizations
    4. Create a Custom Measure from a Dimension
    5. Create Custom Fields Using Group, Bin, and List
    6. Create a Custom Measure
    7. Create a Custom Dimension
  8. Chapter 8 : Intermediate - Sharing and Organization
    1. Download Data
    2. Share and Send Data
    3. Public Sharing of Looks and Iframes
    4. Schedule Data
    5. Conditional Schedule and Alerts
    6. Folders
    7. Manage Permissions
    8. Save, Copy, and Move Looks
    9. Boards
    10. Create a Board
    11. Details about Boards
    12. Favourites and Recently Viewed
  9. Chapter 9 : Expert - Advanced Visualizations
    1. Map Visualization
    2. Single Value Visualization
    3. Single Value Questions
    4. Word Cloud Visualization
    5. Box Plots Visualization
  10. Chapter 10 : Expert - Dashboards
    1. Introduction to Dashboards
    2. Look-Linked Tiles
    3. Text Tiles and Markdown
    4. Edit, Move, and Modify Tiles
    5. Note Icon Question
    6. Dashboard Settings
    7. Filters in Dashboards
    8. Filters Conditionally Applied
    9. Filter Controls
    10. Advanced Filters
    11. Linking and Cascading Filters
    12. Cross Filtering 1
    13. Cross Filtering 2
    14. Cross Filtering 3
    15. End-to-End Dashboard 1
    16. End-to-End Dashboard 2
    17. End-to-End Dashboard 3
  11. Chapter 11 : Expert - Advanced Data Manipulation
    1. Offset Expressions
    2. Rolling and Moving Averages
    3. Rolling and Moving Averages with List
    4. Aggregation Expressions
    5. Merge Results 1
    6. Merge Results 2
  12. Chapter 12 : Conclusion
    1. Congratulations
    2. Next Steps

Product information

  • Title: Mastering Looker and LookML - Complete Looker Guide for Users
  • Author(s): HHN Automate Book Inc.
  • Release date: August 2024
  • Publisher(s): Packt Publishing
  • ISBN: 9781836649595