I work as a senior analytics engineer at an education non-profit.
When JOIN isn't right How do I show data from two or more tables in a way that makes sense for my desired output - especially when there's a many to many relationship? It's a question that has come up several times for me recently in my own work and ...
Great Articles I posted a while ago complaining about how slow it can be using Google docs in Chrome on my old laptop. I also work a fair amount through remote desktop. In both cases typing delay can be very frustrating. Even a slight delay can sub...
Working with Batch Files Sometimes the humble old batch file comes in handy to get things done in Windows. If you need something more modern or advanced there are other options for scripting in Windows: Powershell Windows Subsystem for Linux. Reso...
I found a new (to me) productivity tool called Complice while reading Ben Kuhn's blog. I'm finding it both powerful and encouraging. I've used to do lists apps, written my own lists, and tried organizing my daily tasks and projects before. None were ...
Chrome and My Old Laptop I've been getting a little frustrated with Chrome on my laptop - google docs and Gmail are getting pretty damn slow. VS code is also sluggish. There are a few options: Double the laptop RAM 8GB->16GB Use a native app like su...
I started trying to install Apache Airflow on Windows 10 using pip. Quickly ran into a variety of errors. I eventually found a few articles that explained that Airflow uses Python libraries built for linux. There are a few workarounds - using the ...
Updated 10/23/2020 I’ve been reading through the Data Warehouse Toolkit by Ralph Kimball. The case studies have been practical and applicable. Especially because they look at industries I haven't had the chance to work in. These concepts be used to p...
Here’s a list of data related professional associations along with comments on their current status. I compiled this list while looking for a professional association to participate in. I'll update as I learn more. ODSC - https://odsc.com/ - Open Da...
Star Schema versus Snowflake Schema Overview This is a question that comes up in job interviews where data warehousing is a topic. These are some general summary level notes that I’ve taken during the course of my own research. To get really in dep...