In this guide, we will create and use table partitions in BigQuery. If correctly set up, a BigQuery table partition reduces query costs and runtime. Partitions can also reduce storage costs by using long-term storage… Read More »Working with BigQuery Table Partitions
In this guide, we will learn how to extract data from YouTube in four steps. Using R and the YouTube Data API, we can get information from a channel or a video, such as the… Read More »How to Extract Data from YouTube using R and the YouTube API
This guide includes different ways to create a table in Google BigQuery. You will see that you can create a table through the following methods: CREATE TABLE command CREATE TABLE command from a SELECT query… Read More »How to Create a Table in BigQuery
Do you use free tools for your data analysis projects? Whether you choose free or paid tools, they should accomplish one major purpose. Tools should help you to do more. Are you are spending more… Read More »10 Free Data Analysis Tools in 2020
What are the top 3 skills that you need to master as a data analyst? If you are a fresh graduate or someone who wants to shift into a data analyst role, you need to… Read More »Top 3 Skills for a Data Analyst
In this post, you will learn the fundamentals of working with timestamp and datetime in BigQuery. I will go over the key differences between a timestamp and a datetime. You will see how you can… Read More »BigQuery Timestamp and Datetime Functions
Here’s a truth about strings: Most of the time, we do not use them as is. We always do something with it. We ensure that business rules are being followed. Let’s change the capitalization, or… Read More »BigQuery Substring, Left, Right, and Other String Functions
How can we measure user experience? I used the Chrome UX report and analyzed it in BigQuery. We looked at over 7 million unique websites that were visited in May 2020 using Google Chrome. We… Read More »User Experience on the Web with Chrome UX Reports and Google BigQuery
What is the UNNEST function in BigQuery, and how does this relate to arrays? In this article, we explain how arrays work, and how we can use the UNNEST function to flatten arrays. After processing… Read More »BigQuery UNNEST and Working with Arrays
What is a data type in Google BigQuery? In this article, we discover what data types are, and how they are used in Google BigQuery. We also look at commonly used data types and show… Read More »Data Types in Google BigQuery (Standard SQL)
