Introduction to the new concept of bi-learning

• What is a unified dimension model

• Hierarchies, levels, members, and measures

• What is MDX

• The difference between MDX and SQL

• What is a data warehouse

• What is an OLAP data analysis engine

• BI Enterprise-Class solutions

What is a unified dimension model

A dimension (dimension) is an organized hierarchy that describes the level of data in a fact table

The purpose of the Unified Dimension Model (UDM) is to build a bridge between the user and the data source. The UDM is constructed from one or more physical data sources, and end users can use one of several client tools, such as Microsoft Excel, to issue queries against the UDM.

Hierarchies, levels, members, and measures

A relational database organizes data in a two-dimensional flat table. These tables have one column dimension and one row dimension. There is only one data element at the intersection of each row and column.
Multidimensional databases are different, based on structures called cubes, as shown in. Cubes organize data by hierarchy, rather than as a table.

This is a more classic diagram ...

What is MDX

Mdxmdx--multidimentionalexpressions is a multi-faceted, descriptive-based scripting language that defines, manages, and queries the syntax of SQL SERVER 2005 Analysis SERVICES (SSAS) multidimensional objects and data.

The difference between MDX and SQL

SQL is proposed by Microsoft and other manufacturers, it is not only a query language, but also a set of query standards, to provide a relational database operation and query

Based on the extended SQL syntax rules, MDX also provides data definition functionality, which is the function of expression.

Similarities and differences between SQL and MDX query syntax

SELECT{[Measures].[Sales Amount],[Measures].[Tax Amount]} onCOLUMNS, {[Date].[Fiscal Time].[Fiscal Year].&[ -],[Date].[Fiscal Time].[Fiscal Year].&[ -]} onROWS from [Adventure Works] WHERE([Sales Territory].[Southwest])

In this example, the query defines the following cell set information: The SELECT clause sets the query axis to the sales Amount and tax Amount members of the measures dimension, as well as the 2012 and 2013 members of the date dimension. The FROM clause indicates that the data source is a adventure Works cube. The WHERE clause defines the slicer axis as the southwest member of the Sales Territory dimension.

The difference between MDX and SQL

What is a data warehouse

If your company's data is in many places like most companies, such as multiple databases and operating systems. The Data Warehouse is a container that collects data together to help you get critical information easier and easier.
Microsoft Business Intelligence (BI) 's Data Warehouse components provide a central place for storing data and maintaining all important historical business information and current business information. With a data warehouse, you can easily create reports and analyze information without impacting the performance of your operating system. The Data Warehouse also provides an integrated view of the data, which is very clean and has been transformed and normalized, so you can trust the quality of the information you receive.

What is an OLAP data analysis engine

OLAP (i.e. online analytical processing, on-line Analytical Processing) presents and stores data in an understandable format, provides calculations of measurement data, and allows you to ask questions by investigating information points of interest or interest.
More specifically, the OLAP engine extracts data from one or more data sources and re-recognizes it as a multidimensional structure, making navigating and analyzing data more intuitive and faster. Microsoft SQL Server 2005 Analytics Services is an industry-leading OLAP engine that combines data for easy analysis and can centralize storage agency business logic and key performance indicators (KPIs). This is the formula and calculation method that the organization uses to measure performance. In addition, you can use analysis tools to access data to analyze or "talk to data."

BI Enterprise-Class solutions

Key Performance KPIs

In business terminology, a key performance indicator (KPI) is a measurable measure that is used to measure business performance. KPIs are often evaluated over a period of time.
For example, a unit's sales department can use the monthly gross profit as a key performance indicator, but the human resources department of the same unit can use the employee churn per quarter as a key performance indicator. Both of these are examples of KPIs.

DataMining Data Mining

In short, datamining is in the huge database to find a valuable hidden event, by the statistics and artificial intelligence science and technology, the data to do in-depth analysis, to find out the knowledge, and according to the Enterprise's problems to establish different models, in order to provide enterprise decision-making reference. For example, banks and credit card companies can use the technology of datamining to screen, analyze, deduce and predict large customer profiles, identify which customers are most contributing, which are high-loss groups, or predict the likely response rate of a new product or promotion. Be able to provide suitable products and services at the right time. In other words, through the datamining Enterprise can understand its customers, grasp their preferences, to meet their needs.
In recent years, DataMining has become a hot topic for enterprises. More and more enterprises want to import datamining technology, generally datamining long-range applications include finance, insurance, retail, direct marketing, communications, manufacturing and medical services.

DataMining Data Mining algorithm

Summary: All of this is visual editing, as simple as configuration ... As long as the business thinking clearly not write code people can get started.

Effects after BI is implemented

⊙ improves the performance of OLTP system execution

⊙ enhance the analytical statistic ability of ERP system

⊙ streamline reporting, improve efficiency, decision support

Introduction to the new concept of bi-learning