Data Warehousing & Business Intelligence (BI)

Cicada leveraged its skills and expertise in data warehousing and online analytical processing (OLAP) marketing and set up a focused data warehousing (DWH) and Business Intelligence (BI) practice, which has been since extended to the entire US. We are now trying to build dedicated solutions in industry verticals - like manufacturing, pharmaceuticals, banking, automobiles, government, insurance, and utilities. Services include –

• Data Warehousing.

• Data mart and data warehouse design, using data modeling techniques.

• Data warehouse creation at multiple sites from multiple servers 'Jump-starting' client projects with our in-depth knowledge of Business Objects, Brio, Cognos, Impromptu and Powerplay, Micro-Strategy, Informatica and Data Stage

• Web-enabling of data warehouses and complimentary reporting.

• OLAP tool implementations on the web.

• Single sign-on, using LDAP and web servers.

• Expertise with databases such as Oracle, Sybase, DB2, Informix and Teradata.

• Writing ad hoc queries and reports.

• Integration with enterprise resource planning (ERP) solutions such as SAP, Oracle, etc.

• Integration with eCommerce to build near-real-time data warehouse access.

• Integration with customer relationship management (CRM) tools such as Siebel, Clarify and Oracle CRM.