Looker and LookML for Non-Developers Online Course

Looker and LookML for Non-Developers Online Course

This course provides a complete journey through Google Looker, starting with an introduction to its features and benefits. You’ll begin by setting up your environment with sample data and sandbox exercises, then progress to beginner skills like navigating menus, creating Explores, and visualizing data. Intermediate modules cover filters, custom fields, and data sharing, while advanced sections teach complex visualizations, dashboards, and data manipulation. By the end, you’ll be proficient in Looker, able to analyze and visualize data effectively to make informed decisions.

Who should take this course?

This course is ideal for business analysts, data enthusiasts, and professionals who want to create and analyze dashboards in Looker without a coding background. It’s also perfect for managers, decision-makers, and team members seeking to gain insights from data using LookML and Looker’s intuitive tools.

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

Course Outline

Introduction

• What is Looker
• Features of Looker
• Looker vs. Competitors
• Reasons to Learn Looker
• Course Overview
• How to Succeed
• Instructor Overview

Environment

• Sample Data Walkthrough
• Sandbox Environment Setup 1
• Sandbox Environment Setup 2
• Loading Sample Data into Your Looker Instance 1
• Loading Sample Data into Your Looker Instance 2
• Looker Terminology 1
• Looker Terminology 2
• Looker Terminology 3
• Looker Terminology 4

Beginner - Explores

• Menu Navigation
• Create an Explore
• Dimensions and Fields
• Removing Fields
• Sorting and Adding Totals
• Quick Start Analysis
• Pivot a Field

Beginner - Visualizations

• Introduction to Visualization
• Table Visualization
• Freezing a Table
• Bar and Column Visualization
• Scatter Visualization
• Sizing Dots in Scatter Visualization
• Line and Area Visualizations
• Pie Chart Visualizations

Beginner - Looks

• Create a Look
• Creating Another Look and Organize It
• Organize Looks
• Edit Looks and Look Settings
• Looks Drill Downs and Explorations

Intermediate - Filters

• Introduction to Filters
• Add Values in Filter Box
• Filters in Dimensions and Measures
• Operator Statements
• Advanced Matches and Filter Expressions
• Custom Filters 1
• Custom Filters 2

Intermediate - Custom Fields

• Table Calculations
• Percent of Total
• Using Quick Calculations in Visualizations
• Create a Custom Measure from a Dimension
• Create Custom Fields Using Group, Bin, and List
• Create a Custom Measure
• Create a Custom Dimension

Intermediate - Sharing and Organization

• Download Data
• Share and Send Data
• Public Sharing of Looks and Iframes
• Schedule Data
• Conditional Schedule and Alerts
• Folders
• Manage Permissions
• Save, Copy, and Move Looks
• Boards
• Create a Board
• Details about Boards
• Favourites and Recently Viewed

Expert - Advanced Visualizations

• Map Visualization
• Single Value Visualization
• Single Value Questions
• Word Cloud Visualization
• Box Plots Visualization

Expert - Dashboards

• Introduction to Dashboards
• Look-Linked Tiles
• Text Tiles and Markdown
• Edit, Move, and Modify Tiles
• Note Icon Question
• Dashboard Settings
• Filters in Dashboards
• Filters Conditionally Applied
• Filter Controls
• Advanced Filters
• Linking and Cascading Filters
• Cross Filtering 1
• Cross Filtering 2
• Cross Filtering 3
• End-to-End Dashboard 1
• End-to-End Dashboard 2
• End-to-End Dashboard 3

Expert - Advanced Data Manipulation

• Offset Expressions
• Rolling and Moving Averages
• Rolling and Moving Averages with List
• Aggregation Expressions
• Merge Results 1
• Merge Results 2

Conclusion

• Congratulations
• Next Steps