Complete Introduction to Data Studio (Looker Studio)

Explore formatting and styling options for your Looker Studio tables, including font, colors, headers, borders, wrap text, alignment, and pagination; enable cross filtering to make interactive data filters across visuals.

Learn how to work with multiple metrics in Looker Studio, adding profit and order quantity, applying heat maps and data bars, and adjusting decimals and targets for cross-filtered insights.

Explore advanced calculations in Looker Studio tables with product subcategory and sales, no decimals, and a summary row. Compute percentage of total, difference from total, and percentage of max.

Learn to add slicers and visualization filters using text, numeric, and date controls, and apply filters to individual visualizations to create interactive reports.

Explore how Looker Studio controls work, from input boxes and tick boxes to preset filters and navigation buttons, and learn when each fits your data.

Learn to use the quick filters on the filter bar in edit mode to filter a report by region, price, date, and channels, then reset or remove as needed.

Apply text visualization filters in Looker Studio to a single visualization, including region Asia, starts with and or conditions, and product category audio from a field outside the table.

Create custom calculations in Looker Studio by adding calculated fields to compute total sales, total profit, and the profit ratio. Build these metrics using sum, division, and percentage formatting.

Create calculated fields in Looker Studio to analyze sales by product category, including average sales, highest sale, total sales, and average sale per product. Add country insights with these metrics.

Use the case statement in Looker Studio to evaluate sales and create a field. Use when, then, else, and end case to label sales as over 1000 or below 1000.

Explore the data extraction feature in Looker Studio, embedding selected fields, dimensions, and metrics to speed refreshes using locally stored data. See how the case study demonstrates this approach.

Learn to create an extract data source in Looker Studio from Google Sheets, select dimensions and metrics, save the extraction, and swap visuals to faster extracted data.

Using time series graphs, learn how data changes over time and detect trends from year to month to order date. Explore drill-downs, legends, and line or bar options.

Explore how to customize graphs in Looker Studio, adding trend lines and reference lines, and using cumulative, moving average, and percentiles to analyze sales data over time.

Explore time series comparisons by plotting year-month data and comparing it to the previous year or period using custom date ranges and interval options for boundaries.

Explore area graphs in Looker Studio to visualize how data changes over time with stacked and 100% stacked views, using region breakdown and adjustable axes.

Explore how pie charts show percentage contributions and how limiting items improves readability, while adjusting donut styling, slice padding, inner radius, colors, labeling, and legend placement to suit data.

Use scatter plots to explore the correlation between sales and profit, with axis swaps, trend lines, data labels, and drill-down options across product category, subcategory, and name.

Create dashboards in Looker Studio by combining visualizations with filters and controls to serve a sales manager. Learn to share, invite collaborators, email scheduled updates, and embed reports in websites.