Google Data 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.

Explore column charts in Looker Studio to compare total sales by region and retailer, adjusting labels, colors, spacing, filters, and reference bands for clear insights.

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.

Explore the fixed size list control in Looker Studio, a refined alternative to a drop down for selecting limited dimensions, with configurable header and border, and default selections.

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.

Master map styling in Looker Studio by adjusting color dimensions and metrics, setting default views, bubble size and color legends, and enabling user controls for tilt, zoom, and heat maps.

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.

Discover how pivot tables in Looker Studio organize data by city and tenement, compare metrics like record count and average price, and enable quick filtering and expand-collapse for clean dashboards.

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.

Master inner blends in Looker Studio by blending trips, stations, and regions to drop nonmatching rows and compare inner versus left joins, including record counts and nulls.

Explore full outer and cross joins in Looker Studio by comparing with left outer and inner blends, showing how full outer returns all rows and cross join generates every combination.

Explore calculated fields in Looker Studio, including text, numeric, conditional, and date/time functions. Learn to create and use if statements with a trips dataset to segment data.

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 arithmetic functions in calculated fields to derive cost and price per unit. From total sales and units sold, explore rounding, including round, seal, floor, and square root.

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.

Explore Looker Studio date functions by creating calculated fields for today's date, extracting day, month, year from start dates, and using date diff to measure days.

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.

Create a geo field by concatenating latitude and longitude in Looker Studio, then map points and explore city, continent, and country fields using ISO codes.

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 dynamic charts in Looker Studio, including the forecast parameter, average trips per station with calculated fields, and dimension and metric choices.

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.

Explore Looker Studio's what-if analysis by using parameters and filters to simulate sales growth and cost inflation, and calculate total sales, total cost, and operating profit with calculated fields.

Build a Looker dashboard by modeling San Francisco bike share data with fields for age, decade, trip time, time of day, date; enable region joins with forecast trips and minutes.

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.

Create a professional banner in Canva for a Looker Studio dashboard by setting a 1200 by 100 canvas, using taxi-themed graphics, and applying league Spartan fonts to match dashboard colors.

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.

Master pasting styles in Looker Studio to copy and apply fonts, borders, shadows, and padding across elements and pages for consistent dashboards.

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.

Learn to add and style buttons for navigation in Looker Studio, configure static and dynamic page links, and apply report-level navigation to cycle through pages with next and previous controls.

Create and style filter buttons in Looker Studio, using a boolean field to toggle filters on and off. Apply weekend and day-of-week filters and explore report actions.

Design a wireframe fedex dashboard in Looker Studio, refreshing the theme with modern charts using Adidas data, including a banner, scorecard, bar chart, and controls.

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 gauge charts in Looker Studio, learning to add gauges with ranges, set metrics like number of trips, customize colors, ranges, targets, and compare current data to previous periods.

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.

Create waterfall reports in Looker Studio to visualize how monthly dimensions affect a numeric total, using trips and subscribers data, with vertical styling and color-coded totals.

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.

Explore Gemini in Looker Studio to generate slides and narratives from charts and tables, linking dashboards for interactive product sales insights in Mexico across time by segment and by product.

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.

Build a kpi dashboard in Looker Studio by configuring date range controls, adding input parameters for target sales and profit margins, and creating scorecards with period-on-period and year-on-year comparisons.

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.

Create a Looker Studio trips and tips dashboard for New York taxi data, featuring time series, map filters, a tip-fare scatter plot, and a borough tip percentage bar chart.

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.