14
Jan 2020

Drive Business Growth with Google Data Studio

Course Information

Start Date14 Jan 2020, Tuesday
End Date15 Jan 2020, Wednesday
Time9am to 5pm
Venue100 Orchard Road, Concorde Hotel Singapore 238840
Fee$990 (excluding GST) Inclusive of refreshments, lunch, and course materials
ContactRoshini | 6720 3333 | roshini@aventisglobal.com
Register Now
Get Group Quote
Download Directory

Course Schedule

14 & 15 Jan 2020

16 & 17 Apr 2020

16 & 17 Jul 2020

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

Ivan has over 20 years of experience in Business Consulting, Training, Search Engine Marketing, Conversion Optimisation and Digital Analytics. A certified accountant and programmer by training, he also has over 10 years’ experience as a marketing trainer. Ivan is also one of the few Google-appointed Regional Trainers that trains the official Google Ads, Analytics and Mobile Advertising courses.

Ivan is an external trainer and consultant for various organisations such as Google Mobile Labs, TheKnowledgeEngineers, General Assembly, Econsultancy and ClickAcademy Asia. Well-versed in both the technical and business aspects of digital marketing, his passion is to help organisations of all types to use digital marketing effectively, working with all sizes of business from SMEs through to clients as large as TripAdvisor, CNNGo, Decathlon International, Singapore Tourism Board, and American Express.