Complete Data Visualisation Tutorial for Beginner Data Analysts | 10+ Use Cases in Looker Studio [Video]

In this video I show how to connect & blend data in Google Looker Studio & the methods involved in creating charts & calculations.

Here is the link to access Google BigQuery: https://console.cloud.google.com/bigquery?pli=1

Here is the link to looker studio: https://lookerstudio.google.com/

Here is the link to social media data: https://docs.google.com/spreadsheets/d/16q6myzmXuGJnwHQ9sRMidacu8s5hnTKS4HLkFu6Lp9k/edit?usp=sharing

Here is link to category id details: https://docs.google.com/spreadsheets/d/1nfFchGTH_WxGtPzZT60kGE50o3UtP-ru0XpGVuo7Sms/edit?usp=sharing

Here is the link to dashboard: https://lookerstudio.google.com/reporting/ddb81ec3-430a-4303-bb5f-d7f0bcfbbb64

⏲️===TimeStamps===⏲️
00:00 Introduction
01:54 Upload data to BigQuery
03:05 Import Data into Looker Studio
04:50 Case Statement in Looker Studio
06:46 Blend Data
09:36 Scorecard for overall views & likes
12:34 Metrics by Platform
16:17 Metrics by Category
19:00 Calculated Metrics
25:33 Graphs & Charts
29:31 Conditional Formatting
31:32 Monthwise Trends
35:12 Page Naming