The following problem is based on a problem in section 4 of the book “Model Building in Mathematical Programming”. I’ve modified some aspects of it but it’s similar in nature. …

I haven’t written anything on here since June 2020. I had originally planned to write some more about linear algebra and I’m not sure what happened. In college I briefly did some research on using linear programming to help reduce noise in signals. At that point I don’t think I…

Intro I’ve been writing on Medium for a few years now and I’ve generally stuck to writing about data analytics/engineering and mathematics so this article will be a departure from that. It’s a rant article. If you’ve been paying attention for the past few years you’ve probably seen major websites offering…

Intro This is a continuation of an article I wrote last week by the same name except for part 1. If you haven’t read it, you can read it here https://ryhowe.medium.com/adventures-in-data-engineering-github-actions-ci-cd-part-1-452275f2fd4a however it isn’t technically necessary. …

Intro I started doing data work as an analyst and while the team I worked on had our own GitHub repo most of the team didn’t use it. Most the team was relatively new to data work and there wasn’t much need outside of some reports and a process used for…

Intro I thought about posting about this when it happened but ultimately didn’t because it was overwhelming and I felt kind of ashamed. It also seemed so dumb that other people wouldn’t believe it. Now that it’s been about 8 months I decided I’d post about it. I think if there’s…

Earlier in the week I had someone reach out to me to help them study for interviews to become a data engineer. She had a sample question related to sports and I asked to see her work. She showed me the question and an ERD she had created and I…

Note : everything I’m talking about is in reference to MS SQL however I’m going to use MySQL in the examples. Why? I only have MySQL installed locally. I was working on a job recently to drop some temp tables based on some conditions using a stored procedure and a…

I haven’t written on here for a bit and this will be a significant departure from my previous content where I typically just wrote about math and data analytics to something more about myself. Last week I had a software engineer reach out to ask about how I became a…