Extracting data from sources
Now we get to work. The aim of this book is to design, develop, and deliver a business intelligence product-a data product. In this section, you will explore two extraction methods to import data from different types of sources:
- Importing CSV and other file formats
- Importing data from relational databases
Depending on your background, you may be more or less familiar with both types of extraction methods. Here, you will learn or refresh your knowledge of both in order to have a more complete working understanding of ETL.
Importing CSV and other file formats
You can load the Bike Sharing data file into the R environment by using the
read.csv() function. It is an easy and commonly used way to load CSV files:
bike <- read.csv ...