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
https://en.wikipedia.org/wiki/Data_warehouse

Dimensional modeling
https://en.wikipedia.org/wiki/Dimensional_modeling

Design database to query a date range for scheduling
http://dba.stackexchange.com/questions/30439/design-database-to-query-a-date-range-for-scheduling
Add index to required columns to avoid full table scans

Reporting Database
http://martinfowler.com/bliki/ReportingDatabase.html

Pentaho Data Integration (PDI, also called Kettle) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes.
http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+(Kettle)+Tutorial

http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+-+Java+API+Examples

7 Steps to Data Warehousing
http://sqlmag.com/database-administration/7-steps-data-warehousing

Finally google graphs are good to draw quick graphs for given data
https://developers.google.com/chart/

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s