I learned about the different designs of Data warehouse: Star schema, snowflake schema and constellation schema. Also the different types of OLAP cube: ROLAP, MOLAP and HOLAP.
The software available for Data warehouse is Oracle Data Warehousing:
http://www.oracle.com/us/solutions/datawarehousing/index.htm
Below are websites that gives detailed information on the different OLAP cubes:
http://www.1keydata.com/datawarehousing/molap-rolap.html
http://www.geekinterview.com/question_details/271
I also learned that there is another type of OLAP cube called the DOLAP which is Desktop Online Analytical Process. The OLAP that communicates with Desktop Databases to retrieve the data.
Wednesday, November 18, 2009
Tuesday, November 10, 2009
Week 3
I learned that developing dashboard is not as simple as just putting different graphs in a single screen, it needed important steps to put in those necessary and crucial information. I also learned to create process map which is a guide to help me understand the flow of a single process in a company or any scenario. Six sigma helps in creating the process mapping.
The video tell me what and how six sigma is being implemented:
The video showing how to draw a process map:
There are also process map software available on the internet:
Graham Process Mapping 7.0 -> http://www.processchart.com/
SmartDraw Process Mapping -> http://www.smartdraw.com/specials/process-mapping.htm
Subscribe to:
Posts (Atom)