Data Wrangling – Regular Expressions

The first step of deep analysis using the Team Data Science Process is to find the right question. From there, we need to determine where the data you need lives, or even if you have it. If we don’t have it, we need to get it – a topic I’ll cover in another post. The …

Data Wrangling – ELT not ETL

In Data Science, we most often use Extract, Load and Transform (ELT) as opposed to Extract, Transform and Load (ETL) that you see most often in Business Intelligence (BI). There are a couple of reasons for this. First, in many BI solutions you have a few data sources that you are integrating into a historical …