Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
8 Cards in this Set
- Front
- Back
Business Intelligence
|
Like a hot water heater - transforms data into meaningful information.
Like a restaurant - houses & transforms raw food into a meal This tech takes a look at data from different places, analyzes how that data fits together, and figures out trends... it transforms raw data into meaningful information. |
|
Data Warehouse
|
Like a kitchen -
This technology brings together different data and houses it. This is where the transformation takes place |
|
ETL
|
Extract, Transform, Load
This technology is like a chef - who takes food out of the pantry, transforms it by cooking it, and loads it onto a plate to be eaten. This tech extracts data from a database, transforms it in the data warehouse and loads it into another database or an application. |
|
Big Data
|
HUGE BUZZ WORD
This refers to all the different types information that are being collected by companies at high volume, high speed. This is the data that Business Intelligence is useful for making sense of. |
|
ETL Tools
|
Oracle Warehouse Builder
Pentaho Business Objects DataStage |
|
Extract
|
The process of taking raw data out of a database and entering it into a Data Warehouse.
Like a chef taking food out of a pantry. |
|
Transform
|
The process of combining raw data from different sources so as to make it useful for the business users.
Like a chef sauteing or chopping raw food in order to make a dish. |
|
Load
|
The process of taking transformed data out of the Data Warehouse and putting it into either an Application for immediate use or another Database for later use.
Like a chef plating a dish in a restaurant or putting it into a to-go container. |