Afan Annur AyubiChange Column Name in BigQueryIn 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, 2023Jul 13, 2023
Afan Annur AyubiA 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, 2023Apr 26, 2023
Afan Annur AyubiGet Focused and Relaxed: The Power of Reading to Reduce Stress and Improve ConcentrationIt 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, 2023Apr 11, 2023
Afan Annur AyubiChasing Data Dreams: My Road to Becoming a Skilled AnalystI left my position as a mechanical engineer at a prominent shoe manufacturing company in Sidoarjo, East Java, Indonesia almost two years…Apr 11, 2023Apr 11, 2023
Afan Annur AyubiCalculate Mode in BigQueryMode, mean and median are three commonly used measures of central tendency in statistics. They are used to describe the typical or central…Mar 27, 2023Mar 27, 2023
Afan Annur AyubiSeparate Date and Time in BigqueryIn 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, 2023Mar 25, 2023
Afan Annur AyubiCalculate the Distance using Longitude and Latitude in BigQueryCalculate the distance between two points on the Earth’s surface using their longitude and latitude. Latitude refers to the horizontal…Mar 25, 2023Mar 25, 2023
Afan Annur AyubiIdentify the time differences between a start and end point using BigQueryRecently, 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, 2023Mar 20, 2023
Afan Annur AyubiMerge Table in BigQueryA 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, 20231Mar 16, 20231
Afan Annur AyubiUpload CSV File in BigQuery by DriveA 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, 2023Mar 13, 2023