Live Online Looker Course for Data Engineering

Live Course Module: Looker Course for Data Engineering

Total Duration: 40 Hours (5 Weeks)

Week 1: Introduction to Looker and Data Analytics Fundamentals

Total Time: 8 hours

1. Introduction to Modern Data Analytics (1 hr)

   • Overview of BI and Data Engineering roles

   • Why Looker for modern data stack?

2. Understanding Looker Architecture (1.5 hrs)

   • Looker components: LookML, Explore, Dashboards

   • Integration with data warehouses (BigQuery, Snowflake, Redshift)

3. Setting up Looker Environment (2 hrs – Lab)

   • Looker instance setup

   • Connecting Looker to a SQL data warehouse

4. Navigating the Looker Interface (1.5 hrs)

   • Using Explore, Looks, and Dashboards

   • Understanding data fields, dimensions, and measures

5. Hands-On & Assignment (2 hrs)

   • Build your first “Look” visualization

   • Assignment: Connect Looker to a sample dataset and create a basic dashboard

Week 2: LookML Basics and Data Modeling Concepts

Total Time: 8 hours

1. Introduction to LookML (1.5 hrs)

   • What is LookML?

   • Models, views, explores, and fields

2. Building a Data Model (2 hrs – Lab)

   • Defining dimensions and measures

   • Creating joins and relationships between tables

3. Exploring Derived Tables and Persistent Derived Tables (PDTs) (1.5 hrs)

   • Understanding PDTs and caching mechanisms

   • Writing derived tables using SQL

4. Refining LookML Models (1 hr)

   • Field parameters, filters, and value formats

   • Project organization and naming conventions

5. Hands-On & Assignment (2 hrs)

   • Build a LookML model for sales analytics

   • Assignment: Create an Explore from a LookML model and share insights

Week 3: Advanced LookML, Relationships, and Reusability

Total Time: 8 hours

1. LookML Best Practices (1.5 hrs)

   • Model inheritance and extends

   • Centralized dimensions and reusable fields

2. Advanced Joins and Relationships (1.5 hrs)

   • One-to-many and many-to-many joins

   • Join logic and performance optimization

3. Parameters and Liquid Variables (1.5 hrs)

   • Custom user input via parameters

   • Dynamic dashboards using Liquid templating

4. Version Control and Collaboration (1.5 hrs)

   • Looker Git integration

   • Managing LookML projects with version control

5. Hands-On & Assignment (2 hrs)

   • Implement LookML inheritance and reusable views

   • Assignment: Create a scalable data model for multi-department analytics

Week 4: Dashboards, Visualization, and Embedded Analytics

Total Time: 8 hours

1. Designing Interactive Dashboards (2 hrs)

   • Dashboard filters, layout, and interactivity

   • Visualization best practices

2. Custom Visualizations (1.5 hrs)

   • Using Looker’s visualization library

   • Embedding Looker dashboards in web applications

3. Looker API and Embedding (1.5 hrs)

   • Introduction to Looker API

   • Automating reports and embedding visualizations

4. Performance Optimization and Security (1 hr)

   • Query optimization

   • User roles, access control, and row-level security

5. Hands-On & Assignment (2 hrs)

   • Build an interactive executive dashboard

   • Assignment: Create an embedded analytics report using Looker API

Week 5: Advanced Integrations, Governance, and Capstone Project

Total Time: 8 hours

1. Data Governance and Access Control (1.5 hrs)

   • Data permissions, user attributes, and access filters

   • Managing content governance in Looker

2. Integrating Looker with Data Pipelines (1.5 hrs)

   • Using Looker with dbt, Airflow, and cloud data warehouses

   • Looker integration with Data Engineering workflows

3. Looker Deployment and Monitoring (2 hrs)

   • CI/CD for LookML projects

   • Scheduling reports and monitoring performance

4. Capstone Project (3 hrs)

   • Build a complete Looker solution:

     • Connect → Model → Visualize → Automate

   • Example: E-commerce or Marketing Data Analytics Dashboard

🧩 Final Deliverables

• Mini Projects: 3 (LookML Modeling, Dashboard Design, Embedded Analytics)

• Capstone Project: 1 End-to-End Analytics System in Looker

• Assessments: Weekly quizzes + project evaluation

• Tools Covered: Looker, LookML, Git, SQL (BigQuery/Redshift/Snowflake), API Integrations