Introduction
Perfect Gym offers a Business Intelligence Module subscription. This article introduces a business guide explaining the basic terms connected to BI and its functioning.
- This article is dedicated to PG Champions and Managers who would like to understand what BI is about.
Types of BI Module Subscriptions
- Perfect Gym PGM BI Module Subscription - Dedicated Data Mart plus the predefined Dashboards in the PGM system.
- Perfect Gym PGM BI Module Add-on - ETL Connector - allows you to extract data from Data Mart for your own purposes. This is a connection to SQL Server. You must have advanced IT competencies in your team to use it.
BI Module fundamentals: OLTP vs OLAP
To understand what BI Module is about, you should become familiar with these terms:
OLTP - Online Transactional Processing is a category of data processing that is focused on transaction-oriented tasks. OLTP typically involves inserting, updating, and/or deleting small amounts of data in the database. OLTP mainly deals with large numbers of transactions by a large number of users…. in other words, this is a company Database in the Back Office with a PGM, and a bunch of other well-known PG apps, as a user interface 🙂
OLAP - Online analytical processing is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas… in other words, this is our BI Module with a Data warehouse and your Power BI software, or any other data visualisation tool, as the presentation layer.
BI Module Subscriptions Comparision
| Subscription | Technical Scope |
Where Data is consumed |
Who builds & maintains reports | Scope of data | Data synchronization interval | Technical skills required on the customer side | Access type | Flexibility |
| PGM BI Module |
|
in PGM on predefined BI Dashboards, Predictive Models & Recommendation Engine | Perfect Gym | limited - predefined reports | 1 day | low - experience with PGM |
user in PGM |
low (only predefined reports and models) |
| BI Module Add-on: ETL Connector |
|
depends on customer decision - can be any tool | Customer | whole PG DWH data model* plus a possibility to join data from other sources | 1 day | high - own infrastructure, db admin, data analyst | direct SQL db access via WAF | very high - ability to build own data warehouse collecting data from various systems |
ETL Connector Architecture
BI Module Data Scope
Check this article to become familiar with a data schema available through ETL Connector
BI Module Performance
- Perfect Gym doesn't support of any external tools connected to PG BI Data Mart and any data made available through it (e.g. reports created by the client or 3rd party).
- BI Data Mart has a different structure and stores less data than its source system Perfect Gym Manager (e.g. data entities or their attributes).
- Perfect Gym sets and enforces the limits of your use of PG BI Data Mart and does not guarantee response times or processing capacity to inquiries and reserves the right to block e.g. non-optimized, too complex or overburdening queries at its sole discretion.