Business intelligence

Extract

[...] BI implies yet more integration and ease of use Business Intelligence services Business Intelligence Definition : BI is a broad category of applications and technologies for gathering,storing,analyzing and providing access to data to help enterprise users make better business decisions What are Business Intelligence Systems? Introducing Business Intelligence BI focuses on the and should be seen as a company's unit, scanning the external environment for opportunities and dangers Warehousing One or more copies of transaction and non transaction data that have been transformed in such a way that they are suitable for querying, reporting and other data analysis Features Memory of organization Time dimension Uniformity Not changeable (data) Handles large amount of data useful for critical decision Bigger More consistent Cheap method to store Provides access to reliable, consistent and high quality information Data is always available Data Warehouse Tool Evaluation Server Operating System Database Engine Extract, Transform and Load Business Intelligence Data Warehouse Tool Evaluation Linux Windows NT Server Windows 2000 Server Windows 2000 Advanced Server Data Warehouse Tool Evaluation Oracle IBM DB2 Microsoft SQL Server Extract, transform and load(ETL) 60-80% of BI project effort in this process Extraction from various sources(External or internal data) Transformation involves, conversion such as EBCDIC to ASCII, packed decimal to integer and changes to date formats (e.g. [...]

[...] Business values of BI Improved decision making at all levels Improved business processes More collaborative work environment Increased revenues, total grip on cash flow, reduced costs Decreased reaction time Instant view on which products, customers and markets are most profitable Improved customer satisfaction Monitors external business behavior Fast monitoring Better insight in markets,suppliers,competitors and technology Tracing opportunities Complete end to end information More transparent and calm supply chain Fraud detection with OLAP No guess work, decisions are based on solid evidence Helps in forecasting Technologies Computer system Software to control access to warehouse for different levels Data retention capacity (warehouse) Special software to gather and analyze large quantities of unstructured data such as sales statistics, production metrics,attendence reports Some BI applications are used to analyze performance, projects or internal operations such as business process re-engineering, enterprise management system, executive information system,SCM To store and analyze data tool is “datamining”, datawarehouse,DSS,MIS,OLAP Other tools are used to analyze and manage”human”side of business such as CRM,HR etc BUSINESS INTELLIGENCE How a company benefits from business intelligence They used to print 1,000 page reports for each salesperson Now salespeople get the information they want from company's intranet Company's BI system paid for itself in 9 months Most data marts are application specific. [...]

[...] LARGE OR SMALL COMPANY BOTH Companies which Offer Business Intelligence Products: Actuate Business Objects Cognos HummingBird Hyperion Information Builders MicroStrategy ProClarity Siebel DecisionCentric is a business intelligence system made up of multiple components, all designed to work together and quickly provide the user with actionable information—even for ad hoc requirements. The components of the system include the DecisionCentric server, repository, client interface, database drivers, the Enterprise Information Integration (EII) based data integration engine, and the business intelligence reporting and data analytics tools IT Support for Business Intelligence There are many software companies in the BI field Digital dashboard - displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker A digital dashboard, also known as an enterprise dashboard or executive dashboard, is a business management tool used to visually ascertain the status (or "health") of a business enterprise. [...]

[...] Aronson, and David King Business intelligence roadmap By Larissa Terpeluk Moss, S. Atre Business intelligence By David Loshin Business intelligence Evolution Business intelligence was the 1990s buzzword for the management information system (MIS) of the 1970s and the decision support system (DSS) and executive information system (EIS) of the 1980s. MIS implementations often failed because the hardware was too slow and the software was not sophisticated. Countless DSS, EIS and OLAP tools followed, which added functionality, but were often point solutions to the problem. [...]

[...] LARGE OR SMALL COMPANY BOTH Companies which Offer Business Intelligence Products: Actuate Business Objects Cognos HummingBird Hyperion Information Builders MicroStrategy ProClarity Siebel DecisionCentric is a business intelligence system made up of multiple components, all designed to work together and quickly provide the user with actionable information—even for ad hoc requirements. The components of the system include the DecisionCentric server, repository, client interface, database drivers, the Enterprise Information Integration (EII) based data integration engine, and the business intelligence reporting and data analytics tools IT Support for Business Intelligence There are many software companies in the BI field Digital dashboard - displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker A digital dashboard, also known as an enterprise dashboard or executive dashboard, is a business management tool used to visually ascertain the status (or "health") of a business enterprise. [...]