en flag +1 214 306 68 37
BI Solution for 500+ Nursing Homes

BI Solution for 500+ Nursing Homes

MS SQL Server


The Customer is a US company that renders services to 500+ nursing homes.


Having implemented BI reporting based on Strategy Companion Analyzer, the Customer 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 Customer 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).


Initially, the Customer 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 Customer 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 Customer:

  • 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.

picture 10

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.

picture 11


The Customer 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.

Have a question to our team or need help with your project?

Our team is ready to provide client references, estimate your project, or answer any other question related to your IT initiative.

Upload file

Drag and drop or to upload your file(s)


Max file size 10MB, up to 5 files and 20MB total

Supported formats:

doc, docx, xls, xlsx, ppt, pptx, pps, ppsx, odp, jpeg, jpg, png, psd, webp, svg, mp3, mp4, webm, odt, ods, pdf, rtf, txt, csv, log

More Case Studies