I'm a Data Engineer / BI Developer / Data Architect based in Omaha, Nebraska. Thanks for visiting my site.
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…
Relational database management systems (RDBMS) provide a cornerstone for many apps and services. By technology standards, RDBMS are ancient. Strong theoretical underpinnings have kept RDBMS technologies relevant in a volatile industry. Even non-relational data stores have had to add RDBMS-like…