Solutions / OLAPseek

OLAPseek is an open source application for visualizing data from OLAP cubes. The application allows you to view pre-configured reports and graphs based on data from OLAP cubes, built with third-party ETL tools such as Pentaho Data Integration .

The application has the following benefits:

• simple interface that does not require user training;
• low server performance requirements, up to 100 users on a regular PC;
• no user licenses;
• support for main databases as a source of OLAP cubes - MariaDB, MySQL, MS SQL, Postgres, Oracle;
• the ability to connect charts from the extensive D3.js library;

Data visualization

«The world is complex, dynamic, multidimensional; the paper is static, flat. How are we to represent the rich visual world of experience and measurement on mere flatland?» © Edward Tufte

Check out examples of graphs plotted using the OLAPseek app.

Sample reports

Examples of OLAPseek reports are built for a distribution business model, with data aggregation by month:

• Plan/fact
• Comparison by YTD or MAT
• Comparison by periods
• RFM-analysis
• Holt-Winters forecast
• Sales per employee
• Inventory turnover