Data Analytics Simplified
Imagine that you are the host of “Help! I Wrecked My House!” But instead of navigating through the debris of a DIY home renovation gone awry, you’re diving headfirst into a chaotic world of spreadsheets, rogue data streams, and a jumble of mismatched tools. The mission? To declutter, organize, and automate workflows, laying down the solid groundwork necessary for efficient reporting and data science. This is the life of a data analytics engineer.
Here on this blog, I’ll share insights, tips, tricks, and a robust framework designed to tackle the ever-evolving challenges of data engineering and analytics. Given that every company and initiative comes with its unique set of requirements, and considering the dynamic nature of data, you won’t find any one-size-fits-all guides here. Instead, I aim to share my thought process and problem-solving strategies to help you identify the most effective processes and tools for your projects.
You might find yourself here because you:
No matter your situation, I’m here to equip you with the essential tools for your data analtyics toolkit, tailored specifically for the lean tech startup environment. Welcome!
Creating the syntax for new SQL tables can be a pain especially for CSV files with a lot of columns. I’ve started using DB Browser for SQLite because I prefer GUI interfaces over the command line. A big benefit of using DB Browser is that I can quickly create tables from CSV files and start…
Here is a cool trick I found while working with DB Browser. I had multiple CSVs that all needed to into 1 table. This is possible and the steps to do it aren’t explicit. Here’s what you’ll need to do:
Updating a column in a table based on values in a second table proved to be quite a difficult operation in SQLite. It’s not as straightforward as it is in MySQL where one can use an inner join.
The TSA has started to publish the daily volume of passengers going through checkpoints on its website. The data set also includes the numbers from 2019 in order to measure the impact of travel as a result of COVID-19. It’s a really interesting leading indicator of a recovery in the travel sector. In this post,…
You might encounter this if you simply have a python file of lists or you may have a list from webscraping.
Incorrect number formatting in a cell can cause your cell to appear as something totally different and it can be so frustrating. Dates can sometimes appear as numbers and it’s easy to think you are going crazy. Here’s how to fix it.
Google Sheets has an awesome formula that automatically pull data from a website. This can be a huge time saver especially if you manually pulling data frequently.
In this post, I’m going to walk you through how to take a list of items and repeat each list element X number of times to create a longer list.