About the course
One of the biggest barriers to organisations adopting data visualisation tools and developing a data driven culture is the substantial subscription costs associated with procuring industry-leading tools which can be prohibitive to many companies. This has resulted in a recent shift in adoption of free visualisation tools such as Google Data Studio that can also provide a similarly robust experience.
This Introduction to Data Studio course will teach marketers, business owners, agencies, and data analysts on how to visualise data online to gain insights. You’ll learn how to connect your data, create impactful reports, and collaborate with teammates. You’ll gain the knowledge and tools you need to design compelling reports to share with different stakeholders.
Course content
Day 1
Module 1: Welcome to Data Studio
• Chapter 1A: Data Studio Introduction & Benefits
• Chapter 1B: Setting up Google Data Studio
• Chapter 1C: Principles of data visualisation & dashboard planning
• Chapter 1D: Interface features
• Chapter 1E: Dimensions and metrics
Practical Exercise #1: Dashboard Planning Individual Task
Formulate metrics and dimensions and plan out your dashboard layout
Module 2: Getting Started with Dashboards
• Chapter 2A: Connecting data sources, including Google Analytics and Google Sheets
• Chapter 2B: Creating your first Google Data Studio report
Practical Exercise #2: Dashboard Creation Individual Task
Create a Data Studio dashboard and connect it to Google Sheets and Analytics
Module 3: Dashboard Customisations
• Chapter 3A: Adding a date range
• Chapter 3B: Adding tables and charts
• Chapter 3C: Adding filters and filter controls
• Chapter 3D: Layout and styling
• Chapter 3E: Adding pages
Practical Exercise #3: Dashboard Customisation Individual Task
Customise your dashboard by changing the theme and adding custom charts
Day 2
Module 4: Dashboard Templates
• Chapter 4A: Marketing dashboard
• Chapter 4B: Sales dashboard
• Chapter 4C: E-Commerce dashboard
Practical Exercise #4: Dashboard Customisation Individual Task
Create a dashboard with 3 pages to measure marketing, sales and e-commerce performances respectively
Module 5: Dashboard Management
• Chapter 5A: Publishing & sharing dashboards
• Chapter 5B: Scheduling & exporting reports to PDF
• Chapter 5C: User permissions
Practical Exercise #5: Dashboard Management Individual Task
Practise adding users to the dashboard as well as publishing and exporting it
Module 6: Custom Reporting Needs
• Chapter 6A: Calculated fields & parameters
• Chapter 6B: Blending data from different sources
Practical Exercise #6: Custom Report Individual Task
Create a chart that makes use of calculated fields and blended data sources
Kishan
Kishan is the founder of a data analytics company focused on helping organisations leverage data to inform, persuade and effect better business outcomes. He was previously the regional head of Datalicious where he managed business growth and day-day operations, developing data-driven audience solutions for customers that increased e-commerce conversion rates by 200% and reduced paid advertising costs by 30%. Kishan is also a digital strategist with 10+ years of experience building teams from ground up…
