The Most Comprehensive & Advanced Looker Studio Training Course Online.
Bigger. Better. Updated. Extended. Live.
The 2024 edition of Looker Studio Masterclass is a weekly live training experience with 36+ live lessons scheduled from March to November.
By completing Looker Studio Masterclass, you will become an expert who’s able to plan, design, and fully deliver world-class data pipelines and dashboards using Looker Studio & BigQuery.
No prior experience is needed.
What’s the deal with Looker Studio Masterclass?
From 2021 to 2022, I hosted five cohorts of Data Studio Masterclass. The enrollment was by invitation, maxed at 8 participants per cohort, and used to cost between $2k to $5k.
In 2023, I couldn't host another live cohort due to a busy schedule and other work commitments and decided to make the recording of the 2022 cohort available on YouTube, absolutely for free. Since its release, over 500,000 people have watched the lessons.
A lot has changed since 2022. Back then, the tool was still called Data Studio and Universal Google Analytics was still collecting hits…
Plus, we've seen the release of numerous new features:
The name changed to Looker Studio, a paid Looker Studio Pro version with additional features became available, we’re witnessing the the rise of GA4, Piwik Pro, and other alternatives to Universal Analytics, AI has made transformative impact on our work, and BigQuery has became ever more important.
The whole curriculum needed to get updated and expanded. That’s why I’m recording a new 2024 version of the Looker Studio Masterclass from the scratch to cover the latest concepts and newest features, and to dive deeper into topics like GA4, Data Blending, SQL, AI, and BigQuery.
What’s included in Looker Studio Masterclass?
Weekly Live Lessons
Each week I teach a new lesson in a live workshop. It takes about 90 minutes. You can join and watch the lesson live, or catch up with the recording.
Real-life Examples
Practical and real-life examples are included in lessons to prepare you for the actual use cases and challenges you will face in your work.
Zero to Superhero
Everything you need to transform your skills: from an absolute beginner to a Looker Studio Ninja!
Updated Lessons
The whole curriculum is updated and expanded to reflect the new Looker Studio and Looker Studio Pro features.
New Concepts & Subjects
New concepts and lessons will be added to cover GA4, AI, SQL, RegEx, Data Blending, and BigQuery.
Course Community
You can join the course community to ask questions and get help from other students, alumni, and experts.
Testimonials
JJ Reynolds Measurement Ninja & Lead Looker Studio Instructor at VisionLabs
“Siavash was able to respond to my hyper-specific questions, and explain the theory behind them in a kind and loving way. There was no tutorial or Google search that could provide a response like that.”
Scott Reid D2C Ecommerce Growth Specialist | CRO & Data Visualization Expert at eCommerceOptimizers.com
“The course was perfectly paced, structured, and professionally delivered. It was better than 99.9% of other offerings out there and was loaded with practical information. My abilities have grown significantly, and the result has been increased income and satisfied customers.”
Josh Lannan Digital Marketing Agency Owner
CEO at Influence Live Media
“We only used Looker Studio as a deliverable for our services, until we took your program and realized it could be leveraged as a profit center and also to create self-liquidating offers.”
Brad Imming Paid Search Specialist
“Before joining this course, my work was limited to the hours I put in, so I couldn't scale my business. The masterclass not only allowed me to earn more revenue without spending time on it, but also improved the quality of my services.”
Fred Pike GA & GTM Freak. CXL Instructor. Managing Director & Web Analytics Lead at Northwoods
“It was amazing to meet such intelligent agency owners - people from all walks of life - who wanted to hone their skills and improve their business. One of my cohort members just launched her own course on CXL. That's incredible!”
Natasha Vorompiova Systems & Operations Consultant
Capacity Architect at Systemsrock
“It has been incredible to go through this course. I didn't need to figure out everything and go in blindly. Instead, I can focus on what specifically works for me and my business.”
Irene Portelli Marketing Agency Owner
“It's been incredibly valuable and has had a huge impact on my business. I'm often being hired first. I've been in rooms with a lot of quotes on the table and I've won the bid. My basic charge is now 3x more than before!”
Jennifer Grayeb Agency Owner, Measurement Expert
Looker Studio Instructor at TheNimble Co.
“I'm only 26 mins into the replay and so glad I joined this. Gold already!! I’m seriously geeking out over this stuff. I had no idea any of this was possible, this course is INSANE value so far!!”
Ryan Levander Measurement, SEO, and CRO Expert
Rednavel Consulting
“I watched the Regex workshop and I must say that was the best coverage of this topic that I’ve come across. Loved the use cases and just using this for search queries alone is really worth it.”
Who is it for?
Digital Marketing Specialists
Data Analysts & BI Professionals
SEO & Web Analysts
Performance & Growth Marketers
Researchers & Journalists
Project & Account Managers
Tech & IT Professionals
Educators & Trainers
Content Creators & Copywriters
Your Instructor
My name is Siavash (Ahmad) Kanani.
I run Siavak Analytics from the beautiful city of Budapest, Hungary.
We’re a small team helping a few key clients who make from $200M to $4B in annual revenue - optimize their websites, marketing, operations, employee performance, revenue, and profits by creating and maintaining their data pipelines in BigQuery and automated dashboards in Looker Studio.
My articles, courses, case studies, workshops, and talks have been featured on:
Course Curriculum: What You Will Learn in Looker Studio Masterclass
The number of lessons, and order of topics are indicative and subject to change.
Looker Studio Essentials
In this first section, you will learn the basic concepts and foundations of Looker Studio through an engaging exercise of creating a complete dashboard from start to finish.
Four introductory lessons
Covering topics like creating a full dashboard from start to finish, connecting to and transforming data, visualizing data, sharing reports, collecting viewer input & adding interactivity
Dashboard Planning & Data Transfer
Even before starting to build the dashboard you should have a clear plan of our data pipeline, page and dashboard structure, and the types of data transformations needed. It’s a crucial step that separates a great dashboard that’s easy to use and maintain from a mediocre one that’s hard to use and expand.
Three lessons
Covering topics like Structuring & Dashboard Planning, From Data to Dollars: The Journey of Data, Data Connectors & Data Sources
Data Modeling & Transformation
Data we receive from different tools and platforms in its raw form isn’t ready for visualization and usually isn’t in the exact format that we need it to be. That’s why we need to model (transform) data first to the shape required for visualization. In this section you’ll learn the basics of data transformation in Looker Studio, before moving towards the more advanced concepts.
Eleven lessons
Covering topics like Aggregation, Working with Numbers, Working with Text, RegEx, Working with Special Data Types Like Dates and Geo fields, Filters and Scopes
Plus, some more advanced concepts and techniques in data modeling.
Covering topics including Grouping & Categorizing Data, RegEx Essentials (Plus using AI), Data Blending: Foundations, Data Blending: Join types (w/ Examples), and Working with GA4 Data
Data Visualization
Once our data in in Looker Studio and you’ve prepared it into the format you need, you’ll be ready to visualize it and make it accessible for your end users in a way that is easy to read, understand, and interpret for them.
Three lessons
Covering Data Visualization Essentials, Best Practice, and Tips for Styling Dashboards Like a Pro
Interactions & UX
Looker Studio reports are dynamic and connected to the underlying dataset. The viewer can interact with the report and slice and dice data to look at specific segments or date ranges and explore the data to find the insight they need for their decision making. In this section you’ll learn how to make your Looker Studio reports interactive and tailor the visualizations based on viewer’s preferences and input.
Three lessons
Covering Data Controls, Parameters and viewer Inpput, and Advanced Filters & Controls
Management & Administration
You may start with a single report, but as your business evolves, you’ll end up with dozens or hundreds of reports that require maintenance, usage tracking, security, and access management. In this section, you’ll learn whatever you need to keep your Looker Studio reports and data sources organized and secure.
Two lessons
Covering topics related to Sharing, Security, Tracking, and Access Audit, Asset Management and Organization
Advanced Concepts
Having learned all the main concepts around connecting to data, transforming it, visualizing it, and sharing it in Looker Studio, in this final section you will learn some advanced concepts and Looker Studio Pro features which are accessible to the paid users, and several tips and tricks that come in handy when dealing with real-life projects.
Six lessons
Covering topics such as Leveraging AI in Looker Studio, Looker Studio Pro Features, Custom Visualizations, templr.pro, Custom Connectors, Google Sheets (+ Using AI in Sheets), Caching, Report Performance and Speed Optimization
BigQuery for Looker Studio
This section is all about BigQuery and teaches you how to leverage Google’s fully managed and petabyte scale data warehouse to build data pipelines for your Looker Studio reports. Through several lessons, you will learn the basics of BigQuery and SQL, and the essential skills we need to build scalable and efficient data pipelines for our Looker Studio reports.
Six lessons
Covering topics and concepts like BigQuery SQL Essentials (+ AI Solutions), Creating SQL Workflows, Working with Views, Tables, and Scheduled Queries, Creating an End-to-end Data Pipeline in BigQuery, Working with GA4 Data in BigQuery (+ AI Solutions), Cost & Query Performance Optimization, BigQuery ML, and Real-Life Case Studies
Frequently Asked Questions
That’s it.
It’s the bottom of the page.
You can stop scrolling! 🙂