Danalyser
Danalyser
  • Видео 91
  • Просмотров 772 302
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 m...
Просмотров: 2 052

Видео

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,2 тыс.9 месяцев назад
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!
Просмотров 9939 месяцев назад
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!
Просмотров 21 тыс.Год назад
In this crash course RUclips 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 ...
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)
Просмотров 14 тыс.Год назад
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: ruclips.net/video/JbNMU1tb9ag/видео.html) ✅ Gain insights into ...
PROGRESS BAR in KPI SCORECARD! Looker Studio NEW Feature! (How to Create Scorecard 2023)
Просмотров 17 тыс.Год назад
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: ruclips.net/video/lNME-EeWJ-4/видео.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!
Просмотров 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
Просмотров 19 тыс.Год назад
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,2 тыс.Год назад
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 💰
Просмотров 487Год назад
Starting a RUclips Data Tech Channel for 609 days 🚀 | How much RUclips 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,5 тыс.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,6 тыс.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

Комментарии

  • @janacarvalhoo
    @janacarvalhoo 6 дней назад

    you are amazing! Thanks for the video 😃

  • @HarishMahale-y8n
    @HarishMahale-y8n 8 дней назад

    Is there a way to get the target value dynamically fetched from the data, say when different projects have different target values and we want to track the project progress basis that project's target value.

  • @JODigital-b3i
    @JODigital-b3i 10 дней назад

    Does this not work on blended data sources? Do you have another solution that would work for a blended data source?

  • @merichitrakari
    @merichitrakari 11 дней назад

    Very helpful video

  • @motumotu2675
    @motumotu2675 12 дней назад

    Do u have any course?

  • @bagus442
    @bagus442 14 дней назад

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

  • @wayneshort3647
    @wayneshort3647 16 дней назад

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

  • @PeterStoddard-c6m
    @PeterStoddard-c6m 17 дней назад

    Just what I was looking for. Thank you!

  • @PoojaShah-g4e
    @PoojaShah-g4e 19 дней назад

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

  • @sahandharmarathne8251
    @sahandharmarathne8251 19 дней назад

    Thank you so much

  • @DiziBrandTeam
    @DiziBrandTeam 21 день назад

    Please share to me this template

  • @Abouasmaaya
    @Abouasmaaya 22 дня назад

  • @vaidehivenkatesan4729
    @vaidehivenkatesan4729 Месяц назад

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

  • @amitgurav8495
    @amitgurav8495 Месяц назад

    Avoid unnecessary talks

  • @Jul-w4s
    @Jul-w4s Месяц назад

    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 2 месяца назад

    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 3 месяца назад

    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 3 месяца назад

    thanks ✅

  • @Darok6699
    @Darok6699 3 месяца назад

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

  • @arunamanipura3864
    @arunamanipura3864 3 месяца назад

    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 4 месяца назад

    Helpful!

  • @DeleciaSydnor
    @DeleciaSydnor 4 месяца назад

    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 4 месяца назад

    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 4 месяца назад

    OMG, THANK YOU SO MUCH FOR SHARING!!!

  • @grabtv4211
    @grabtv4211 4 месяца назад

    Please make more videos 😢😢😢

  • @carlo81624
    @carlo81624 4 месяца назад

    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 5 месяцев назад

    Best video on Looker, thanks!

  • @imbrandana
    @imbrandana 5 месяцев назад

    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