Dimension Vs Facts Table

https://en.wikipedia.org/wiki/Dimension_(data_warehouse)

https://en.wikipedia.org/wiki/Fact_table

https://network.informatica.com/thread/42342

——

ETL Design Pattern: http://www.leapfrogbi.com/2013/05/11/etl-design-patterns-the-foundation/

Standard ETL Scenarios: https://dwbi.org/etl/etl-design-pattern/57-etl-design-pattern

Advertisements

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/

https://en.wikipedia.org/wiki/List_of_reporting_software
Tableau

Business Intelligence
http://bigdata-madesimple.com/top-business-intelligence-bi-tools-in-the-market/