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
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)
Let’s discover how you can use Google BigQuery as a platform for data analysis. We look at pricing, the use of API, and some samples to get us started working on Google BigQuery. You can… Read More »How to Use Google BigQuery
Am I good enough? What does it take to become an expert in writing SQL? I used to spend countless hours asking myself if I have written a query the best way possible. Now, I… Read More »How to Write Better Queries in SQL?
