OLAP is a category of software that allows users to analyze information from multiple database systems at the same time. It is a technology that enables analysts to extract and view business data from different points of view. OLAP stands for Online Analytical Processing.
Four types of analytical operations in OLAP are:
- Roll-up
- Drill-down
- Slice and dice
- Pivot (rotate)
$git clone https://github.com/pyfet/DatawareHouse.git
$python -m venv venv #for Windows, fedora and arch based systems
$source venv/bin/activate
$pip install -r requirements.txt
$python3 OLAP.py