by Galaktikasoft | Feb 28, 2018 | Ranet OLAP Blog |
Introduction Ranet OLAP as the name implies is an online analytical processing which refers to mining and analyzing fresh data belonging to current business processes. Owing to OLAP information originating from several sources can be stored in various formats in one... by Galaktikasoft | Feb 27, 2018 | Ranet OLAP Blog |
1. Detecting the flaws All large organizations managing big amounts of storage data have to regularly optimize databases performance. In this article we’re going to review several methods to enhance OLAP performance particularly. Those methods are aimed to improve the... by Galaktikasoft | Feb 6, 2018 | Ranet OLAP Blog |
What is BI According to Gartner glossary business intelligence (BI) is an umbrella phrase that involves applications, infrastructure, tools, and best practices which ensure access to the analysis of the requisite information to boost and enhance performance and... by Galaktikasoft | Feb 5, 2018 | Ranet OLAP Blog |
What is the use of OLAP Being a part of BI, OLAP technology, developed to enable fast extraction of requisite data from the data warehouse, is populated from OLTP databases (CRM, ERP, AR, AP etc.) through ETL tools. Online Analytical Processing systems, offered today... by Galaktikasoft | Jan 31, 2018 | Ranet OLAP Blog |
OLAP Cubes Today we’d like to highlight the most principle part of OLAP technology – OLAP cube. If you had ever wondered what is a cube in BI in general and want to define OLAP cube technology you will likely find the answer here. The Technology of an OLAP... by Galaktikasoft | Jan 25, 2018 | Ranet OLAP Blog |
OLAP is a widely spread technology belonging to Business Intelligence processes developed to coordinate and analyze vast amounts of data. OLAP databases are stored in the form of multidimensional cubes where each cube comprises the data supposed relevant by a cube... by Galaktikasoft | Jan 23, 2018 | Ranet OLAP Blog |
OLTP and OLAP difference Nowadays, practically all organizations can’t but accept big data streaming and processing as the most valuable resource to profit in their business. Due to data mining and handling companies are able to apply analytics and collect vital... by Galaktikasoft | Dec 12, 2017 | Ranet OLAP Blog |
OLAP Basics and Multidimensional Model What is Online Analytical Processing? Short history of OLAP OLAP systems overview Types of OLAP OLAP vs. OLTP OLAP operations OLAP APIs OLAP analysis tools Advantages and disadvantages of OLAP Application of OLAP What is Online... by Galaktikasoft | Dec 5, 2017 | Ranet OLAP Blog |
As you know, the data in OLAP cubes has a multilevel hierarchical structure. This form of data representation is easy and comprehensible for humans. However, when the client application receives it from the OLAP data source, it is transformed into a flat table.... by Galaktikasoft | Nov 29, 2017 | Ranet OLAP Blog |
One of the most sought-after capacities of business intelligence engine is visual representation of business data in the web pivot table. We have already written about sparklines in one of our previous posts. Using sparklines is especially useful while ad hoc... by Galaktikasoft | Nov 28, 2017 | Ranet OLAP Blog |
Before you start using BI software based on OLAP it is important to understand the basic terms and concepts of OLAP. Let's start with OLAP itself. OLAP (online analytical processing) is a technology that provides users with the fast and high-quality processing of... by Galaktikasoft | Nov 22, 2017 | Ranet OLAP Blog |
Business intelligence systems offer powerful tools for precise ad hoc reporting. One of useful options is a possibility to save and download reports. It allows users to share reports with teammates or continue working with document in the web pivot table later without...