It can be difficult determining the exact server specifications for a Yellowfin instance as required resources differ greatly with the deployment model, number of concurrent users, report size and complexity, and the use of different reporting components like GIS functionality and Analytic Functions. This document will assist in determining the server specifications for a new instance of Yellowfin, using real installations as a guide.
Yellowfin Reference Installation 1
The Yellowfin deployment serves as the reporting layer for a work health safety application. Factory managers use the application to record details such as injuries and incidents at work places, safety toolkit checks, etc across factories. The reporting suite tracks and analyzes incident and injury reports.
Model: Single Server Installation
Total number of users: 300+
Concurrent users: 30
Environment: 1 application server, 1 database server. Database server contains both the Yellowfin database and the data warehouse.
Yellowfin Reference Installation 2
This Yellowfin deployment provides analytical and historical reporting for an e-commerce company specializing in the property market - the client uses this installation to report off their internal data warehouse.
The reporting suite in this installation is used both internally by sales staff and management, and externally by real estate agents. Internally, staff utilize the internal deployment to investigate sales performance, pricing, location popularity and geographical density, whereas management and executives refer to KPI reports and dashboards to track overall organizational performance. The external deployment provides estate price, popularity, and distribution for estate agents.
- Model: Single Server Installation
- Concurrent Users: 50
- Environment: 1 application server, 1 database server. Database server contains both the Yellowfin database and the data warehouse.
Yellowfin Reference Installation 3
This Yellowfin deployment provides analytical reporting to a higher education organization - the client uses this installation to report off their internal data warehouse.
The reporting suite in this installation is used internally by staff to track the performance and quality of research output by its constituents. Such results are analyzed with the reporting tool and compared against national/world benchmark values. This deployment is also used for monitoring and evaluating funding sources, staffing levels, current research progress, and applied measures.
- Model: Multi Server Installation
- Concurrent Users: 20
- Environment: 2 web servers, 2 applications servers, and a 5 node database server. The database server contains both the Yellowfin database and the data warehouse.
Yellowfin Reference Installation 4
This Yellowfin deployment provides analytical and historical reporting for a corporate travel agency; the client uses this installation to report off their third-party travel booking application’s data warehouse.
The reporting suite is available to internal staff, management, and their clients – staff are able to track air/accommodation bookings and ticketing information, executives often refer to daily KPIs and high level performance across the organization, and clients can log in and view their own travel expenditure. A small portion of the reporting suite utilizes the geospatial feature to track client locations at all times – this proved to be particularly useful in the event of disasters or terrorist attacks.
Client-facing staff in sales also use the mobile BI feature of Yellowfin extensively.
- Model: Single Server Installation
- Concurrent Users: 10
- Environment: 1 server containing the application server, database server, and data warehouse.
Yellowfin Reference Installation 5
This Yellowfin deployment provides analytical and historical reporting for a road tolling company – the client uses this installation to report off their internal tolling and billing system.
The reporting suite is used internally to track vehicle and tag logistics, check process and data workflows, assist in road tolling crisis management, and maintain financial integrity of their billing system.
This installation also provides financial reporting for internal staff and externally to the Australian Stock Exchange (ASX).
- Model: Multi Server Installation
- Concurrent Users: 100
- Environment: 2 web servers, 2 applications servers, and a 2 node database server. The database server contains both the Yellowfin database and the data warehouse.
Yellowfin Reference Installation 6
This Yellowfin deployment provides analytical reporting for an e-commerce company in the telecommunications sector – the client uses this installation to report off their internal data warehouse.
The client offers this reporting suite as a client-facing external feature of their portal. Businesses who sign up with this client are able to track appearances, interactions, and visibility of their online and offline advertisements, thus providing ROI reporting on their investment.
- Model: Multi Server Installation
- Concurrent Users: 6,000
- Environment: 4 web servers, 4 applications servers, and a 4 node database server. The database server contains both the Yellowfin database and the data warehouse.
Previous topic: Scalability testing