Dynamic Dashboards and Data Analysis with Looker Studio

Welcome to Dynamic Dashboards and Data Analysis with Google Looker Studio. In this course, you will learn how to build powerful data visualizations and unlock insights that can help you drive business results for your clients or employers. This course aims to strike a balance between the foundations of data analysis and hands-on practical examples.

The course starts with an introductory view of key concepts such as aggregation, pivot tables, calculated fields, data blending and then dives into real-world projects, including:Project 1: Create a User Journey Funnel with Google AnalyticsProject 2: Create a device breakdown visualization with user-level dataNEW* Dashboard Building Challenge: Create a dashboard in 10 minutes and get feedback from the instructor and/or your fellow students. (Assignment)By the end of the course, you will be able to:Use and understand all chart types throughout the course (Bullets, Pie Charts, Scorecards, Scatter plot and etc. )Connect and blend data sources from Google Analytics and Google SheetsCreate custom dimensions with conditional expressions (CASE + REGEXP_MATCH + IN)Build a user journey funnel with Google Analytics data based on a "Page Title" dimensionCreate a device breakdown visualization and explore user-level data with scatter plot (eCommerece)Create a Google BigQuery table based on a specific SQL query and visualize it in Looker Studio, formerly Google Data StudioCreate time series with rolling dates and interaction filtersConfigure Gauge charts to track performance against a specific goal or KPIAutomate reports with advanced date selection filtersUnderstand the access levels in Looker Studio - "Owner" vs "Viewer"Apply conditional formatting rules to signal data anomalies Extract a report theme and colour scheme from an image in Looker Studio, formerly Google Data StudioApply IF statements within a CASE and use operatorsWhat are the students who took the course saying.

"The pace of the course was great and I was able to follow along with all the exercises using the provided data files and Google Analytics demo account" - Tricia"The course is fantastic. The instructor was clear and on-point when it came to the content. Lachezar took me from a complete beginner to someone who can actually build dashboards and understand how DS works.

I was blown away by how relatively short the video content was compared to the value I received - if you go beyond what's instructed and dive deep to recreate every single step (and dashboard) presented in this course yourself, it'll take you easily 10-15 hours of work to do. This is a no fluff course, updated, with great support from the instructor - I urge you to go for it. " - Roi"This course has been very very done, clear and insightful.