Data – Think Differently

Many who are not exposed to Data Warehouse / Data Mining / Reporting won’t understand data properly.
Many times we are tempted to fetch reports from live database. Which is not correct.

Try to read about these two terms
Online analytical processing (OLAP)
Online transaction processing (OLTP)
Predictive analysis

Dimensional modeling

Design database to query a date range for scheduling
Add index to required columns to avoid full table scans

Reporting Database

Pentaho Data Integration (PDI, also called Kettle) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes.

7 Steps to Data Warehousing

Finally google graphs are good to draw quick graphs for given data

Business Intelligence


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s