Business Analysis OLAP
Business analysis is that the term wont to describe visualizing knowledge during a three-dimensional manner. Query and report knowledge usually is conferred in row when row of two-dimensional knowledge. The first dimension is that the headings for the knowledge columns; the second dimension is that the actual data listed below those column headings.
Business analysis permits the user to plot knowledge in row and column coordinates to more perceive the intersecting points. In essence, this visualization of OLAP is most frequently utilized with AN OLAP specialty info, although the business analysis can be done without such a database.
Business analysis introduces analytical processes and a degree of variability into the user interaction model. Conceptually, the first steps are pretty much the same as the steps for querying and reporting, but then the user takes over:
Manipulate the data.
Look at it in a different way. Place some knowledge on the rows, place other data on the columns, place the interested measurement at the intersecting cell.
View the new results.
Change the presentation style of the data into a bar graph or line chart. Add in another column of knowledge to refine the points on the graph. In addition, the user can request the data beneath the data, such as the details underneath a summary.
What Is OLAP?
OLAP could be a class of code that enables users to research info from multiple info systems at a similar time. It is a technology that allows analysts to extract read business knowledge from totally different points of view. OLAP stands for Online Analytical Processing.
Analysts frequently need to group, aggregate and join data. These operations in relational databases are resource intensive. With OLAP knowledge will be pre-calculated and pre-aggregated, making analysis faster.
OLAP databases square measure divided into one or a lot of cubes. The cubes are designed in such a way that creating and viewing reports become easy.
At the core of the OLAP, concept is an OLAP Cube. The OLAP cube could be a organization optimized for terribly fast knowledge analysis.
The OLAP Cube consists of numeric facts referred to as measures that square measure classified by dimensions. OLAP Cube is also called the hyper cube.
Usually, data operations and analysis are performed using the simple spreadsheet, where data values are arranged in row and column format. This is ideal for two-dimensional data. However, OLAP contains multidimensional data, with data usually obtained from a different and unrelated source. Using a spreadsheet is not an optimal option. The cube can store and analyze multidimensional data in a logical and orderly manner.
How does it work?
A Data warehouse would extract information from multiple data sources and formats like text files, excel sheet, multimedia files, etc.
The extracted data is cleaned and transformed. Data is loaded into AN OLAP server (or OLAP cube) wherever info is pre-calculated ahead for more analysis.
Basic analytical operations of OLAP
Four types of analytical operations in OLAP are:
- Slice and dice
- Pivot (rotate)