New 2024 Looker Studio Google Sheets Option

In this video we look at the Extension option, Looker Studio. This is Google’s Business Intelligence Tool, similar to Power BI or Tableau. You can create a quick report or dashboard with much more customizations than Google Sheet’s native chart options. In this video we will walk through creating a report, adding charts, connecting more data, and sharing the report. Feel free to use the data I am using in the links below, or use your own data.
NOTE: Some workspace accounts may not have access depending on your Google Admin Console Settings! If you cannot get into it you may need to reach out to your Google Accounts Administrator to see if this can be used!
---
📈Data Links:
1️⃣Favorite Things Data
docs.google.com/spreadsheets/...
2️⃣Dates data to connect to:
docs.google.com/spreadsheets/...
---
⏳Timestamps:
00:00 Introduction
00:55 Data Overview in the Two Google Sheets
02:34 Use Extension / Looker Studio / Create a Report
03:17 Menu Bar Options Overview
05:00 Looker Studio Charts and Drilling Down into Data
05:47 Report Level Vs. Page Level Charts
06:35 Breakdown Dimensions
07:17 Adding More Charts
07:43 Adjusting Dimension Value Colors
08:43 Add a Control
09:32 Adding and Adjusting Metrics on Charts
11:04 Adding and Refreshing Data
11:44 Add Data to Looker Studio Report
12:27 Using Different Datasets
13:00 Blend Data
15:19 Using Blended Data
18:54 Save Report and Name Version History
19:46 Adding A Slider Control
22:19 Add a Table Chart
24:15 Rename Pages
25:12 Check all Page(s) and Verify Data Sources!
26:28 Sharing Your Report
28:46 Conclusions
29:53 Looker Studio and Workspace Accounts
31:01 End Slides
--
If you wanted to view the report I made in this video, here is the link:
lookerstudio.google.com/repor...
---
🗣️Socials:
WEBSITE: matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN: www.linkedin.com/in/matthew-k...
INSTAGRAM: / matttechtidbits
Need a Freelancer? Check out my Upwork Profile:
www.upwork.com/freelancers/~0...
🎵Music is "WFH" by Ambiosynthesis
• WFH
-
#️⃣
#sheets
#spreadsheet
#googlesheets
#lookerstudio
#technology