Services |
|
|
|
|
Datawarehousing |
In simple terms "A Data Warehouse is a repository
of integrated information, available for queries and analysis. Data and
information are extracted from heterogeneous sources as they are
generated....This makes it much easier and more efficient to run
queries over data that originally came from different sources"
It sounds simple but there are many challenges in designing,
developing, deploying and most importantly keeping it updated almost in
real time from operational systems. At Projas we have years of
experience deploying data warehousing solutions, our team can help you
deliver comprehensive solutions by helping you in
Business requirements
analysis
Data modeling of data
warehouse (Star Schema)
Extracts design and
development for loading data into data warehouse
Design and implementation
of cubes for OLAP type requirements
Setting up reporting
framework in the tool of your choice
 Technologies we have
expertise in |
| ETL tools |
Informatica, Oracle warehouse builder,
PL/SQL, Perl |
|
| BI tools |
Hyperion Essbase, Hyperion Analyzer, Brio, Microsoft Analysis Services, ProClarity, ArcPlan Dynasight , Microstrategy, Business objects, Oracle
Reports, Oracle Discoverer, Orcale BI Beans, Customized reports |
|
| Data standardization tools |
FirstLogic, Trillium |
|
Databases |
Oracle, Sybase, SQL Server, DB2, Teradata |
|
| |
|
|
|
|
|
|
|