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
- Overview of cloud-native reporting architecture and navigating the interface
- Creating your first report: distinguishing between reports, dashboards, and pages
- Establishing defaults, managing themes, and aligning with organizational branding standards
- Lab 1: Setting up a Looker Studio environment, creating a blank report, and applying a custom theme
Working with Data Sources
- Understanding connector types and supported platforms (e.g., Google Sheets, CSV, BigQuery, GA4, MySQL)
- Configuring connections, setting refresh intervals, and managing query limits
- Data validation: inspecting schemas, mapping field types, and troubleshooting errors
- Lab 2: Connecting two data sources, verifying data ingestion, and configuring automated refresh schedules
Metrics and Dimensions
- Differentiating field types: metrics (aggregations) versus dimensions (categorical/text)
- Configuring breakdowns, date ranges, and rollups for contextual reporting
- Handling nulls, missing data, and standardizing timezone/date formats
- Lab 3: Constructing base tables and charts using raw dimensions/metrics with dynamic date controls
Filters and Sorting
- Distinguishing report-level, page-level, and chart-level filters
- Implementing date range controls, dropdowns, checkboxes, and search filters
- Sorting logic: alphabetical, numeric, reverse order, 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
- Utilizing formula functions:
CASE,REGEXP,DATE_DIFF,IF,SUM,AVG, and string manipulation - Performance considerations: comparing computed fields versus source-level calculations
- Lab 5: Writing custom KPIs, implementing conditional formatting logic, and deriving metrics using native functions
Building Visualizations and Dashboard Design
- Selecting appropriate chart types for business queries (tables, bar/line, scorecards, geo maps, scatter, pivot)
- Enhancing interactivity: click-through URLs, drill-downs, and custom tooltips
- Layout & responsive design: grid systems, padding, alignment, and mobile/tablet optimization
- Accessibility & readability: contrast, labeling, and principles of clear data storytelling
- 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 joins in Looker Studio
- Defining common dimensions and addressing 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 resolving common blending errors
Sharing and Publishing
- Access controls: managing viewers, commenters, editors, and organization-restricted permissions
- Auto-refresh, email subscriptions, and scheduled report distribution
- Embedding reports in websites/portals and utilizing export options (PDF, CSV, PPTX)
- Dashboard governance: versioning, naming conventions, and maintaining 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: Participants submit a fully functional, interactive Looker Studio dashboard accompanied by supporting documentation
Requirements
- Active Gmail account
- Fundamental knowledge of spreadsheets, data structures, or reporting workflows (optional)
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.
