Google Looker Studio Course

Lesson 1 • Navigating the Interface

Explores the home screen, report editor, and navigation menus in detail. Students gain confidence moving between reports, data sources, and explorer views.

Lesson 2 • Understanding Reports and Data Sources

Defines the relationship between reports and data sources as separate objects. Students understand how this architecture affects sharing and reuse.

Lesson 3 • Setting Up Your Account

Guides students through account creation, Google account requirements, and initial settings. Ensures every student has a working environment before building reports.

Lesson 1 • Configuring Data Source Fields

Teaches field renaming, data type assignment, and default aggregation settings within a data source. Proper configuration here prevents errors in all downstream reports.

Lesson 2 • Blending Multiple Data Sources

Introduces data blending to combine fields from two or more sources in a single chart. Students learn join keys, blend limitations, and when blending is appropriate.

Lesson 3 • Built-In Google Connectors

Covers native connectors for Google Sheets, Google Analytics, and Google Ads. Students connect to the most common data sources used in real-world reporting.

Lesson 4 • Third-Party and Partner Connectors

Introduces partner connectors from the Looker Studio connector gallery for non-Google platforms. Students evaluate and select appropriate connectors for diverse data needs.

Lesson 1 • Adding Pages and Navigation

Explains multi-page report structure, page management, and navigation components. Students organize complex reports into logical, user-friendly sections.

Lesson 2 • Formatting and Styling Components

Explores the Style tab options for colors, fonts, borders, and backgrounds. Consistent styling makes reports professional and easier to read.

Lesson 3 • Configuring Chart Data Properties

Teaches how to assign dimensions, metrics, date ranges, and sort orders to any chart. Students control exactly what data each component displays.

Lesson 4 • Adding and Arranging Components

Covers inserting charts, tables, text boxes, images, and shapes onto the canvas. Students build spatial awareness for effective report layout.

Lesson 1 • Tables and Scorecards

Covers table charts, pivot tables, and scorecards for displaying raw and summarized data. These are the most frequently used components in business dashboards.

Lesson 2 • Time Series and Bar Charts

Teaches time series, bar, and column charts for trend and comparison analysis. Students configure axes, series, and reference lines for clear storytelling.

Lesson 3 • Scatter Plots and Bullet Charts

Introduces scatter plots for correlation analysis and bullet charts for goal tracking. Students use these advanced chart types for analytical and executive reporting.

Lesson 4 • Custom and Community Visualizations

Covers adding community-built visualizations from the Looker Studio gallery. Students extend native capabilities with specialized chart types for unique needs.

Lesson 1 • Filter Controls for Viewers

Teaches drop-down lists, checkboxes, and input field controls that viewers can interact with. These controls transform static reports into self-service dashboards.

Lesson 2 • URL Filters and Embedded Parameters

Explains passing filter values through URL parameters for programmatic report filtering. Students automate report personalization for different audiences or systems.

Lesson 3 • Cross-Filtering Between Charts

Introduces cross-filtering so clicking one chart filters other charts on the same page. Students design interactive dashboards that respond to viewer exploration.

Lesson 4 • Report-Level and Page-Level Filters

Explains how to apply filters that affect all charts on a report or a single page. Students control data scope precisely across complex multi-page reports.

Lesson 1 • Conditional Logic with CASE and IF

Teaches CASE WHEN and IF statements for segmenting and categorizing data. Students create custom segments, labels, and conditional metrics.

Lesson 2 • Arithmetic and Text Functions

Covers numeric operators, math functions, and string manipulation functions. Students build revenue calculations, concatenations, and text-based transformations.

Lesson 3 • Introduction to Calculated Fields

Defines calculated fields, their scope, and where they can be created. Students understand the difference between data source-level and chart-level calculated fields.

Lesson 4 • Aggregation and Advanced Metrics

Covers SUM, AVG, COUNT, and COUNTD functions for building custom aggregate metrics. Students create calculated metrics that go beyond default aggregation options.

Lesson 1 • Embedding Reports in Websites

Teaches how to embed Looker Studio reports in web pages using the embed code feature. Students integrate live dashboards into portals, intranets, and client sites.

Lesson 2 • Sharing Reports with Collaborators

Covers sharing settings, permission levels, and inviting specific users or groups. Students grant appropriate access without exposing sensitive data or edit rights.

Lesson 3 • Scheduling and Exporting Reports

Covers scheduled email delivery and PDF export options for report distribution. Students automate recurring report delivery to stakeholders who prefer email.

Lesson 4 • Link Sharing and Public Access

Explains link-based sharing options including view-only and public-on-the-web settings. Students choose the right sharing mode for internal vs. external audiences.

Lesson 1 • Dashboard Design Principles

Covers visual hierarchy, whitespace, color theory, and audience-centered design for dashboards. Students apply design principles that improve comprehension and reduce cognitive load.

Lesson 2 • Performance Optimization Techniques

Identifies causes of slow reports and applies techniques to reduce load time and query cost. Students deliver fast, responsive dashboards even with large or complex data sources.

Lesson 3 • Building a Scalable Reporting System

Covers naming conventions, folder organization, shared data sources, and documentation practices. Students design a reporting infrastructure that scales across teams and time.

Lesson 4 • Row-Level Security and Data Access

Explains viewer-based filtering and data credential options to restrict data by user. Students implement access control so each viewer sees only their authorized data.