Module 1. Getting Started with Looker
- Navigate to Explores and Saved Content
- Create Looks
- Work with Dimensions and Measures
- Exploring Data in Looker
- Build and Save Reports
Module 2. Introduction to Data Modeling
- Dimensions and fact tables
- Dimensional model
- Star and SnowFlake schema
- Understanding the data source
Module 3. Getting started with LookML
- Understanding Looker Project Structure
- How to create a view
- How to create a model
- Building Explores
- How looker generates SQL
- SQL runner basics
- Editing and Validating LookML
- Data security in looker
- Model Parameters
- Explore Parameters
- View Parameters
- Join Parameters
- Field Parameters
- Reusing existing dimensions
- Measures
- Sets
Module 4. Building Visualizations:
- Building Visualizations
- Creating user-defined dashboard
- Creating LookML Dashboard
- Create Different Visualizations
- Table
- Bar Chart
- Scatter plot
- Line Chart
- Area
- Pie Chart
- Single Value(KPI)
- Box Plot
- Funnel Chart
- Donut Multiples
Module 5. Advanced LookML Concepts
- Derived tables
- Reusing code with extends
- Table calculations
- Liquid variables and Parameters
- Filtering Explore data
- Always filter on Explore
- Always where on explore
- Conditional filter
- Content Validation
- Changing Filter suggestions
- Template filters