technology // business intelligence

BI Expertise

Database is the core of any application system. Imagine the volume of data that has been collected by every corporation so far and also in the future. Every company is sitting on amazing amount of intelligence in these databases. Every executive needs sufficient data and reports on his table to make intelligent decisions. The impact of these decisions can be in millions of dollars. For Fortune 20 corporations, it can run in even in billions of dollars. This is what “Business Intelligence” system’s are all about. iknowvate is involved in helping multiple Fortune 100 companies in managing the complete lifecycle of these Business Intelligence projects.

BI Process

Identify various sources of data (bases)
Architect, design and structure a scaleable data warehouse
Migrate the data from source databases into the target data warehouse
Cleanse the data and have good, clean, relevant data
Analyze the data
Create reports and provide simple on demand access to all the stake holders

Technology Expertise

Source Database		Oracle, DB2, UDB, Informix, Sybase, SQL Server, VSAM, IMSDB, IDMS, MS ACCESS
Target Data Warehouse		UDB, Oracle, Teradata
ETL Tools		Informatica, Datastage, ETI, Ab Initio
Analytical Tools		Cognos, Hypserion/Essbase, SAS, Business Object, SAP BW
Reporting Tools		Crystal Reports, SQR, Cognos ReportNet, SAP BW, Business Object, Micro Strategy.