16
Apr 2020

Data Visualisation Using Google Data Studio

Course Information

Start Date16 Apr 2020, Thursday
End Date16 Apr 2020, Thursday
Time9am to 5pm
Venue100 Orchard Road, Concorde Hotel Singapore 238840
Fee$680 (excluding GST) Inclusive of refreshments, lunch, and course materials
ContactRoshini | 6720 3333 | training.aventis@gmail.com
Register Now
Get Group Quote
Download Brochure

Introduction

Whether you’re looking to create detailed reports or high-level dashboards, Data Studio has the tools you need to easily bring your data analysis together, create compelling visualisations, and share insights with your team. It is a powerful and user-friendly drag and drop tool that allows a multitude of different dashboards and reports to be created within minutes. Data can also be connected from a variety of sources including Google Analytics, Ads, Search Console, Sheets, MySQL databases and BigQuery.

In this engaging and hands-on course, you will learn how to visualise data online to gain insights. You will also learn how to connect your data, create impactful reports, and collaborate with your teammates. Digital Marketing Expert, Ivan Wong will also be sharing valuable insights and tools you need to design compelling reports to share with different stakeholders

Course Highlights

In this hands-on course, you will learn how to:

  • Connect Data Studio to Google Sheets
  • Calculate Averages, Highest values, Lowest Values and number of Unique Values
  • Create Scorecards to display key metrics and KPIs
  • Create powerful trend analysis graphs to help with forecasting
  • Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button
  • Gain powerful analysis from Stacked Bar and 100% graphs
  • Create powerful Time and Category filters to easily create interactive reports
  • Share your Reports and Dashboards with other users
Target Audience
  • Professionals in Marketing, Sales, Business Development, and Digital Analytics
  • Professionals and individuals with an interest to leverage Google Data Studio to create reports and dashboards for business analysis
  • Trainers, Consultants and Educators
Prerequisite

Basic computer knowledge is required as participants are required to bring a laptop.

Course Outline

Module 1: Fundamentals

  • Introduction & Benefits
  • Setting up Google Data Studio
  • Principles of data visualization
  • Interface features
  • Dimensions and metrics

 

Module 2: Reports

  • Connecting data sources, including Google Analytics and Google Sheets
  • Creating your first Google Data Studio report

 

Module 3: Customization

  • Adding a date range
  • Adding tables and chart widgets
  • Adding a filter control
  • Using filters
  • Layout and styling
  • Adding pages

 

Module 4: Dashboards

  • Marketing dashboard
  • B2B dashboard
  • Conversion dashboard
  • Ecommerce dashboard
  • Content dashboard
  • Social dashboard

 

Module 5: Management

  • Publishing & sharing dashboards
  • Exporting
  • User permissions

 

Module 6: Advanced

  • Calculated fields
  • Working with Google Sheets
  • Blending data from different sources
  • Additional options
Digital Marketing Expert: Ivan Wong

Driving growth for companies across Asia through digital marketing, Ivan has over 20 years of experience in business consulting, training, performance marketing, B2B/B2C SEO, UX & conversion optimisation and digital analytics. He specialises in driving ROI from cross-channel digital campaigns and can work with operations, marketing & sales at all levels of management, from formulating strategies, training teams, to overseeing clients and project management

Well-versed in both the technical and business aspects of digital marketing, Ivan is in the pioneer batch of Google-appointed Regional Trainers, training agencies and marketers in Google Ads, Analytics and Shopping advertising courses since 2013. He has provided training and consultancy for over 500 clients on behalf of leading marketing agencies including Google Mobile Labs, IE Singapore, The Knowledge Engineers and ClickAcademy Asia.