Danalyser
Danalyser
  • 91
  • 721 817
EXCLUSIVE TIPS: How to Customise WEEK Label in Looker Studio 2024! (Week Number + Date Ranges)
Are you struggling with overly long labels and space-consuming week labels on your Looker Studio dashboards? Check out this tutorial to make your dashboard looks clean and easy-to-read!
We'll be using a couple of DATETIME formulas to achieve this! Join us now!
- -
✅ This video is a FREE preview of my WWDT (Work with Date Time) course Module 4, designed to help the Looker community master date fields, visualizations, and more! We'll be doing this mini datetime course for 4 WEEKS consecutively! So be sure to subscribe and join us!
🔥 EARLY BIRD SPECIAL PROMO! 🔥 😍
If you're interested in our growing library of tutorials like this, you'll love our course WWDT. We are offering early bird price at more than 60% OFF for YOU!
Check out the WWDT Looker Studio course here:
👉 bit.ly/wwdt-yt-video 👈
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ th-cam.com/users/Danalyser
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
⭐️ NEW TO LOOKER STUDIO (GOOGLE DATA STUDIO)
Check out our FREE GLS Course here 👉 th-cam.com/video/dsAVSsdYC10/w-d-xo.html
We uses practical approach and covers almost everything you need to get started in Google Looker Studio! Take the course now and shine ✨
F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!
Try Canva Pro FREE for 30 days: partner.canva.com/danalyser
[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]
#GoogleLookerStudio #Danalyser #GoogleDataStudio
--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------
💌 W A T C H N E X T
⚈ Show current date in dashboard
👉 th-cam.com/video/EVQ_nW19eq0/w-d-xo.html
มุมมอง: 1 258

วีดีโอ

How to Calculate Days Until Today in Looker Studio Dynamically (Formula Included!)
มุมมอง 1.2K5 หลายเดือนก่อน
Learn how to calculate the days until today with ease in this tutorial. This calculation is very useful if you want to calculate metrics like "Days since customer last bought" - which is a great indication of customer loyalty. - - ✅ This video is a FREE preview of my WWDT (Work with Date Time) course Module 3, designed to help the Looker community master date fields, visualizations, and more! W...
Week 2: How to use PARSE_DATE Formula to fix the date formula in Looker Studio (From text to date)
มุมมอง 1.2K5 หลายเดือนก่อน
Are you tired of struggling with date formats in Looker Studio? Do you often find yourself fixing date fields recognized as mere text? if so, this video is the guide you need! 🌟 This video walkthrough begins with a step-by-step explanation of the PARSE_DATE function's syntax, breaking down each component to make it easily understandable. You'll learn how to specify the format string, crucial fo...
All You Need to Know about LOOKER STUDIO DATETIME! ⏰ Beginner guide to Looker Studio Dates!
มุมมอง 6325 หลายเดือนก่อน
Elevate your data game with Looker Studio's Date Fields! 🗓️ Uncover the secrets 🤫 to creating dynamic, insightful visualizations using automatic date hierarchies, specialized date filters, and easy formatting options. See why getting your data types right is the key 🔑 to unlocking Looker Studio's full potential! - - ✅ This video is a FREE preview of my WWDT (Work with Date Time) course - Module...
Dashboarding has never been so EASY! 🔥 Google Looker Studio + Chatgpt Crash Course in 25 Min!
มุมมอง 17Kปีที่แล้ว
In this crash course TH-cam video, we're diving into the exciting world of data analysis and visualization using Looker Studio. But guess what? We've got an awesome helper with us - Chat GPT! 🚀 🌼 We'll start by introducing you to the basics of data analysis, data visualization, and data prepping in Looker Studio. Don't worry if you're new to this - we've got you covered! 🌼 But here's the cool p...
Advanced Data Filtering with Looker Studio Buttons: Step-by-Step Guide
มุมมอง 18Kปีที่แล้ว
In this engaging tutorial, learn how to supercharge your data analysis with Looker Studio's new button feature. In this tutorial, you’ll learn ✅ How to create a filter button ✅ How to write Boolean expression for control field (single condition) ✅ How to write Boolean expression for control field (multiple condition) ✅ How to group filters (Timestamps available below) Sorry I made a mistake tha...
Unlock 🔓 Looker Studio Scorecard Potential😍 Visualise Key Metrics in 3 EASY way (Google Data Studio)
มุมมอง 12Kปีที่แล้ว
In this video, we take a deep dive into Looker Studio's scorecards, revealing their practical applications and how they can enhance your reporting efforts 🔥 Join us as we explore three key use cases that will revolutionize the way you analyze data. We'll show you how to: ✅ Track progress toward targets (Detailed tutorial available: th-cam.com/video/JbNMU1tb9ag/w-d-xo.html) ✅ Gain insights into ...
PROGRESS BAR in KPI SCORECARD! Looker Studio NEW Feature! (How to Create Scorecard 2023)
มุมมอง 14Kปีที่แล้ว
In this Looker Studio (Google Data Studio) tutorial, we explore the exciting new features of the scorecard chart, focusing on the latest update that allows you to create stunning progress bars. This allows you to compare your actual stats vs a target that can be set manually / dynamically in the scorecard chart settings. Discover the essential steps to create impactful scorecards in Looker Stud...
I Scraped All My Youtube Videos 👾 No Installation Needed! 👩‍💻 Selenium, BeautifulSoup, Google Colab
มุมมอง 1.1Kปีที่แล้ว
In this video, I attempted to crawl my own youtube channel to extract all the videos content. I know how frustrating to encounter challenges installing stuff locally before even start writing a single line of code. Hence, I tried using Google Colab to eliminate the need to install anything on your local computer. Once you get the script, you can start your web-scraping experiments! 🎉 Happy Scra...
BUILD APP in LOOKER STUDIO❓❗️ Easy Project to Build Your Portfolio 👩‍💻 (1 Hour Complete Tutorial)
มุมมอง 6Kปีที่แล้ว
Join my membership to get the resources 👉 subscribepage.io/the-analysts-membership (Currently at 50% OFF to welcome new members! Registration closed & promo ended on June 1st) Buy one-time off access to the resources 👉 bit.ly/415c0mc (You can purchase this at all time) In Part 1 of this series, we'll be building an application using Looker Studio. This is a Resource Library Dashboard where the ...
AUTOMATE your CUSTOM URL LINKS Generation with Calculated Field (Formula: HYPERLINK, CONCAT)
มุมมอง 4.5Kปีที่แล้ว
In Part 1 tutorial last week, you've learned how to generate a custom bookmark URL link with one or multiple filter conditions MANUALLY. In this video, you'll use simple formula to AUTOMATE the link generations for you! Watch to learn the trick! 🎉 About BOOKMARK URL SEE PART 1 VIDEO HERE: th-cam.com/video/lNME-EeWJ-4/w-d-xo.html Special Thanks to @Vision-Labs for sharing the solution in their v...
HOW TO FORMAT COMMON DATA TYPES in Google Looker (Data) Studio: Time, Currency, % and more!
มุมมอง 12Kปีที่แล้ว
This video tutorial covers how to format 5 common data types in Looker Studio (Google Data Studio), including time duration, currency, percentage, year-month, and week. If you are facing challenges with formatting values in LS, this is your best reference! ▶ On top of that, we would also share with you the best practice you should know when you format data in Looker Studio, so that you can save...
SAVE your FILTERED REPORT with Custom Bookmark (URL LINKS) - Looker Studio Tutorials/Data Studio
มุมมอง 6Kปีที่แล้ว
Do you know you can save your REPORT VIEW easily in Looker Studio with URL Link? Watch to find out more! 💛 In this quick tutorial (PART 1), you'll learn how to generate the custom bookmark link as a report developer. If you're the report viewers/users instead, you may be able to figure out if the feature has been turned on by the developer and learn how to bookmark your preferred view with a un...
CHALLENGE 🔥 - SUMIF Function in Looker Studio | Calculate SUM based on Multiple Conditions / Rules
มุมมอง 17Kปีที่แล้ว
How to use SUM IF formula in Looker Studio? (a.k.a. Google Data Studio). In this video, we cover 4 EXAMPLES to help you understand how to translate your business rules into formulas. I decided to make today's video more interesting, by incorporating a popular Data Science dataset. I'll come out with 4 questions (quiz) that you could answer using the dataset. I hope it makes your GDS learning ea...
TIME SAVING TRICKS in Looker Studio (Google Data Studio) 🙌🏻 GLS Productivity Tips Part 2
มุมมอง 3.5Kปีที่แล้ว
TIME SAVING TRICKS in Looker Studio (Google Data Studio) 🙌🏻 GLS Productivity Tips Part 2
5 Productivity Tips to Work Efficiently in Looker Studio and any other BI Tools! 🚀 (PART 1)
มุมมอง 1.9Kปีที่แล้ว
5 Productivity Tips to Work Efficiently in Looker Studio and any other BI Tools! 🚀 (PART 1)
Starting a Youtube Data Tech Channel for 609 days 🚀 | How much Youtube Paid me in 2022 💰
มุมมอง 464ปีที่แล้ว
Starting a TH-cam Data Tech Channel for 609 days 🚀 | How much TH-cam Paid me in 2022 💰
Animated Bar Chart 📊 Without Coding in Google Data Studio For Free (+ Example & Easy Tutorial)
มุมมอง 8Kปีที่แล้ว
Animated Bar Chart 📊 Without Coding in Google Data Studio For Free ( Example & Easy Tutorial)
2-IN-1 PIVOT TABLE TUTORIAL - Build Google Sheets Pivot Tables in Google Data Studio w/ 3 Examples
มุมมอง 3.7Kปีที่แล้ว
2-IN-1 PIVOT TABLE TUTORIAL - Build Google Sheets Pivot Tables in Google Data Studio w/ 3 Examples
How to - Format Date / Datetime / Timestamp with FORMAT_DATETIME() Formula - 5 EXAMPLES INCLUDED 🎉
มุมมอง 8K2 ปีที่แล้ว
How to - Format Date / Datetime / Timestamp with FORMAT_DATETIME() Formula - 5 EXAMPLES INCLUDED 🎉
How I Calculate Weekly (WoW) Growth Rate in Data Studio Using Data Blend (Self Join Method Example)
มุมมอง 19K2 ปีที่แล้ว
How I Calculate Weekly (WoW) Growth Rate in Data Studio Using Data Blend (Self Join Method Example)
Google Sheets - Combine Data From Multiple Worksheets (Tabs) into ONE ⇨ Filter ⇨ Sort (➕ Example)
มุมมอง 7K2 ปีที่แล้ว
Google Sheets - Combine Data From Multiple Worksheets (Tabs) into ONE ⇨ Filter ⇨ Sort (➕ Example)
Simple Way to Build Data Comparison Tool in Data Studio: Apply Filter to Specific Charts (GDS Tips)
มุมมอง 6K2 ปีที่แล้ว
Simple Way to Build Data Comparison Tool in Data Studio: Apply Filter to Specific Charts (GDS Tips)
A Case Study: Advanced Data Transformation in Google Sheets for Data Studio | Accumulated Percentage
มุมมอง 2.3K2 ปีที่แล้ว
A Case Study: Advanced Data Transformation in Google Sheets for Data Studio | Accumulated Percentage
DATE FUNCTION | How to show Yesterday Date in Data Studio ✅ Formulas Provided 🎉
มุมมอง 4.2K2 ปีที่แล้ว
DATE FUNCTION | How to show Yesterday Date in Data Studio ✅ Formulas Provided 🎉
Generate Flag Images to Google Data Studio Table Charts Dynamically [Calculated Field Tutorial]
มุมมอง 1.9K2 ปีที่แล้ว
Generate Flag Images to Google Data Studio Table Charts Dynamically [Calculated Field Tutorial]
GDS Dynamic Date Comparison in Table Chart (Compare to Previous Period)
มุมมอง 7K2 ปีที่แล้ว
GDS Dynamic Date Comparison in Table Chart (Compare to Previous Period)
WORDCLOUD Tutorial for Google Data Studio + Custom Visualisation Add-On + Practice Dataset
มุมมอง 6K2 ปีที่แล้ว
WORDCLOUD Tutorial for Google Data Studio Custom Visualisation Add-On Practice Dataset
Account & Password Manager in Google Sheets : Track Multiple Accounts for Unlimited Clients!
มุมมอง 3K2 ปีที่แล้ว
Account & Password Manager in Google Sheets : Track Multiple Accounts for Unlimited Clients!
DATA BLEND TUTORIAL: How to create groupings based on aggregated metrics in Google Data Studio
มุมมอง 5K2 ปีที่แล้ว
DATA BLEND TUTORIAL: How to create groupings based on aggregated metrics in Google Data Studio

ความคิดเห็น

  • @ShahAnkit-f7o
    @ShahAnkit-f7o 2 วันที่ผ่านมา

    Thank you so much for such a detailed video. This is exactly what I was looking for, url with filter option

  • @semponmanickam5924
    @semponmanickam5924 6 วันที่ผ่านมา

    Can you please create Month over Month Report for Clicks?

  • @kennethgarcia1178
    @kennethgarcia1178 8 วันที่ผ่านมา

    ❤❤❤

  • @Travelvia-nx2sx
    @Travelvia-nx2sx 10 วันที่ผ่านมา

    The best data visualisation presentation ever! Keep it up, you're number one👍

  • @agung_laksana
    @agung_laksana 11 วันที่ผ่านมา

    Hi, can I get the start date and end date from date range filter in calculated field formula?

  • @healthadvice3091
    @healthadvice3091 12 วันที่ผ่านมา

    you`re cute

  • @NitishJagadeskumar
    @NitishJagadeskumar 13 วันที่ผ่านมา

    Can you please share sample data excel

  • @StanleyTNQ
    @StanleyTNQ 17 วันที่ผ่านมา

    Helpful!

  • @DeleciaSydnor
    @DeleciaSydnor 18 วันที่ผ่านมา

    Hi, how can we set targets when filters are applied? If I have a target for a whole class to be 1000, but I want that to change when I select a student. How to get it to update. Thank you!

  • @navsaridapcu8212
    @navsaridapcu8212 18 วันที่ผ่านมา

    i need day copunt user wise like 1 Jul, 2024 to 31 Jul, 2024 Total day Person Day Count Name 1 29 Name 2 27 Name 3 31 PLS HELP ME I SHOW IN MY TABLE GOOGLE STUDIO

  • @viniciusgmdcompany
    @viniciusgmdcompany 19 วันที่ผ่านมา

    OMG, THANK YOU SO MUCH FOR SHARING!!!

  • @grabtv4211
    @grabtv4211 25 วันที่ผ่านมา

    Please make more videos 😢😢😢

  • @carlo81624
    @carlo81624 28 วันที่ผ่านมา

    Can this be done on a table?

  • @rpsinghsethi
    @rpsinghsethi หลายเดือนก่อน

    I want to add only 100 blogs😂data of last month then how do ido this?

  • @MohammadMoniruzzaman-b3f
    @MohammadMoniruzzaman-b3f หลายเดือนก่อน

    Thank you so much, @Danalyser. This is more and more helpful for me.

  • @ren.aldamia
    @ren.aldamia หลายเดือนก่อน

    Hi this is really helpful thanks a lot. But I have a question, hopefully you can read this comment, what if in our data set has another column for example marketplace in where the order happen, how can I add the marketplace as metric so that it will not be treated as number? I want to include this marketplace so that I can able to use filter button on the charts and table.

  • @nickarrigo5540
    @nickarrigo5540 หลายเดือนก่อน

    Thank you! Very helpful.

  • @VladVlad-un5xz
    @VladVlad-un5xz หลายเดือนก่อน

    It's not working now. I see only the "Data set configuration error".

  • @gekonomicus
    @gekonomicus หลายเดือนก่อน

    Best video on Looker, thanks!

  • @imbrandana
    @imbrandana หลายเดือนก่อน

    This is great! Thank you! Can you help me apply a date range filter to the URL string somehow? I just want to auto-set the date in links if there is a way to select a specific range or even just a single month from the calendar and year, if able to specify in the URL string.

  • @AbdulRahim-tl7tm
    @AbdulRahim-tl7tm 2 หลายเดือนก่อน

    Love your channel

  • @charmingtv5970
    @charmingtv5970 2 หลายเดือนก่อน

    It works!!!!

  • @GabrielleFrater-Schmid
    @GabrielleFrater-Schmid 2 หลายเดือนก่อน

    Thanks, this has been super helpful

  • @user-gq6wi4ul2v
    @user-gq6wi4ul2v 2 หลายเดือนก่อน

    How do i change the week duration to be a friday to thursday instead of other days?

  • @sivakumarak8999
    @sivakumarak8999 2 หลายเดือนก่อน

    This is very useful! Is there a way to have the Total value is fixed even if apply filters?

  • @gangavarapujaisaideep3015
    @gangavarapujaisaideep3015 2 หลายเดือนก่อน

    Hello! I am trying to have a dynamic title as suggested in my own use case. But I am unable to implement it. The formula IF(COUNT_DISTINCT(COUNTRY)>1,"MUKTIPLE",MAX(COUNTRY)) is not working. Can you help

  • @vossa0
    @vossa0 2 หลายเดือนก่อน

    Great video! thanks for sharing. There is an issue though one you share links and you want only to give partial views, the user can always click uptop on the "Reset" button and the dashboard will reset all filters, showing all information. Any idea how that could be solved?

  • @gauravkumar-sh2sf
    @gauravkumar-sh2sf 2 หลายเดือนก่อน

    Hi dear, I am not able to download the sample data. The website link says: Dear visitor, You're not allowed to access this store. Please help.

  • @dwingirl6064
    @dwingirl6064 2 หลายเดือนก่อน

    Sis, can you make a tutorial on making a dashboard about visualizing environmental pollution data using Google Looker Studio?

  • @dwingirl6064
    @dwingirl6064 2 หลายเดือนก่อน

    Sis, can you make a tutorial on making a dashboard about visualizing environmental pollution data using Google Looker Studio?

  • @dhinabastarirochim3407
    @dhinabastarirochim3407 2 หลายเดือนก่อน

    Hello, thankyou for sharing this. i wanna ask something, how the barchart color of the progress responsible can be set based on the progress, e.g. progress 0% to 30% yellow in looker studio? this for my project, so i hope you read my comment

  • @travis37115
    @travis37115 2 หลายเดือนก่อน

    Yeah, I was about to say um….. the NFL doesn’t have a World Cup. Wrong sport Love!

  • @ggeofani6048
    @ggeofani6048 2 หลายเดือนก่อน

    hi, its possible to make a button to download a dasboard report as a image?

  • @anirbanmodak4791
    @anirbanmodak4791 2 หลายเดือนก่อน

    I have 2 google sheets say GS1 and GS2 as my Data Sources. GS1 has Email Campaign Log Data (from Service Provider: Twilio) for individual email Id's. GS2 has Employee Name and Org Name for individual email Id's. The GS1 sheet has all the data to Create the Campaign Tracking Report. But If the Marketing Manager wants to hover the mouse on an email and wants to see the Name & Org Name, then a lookup into the GS2 sheet will be required. Is this feasible in Looker ? If yes, may I get a Video link, where we can achieve this ?

  • @anirbanmodak4791
    @anirbanmodak4791 2 หลายเดือนก่อน

    You have done a great job. I (as a beginner) liked a lot.

  • @SudarshanShrikantAtwe
    @SudarshanShrikantAtwe 3 หลายเดือนก่อน

    i have created a category from metric nut it is taking the category as metric i want it as a dimension, i tried cast function but it did not helped, can you help me?

  • @ramzidjauhari3829
    @ramzidjauhari3829 3 หลายเดือนก่อน

    Hi SL... Can you help me, how if I want to have a time-series-chart (or a table) of percentage of something monthly? I've tried to use the 100%-stacked-area-chart, it went well. But I want it to be visualized using a time-series (or a table), so I can see the trend of each of fruit. I can not draw the chart, but I want the table looks like below this. The table consists of the sum of each fruit in a month and the proportional percentage. Thank you. the raw-data: Timestamp |. Fruit. |. Sum. | Jan-2024 | Banana | 10 | Jan-2024 | Apple | 20 | Jan-2024 | Mango | 70 | Feb-2024 | Banana | 30 | Feb-2024 | Apple | 50 | Feb-2024 | Mango | 80 | Mar-2024 | Banana | 80 | Mar-2024 | Apple | 100 | Mar-2024 |. Mango. |. 100. | The table I want to be look like: Fruit | Jan-2024 | Feb-2024 | Mar-2024 | Banana. |. 10. | 10% |. 30. | 19% | 80. |. 28% | Apple. |. 20 |. 20%. |. 50. | 31% |. 100. |. 36%. | Mango. |. 70 |. 70%. |. 80. | 50% |. 100. |. 36%. | Thank you very much

  • @faradillaalvionita351
    @faradillaalvionita351 3 หลายเดือนก่อน

    Thank you so much. It helps me a lot! Btw, how to adjust a column in Looker Studio? Example there are 4 column but when we click a filter, there will shown 5 column. Tia!

  • @logesh8501
    @logesh8501 3 หลายเดือนก่อน

    please continue making videos

  • @ElectronicBarta
    @ElectronicBarta 3 หลายเดือนก่อน

    so difficult.... can you explain easy............. please

  • @danielpenteado
    @danielpenteado 3 หลายเดือนก่อน

    i was expecting to see how the data structure

  • @logesh8501
    @logesh8501 3 หลายเดือนก่อน

    Thank you very much !!!

  • @RoemmersDatosMedicos
    @RoemmersDatosMedicos 3 หลายเดือนก่อน

    Hi, great video, can you help me with this? Hi I have these values: Product | Sales | Price A 1500 10 B 5000 15 C 250 25 D 1700 30 Leader sales product price is 15 Want to get Product | Sales | Price | Price Diff A 1500 10 -33% B 5000 15 0% C 250 25 67% D 1700 30 100% How do i achieve this in looker studio using all my dimensions values? Thank you!

  • @alfonsosanchezramirez442
    @alfonsosanchezramirez442 3 หลายเดือนก่อน

    ERES MUY BUENA, GRACIAS POR TU APORTE ME SIRVIO MUCHISIMO

  • @RaviKumar-pr2by
    @RaviKumar-pr2by 3 หลายเดือนก่อน

    Excellent course to the point..i want to see more custom big formulas like in Power BI using of math and analytics but its a very good start for me as a beginner as excel got hanged when there is so much data and with lots of formulas you course give me the confidence to start and its little lengthy but worth it and other like 20 or 15 mintes dashboard ready but they don't give the depth as a beginner to start Thanks and Blessed you Danalyser..

  • @pixelharmonie-webdesign
    @pixelharmonie-webdesign 3 หลายเดือนก่อน

    Thats sooooo awesome! In the past i used i d self generated php file... dirty way... but u bring the clean way ♥

  • @alyaqasrina2354
    @alyaqasrina2354 3 หลายเดือนก่อน

    hi, can i know why my image does not appear? i took the image link from google btw.

  • @stonesgoods8100
    @stonesgoods8100 3 หลายเดือนก่อน

    The formula we are all looking for is DATETIME_SUB(TODAY("-08"),interval 1 DAY) Great video. Wish you had put that in the video description.

  • @ZinaAl-Taie
    @ZinaAl-Taie 4 หลายเดือนก่อน

    what about formatting the data label %s to 0 decimal within 100% staked bar chart?

  • @EilayThinzar
    @EilayThinzar 4 หลายเดือนก่อน

    How to Data studio Metric Sum Formula