Data Engineering
Analysing and Visualising Data in Looker
Step into the world of data exploration and analysis with Looker, designed to empower SQL developers and analysts. This comprehensive one-day course provides the perfect starting point to master data insights without writing complex queries
1 Days

Target Audience
This course is ideal for business users seeking to derive actionable insights from data and data analysts tasked with performing analysis and creating visualizations to support organizational decision-making
What you'll learn
By the end of this course, you will be able to:
• Articulate what Looker is and its capabilities for data analysis and visualization.
• Master the four core analytical concepts in Looker: dimensions, measures, filters, and pivots.
• Analyze and visualize data using dimensions, measures, filters, and pivots effectively.
• Build advanced metrics instantly with table calculations for deeper insights.
• Design and share interactive dashboards to consolidate visualizations.
• Organize content efficiently using folders and boards to enhance navigability and accessibility.


COURSE AGENDA
Introduction to Looker Overview:
- Learn the Looker interface and its core components.
- Define Looker’s capabilities for data analysis and visualization.
- Master navigation within Looker to access data and tools.
Core Analytics Concepts Key Concepts:
- Understand Looker’s four analytical pillars: dimensions, measures, filters, and pivots.
- Use dimensions to explore data attributes.
- Aggregate data attributes using measures.
- Combine dimensions and measures for in-depth analysis and visualization.
- Apply filters to focus on specific subsets of data.
- Leverage pivots to restructure and group data dynamically.
Table Calculations Advanced Metrics:
- Explore table calculations and offset functions for data manipulation.
- Learn the types of table calculations and offset functions available in Looker.
- Instantly create new metrics and insights using these advanced tools.
Looks & Dashboards Building and Sharing Insights:
- Create and deliver standalone visualization reports, called Looks, to share insights.
- Build and share dashboards to consolidate multiple visualizations for business analysis.
- Add new content and filters to dashboards for flexible, targeted analysis.
- Explore options for delivering data outside of Looker for broader stakeholder access.
Content Management Organizing Data:
- Use folders to organize content for easy navigation and discovery.
- Create and share boards to centralize content around specific topics or themes.
Modern Application Development
Deploy with Cloud Run:
Launch serverless apps that scale automatically.
Build with Cloud Functions:
Create event-driven serverless applications.
Containerize & Scale:
Deploy containerized apps using GKE and Cloud Run.
Comprehensive Review
Consolidate Learning:
Review key Google Cloud concepts for a solid foundation.
Connect Concepts:
Understand how modules apply to real-world scenarios.
Prepare for Implementation:
Apply course knowledge to practical Google Cloud solutions.
Cloud Functions Core
- Deploy serverless solutions
- Implement function triggers
- Secure function access
Advanced Functions
- Integrate with databases
- Manage secrets and variables
- Implement best practices
Workflow Automation
- Design serverless workflows
- Implement logic controls
- Master service authentication
- Build automated processes