7 ESSENTIAL Looker Studio HACKS EVERYONE Should Know!
ฝัง
- เผยแพร่เมื่อ 18 พ.ค. 2024
- START YOUR BI JOURNEY! - learnbi.online
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
Power BI For Business Intelligence - geni.us/powerbi-udemy
Ultimate Guide to Google Data Studio - geni.us/vbi-edu
Google Data Analytics Course - geni.us/coursera_analytics
Learn SQL - geni.us/learnsql
SKILLSHARE - 30-day free trial! - geni.us/skillshare30day
UDEMY - geni.us/udemy_vb
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - www.tableau.com/
Data Studio - datastudio.google.com/
📊 DATA HUBS & WEBSITES:
Power My Analytics: geni.us/YLc9Re
Windsor.ai - geni.us/windsorai
Data Slayer: geni.us/dataslayer
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
🎥 MY TH-cam GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Mic - amzn.to/3t1n1aK
Lavalier Mic - amzn.to/3vVUi8V
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg - บันเทิง
🚀 BI CAREER STARTER PROGRAM 🚀
A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS.
Your new career starts here 👉🏻 geni.us/bicsp
The last one was super powerful 💯 Great Video
Adam, great channel and content, and yeah those hacks are really useful! Thank you.
You’re welcome!
Very helpful! Thank you
You're welcome!
So helpful
Terrific 🎉
Hey there, Glad to discover your channel.
I have a simple question as an sql newbie.
Do you advice me to produce report by using SQL in-built reporting services or should i consider crystal reports for any better features?
Thanks for taking care of this.
If you are going to be working almost exclusively with SQL then a SQL-centric reporting tool might be fine but if you’re going to be working with a variety of different data sources, you’ll probably want to consider something more versatile like Tableau, Power BI, Data Studio etc.
paste styles only! thank YoU!
You're welcome!
Hello, thanks for your videos. Do you know if it is possible to have looker in self-hosted instead of the cloud ?
Looker can be self hosted but I don’t think Looker Studio can.
Hi Adam! Great video! I have another question: when I am copying a report because I want one similar for another client, something strange happens, namely that when I am changing data source in the copy it applies in the origin report as well. How can I prevent that to happen? I would be more than happy for an answer as I am working with this now. :D Happy New Year!
As far as I'm aware, that isn't the normal behaviour when duplicating reports. What I would suggest after duplicating is to delete all data sources before adding new ones.
Thanks! can I adjust the height of the rows on a pivot table?
Did you mean to type your comment into the google search bar?
How to freeze header in looker studio dashboard?
Hi! Thanks for sharing. I have a question related to performance: I'm using Windsor AI to input my data from Google Ads and Meta Ads into Looker Studio but it makes editing reports terrific (in a bad way), is there anyway to make it run faster?
I’d recommend contacting Windsor support
Hi, amazing video
I have a question, how to make differen color to the text in different category. If normal it be green text, but if abnormal be red text, automaticly?
You would need to use conditional formatting. Is only available for certain visualization types so check the settings of your visualization to see if it’s available.
thanks so much @@LearnBI
How to use conditional formatting on a field based on a different field?
All of the conditional formatting options are there in the interface (Setup tab). If you can’t see them, they don’t exist.
How do we group filter on page 1 with a graph on page 2
support.google.com/looker-studio/answer/6291066?hl=en
How I will data font size increase in looker studio it is very little.
In the style tab to the right of the report when the visualization is selected.
How can I import Excel spreadsheets?
You can’t, you need to save Excel as CSV and use the file upload connector. Or you could upload to Google Drive and save as Google Sheet and use that connector.
@@LearnBI thanks
You’re welcome
i want to create a comparison report of conversion rate between new users and returning users. Is this possible? I mean how many users converted from new users count and how many converted from returning user count. Please help
I’m assuming you’re talking about Google Analytics? That kind of report is possible but much too complicated to explain in the comment of a TH-cam video. I’d suggested joining a Looker Studio Facebook group and asking your question there instead.
Could you please make a video on this
It’s not something a lot of people are looking for so probably not.
Actually one our client has asked us for such report. But it seems quite difficult for me to figure out.
Like I said, try asking in a Facebook group. Good luck!
Ciao, non trovo nessuno in grado di modificare il colore degli istogrammi in un grafico di datastudio, in base al valore positivo o negativo. Esempio blu se positivo, rosso se negativo. Tu ci riesci ?
Non è possibile applicare la formattazione condizionale a un semplice istogramma. Quello che potresti provare e utilizzare è un grafico a cascata dalle visualizzazioni della community, ma di solito viene utilizzato solo per casi d'uso specifici. Oppure usa una tabella e applica la formattazione condizionale.
Does anyone know how to export graphics in looker studio (png -jpg)
What do you mean by graphics?
Any way to put a password on a report url ?
No not in a url. There are workarounds for adding a password using parameters and filters but not directly in the url. Not sure why you’d want to do that anyway.