Looker Studio – The Practical Masterclass

Explore the Adidas Kaggle sales dataset with 10,000 observations, covering retailers, regions, product categories, prices per unit, units sold, total sales, and operating margin in Looker Studio.

Create and style scorecards in Looker Studio to track KPIs, add sparklines and dynamic targets, and compare performance across dates and quarters, with compact numbers and borders.

Create and style a dimension scorecard, sort by total sales to identify retailers and regions with highest and lowest sales, and customize labels and borders for a filterable KPI view.

Explore Looker Studio table formatting, including resize, sort options, vertical to horizontal tables, header styling, colors, freezing rows, pagination, number formats, and conditional formatting with color scales.

Explore how filters and controls in Looker Studio shape dashboards by applying quick and main filters, adjusting chart scope, and enabling user pickers like a state dropdown.

Explore how to add and manage filters in Looker Studio, apply them to pages and reports, and view applied filters for retailers, products, and operating margin.

Learn to add and customize the drop-down filter in Looker Studio, set default selections, switch metrics like sales target or operating profit, and tailor styling for region, state, and more.

Master dimension controls in Looker Studio by applying a drop-down to switch dimensions across visuals, grouping graphs so only selected charts respond, and building integrated dashboards with controls and filters.

Develop a two-page Looker Studio sales dashboard: an overview with scorecards and bar charts by region and product, plus a detailed report with tables, heat maps, and time series analysis.

Build a practical executive dashboard in Looker Studio by adding quarter, region, and product controls, six scorecards for total sales and profit, and two bar charts for region and product.

build a Looker Studio dashboard with date and product filters, retailer and detail tables, heat maps, and a smoothed line chart of sales and profit by year quarter.

Explore the Polish property sales data in Looker Studio. Build a dashboard with six months of 2024 apartment prices across 15 largest Polish cities, including geo mapping and offer price.

Explore numeric aggregations in Looker Studio by calculating sum, average, count, count distinct, max, min, and median price per city, including a summary row for a six-month property dataset.

Explore text field types and the drill down action in Looker Studio, including dimension properties, geo data, URL and image options, and building drill paths with filters.

Explore geo data types in Looker Studio by building maps with city and lat/long fields, using calculated fields to create regions, and understanding geo dimensions limitations in Google Maps visuals.

Use dimension controls to switch map dimensions between country and city in Looker Studio, configuring geo fields and grouping the control to affect only the map.

Explore Looker Studio's geo chart, assign city as the dimension, use sum, average, and max price metrics with a slider to drill from city to country on dashboards.

Explore Looker Studio pie and donut charts, drill from country to city, and use price as a metric with tooltips and percentage. Apply styling, cross filtering, and grouping others.

Build intermediate dashboards in Looker Studio: a city sales dashboard with city-level metrics and price drivers, and a property selector dashboard with a table, map, and filters.

Create an interactive property selector dashboard in Looker Studio using city, boolean, and range filters, a table of properties, and a map with drill-down to street view.

Extract seconds, minutes, and hours from date times in Looker Studio, concatenate parts, and use datetime diff, add, sub, and trunk for durations and categorization.

Learn to create calculated fields by grouping numeric and categorical fields in Looker Studio. Build small, medium, and large sales buckets from units sold and reduce dimensionality.

bin numeric fields in looker studio to create a duration bin dimension, using a 10,000 bin size with min and max values, and explore custom breakpoints for monthly buckets.

Create chart-specific calculated fields in Looker Studio, applying them at the chart level and on blended data sets, including concatenation of station names and chart-level group or bin options.

Explore how to use parameters in Looker Studio to drive calculated fields, including date aggregation options (month, quarter, year), growth rate controls, and a boolean switch for what-if analysis.

Model San Fran bike trips dataset by creating fields for age, decade of birth, trip time, and time of day, apply growth parameters, then blend regions and stations for dashboard.

Learn how to add images in Looker Studio via upload or URL, ensure reliable hosting, and design banners with Canva to create a cohesive dashboard theme.

Explore the arrange toolbar to control element order, align and distribute visuals, and set a banner to report level for multi-page dashboards, saving time and improving layout.

Learn to group and ungroup dashboard elements in Looker Studio, apply common styles to grouped items, and use group level filters to control scoped visuals like bar charts and scorecards.

Explore the four levels of scope in Looker Studio: report, page, group, and chart, and see how filters, parameters, and forecasts change calculations across a dashboard.

Explore combo plots that combine bar charts and line graphs in a single dual-axis chart, with tips on axis setup, labeling, styling, and legend placement.

Explore funnel charts in Looker Studio, showing proportions as percentages of max or previous steps. Use styles like stepped bar, smoothed bar, and inverted triangle across sales and day-of-week data.

Explore sankey charts to show relationships between retailer and region using value metrics like record count, sales, and operating profit, with filters and color options for clarity.

Master version control and sharing in Looker Studio by using version history, renaming and restoring versions, managing drafts and publish flows, and controlling viewer, editor access and link visibility.

Embed a Looker Studio dashboard into websites using the HTML embed code, resize to 900 by 650, and share dashboards publicly with live filters.

Schedule email delivery for Looker Studio dashboards, customize the subject and filters, and set recurrence and dynamic dates to deliver the correct quarterly data.

Connect Looker Studio to Google Sheets to create dashboards from a spreadsheet, configure headers and data sources, and enable live refresh and cross-filterable charts.

Learn to connect data in Looker Studio by linking Google Sheets and BigQuery with user-driven parameters, creating live queries, and enabling county and date filters in Portfolio Project 1.

Learn to create calculated fields in Looker Studio, such as tip percentage and fare per mile, and build map addresses using concatenated pickup and drop-off fields.

Publish a Looker Studio dashboard as public with viewer access, schedule a monthly report on the 28th, and embed it on a Google site while testing filters.