
BI Solution for 500+ Nursing Homes
About Our Client
The Client is a US company that renders services to 500+ nursing homes.
Challenge
Having implemented BI reporting based on Strategy Companion Analyzer, the Client ended up with multiple overlapping automatically generated cubes with the restricted tuning possibility, limited functionality and no naming convention observed.
Dissatisfied with their existing analytical system, the Client chose ScienceSoft as an expert in business intelligence services. The ultimate objective was to develop an analytical system with a universal cube, as well as establish a standardized and comprehensive reporting.
Security was another challenge to solve, as the process used to run as follows: after the system produced the report, the administrator copied it, applied filters and allocated duplicate filtered reports to different folders (each folder showed the information about a certain US state).
Solution
Initially, the Client and ScienceSoft started out with a trial project. The project scope included analytical cube development that was based on one of the existing cubes generated by Strategy Companion Analyzer. Once the trial project finished successfully, the Client r commissioned ScienceSoft’s team to proceed with a universal analytical cube development.
ScienceSoft started with creating a data warehouse based on Microsoft SQL Server. After that, the team developed three ETL modes:
- From scratch
- Incremental
- Monthly publishing
ScienceSoft’s team also delivered a universal analytical cube that embraced 4 important business areas, as identified by the Client:
- Residents
- Encounters (any contact with a resident: personal, by phone or via the Internet)
- Claims (invoices issued after encounters)
- Transactions (invoices paid and due)
ScienceSoft’s team kept Strategy Companion Analyzer as user interface technology.
At the closing project stages, ScienceSoft’s team was working to bring the security to Microsoft SQL Server Analysis Services (SSAS) level. The solution will help to avoid duplicate reports for different users. Instead, one report will be created and the users will access particular information blocks according to their permissions.
Results
The Client benefited from the improved analytical process and standardized reporting. Additionally, the consolidation achieved at all levels (database, SSAS and reporting) simplified the analytical system support.
Technologies and Tools
Microsoft SQL Server, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Strategy Companion Analyzer.
More Case Studies
80 results for:

Underwriting Automation Software for a Global Aviation Insurer with $30B in Assets
A custom underwriting system automates risk assessment, insurance pricing, policy administration, task management, and compliance control. The new software helped increase underwriter productivity, minimize the risk of fraud, and reduce IT costs.

The World’s Largest PLM Software for 12K+ Enterprises with $300B in Annual Sales
ScienceSoft delivered product lifecycle management software that helps 12,000 manufacturers and 32 large retailers worldwide communicate faster and improve supply chain transparency. The platform drives the development of products with $300+ billion in annual sales.