Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Getting Started with Looker Studio
- Cloud-native reporting architecture and interface navigation
- Creating your first report: report vs. dashboard vs. page concepts
- Setting defaults, theme management, and organizational branding standards
- Lab 1: Provisioning a Looker Studio environment, creating a blank report, and applying a custom theme
Working with Data Sources
- Connector types and supported platforms (Google Sheets, CSV, BigQuery, GA4, MySQL, etc.)
- Connection configuration, refresh intervals, and query limits
- Data validation: schema inspection, field type mapping, and error troubleshooting
- Lab 2: Connecting two data sources, verifying data ingestion, and configuring automated refresh schedules
Metrics and Dimensions
- Understanding field types: metrics (aggregations) vs. dimensions (categorical/text)
- Configuring breakdowns, date ranges, and rollups for contextual reporting
- Managing nulls, missing data, and timezone/date formatting standards
- Lab 3: Building base tables and charts using raw dimensions/metrics with dynamic date controls
Filters and Sorting
- Report-level vs. page-level vs. chart-level filters
- Implementing date range controls, dropdowns, checkboxes, and search filters
- Sorting logic: alphabetical, numeric, reverse, and multi-field sorting
- Lab 4: Adding interactive filters to a dashboard, testing filter dependencies, and optimizing query performance
Data Calculations
- Creating custom metrics and dimensions within Looker Studio
- Formula functions:
CASE,REGEXP,DATE_DIFF,IF,SUM,AVG, and string manipulation - Performance considerations: computed fields vs. source-level calculations
- Lab 5: Writing custom KPIs, conditional formatting logic, and derived metrics using native functions
Building Visualizations and Dashboard Design
- Selecting appropriate chart types for business questions (tables, bar/line, scorecards, geo maps, scatter, pivot)
- Interactive elements: click-through URLs, drill-downs, and tooltip customization
- Layout & responsive design: grid systems, padding, alignment, and mobile/tablet optimization
- Accessibility & readability: contrast, labeling, and clear data storytelling principles
- Lab 6: Assembling a multi-page dashboard with responsive layout, interactive elements, and professional styling
Data Blending
- Understanding join types: inner, left/right outer, and full outer in Looker Studio
- Defining common dimensions and handling mismatched data keys
- Blending strategies: pre-aggregation, normalization, and performance tuning
- Lab 7: Blending two datasets (e.g., sales + marketing spend), validating join results, and fixing common blending errors
Sharing and Publishing
- Access controls: viewers, commenters, editors, and organization-restricted permissions
- Auto-refresh, email subscriptions, and scheduled report distribution
- Embedding reports in websites/portsals and export options (PDF, CSV, PPTX)
- Dashboard governance: versioning, naming conventions, and audit trails
- Lab 8: Publishing a production-ready dashboard, configuring sharing permissions, setting up auto-refresh, and exporting artifacts
Capstone & Real-World Implementation
- End-to-end workflow: data connection → calculations → filters → visualization → publishing
- Peer review of dashboard builds with facilitator feedback on design, performance, and clarity
- Open Q&A, troubleshooting common connector/calculation errors, and resource distribution
- Deliverable: Participant submits a fully functional, interactive Looker Studio dashboard with supporting documentation
Requirements
- Gmail account
- Basic familiarity with spreadsheets, data structures, or reporting workflows (not required)
7 Hours
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
It was a really good training course, well prepared and explained by the trainer with great hands on experience on GCP.
