ETL in Data Mining

ETL in Data Mining

Definitions Data Mining is a methodical approach to identifying patterns in data. In the past, a good business analyst would look through data for trends, but with modern databases it is hard to work with data manually. Data mining allows you to instruct the computer...
Web-based OLAP Overview

Web-based OLAP Overview

Web-based OLAP Definition OLAP is a Business Intelligence technology designed to carry out analysis and draw up reports based on data available in a multidimensional view. OLAP is suitable for businesses with multiple departments and points on sales. Every location...
OLAP Security

OLAP Security

When working with Ranet OLAP, access to business data in the pivot table can be organized according to the principle of Microsoft SQL Server Analysis Services where you can customize access rights for all users. Such a security model based on users’ roles for each...
Multidimensional Expressions

Multidimensional Expressions

Multidimensional Expressions In BI world such tools as OLAP and multidimensional data analysis still play the leading roles. The reasons are clear: they are fast, accurate and efficient. But how does it work on practise? The key to this knowledge is MDX query...
MOLAP – Multidimensional OLAP

MOLAP – Multidimensional OLAP

Overview There are basically three types of online analytical processing: MOLAP, ROLAP, and HOLAP. In this article we’re going to speak about MOLAP particularly. MOLAP is short for multidimensional online analytical processing: it is taken for the traditional version...
Write US