Data

If you love it, let it go? — Open data I was really privileged to spend this week visiting Malta as a guest speaker for Eurogeographics at their general meeting. The location data community is amazing! They have worked together for years and it is probably the most advanced data…

In an ideal world, your SaaS provider, e.g. Xero allows you to export your data or has some systems in place that push data to your preferred storage, e.g. to your data warehouse. In the real world, the shared data might be outdated which could impact the quality of data…

In this project I use Rapid APIs Realtor showing available listings to rent. I filtered the API in my code to only view available rentable residential buildings in Georgia but this is editable and could be more specific/expansive. This is an ETL project where I extract from the API, transform…

Today I reviewed my draft stories and saw this: On November 21, 2022 I wrote my first Medium post on this very topic. Now, after 21 days, here I come with volume 2. He he he… I swear it is coincidence. Well, I guess it’s not a coincidence, huh? Not…

When it comes to SQL, most people are comfortable with GROUP BY since it serves their purpose well. However, once you start working with more complex data sets or implementing complex business logic, GROUP BY might not be enough to achieve your business requirements. This is where window functions come…

Hey there, privacy lovers! Are you tired of feeling like your personal data is always at risk of falling into the wrong hands? Fear not, because AI is here to save the day! In this article, we’ll take a look at how artificial intelligence (AI) is helping organizations protect sensitive…

There are 383 Metropolitan Statistical Areas(MSA) in the USA GDP data collected from the U.S Bureau of Economic Analysis. The GDP value includes all the industries' revenue for the year 2017. For the data set. click here There are a total of 14497 Starbucks stores in the USA 6249 stores present in Metropolitan Statistical Areas Click here for Starbucks’ sample POI data source from ScrapeHero.

Optimizing query performance is critical when it comes to managing large datasets, especially in serverless resources like BigQuery. To achieve this goal, implementing an effective partitioning and clustering strategy is key. Not only can this strategy enhance the speed of your queries, but it also will help you save on…