Google Data Studio from Beginner to Advanced

Access Google Data Studio to start this course and explore three sections: beginners, intermediate, and advanced. Copy the assignments and the report, and use the data source for hands-on practice.

Create the first report in Google Data Studio by connecting a Google Sheets data source for the DHL store orders, configuring field types, and exploring data for graphs and tables.

Explore Google Data Studio's report options, including creating or copying reports, inserting charts, managing pages, adjusting layout, and switching between view and edit modes.

Create your first table in Google Data Studio by adding a text field, naming the report, and using ship date with sales and profit in USD.

Duplicate the table to reuse across pages, rename fields, wrapping long names, define report level objects like a logo and text blocks, and adjust sorting.

Convert a table to a bar chart in Google Data Studio, adjust bar style, and show sales and profit with dual axes and data labels.

Discover how to build a combo chart to display multiple parameters, assigning sales to the left axis and profit and discount to the right, using bars and lines.

Use a time series chart to compare historical data in Google Data Studio, adjust the date range, and enable previous year or previous period comparisons for insights.

Enable users to modify data ranges in Google Data Studio by adding a date range object, setting a default range, and using view or manual modes to select this year.

Learn to add a filter control in Google Data Studio, define dimensions and metrics, and analyze data using date range, segment, and category filters with expandable styling.

Use the pie chart in Google Data Studio to analyze market share by subcategory, switching the metric to sales and adjusting dimensions to reveal top subcategories.

Use the area chart in Google Data Studio to show market share over time, duplicate a report, switch from time series, and adjust time dimension and breakdown for month-by-month comparison.

Use the geo map in Google Data Studio to analyze sales locations by city, adjust data levels from ship date, and identify cities with the biggest sales.

Explore using a scorecard in Google Data Studio to compare results by creating a scorecard, adjusting data sources and date ranges, and applying previous period or previous year comparisons.

Use the bullet chart in Google Data Studio to compare results to the target by adjusting ranges, displaying the target line, and copying scorecard data for a larger, clearer view.

Build a pivot table in google data studio using the people table to view sales by category and segment, adjusting date range and ship date, with revenue-based sorting.

Emphasize data differences with heat maps and bar charts in Google Data Studio. Learn to switch metrics, apply color themes, and display numbers to identify top segments across periods.

Learn to show different stories on one page by grouping segments, using date range filters for shipped and open orders, and linking objects such as tables, rectangles, and text fields.

Improve layout consistency by aligning segments left, right, or center and distributing objects horizontally or vertically. Align tables and center elements within a rectangle to create a clean, consistent design.

Share Google Data Studio reports via file > share or the side panel, set access to private, anyone with the link, or public, and adjust editor permissions and downloading restrictions.

Enable a custom bookmark link by turning on the report setting. Save links with user-specific filter configurations to view country markets, such as China or the United States, in reports.

Embed Google Data Studio reports into websites or intranets by copying the embed code, inserting it on a page, and adjusting the size.

Create your first calculated field in Google Data Studio to compute the margin as a percentage of sales using the sales and profit fields.

Create a calculated field to measure duration between two dates in Google Data Studio, using to_date for formats and applying it to ship date and other date fields.

Create a calculated field using a case function to apply conditional logic, defining on-time shipments relative to a four-day target and displaying the results as a percentage.