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

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…

Can Today’s Headlines Predict Tomorrow’s Stock Prices?

Can Today’s Headlines Predict Tomorrow’s Stock Prices?

Let’s pretend we’re back in 2016 for a moment. It's the morning of Tuesday February 9th.  You are ready to take on the day right after you check Reuters news.  A bearish headline catches your eye:  “SE Asia…

Privacy Policy