Introduction to Google Data Studio

• Welcome to Course

• Google Data Studio

• Report Gallery

• Example 1: Website Traffic

• Example 2: Sales

• Example 3: People Analytics

• Example 4: Photo Album

• Create Your First Report (I)

• Create Your First Report (II)

• Exercise: Create Your First Report

Preparing Data

• Connectors

• Create Data Source

• Lazada Transactions Dataset

• File Upload Connector

• Google Sheets Connector

• Facebook Insights Dataset

• BigQuery Connector

• Edit Data Source

• Edit Fields

• Exercise: Edit Fields

• Add a Calculated Field

• Data Source Settings

• Edit Connection

• Exercise: Preparing Dataset

Creating Reports - Table

• Create Report

• Create Table

• Date/Time Dimension

• Metrics

• Chart Interaction

• Exercise: Daily Sales

• Solution: Daily Sales Methods of Aggregation

• Comparison Calculation

• Running Calculation

• Exercise: Sales analysis by product

• Table Formatting

• Conditional Formatting

• Table with Heatmap/Bars

• Filtering Table/Optional Metrics

• Exercise: Transaction with Status Flag

• Create Pivot Table

• Expand/Collapse

• Applying Filter with Pivot Table

Creating Reports - Other Charts

• Scorecard

• Comparison Date Range

• Sparkline

• Exercise: Sparkline

• Time Series

• Time Series: Formatting

• Time Series: Multiple Metrics

• Time Series: Break Down

• Exercise: Times Series

• Area Chart

• Bar Chart

• Bar Chart: Multiple Dimensions/Metrics

• Exercise: Bar Chart

• Pie/Donut Chart

• Tree Map

• Scatterplot

• Geo Map/Google Maps

• Bullet Chart

• Community Visualization

Creating Reports - Coontrols

• Controls

• Input Box

• Advanced Filter

• Date Range

• Scope of Control

• Navigation

Sharing Reports

• Sharing

• Schedule Email Delivery

• Report Link & Embed Report

• Download Report

Advanced Features

• New Metrics

• Text Transformation

• Branching Logic

• Other Formulas

• Blended Data (I)

• Blended Data (II)

• Reaggregation

• Blended Lag & Self Join

• Exercise: Blend Lag

• Data Hierarchies

• Parameter

Case Study