Data Warehousing & Business Intelligence

The area of data warehousing and business intelligence whether at an enterprise level or comprising of unified smaller data marts enables an organisation to transform its most valued asset, ‘business data’ into business ‘knowledge’. This in turn enables a business to derive a 360° degree view of its activities and be empowered with this business ‘knowledge’ to greater exploit market opportunities, mitigate risks, build upon core strengths and address weaknesses.

MagenTys implementation of a Data Warehouse and Business Intelligence solution are based on multiple driving factors:

• Ability to execute and deliver using the proposed product solution.
• Completeness of vision - The proposed product solution extends not only to fulfill current demand, but also future business needs.
• Total cost of ownership and the return on investment in deploying the proposed product solution.
• Clients comfort level and internal knowledge base.
• MagenTys product and business knowledge in deploying the proposed data warehouse and BI platform.

A Data Warehouse and Business Intelligence platform comprises of multiple processes that must seamlessly integrate into a single, easily accessible repository of corporate data. The BI presentation layer allows our clients to fully assess company activities using customised reports and analytics.

Salient features of our Business Intelligence solution:

• Reporting and querying
• OLAP (Online Analytical Processing)
• Digital Dashboards
• Data Mining/Predictive Analytics
• Business Performance Management
• Benchmarking

MagenTys specialises in the following products within the BI/DW arena:

ETL Tools: Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI),  Informatica, Ab Initio

Presentation Layer/BI Tool: Oracle Business Intelligence Enterprise Edition (OBIEE), Business Objects, Cognos, MicroStrategy, QlikView

Database: Oracle, DB2, SQL Server, Netezza

Data Mining: Oracle Data Miner, SAS

Automated Test Tools: HP Quick Test Professional, HP Loadrunner

Case Studies:

Grameenphone-BI_DW.pdf