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
Introduction to Looker Studio
- Overview of cloud-native reporting architecture and interface navigation
- Fundamentals of report creation: distinguishing between reports, dashboards, and pages
- Configuration of defaults, theme management, and alignment with organizational branding standards
- Lab 1: Establishment of a Looker Studio environment for government use, creation of a blank report, and application of a custom theme
Data Source Integration
- Overview of connector types and supported platforms (Google Sheets, CSV, BigQuery, GA4, MySQL, etc.)
- Configuration of connection parameters, refresh intervals, and query constraints
- Data validation procedures: schema inspection, field type mapping, and error troubleshooting
- Lab 2: Integration of two data sources, verification of data ingestion, and configuration of automated refresh schedules
Metrics and Dimensions
- Definition of field types: metrics (aggregations) versus dimensions (categorical/text)
- Configuration of breakdowns, date ranges, and rollups to support contextual reporting
- Management of null values, missing data, and adherence to timezone and date formatting standards
- Lab 3: Construction of base tables and charts using raw dimensions and metrics with dynamic date controls
Filters and Sorting
- Distinction between report-level, page-level, and chart-level filters
- Implementation of date range controls, dropdowns, checkboxes, and search filters
- Sorting logic applications: alphabetical, numeric, reverse, and multi-field sorting
- Lab 4: Integration of interactive filters into a dashboard, testing of filter dependencies, and optimization of query performance
Data Calculations
- Creation of custom metrics and dimensions within the Looker Studio platform
- Utilization of formula functions:
CASE,REGEXP,DATE_DIFF,IF,SUM,AVG, and string manipulation - Performance considerations: comparison of computed fields versus source-level calculations
- Lab 5: Development of custom KPIs, conditional formatting logic, and derived metrics using native functions
Visualization and Dashboard Design
- Selection of appropriate chart types for specific analytical questions (tables, bar/line charts, scorecards, geo maps, scatter plots, pivot tables)
- Implementation of interactive elements: click-through URLs, drill-down capabilities, and tooltip customization
- Layout and responsive design principles: grid systems, padding, alignment, and mobile/tablet optimization
- Accessibility and readability standards: contrast ratios, labeling conventions, and clear data storytelling principles
- Lab 6: Assembly of a multi-page dashboard featuring responsive layout, interactive elements, and professional styling
Data Blending
- Understanding of join types: inner, left/right outer, and full outer joins in Looker Studio
- Definition of common dimensions and handling of mismatched data keys
- Blending strategies: pre-aggregation, normalization, and performance tuning
- Lab 7: Execution of data blending operations (e.g., sales and marketing spend), validation of join results, and resolution of common blending errors
Sharing and Publishing
- Access control mechanisms: viewer, commenter, and editor roles, alongside organization-restricted permissions
- Configuration of auto-refresh, email subscriptions, and scheduled report distribution
- Embedding of reports in external websites/portsals and export options (PDF, CSV, PPTX)
- Dashboard governance protocols: versioning, naming conventions, and audit trail maintenance
- Lab 8: Publication of a production-ready dashboard, configuration of sharing permissions, setup of auto-refresh, and export of artifacts
Capstone and Real-World Implementation
- Comprehensive workflow overview: data connection to calculations, filters, visualization, and publishing
- Peer review of dashboard builds with facilitator feedback on design, performance, and clarity
- Open Q&A session, troubleshooting of common connector/calculation errors, and distribution of additional resources
- Deliverable: Submission of a fully functional, interactive Looker Studio dashboard with supporting documentation for government stakeholders
Requirements
- Active Gmail account
- Foundational understanding of spreadsheet applications, data structures, or reporting procedures (optional)
7 Hours
Testimonials (3)
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.
Mircea
Course - Google Cloud Platform Basics and Management
Responses with solutions and practical use.
