"The structure, the practice exams, the instructor — all top tier. Passed first try."
Course Outline
What the programme covers, module by module.
Module 1: Introduction to Google Data Studio
- Overview of Looker Studio
- Features and Capabilities
- Use Cases
- User Interface
- Report Creation Workflow
Module 2: Getting Started
- Creating Reports
- Navigation Basics
- Report Settings
- Data Source Overview
- Workspace Management
Module 3: Connecting Data Sources
- Google Sheets
- Excel Files
- Google Analytics
- BigQuery
- Database Connections
Module 4: Data Preparation
- Importing Data
- Data Validation
- Field Management
- Data Types
- Data Refresh
Module 5: Building Charts
- Scorecards
- Tables
- Bar Charts
- Line Charts
- Pie Charts
Module 6: Advanced Visualizations
- Geo Maps
- Time Series Charts
- Scatter Charts
- Bubble Charts
- Combo Charts
Module 7: Filters and Controls
- Date Range Controls
- Drop-Down Filters
- Search Controls
- Interactive Filtering
- Report Navigation
Module 8: Calculated Fields
- Formula Basics
- Arithmetic Functions
- Text Functions
- Date Functions
- Conditional Expressions
Module 9: Data Blending
- Blending Multiple Data Sources
- Join Types
- Relationship Management
- Combined Metrics
- Data Validation
Module 10: Dashboard Design
- Dashboard Layout
- Themes and Styling
- Branding
- User Experience
- Responsive Design
Module 11: Interactive Reporting
- Drill-Down Reports
- Drill-Through Navigation
- Dynamic Controls
- Report Interactivity
- User-Friendly Dashboards
Module 12: Performance Optimization
- Efficient Data Models
- Query Optimization
- Reducing Report Load Time
- Best Practices
- Dashboard Maintenance
Module 13: Sharing and Collaboration
- Sharing Reports
- User Permissions
- Team Collaboration
- Version Management
- Report Publishing
Module 14: Data Security
- Access Control
- Data Privacy
- Secure Sharing
- Viewer Permissions
- Governance Practices
Module 15: Marketing Dashboards
- Website Performance Reports
- Campaign Dashboards
- SEO Reporting
- Advertising Analytics
- Social Media Insights
Module 16: Sales and Business Dashboards
- Sales Performance
- Revenue Analysis
- Customer Insights
- KPI Tracking
- Business Metrics
Module 17: Custom Reports
- Executive Dashboards
- Operational Reports
- Financial Reporting
- Department Reports
- Automated Templates
Module 18: Working with BigQuery
- BigQuery Integration
- Query Results
- Large Dataset Reporting
- Data Optimization
- Cloud Reporting
Module 19: Report Automation
- Scheduled Report Delivery
- Data Refresh Automation
- Dashboard Maintenance
- Workflow Optimization
- Reporting Best Practices
Module 20: Troubleshooting Reports
- Data Connection Issues
- Visualization Errors
- Formula Debugging
- Performance Issues
- Quality Checks
Module 21: Best Practices
- Dashboard Design Standards
- Data Visualization Principles
- Storytelling with Data
- Accessibility
- Report Documentation
Module 22: End-to-End Dashboard Project
- Business Requirement Analysis
- Data Integration
- Dashboard Development
- Performance Testing
- Final Report Presentation
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device