- 75
- 18 620
datadice
เข้าร่วมเมื่อ 14 ธ.ค. 2021
Dive into the world of data - Your ultimate guide for Digital Analytics!
On our channel, Thomas, Alex, and Ricardo talk about data. Here we give the latest releases, know-how, and best practices for tools like BigQuery, Dataform, Looker Studio, Google Analytics, and Google Tag Manager.
The mission of datadice is to educate and assist businesses in the decision-making process by mining the correct information to grow their business from the pool of complex data ranging from e-commerce, CRM, and user behavior data from the website. We also assist companies in developing a data strategy and dynamic way of handling large sets of data in the most straightforward way possible through BigQuery, Y42, and Data Studio.
Be sure to subscribe to our weekly videos to help inspire you and to make data-driven decisions.
If there’s anything else you’d like to know, please do get in touch via our email solutions@datadice.io.
On our channel, Thomas, Alex, and Ricardo talk about data. Here we give the latest releases, know-how, and best practices for tools like BigQuery, Dataform, Looker Studio, Google Analytics, and Google Tag Manager.
The mission of datadice is to educate and assist businesses in the decision-making process by mining the correct information to grow their business from the pool of complex data ranging from e-commerce, CRM, and user behavior data from the website. We also assist companies in developing a data strategy and dynamic way of handling large sets of data in the most straightforward way possible through BigQuery, Y42, and Data Studio.
Be sure to subscribe to our weekly videos to help inspire you and to make data-driven decisions.
If there’s anything else you’d like to know, please do get in touch via our email solutions@datadice.io.
BigQuery CASE WHEN Function
Learn how to use the CASE WHEN function in BigQuery to handle conditional logic in your SQL queries. This tutorial will walk you through the basics, showing you how to simplify your data analysis with easy-to-follow examples.
Keywords:
#BigQuerySQL #SQLFunctions #BigQueryTips #DataScience #SQLQuery #GoogleBigQuery #LearnSQL #SQLforBeginners #DataAnalytics #BigQueryConditionalLogic #TechTutorial #DataEngineering #BigQueryCaseWhen #SQLBasics #CloudData #BigQueryGuide
Company Website: www.datadice.io/
Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): bit.ly/3qqJKeX
Keywords:
#BigQuerySQL #SQLFunctions #BigQueryTips #DataScience #SQLQuery #GoogleBigQuery #LearnSQL #SQLforBeginners #DataAnalytics #BigQueryConditionalLogic #TechTutorial #DataEngineering #BigQueryCaseWhen #SQLBasics #CloudData #BigQueryGuide
Company Website: www.datadice.io/
Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): bit.ly/3qqJKeX
มุมมอง: 37
วีดีโอ
BigQuery CAST | SAFE_CAST Operation
มุมมอง 11114 วันที่ผ่านมา
Learn how to use the CAST function in BigQuery to convert data types for better analysis and performance. In this quick tutorial, we'll cover common use cases, syntax, and tips for using CAST effectively in your SQL queries. Whether you're handling numbers, strings, or dates, mastering CAST will help you manipulate your data with ease! Keywords: #BigQueryCASTOperation #CASTFunctionBigQuery #Big...
BigQuery Multiple Queries | WITH
มุมมอง 117หลายเดือนก่อน
Learn how to use multiple queries with WITH #bigquery #sql #bigdatasolutions Company Website: www.datadice.io/ Follow us: Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): bit.ly/3trJPRr LinkedIn (stay informed about most important company news): bit.ly/3qqJKeX
BigQuery DATE & TIME Functions|EXTRACT, TRUNC, FORMAT, PARSE
มุมมอง 163หลายเดือนก่อน
Learn how to use date and time functions in BigQuery. Company Website: www.datadice.io/ Follow us: Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): bit.ly/3trJPRr LinkedIn (stay informed about most important company news): bit.ly/3qqJKeX Timestamps: 2:00: CURRENT DATE and TIME 4:30: DATE 5:10: EXTRACT 7:...
BigQuery String Functions | UPPER, LOWER, LEFT, RIGHT, SUBSTR
มุมมอง 27หลายเดือนก่อน
Learn how to use string functions in BigQuery. Keywords: BigQuery join tutorial, SQL join types, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SQL join keys, BigQuery data manipulation, SQL data types, handle NULL values in SQL, Bike Share data example, BigQuery SQL tutorial, data analytics, SQL for beginners, advanced SQL joins, BigQuery SQL course, optimize BigQuery queries Company Website: w...
BigQuery JOIN Operation | FULL JOIN, LEFT JOIN, INNER JOIN
มุมมอง 802 หลายเดือนก่อน
Learn how to master SQL joins in BigQuery with this comprehensive tutorial! We cover INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN with practical examples using Bike Share data. Perfect for beginners and advanced users looking to enhance their data manipulation skills. Explore the importance of join keys, data types, and handling NULL values. Boost your SQL knowledge and optimize your BigQue...
BigQuery HAVING Statement | Tutorial for Beginners
มุมมอง 633 หลายเดือนก่อน
Learn how to effectively use the HAVING statement in SQL with our beginner-friendly BigQuery tutorial. Understand the key differences between HAVING and WHERE, and see practical examples of filtering aggregated data. Perfect for those looking to master SQL aggregation functions. Watch now for expert tips and detailed explanations! Company Website: www.datadice.io/ Follow us: Medium (blog posts ...
BigQuery Aggregation Function: AVG, SUM, MIN, MAX and COUNT
มุมมอง 753 หลายเดือนก่อน
Learn how to use BigQuery's aggregation functions like AVG, SUM, MIN, MAX, and COUNT in SQL to analyze and summarize data effectively. This tutorial covers practical examples, combining these functions with the GROUP BY statement for comprehensive data insights. Ideal for enhancing your SQL skills and understanding essential data aggregation techniques. Chapters: 0:26 Introduction to Aggregatio...
BigQuery Group By Statement and COUNT Function
มุมมอง 824 หลายเดือนก่อน
In this video, we'll explore the GROUP BY statement and the COUNT function in BigQuery. Perfect for beginners and those looking to enhance their SQL skills, this tutorial will guide you step-by-step through using GROUP BY for effective data aggregation. What You'll Learn: How to use the GROUP BY statement in BigQuery The difference between GROUP BY and SELECT DISTINCT Practical examples of usin...
BigQuery WHERE Statement (Part 2), LIKE, NULL, REGEXP_CONTAINS
มุมมอง 625 หลายเดือนก่อน
BigQuery WHERE Statement (Part 2), LIKE, NULL, REGEXP_CONTAINS
BigQuery ORDER BY Statement | Tutorial for Beginners
มุมมอง 546 หลายเดือนก่อน
BigQuery ORDER BY Statement | Tutorial for Beginners
BigQuery Where Statement (Part 1) | Tutorial of Beginners
มุมมอง 726 หลายเดือนก่อน
BigQuery Where Statement (Part 1) | Tutorial of Beginners
BigQuery SELECT * FROM |Tutorial For Beginners
มุมมอง 1098 หลายเดือนก่อน
BigQuery SELECT * FROM |Tutorial For Beginners
💻 Google Tag Manager (GTM) #1 - Overview, DataLayer, Server Tracking
มุมมอง 153ปีที่แล้ว
💻 Google Tag Manager (GTM) #1 - Overview, DataLayer, Server Tracking
🪜 Looker Studio Best Practices #11 - Default vs. Custom Navigation
มุมมอง 107ปีที่แล้ว
🪜 Looker Studio Best Practices #11 - Default vs. Custom Navigation
📰 NEW BigQuery & Looker Studio Features 2023 - Execution Graphs, Lineage, Append
มุมมอง 106ปีที่แล้ว
📰 NEW BigQuery & Looker Studio Features 2023 - Execution Graphs, Lineage, Append
♻️ NEW Tag Manager & GA4 Features 2023 - Tag Coverage, Enhanced Measurements, Landing Page Reports
มุมมอง 143ปีที่แล้ว
♻️ NEW Tag Manager & GA4 Features 2023 - Tag Coverage, Enhanced Measurements, Landing Page Reports
Data Studio Best Practices #10 - Dashboard and data source permissions
มุมมอง 103ปีที่แล้ว
Data Studio Best Practices #10 - Dashboard and data source permissions
🆕 Start a new BigQuery & LookerStudio project. ASK these questions first!
มุมมอง 191ปีที่แล้ว
🆕 Start a new BigQuery & LookerStudio project. ASK these questions first!
Google Analytics - GA4 vs. UA #2 - Customizations, Sharing, BigQuery Export
มุมมอง 89ปีที่แล้ว
Google Analytics - GA4 vs. UA #2 - Customizations, Sharing, BigQuery Export
Google Analytics - GA4 vs. UA #1 - Frontend, Data Structure, Bounce Rate
มุมมอง 80ปีที่แล้ว
Google Analytics - GA4 vs. UA #1 - Frontend, Data Structure, Bounce Rate
New GA/GTM Features #1 - Event Exclusion, Attribution, Firestore API
มุมมอง 792 ปีที่แล้ว
New GA/GTM Features #1 - Event Exclusion, Attribution, Firestore API
We should talk about data | Introduction to our channel
มุมมอง 3382 ปีที่แล้ว
We should talk about data | Introduction to our channel
New BigQuery Features #1 - Recursion, Analytics Hub, Column Masking
มุมมอง 1962 ปีที่แล้ว
New BigQuery Features #1 - Recursion, Analytics Hub, Column Masking
New Data Studio Features #2 - Linking API, Data Panel, Default Cross Filtering
มุมมอง 3562 ปีที่แล้ว
New Data Studio Features #2 - Linking API, Data Panel, Default Cross Filtering
New Data Studio Features #1 - Data Updates, Data Blending, Navigation in Embedded Report
มุมมอง 772 ปีที่แล้ว
New Data Studio Features #1 - Data Updates, Data Blending, Navigation in Embedded Report
BigQuery Connections #3 - Google Sheets
มุมมอง 1412 ปีที่แล้ว
BigQuery Connections #3 - Google Sheets
BigQuery Connections #2 - Google Analytics
มุมมอง 1542 ปีที่แล้ว
BigQuery Connections #2 - Google Analytics
Great video! The CASE WHEN function in BigQuery is one of the most handy functions for analyzing data. 🤖
Thank you for your feedback 💯
🔥stark!
👍
We can also use SAFE clause not only for CASTing, but also for other functions by simply: SAFE.function_name(). Eg: SAFE.SUBSTR().
Great explanation on using the CAST function in BigQuery!
This is an absolute game-changer for anyone working with BigQuery! Perfect for improving query efficiency and clarity! Highly recommend this to all data professionals out there 🔥💡 Keep up the great work!
This video was super helpful! Loved how you explained combining multiple CTEs step-by-step-it made complex queries much easier to understand. 🔥 Could you dive deeper into optimizing performance when using multiple WITH clauses in a future video?
Is possible to do subqueries in the ON clause of a JOIN? For example, when i want to compare if the value of a field is in a different dataset already, then i dont want to join it.
Definitely, we will cover this topic!
Really helpful! Cool stuff
Good explanation! Covered so many date and time functions-very insightful!
Tablaeu?
Thank you!
I receive this message when I try to transfer: "Billing is disabled for this project. Please ask the project owner to enable it." How much money does it cost?
Hi @JuanSagua To initiate the transfer, you must add payment information (e.g., credit card) to your GCP (Google Cloud Platform) project. To do this, navigate to GCP, click on the "Hamburger button" located in the top left corner, and then scroll to "Billing". In the Billing section, you will be able to add your payment details. Regarding Costs: Although adding payment information is a prerequisite for this process, the transfer itself is free of charge. For further details, visit: console.cloud.google.com/marketplace/product/bigquery-data-connectors/google_ads. Please note, while the transfer is free, querying data in BigQuery does incur costs. However, there are monthly and one-time free usage tiers. You can monitor your cloud expenses under the "Billing" menu at any time. Greetings Alex
Are there more parts?
I'm going to check out your channel now! New fan :)!!! YT ranking services > Promo>SM!
it's almost 2023 :)
haha, good catch - The first thing I saw after it went online. 😀
PЯӨMӨƧM ⭐
The new UI is absolute trash. Can't believe someone has approved it. Random tabs keep popping out every time you click something. In 10 minutes you don't know which tab is which. You can no longer add field names by clicking table schema at the bottom of the screen - you need to use split tabs which create even more mess and are UNUSABLE on smaller screens. I am 20% slower with the new UI and every time I have to use it I want to eat my keyboard. Please give us an option to disable the stupid tabs and start showing table schema at the bottom when you click a view or a table. And the new UI is just slow. I would never believe I'd say something like this but Snowflake is terrible but Google is now far worse. Well done!
Yeah we also sometimes recognize that the new UI is a bit slower then the old one. But I see more advantages than disadvantages with the tab approach. Furthermore Google improved the behavior of the tabs in the last weeks. E.g. the tabs are replacing each other when you switch for example from one table to another, but it does not replace the tab if you have a changed query inside. I would also be a fan of an option to show table schemas at the lower part of the screen. ~Alex
The first comment who finds the missing "R" gets a datadice hoodie 🙄 Or a free hour of data consultancy in case you don't like hoodies. Up to you :-)
FYI - Your thumbnail obscures what you're clicking on to create the field
Hey Daniel. Good point. Thx for your Input. We will see if we can change that without completely deleting and renewing the video. But we will definitely check that in the next videos. Obviously the button is "APPLY". But I think you're aware of that :)
Alex is the best :)
🦕
Hi guys! I really appreciate your time on describing tips and differentes advices using this charts. Right now, I'm Data Analyst and I'm very interested in this content. PD: about your Udemy course, it's only available on German? (I want to study with English subtitles).
I would follow you Ricardo 🙏😀
Tolles Intro 😊🥰
wow never thought i will ever find a video - in favour - of the new bq ui. you guys are hardcore
haha, tough topic indeed, we tried to stay optimistic :) Whats your biggest Con?
@@datadice hahah :-P just joking - it was really nice video and i agree with some of the pros. For me the new ui feels a bit sketchy because the auto-complete is very slow or does not work, and when it does - sometimes it gives false suggestions like e.g. auto completes columns that do not exist in the current table .. that is a bit strange. I also find that the split-tabs quickly fill up the screen and it becomes a bit too much - but if i understood correctly you have either bigger or more screens ... so i guess that helps. What i do miss from the old/current ui is the possibility to cycle back-and-forth through results ( you could click on the results pane and go back and forward in time - if you know what i mean .. that was nice ). Anyways - thanks for the great content, I love your updates on medium btw. Any chance i can subscribe to them without joining medium ? Keep up the great work !
Super tolle Videos. Weiter so 🙏
Vielen Dank, Laura. Jede Woche kommt eine neue Folge. Stay tuned ;)
Nice content mate. Increase your stats = P r o m o s m !