Google Data Studio | Beginner to Expert

Connect your Google Analytics account to Google Data Studio to visualize analytics data, authorize access, select the Universal Analytics account, and add dimensions and metrics to the report.

Learn to load Google Sheets as a data source in Google Data Studio, authorize access, and use separate data sources for each worksheet with last year data if needed.

Explore the data sources available in Google Data Studio, including Google Analytics, Google Sheets, BigQuery, and Search Console, MySQL and PostgreSQL databases, and CSV uploads, plus 300+ third-party connectors.

Create tables in Google Data Studio by selecting a table from the chart dropdown, using the sample analytics dataset, and adding multiple columns; manage dimension‑metric errors and explore filtering options.

Learn to create pivot tables in Google Data Studio by turning a table into a cross-dimension view of pages by country, with last seven days data via a data controller.

Explore formatting and styling in a Data Studio report, including renaming reports and pages, applying themes and company colors, and inserting logos and text for a branded, polished look.

Explore aggregation methods in Google Data Studio, including sum, average, count, min, max, and more, applied to metrics and dimensions with examples from subscriptions and lifetime value.

Explore date comparisons in Google Data Studio visualizations by using custom date ranges, previous period, and auto date range to compare year over year or quarters.

Learn to sort, filter, and control data in Google Data Studio using table filters, custom filters, and interactive controls to refine lifetime value insights.

Learn to create and customize column and bar charts in Google Data Studio, using dimensions and metrics, right-axis styling, and stacking to compare lifetime value and averages.

Learn to convert a 100 percent bar chart into a pie or donut chart in Google Data Studio, adjust dimensions and metrics, and compare lifetime value by subscription plan.

Create a geographic map in Google Data Studio using Google's sample dataset, switch to the Google Analytics data source, and explore city-level US insights (California) for stakeholders.

Create a scatterplot bubble chart in Google Data Studio with new users on the x axis, page views on the y axis, bubble size by users, and region filters.

Use score cards in Google Data Studio to show daily and weekly metrics at the top of reports, customize data ranges, compare with the previous period, and set goals.

Create custom metrics in Google Data Studio by combining, dividing, and concatenating metrics to track goal progress and normalize data with lower functions.

Learn to use case statements in Google Data Studio to create custom metrics, mapping sources like google.com to Google and linkedin.com to LinkedIn, and group values into regions or tiers.

Blend data from multiple sources in Google Data Studio by cross-referencing the region to combine metrics like users and page views from Google Analytics, Google Search Console, and Google Sheets.

Export data from Google Data Studio to CSV or Google Sheets for quick analysis or sharing. Use the report view and export options to save as Excel or a sheet.

Schedule email deliveries from your Google Data Studio report to receive daily or custom updates, with a PDF attachment, ensuring colleagues access a fresh report without logging in.

Learn to share Google Data Studio reports by inviting contributors or granting view or edit access, copying links, and avoiding public links to protect sensitive data.