1 / 13

Business Intelligence

Business Intelligence. Zamaneh Jahed. What is Business Intelligence?. Business Intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better decisions.

natara
Download Presentation

Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence Zamaneh Jahed

  2. What is Business Intelligence? 1 Business Intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better decisions.

  3. BI has its root in the MIS reporting system of the 1970. • This term was introduced by Gartner Group in the middle 90s. • Until 2005, BI systems had Artificial intelligence capabilities. A Brief History of BI 2

  4. BI Architecture Conformed Dimensions Analytical Layer Presentation Data storage, retrieval Layer Web Portal NightlyReplication Fact Tables Portal Portal Semantic Portal Portal Data source layer Security SASInformation Maps Excel Flash Dashboard HTML Data Transformation Metadata Web Services Metadata Registry 3/

  5. Operational Data Source: Business Intelligence system collects data from various sources including operation database, OLTP, ERP, external database and etc. ETL tools (Extract, Transform, Load): They are used to pull data from source database, transform the data so that it is compatible with the data warehouse and then load it into data warehouse. 5

  6. ETL Process E X T R A C T T R A N S F O R M LO A D Customer E T BI Target Database Accounting E T Inventory E T Orders E T 6

  7. Data Warehouse Data warehouse is a database that stores current and historical data. It consolidates and standardizes information from different operational database so that the information can be used across the enterprise for management analysis and decision making. 7

  8. Data Mart Data Mart is a subset of a data warehouse in which a summarized or highly focused portion of the organization’s data is placed in a separate database for a specific population of users. 8

  9. Cube The basic unit of storage and analysis in Analysis Services is the cube. A cube is a collection of data that’s been aggregated to allow queries to return data quickly. • Dimension Each cube has one or more dimensions, each based on one or more dimension tables. A dimension represents a category for analyzing business data • Fact table A fact table contains the basic information that you wish to summarize. This might be order detail information, payroll records, or anything else that’s amenable to summing and averaging. 10

  10. OLTP and OLAP • OLTP (On-line Transaction Processing) • Major task of traditional relational DBMS. • Day to day operations: purchasing, inventory, banking, manufacturing, payroll, registration, accounting, etc. • Aims at reliable and efficient processing of a large number of transaction and ensuring data consistency. • OLAP (On-line Analytical Processing) • Major task of data warehouse system. • Data analysis and decision making. • Aims at efficient multidimensional processing of large data volumes. 9

  11. OLAP or multidimensional analysis: Means you can analyze ‘measures’ at the intersection of any combination of dimensions: “Show me the Revenue we made from Customer A for Product 1 in January 2007” Revenue:2,000,000. Measure Time Product Customer 11

  12. References • Butuza- A. 2011.Increasing the Business Performances using Business Intelligence • Microsoft SQL Server 2008 Analysis Services Step by Step. • Kenneth C. Laudon and Jane P. Laudon, Management Information systems. • Larissa T. Moss, ShakuAtre, Business Intelligence Roadmap: The complete Project Lifecycle for Decision Support Applications. • Turban, Efraim.Business Intelligence: managerial approach. 12

More Related