I'm a Data Engineer / BI Developer / Data Architect based in Omaha, Nebraska. Thanks for visiting my site.
In short, the filter placement could change the query results if the query uses an outer join. Left (right) outer joins add back non-matching rows from the left (right) table after the ON filter. A row might match the ON…
On September 14th I'll be delivering my session "Building Web apps with R and SQL Server" at SQL Saturday Kansas City. I enjoy this event. The organizers do a great job, the venue is fantastic, and it's close to Omaha.…
I'm delighted to speak at SQL Saturday 888 in Sioux Falls this weekend. I'm delivering a session on web development with R. R isn't well known for enterprise Web Applications. However, recent advancements in the R ecosystem aim to change…
Earlier this month I delivered a presentation to the Omaha R user group. Originally I had planned to write out the major themes of the presentation into a series of blog posts. It later occurred to me that I could…
The CASE expression is one of the most important functions for cleaning and enriching data. CASE evaluates a column or group of columns against one or more conditions and then returns an expression. This is helpful for cutting data into…