Google Data (Looker) Studio for Data Visualization

Connect, blend, and analyze data across multiple sources in Data Studio by configuring dimensions, metrics, data types, and automatic refresh for accurate visualizations.

Connect multiple data sources to a single Looker Studio report. Build geo charts and bubble maps using country wise box office data, with bubble size by tickets.

Understand metrics and dimensions, and see how data can serve as metrics or dimensions, illustrated by top 1000 movies with ratings, genres, and revenue.

Explore calculated fields in Data Studio to manipulate data without editing the source. Use these fields to normalize metrics and compute the average earning per ticket across countries for visualization.

Create a calculated field to compute average ticket price across countries by dividing revenue by tickets. Learn how Data Studio aggregates data and fix mismatches with sum functions.

Leverage arithmetic operators in calculated fields to sum multiple market figures in Looker Studio, creating a total box office view and exploring data visualization techniques.

Learn how calculated field functions work, using sum and average to compute US box office revenue across ranges, and apply similar functions in Data Studio.

Learn to use max and nary_max functions in data studio to find the highest revenue by market for each movie, and modify charts dynamically by switching chart types.

Explore conditional functions in data studio, using the if function to test conditions and categorize movie runtimes as short or long (less than 120 minutes).

Explore conditional operators and their use in data to categorize movies by runtime, such as less than 120, equal to 120, and not equal to 120.

Use conditional functions to classify movies by runtime (less than 120 minutes vs more) and display results in a pie/donut chart with string literals labeling short and long movies.

Explore nested if statements and nested conditional functions in Google Data Studio (Looker Studio) to categorize movie runtimes into short, medium, and long segments for data visualization.

Learn how and or operators work in Google data studio, using runtime between 120 and 180 minutes as examples, including all conditions and nested if statements.

Learn to implement a nested if in Looker Studio to categorize movie runtimes into short, long, and very long using thresholds under 120, 120–180, and 180+.

Explore using the case conditional function in Google Data Studio to group movies into very old, old, and new by year, replacing nested ifs and improving readability for visuals.

Explore bullet charts in Looker Studio and learn to use calculated fields to show min, average, max thresholds and a target with clear color styling.

Explore pivot tables in Looker Studio and build text-based calculated fields to concatenate actor names into a single column using text functions, with multiple dimensions and a matrix layout.

Learn to enhance pivot table readability in Looker Studio by using the concatenate function with pipes, spaces, and commas, add a second column, and explore a third calculated text field.

Use substring to trim movie details in a pivot table, then apply text functions like contains, lower, upper, trim, and starts with to create concise fields.

Learn to create and deploy global calculated fields in Google Data Studio Looker Studio, turning a runtime length function into a reusable runtime slot across charts.

Learn how to organize charts and reports by creating and managing pages in Looker Studio, including naming, ordering, and moving visuals across multiple pages.

Learn to arrange and align multiple charts in Looker Studio, using horizontal and vertical alignment, box sizing, padding, and text styling to create a symmetrical, uniform report page.

Master inter-chart alignment in Looker Studio by using margins, alignment lines, and magnet-like snapping to organize charts. Align vertically, adjust spacing, and reserve space for titles.

Label charts with clear headings and format text to improve readability in Looker Studio reports. Control font color bold centering and visibility to order components and create cohesive visuals.

Apply themes to instantly change a report's look and feel in Looker Studio, selecting presets, and adjusting fonts, colors, backgrounds, and legend visibility.

Group components by right-clicking and selecting group, then move them together. Select all score cards on a page and apply style changes across charts using the same data source.

Learn how to use multiple column sorting in Looker Studio reports to rank directors by votes and movie count, using first level and second level sorting with the shift key.

Arrange and label charts across pages one to three in google data studio looker studio to create a clear report; adjust layout height to keep charts aligned.

Learn to use controls in data studio, including dropdown lists, to let end users filter data by movie, runtime, and director, and see live changes in charts and metrics.

Learn how the fixed size list control works in Looker Studio, showing all options at once and updating data as you select different movie names or time slots.

Explore the input box and advanced filter to filter data by movie name, genre, and director, using exact matches, starts with, and regex for drama or action results.

Use the slider control to filter movie data by year, revealing how older films in the 1920–1950 range shift genre trends and popularity, from comedies to drama.

Explore how the data control checkbox functions as a boolean toggle in Google Data Studio, using a calculated field to separate movies by metascore above or below 85.

Group the target charts and apply a dedicated slider to them, so only one or two charts refresh when adjusted, leaving the rest of the report untouched.

Apply filters to charts to control data, selecting include or exclude genres like drama, comedy, crime, action, biography, animation, and adventure at chart, page, or report levels.

Learn to pull data from Google Analytics into Google Data Studio and visualize it with charts for insightful website analysis.

Connect Google Analytics data from a demo account to Data Studio, explore third-party connectors, and start building charts and reports for a Google merchandise store.

Create scorecards in Google Analytics Data Studio and compare the last 28 days to the previous period, using dynamic date ranges to reveal trends in views, active users, and revenue.

Explore how Google Data Studio (Looker Studio) standardizes data visualization across diverse sources, highlighting homogeneous metrics and scorecards, and easing report creation despite varying data meanings.

Demonstrates how to set up and use the date range control with Google Analytics data, enabling end users to adjust report views and compare data across customized periods.

Explore how to create a time series chart in Looker Studio, comparing views and total users over time using date and day of week dimensions to reveal seasonality.

Use geo charts in data studio with Google Analytics data to visualize active users and revenue by country and city, using bubble maps and heatmaps.

Explore bubble charts in Google Analytics data to compare daily views, active users, and revenue across the days of the week, with bubble size reflecting revenue.

Create a pivot table with a heatmap in Google Data Studio using Google Analytics data to compare revenue across device categories and days of the week.

Plot revenue trends across dates with a line chart in Data Studio, add date as the dimension, and include metrics like purchase revenue, add to cart, and checkouts to diagnose declines in Google Analytics data.

Use community visualizations in Google Data Studio to build funnels, tracking e commerce journeys from item list views to purchases and identifying where the funnels encounter problems.

Use radar charts in Looker Studio to compare multiple metrics across device categories, such as views, total users, active users, add to cart, and conversions.

Explore a time plot that blends time series and bubble charts to compare browser performance on add to cart and checkouts, highlighting Chrome.

Use heatmap visualizations to map two dimensions on the x and y axes and compare metric intensity by color, while noting label visibility and potential dimension compatibility issues.

Learn housekeeping tasks in community visualizations, including managing visualization resources and revoking permissions. Explore more visualizations, remove added report sources, and access developer guidance and support documents.

Extend Looker Studio with free data sources and connect Excel or CRM data to create dashboards from analytics and Google Analytics. Explore updates and Udemy courses to deepen analytics skills.

Preview data in Looker Studio sources to see sample fields and values from Google Sheets before building reports. Refresh the data preview and manage data sources for quick visualization.