Michael O'Toole

Understanding the Differences Between OLTP and OLAP

Understanding the Differences Between OLTP and OLAP

In the data analytics world, OLTP systems generate source data and OLAP systems analyze it.

SQL Essentials: Part 2

SQL Essentials: Part 2

SQL is the analyst’s language of choice for handling structured data. Part 2 of this series introduces more advanced SQL functions.

SQL Essentials: Part 1

SQL Essentials: Part 1

SQL is the analyst’s language of choice for handling structured data. Here's an introduction to some basic but essential SQL functions.

Guest Post: When Your DWH Is Not a DWH

Guest Post: When Your DWH Is Not a DWH

Watch out for the following signs that your organization does not warehouse data correctly.

Guest Post: Extract, Load and Analyze  – the Agile Way

Guest Post: Extract, Load and Analyze – the Agile Way

Data modeling and transformation sometimes get in the way of agility.

Start analyzing your data in minutes, not months

Launch any Fivetran connector instantly.