Small Projects & Case Study

Hai Beginers ,

Well you have done with learning process on required Data Warehouse , Database , UNIX tools .And you are eager to practice in developing the Dimensions and Fact Tables from OLTP tables.You have choosen right place for that.DWHlabs providing few real time projects realted to different domains on Data Warehouse.Remeber this information is for practice purpose alone.

Make sure you must have prior knowledge on ETL Tool or Reporting Tool and Database tool like SQL server / Oracle / DB2 etc., and of course command on SQL (recommended to have knowledge on PL/SQl ), UNIX Shell Scripting languages.

In this we provide what are differnt tables you have to prepare in Database level (SOURCE) and Dimension and Fact Tables (Target / Data Warehouse) .We implement the project task in 4 steps to make you understand more better.

Step 1 :: Pictorial representation of the Table .

Step 2 :: Tables with Attributes.

Step 3 :: Relations between the Tables.

Step 4 :: Dimension and Fact Tables with structure.

Apart from this, DWHlabs providing Case Studies on different domains .This case studies are available in official websites of different companies.Please go in it to understand how the differnt Data Warehouse design happens with the same tools depending on the client requirement.

Request ::

If you want to contribute your Projects to DWHlabs.Please click here to visit the Knowledge form.