Looker Studio – The Practical Masterclass

Build Looker Studio reports by exploring dashboards and elements like logos, filters, text, charts, and tables, and master the report setup, data and style options, and the five core visualizations.

Explore Looker Studio by creating a blank report, connecting a data source, configuring charts with style and setup, and mastering report, page, and share settings for effective dashboards.

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.

learn to build and customize bar charts in Looker Studio, including selecting dimensions and metrics, sorting, drilling, filtering, styling, and exploring stacked variants with cross-filtering.

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 time series charts in Looker Studio, add and aggregate dates by month or quarter, and style line charts with legend placement, reference bands, and data labels for clear insights.

Explore time series charts in Looker Studio with drill downs and comparisons over custom date ranges, using invoice date, year month, and ISO week.

Explore multi-dimension time series charts in Looker Studio by combining multi-metric views, such as total sales and operating profit, using optional metrics, dimensions, and styling across series.

Master Looker Studio tables, from a regular table with one dimension and one metric to drill-down dates, pagination, and a summary row. Sort by headers and export to Google Sheets.

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.

Convert metrics in Looker Studio tables to bars or heat maps, apply styling like numbers, targets, fonts, and colors, and explore the five core visualizations.

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.

Use slider and input box controls to filter numeric data in Looker Studio dashboards, setting price per unit with min/max, step, labels, colors, and default values for responsive results.

Learn to configure advanced controls in Looker Studio, switching between advanced filters, input boxes, dropdowns, and fixed lists, with end-user search types like equals, contains, start with, and regex.

Use the date range control in Looker Studio to filter dashboards with fixed and dynamic date ranges, selecting start and end dates, and customize the picker's styling.

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 numeric types and formatting in Looker Studio, applying currency, percentage, and custom number formats, adjusting decimals, and handling negative values with brackets or minus signs.

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 data aggregations in Looker Studio by differentiating continuous and discrete dates, and learn how year, quarter, month, ISO week, and day of week reflect granularity for filters.

Master date formatting in Looker Studio, including custom separators and quarter and iso week year formats, and implement drill actions to drill from quarter to days and into dimensions.

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.

Explore map chart setup in Looker Studio, focusing on bubble maps, field maps, and heat maps, with tooltips, color by ownership or type, size by price, and calculated fields.

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.

Master pivot table styling in Looker Studio to make pivot tables professional and usable. Learn to adjust text, titles, fonts, colors, borders, and subtotals, plus sorting and conditional formatting.

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.

Learn how to create new data sets with left outer blends and right outer joins in Looker Studio, blending stations and regions to reveal nulls and joined fields.

Explore string functions in Looker Studio by building calculated fields, using concat, left text, and uppercase and lowercase transformations, and applying replace and contains for station data.

Learn how Looker Studio uses aggregate functions to derive medians, percentiles, and calculated fields from total sales and records, illustrating how to control aggregation and order of operations.

Learn to use conditional functions in Looker Studio to create calculated fields, classify trips by station and duration, fill nulls, and derive weekday and month categories.

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 creating real calculated fields in Looker Studio, including city-state concatenation, product abbreviations, cost metrics, season and day-of-week fields, and value bins for deep data insights.

Explore how parameters empower end users to customize dashboards in Looker Studio, with text, numeric, range, boolean, and list values, plus sliders, calculated fields, and what-if analysis.

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.

Create an advanced Looker Studio dashboard by blending data, building dropdowns and sliders, and visualizing trips, forecast trips, and minutes per region, with a detailed table and filters across dashboards.

Master Looker Studio design by combining text, shapes, lines, and images to build customizable dashboards, using rectangles, borders, and connectors, plus text links and color options.

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 themes and layouts in Looker Studio to keep dashboards consistent across pages, customizing backgrounds, text, charts, and navigation with default and executive themes.

Extract a theme from an image to drive Looker Studio dashboard colors. Apply the resulting theme across charts, backgrounds, borders, text styles, and palettes to create a cohesive, customized look.

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.

Design a FedEx themed Looker Studio dashboard by building a Canva banner, applying brand colors, and assembling scorecards, bar charts, and a themed table.

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.

Export visuals and data from Looker Studio dashboards as PDFs, CSVs, or Google Sheets, including all pages or selected pages, with optional password and option to ignore background color.

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

Compare reports and data explorer in Looker Studio, then use the explorer for data analysis with dynamic charts, filters, and cross-filtering to shape dashboards.

Explore data quickly with Looker Studio's explorer by creating, saving, and sharing charts across tabs; cross-filter visuals and build reports, with upcoming data integrations including Google Sheets.

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.

Connect Looker Studio to BigQuery via a custom query, clean nulls with Gemini, and build dashboards with tables, bar charts, and line charts, refreshed every 12 hours.

Create two Looker Studio dashboards for Casey's general store using the Iowa Liquor Sales data: a KPI dashboard with sales, profit, bottle profit, and comparisons, plus a map-based detail dashboard.

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.

Create a KPI dashboard in Looker Studio using a Casey's logo from Canva, apply a gray theme, and add filters, dropdowns, and input boxes across two pages with a map.

Learn to build a detailed Looker Studio dashboard by configuring filters, adding dimensions (date, season, store, vendor, category), and creating a table and map with profit versus target insights.

Learn how to share Looker Studio dashboards publicly, schedule monthly deliveries with filters (last month) and parameters, and embed responsive dashboards on Google Sites with custom reports.

Explore BigQuery taxi trip data by joining pickup zones to geom data, creating a filtered 2022 dataset for 9-10 am, and building two dashboards for the tip and the trip.

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.

Build the trips dashboard with pickup and drop-off dropdowns and a month-year date field. Display a bubble map, a table, and a line chart showing total and average metrics.

Learn the tips dashboard solution in Looker Studio by reusing the trips dashboard, converting dropdowns to range controls, and building tip and fare visuals by pickup zone.

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.

Explore Looker Studio through a self-directed portfolio project using the Looker ecommerce BigQuery dataset from Kaggle, linking distribution centers, events, orders, products, and users for sales and product insights.

Apply what you learned by doing the course projects and refining your data analytics skills with Looker Studio. Explore upcoming features and the recommended BigQuery pathway for faster data transformations.