Matt Sharkey's Picture

Matthew Sharkey

I'm a Data Engineer / BI Developer / Data Architect based in Omaha, Nebraska. Thanks for visiting my site.

Latest Articles

Speaking at SQL Saturday Kansas City

Speaking at SQL Saturday Kansas City

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.…

SQL Saturday 888 - Sioux Falls

SQL Saturday 888 - Sioux Falls

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…

Cleaning and Enriching Data with the CASE Expression

Cleaning and Enriching Data with the CASE Expression

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…

When to use Relational Databases

When to use Relational Databases

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…

Privacy Policy