Danalyser
Danalyser
  • 91
  • 766 166
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 @ ua-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 👉 ua-cam.com/video/dsAVSsdYC10/v-deo.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
👉 ua-cam.com/video/EVQ_nW19eq0/v-deo.html
Переглядів: 1 952

Відео

How to Calculate Days Until Today in Looker Studio Dynamically (Formula Included!)
Переглядів 1,8 тис.8 місяців тому
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)
Переглядів 2,1 тис.8 місяців тому
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!
Переглядів 9488 місяців тому
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!
Переглядів 20 тис.Рік тому
In this crash course UA-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
Переглядів 22 тис.Рік тому
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)
Переглядів 13 тис.Рік тому
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: ua-cam.com/video/JbNMU1tb9ag/v-deo.html) ✅ Gain insights into g...
PROGRESS BAR in KPI SCORECARD! Looker Studio NEW Feature! (How to Create Scorecard 2023)
Переглядів 16 тис.Рік тому
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,3 тис.Рік тому
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)
Переглядів 6 тис.Рік тому
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)
Переглядів 5 тис.Рік тому
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: ua-cam.com/video/lNME-EeWJ-4/v-deo.html Special Thanks to @Vision-Labs for sharing the solution in their vi...
HOW TO FORMAT COMMON DATA TYPES in Google Looker (Data) Studio: Time, Currency, % and more!
Переглядів 13 тис.Рік тому
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
Переглядів 7 тис.Рік тому
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
Переглядів 18 тис.Рік тому
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,8 тис.Рік тому
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)
Переглядів 2,1 тис.Рік тому
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 💰
Переглядів 485Рік тому
Starting a UA-cam Data Tech Channel for 609 days 🚀 | How much UA-cam Paid me in 2022 💰
Animated Bar Chart 📊 Without Coding in Google Data Studio For Free (+ Example & Easy Tutorial)
Переглядів 9 тис.2 роки тому
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,9 тис.2 роки тому
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 🎉
Переглядів 8 тис.2 роки тому
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)
Переглядів 20 тис.2 роки тому
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)
Переглядів 8 тис.2 роки тому
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)
Переглядів 6 тис.2 роки тому
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,4 тис.2 роки тому
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,5 тис.2 роки тому
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]
Переглядів 2,1 тис.2 роки тому
Generate Flag Images to Google Data Studio Table Charts Dynamically [Calculated Field Tutorial]
GDS Dynamic Date Comparison in Table Chart (Compare to Previous Period)
Переглядів 7 тис.2 роки тому
GDS Dynamic Date Comparison in Table Chart (Compare to Previous Period)
WORDCLOUD Tutorial for Google Data Studio + Custom Visualisation Add-On + Practice Dataset
Переглядів 7 тис.2 роки тому
WORDCLOUD Tutorial for Google Data Studio Custom Visualisation Add-On Practice Dataset
Account & Password Manager in Google Sheets : Track Multiple Accounts for Unlimited Clients!
Переглядів 3,3 тис.2 роки тому
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
Переглядів 5 тис.2 роки тому
DATA BLEND TUTORIAL: How to create groupings based on aggregated metrics in Google Data Studio

КОМЕНТАРІ

  • @bagus442
    @bagus442 21 годину тому

    Thanks a lot, finally i have done this course, try to make one for my job

  • @wayneshort3647
    @wayneshort3647 2 дні тому

    This video assisted me in getting a project ready to scale to 2000 clients, thank you so much !

  • @PeterStoddard-c6m
    @PeterStoddard-c6m 4 дні тому

    Just what I was looking for. Thank you!

  • @PoojaShah-g4e
    @PoojaShah-g4e 5 днів тому

    Could we also have a video on how can we add google adwords ad label in google data studio

  • @sahandharmarathne8251
    @sahandharmarathne8251 6 днів тому

    Thank you so much

  • @DiziBrandTeam
    @DiziBrandTeam 8 днів тому

    Please share to me this template

  • @Abouasmaaya
    @Abouasmaaya 9 днів тому

  • @vaidehivenkatesan4729
    @vaidehivenkatesan4729 24 дні тому

    Thank you for this detailed video! This is a life saver!

  • @amitgurav8495
    @amitgurav8495 24 дні тому

    Avoid unnecessary talks

  • @Jul-w4s
    @Jul-w4s 26 днів тому

    Thanks for your video. It helped me to convert one date into the correct format. But I am struggling to convert a bunch of dates for one chart, for example.

  • @nabatin
    @nabatin Місяць тому

    Im stuck on my data for 2 days. And you were help me. Thanks a lot

  • @JafetNet
    @JafetNet Місяць тому

    I tried this to get the total number of sessions from source/medium = google/cpc and I got an error. How can you get a score card with a filter just of sessions from a certain channel?

  • @TheCoolsparks
    @TheCoolsparks Місяць тому

    Thanks for this will try it later. Im also interested in the translation of language course

  • @vjr3503
    @vjr3503 Місяць тому

    Hi do you know how to automate webscrapping with google collab?

  • @NgynAn-dg3kp
    @NgynAn-dg3kp Місяць тому

    Hi is there a github repo of the notebook in the video

  • @marlenecodes
    @marlenecodes Місяць тому

    Out of curiosity, which video recording application are you using? and also brand for camera and mic? would you recommend?

  • @romanyastreb2542
    @romanyastreb2542 Місяць тому

    thanks for the video. Helped me a lot also :)

  • @anindanr
    @anindanr Місяць тому

    Thank you so much for this!!! 💕

  • @axonide7437
    @axonide7437 Місяць тому

    Thankyou, verymuch i watch every single videos u made about looker studio and it really helped me out to master lookerstudio! I'm waiting for the new videos comin out :)

  • @ridhoilhamdpk
    @ridhoilhamdpk 2 місяці тому

    Hi SL nice tutorial, and i want to know more, can you explain for example how many average order in a week/in a day with scorecard chart?

  • @thechesstrain528
    @thechesstrain528 2 місяці тому

    thanks ✅

  • @Darok6699
    @Darok6699 2 місяці тому

    Thank you so much for the time you spend making this video you saved me :D Gracias!

  • @arunamanipura3864
    @arunamanipura3864 2 місяці тому

    An excellent tutorial which I thoroughly enjoyed by following and applying to my requirements. Thanks very much.

  • @ShahAnkit-f7o
    @ShahAnkit-f7o 3 місяці тому

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

  • @semponmanickam5924
    @semponmanickam5924 3 місяці тому

    Can you please create Month over Month Report for Clicks?

  • @kennethgarcia1178
    @kennethgarcia1178 3 місяці тому

    ❤❤❤

  • @Travelvia-nx2sx
    @Travelvia-nx2sx 3 місяці тому

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

  • @agung_laksana
    @agung_laksana 3 місяці тому

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

  • @healthadvice3091
    @healthadvice3091 3 місяці тому

    you`re cute

  • @NitishJagadeskumar
    @NitishJagadeskumar 3 місяці тому

    Can you please share sample data excel

  • @StanleyTNQ
    @StanleyTNQ 3 місяці тому

    Helpful!

  • @DeleciaSydnor
    @DeleciaSydnor 3 місяці тому

    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 3 місяці тому

    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 3 місяці тому

    OMG, THANK YOU SO MUCH FOR SHARING!!!

  • @grabtv4211
    @grabtv4211 3 місяці тому

    Please make more videos 😢😢😢

  • @carlo81624
    @carlo81624 3 місяці тому

    Can this be done on a table?

  • @rpsinghsethi
    @rpsinghsethi 4 місяці тому

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

  • @MohammadMoniruzzaman-b3f
    @MohammadMoniruzzaman-b3f 4 місяці тому

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

  • @ren.aldamia
    @ren.aldamia 4 місяці тому

    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 4 місяці тому

    Thank you! Very helpful.

  • @gekonomicus
    @gekonomicus 4 місяці тому

    Best video on Looker, thanks!

  • @imbrandana
    @imbrandana 4 місяці тому

    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 5 місяців тому

    Love your channel

  • @charmingtv5970
    @charmingtv5970 5 місяців тому

    It works!!!!

  • @GabrielleFrater-Schmid
    @GabrielleFrater-Schmid 5 місяців тому

    Thanks, this has been super helpful

  • @AzizSyed-t6v
    @AzizSyed-t6v 5 місяців тому

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

  • @sivakumarak8999
    @sivakumarak8999 5 місяців тому

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

  • @gangavarapujaisaideep3015
    @gangavarapujaisaideep3015 5 місяців тому

    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 5 місяців тому

    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 5 місяців тому

    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.