70 likes | 189 Views
Business Intelligence (BI). Class presentation. What is BI ?. Transforms raw data into meaningful and useful information for business purposes. Handles large amounts of information to help identify and develop new opportunities.
E N D
Business Intelligence (BI) Class presentation
What is BI ? • Transforms raw data into meaningful and useful information for business purposes. • Handles large amounts of information to help identify and develop new opportunities. • Provides historical, current and predictive views of business operations. • Common functions are online analytical processing (OLAP), analytics, data mining, and predictive analytics.
Online Analytical Processing (OLAP) • OLAP is an approach to answering multi-dimensional analytical (MDA) queries swiftly. • The term OLAP was created as a slight modification of the traditional database term OLTP (Online Transaction Processing). • The core of any OLAP system is an OLAP cube that consists of numeric facts called measures which are categorized by dimensions.
Measures and Dimensions • Each measure has a set of labels, or meta-data, associated with it. A dimension is what describes these labels; it provides information about the measure. • A simple example would be a cube that contains a store's sales as a measure, and Date/Time as a dimension. Each Sale has a Date/Time label that describes more about that sale. • Any number of dimensions can be added to the structure such as Store, Cashier, or Customer by adding a foreign key column to the fact table. This allows an analyst to view the measures along any combination of the dimensions.
Analytics • The discovery and communication of meaningful patterns in data. Analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. • Analytics often favors data visualization to communicate insight.
Data Mining • The computational process of discovering patterns in large data sets involving methods at the intersection of artificial intelligence, machine learning, statistics, and database systems.
Predictive Analytics • Makes predictions about future, or otherwise unknown, events. • In business, predictive models exploit patterns found in historical and transactional data to identify risks and opportunities. • One of the most well known applications is credit scoring, which is used throughout financial services. Scoring models process a customer's credit history, loan application, customer data, etc., in order to rank-order individuals by their likelihood of making future credit payments on time.