Afan Annur Ayubi – Medium

Afan Annur Ayubi

Afan Annur Ayubi

Change Column Name in BigQuery

In the realm of Big Data and Analytics, Google’s BigQuery often stands out as a powerful tool that enables super-fast SQL queries against…

Jul 13, 2023

Change Column Name in BigQuery

Jul 13, 2023

Afan Annur Ayubi

A Case Study of Cyclistic Project using Python — Discover the Power of Data Analysis and…

This case study showcases the power of Python and data analysis in driving actionable insights to improve business outcomes.

Apr 26, 2023

A Case Study of Cyclistic Project using Python — Discover the Power of Data Analysis and…

Apr 26, 2023

Afan Annur Ayubi

Get Focused and Relaxed: The Power of Reading to Reduce Stress and Improve Concentration

It was a typical Tuesday night. My mind was racing with worries about work, money, and the latest drama on social media. I tried to…

Apr 11, 2023

Get Focused and Relaxed: The Power of Reading to Reduce Stress and Improve Concentration

Apr 11, 2023

Afan Annur Ayubi

Chasing Data Dreams: My Road to Becoming a Skilled Analyst

I left my position as a mechanical engineer at a prominent shoe manufacturing company in Sidoarjo, East Java, Indonesia almost two years…

Apr 11, 2023

Chasing Data Dreams: My Road to Becoming a Skilled Analyst

Apr 11, 2023

Afan Annur Ayubi

Calculate Mode in BigQuery

Mode, mean and median are three commonly used measures of central tendency in statistics. They are used to describe the typical or central…

Mar 27, 2023

Calculate Mode in BigQuery

Mar 27, 2023

Afan Annur Ayubi

Separate Date and Time in Bigquery

In BigQuery, you can separate date and time from a timestamp field using the EXTRACT function. Here is an example. If we want to extract…

Mar 25, 2023

Separate Date and Time in Bigquery

Mar 25, 2023

Afan Annur Ayubi

Calculate the Distance using Longitude and Latitude in BigQuery

Calculate the distance between two points on the Earth’s surface using their longitude and latitude. Latitude refers to the horizontal…

Mar 25, 2023

Calculate the Distance using Longitude and Latitude in BigQuery

Mar 25, 2023

Afan Annur Ayubi

Identify the time differences between a start and end point using BigQuery

Recently, I have been processing TIMESTAMP type of data. In SQL, the TIMESTAMP data type is used to store date and time values in a…

Mar 20, 2023

Identify the time differences between a start and end point using BigQuery

Mar 20, 2023

Afan Annur Ayubi

Merge Table in BigQuery

A merge table is essentially a virtual table that is created by combining the data from two or more tables. This is typically done when you…

Mar 16, 2023

Merge Table in BigQuery

Mar 16, 2023

Afan Annur Ayubi

Upload CSV File in BigQuery by Drive

A while ago, I had some problems uploading a CSV file to BigQuery because the file is too large. I decided to use google drive to upload…

Mar 13, 2023

Upload CSV File in BigQuery by Drive

Mar 13, 2023

Afan Annur Ayubi

Afan Annur Ayubi

Passionate about data and product development. Sharing my experiences and insights in the world of tech and beyond.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams