Data Warehousing/Business Intelligence
A Data Warehouse is a central repository of divergent information from various systems, with consolidated “one version of the truth” view of enterprise data. The main purpose of a Data Warehouse is to empower the management in making timely and informed decisions based on trending, forecasting and analysis of business information.

Infohex handles Data Warehouse projects starting with an ROI analysis to highlight the value of a Data Warehouse for a specific business. Upon management approval, business requirements phase begins, leading into a highly interactive and iterative development of a Data Warehouse with continual deliverables to – and constant feedback from – the end users. Infohex has successfully implemented several large and medium scale Data Warehouses in different industries such as Telecommunications, Utilities, Search Engines, Internet Yellow Pages, Retail Software, Education, Finance, Customer Care and Transportation.

Business Intelligence (BI) is the term used for the OLAP (Online Analytical Processing) Reporting tools that present analytical reports to the end users from a Data Warehouse. The BI tools allow the users to ‘slice-n-dice’ the data by different business aspects and apply different ‘what-if’ scenarios. The users can start with a high level view and drill-down into specific areas; rollup into higher level aggregations and drill-across for a comparative analysis. BI tools offer many report distribution options such as intranet, e-mail, PDA, etc.; can create reports that can be integrated seamlessly between a desktop PC and web interface.

A typical Data Warehouse project involves:

• Business Requirements Gathering & Analysis
• Project Management
• Data Architecture
• Data Acquisition and Movement
• Database Administration
• BI and ETL tool Administration
• OLAP Report Development
• End User Support

Rhapsody has deployed several Data Warehouse teams with skill sets that complement one another and form a highly productive and goal-oriented task force in implementing and maintaining Data Warehouses and Data Marts.

Component of Datawarehouse Architecture

Infohex has varied skill sets that we can choose from to form a Data Warehousing/Business Intelligence team for your business. The skill sets include and are not limited to multiple server platforms – Unix, Linux, Microsoft Windows, Mainframe; database platforms – Oracle, Microsoft SQL Server, Teradata, Sybase, Informix, PostgreSQL, mySQL; ETL tools – IBM DataStage, Informatica, Ab Initio, Microsoft DTS, Embarcadero DT-Studio; BI tools – MicroStrategy, Cognos, Business Objects, Hyperion, Actuate; Data Mining & Statistical Analysis – SAS; Other tools- ERwin (Data Modeling), Ambeo/Embarcadero (Data Security).

Please Contact Us so we can visit with you and present our Data Warehousing and Business Intelligence services.