On Demand BI and DW

Business Intelligence includes a broad category of applications and technologies used for gathering, storing, analysing, and providing access to business data that help enterprise users make better business decisions thus delivering competitive advantage. These systems helps business users extract ‘personalised’ meaningful information about their business and industry, not typically available from internal systems alone. It encompasses advanced decision support tools and back-office systems and databases to support those tools.

The data warehouse is the back-office database. The database along with the support tools required to build and maintain the data warehouse constitutes the data warehousing. Thus, data warehousing includes all aspects of managing the development, implementation and operation of a data warehouse or data mart including meta data management, data acquisition, data cleansing, data transformation, storage management, data distribution, data archiving, operational reporting, analytical reporting, security management, backup/recovery planning etc.

Today, however, there is no good deal of difference between data warehousing and business intelligence. In the early days of data warehousing, data warehousing described the capture, integration and storage of data. Software vendors noticed that there was a lack of good data access tools to query the data, so the “business intelligence” tools were born. Hence, today, if one had to force oneself into make a distinction between the two - data warehousing describes the actual database and processes to manage it, while BI describes the processes and tools to query, access and analyze the data.

Benefits

• Aides business leaders in robust decision making
• Helps achieve manpower savings
• Helps save processing costs
• Reduces overhead costs (outsourcing and administrative)
• Increases productivity and efficiency
• Improves turn-around time on data collection
• Lays the foundation for new business initiatives
• Offers a precise picture of customer needs and desires
• Helps carry out improved and targeted marketing campaigns

An On Demand BI/DW solution offers additional benefits of using the Cloud infrastructure. A robust, secure and scalable On Demand BI/DW system can be implemented ‘quickly’. The system comes with flexible subscription models that help you choose from a variety of options.

DATASiSAR offers a full fledged BI/DW implementation service. A typical BI/DW project life cycle consists of:

• Generation of a Business Blueprint
• Creation of a Project Plan
• Analysis of Data and Metadata repository
• Design of BI/DW Architecture
• dentification of ETL, BI , OLAP tools
• Design of Database and Metadata repository
• ETL development, Application development, and Metadata repository development
• Data integration from external applications
• Implementation
• Testing
• Go-Live
• End User Training
• Post-Implementation Support