Qualex Chat
Qualex Chat


Qualex Healthcare Practice II

Project Overview:

Qualex Consulting Services, Inc. (QLX) currently provides BI solutions for one of the largest healthcare insurers in the US. QLX provides consulting and implementation expertise to develop ETL processes and BI reporting using OLAP and web technology to provide access to large amounts of data stored in the customer’s “Enterprise Data Warehouse.”

Our task was to work with the actuarial team to provide tools for analyzing up to 7 years of claim and enrollment data in a way that would allow for quick and easy analysis as well as a method for providing standard monthly reports. One of the challenges with claims and enrollment data analysis besides the massive amounts of data to be analyzed, is the non-additive nature of the data. Providing summarization of large data in a “cube” environment can become complicated when drilling into claim and enrollment data. Analysis fields like Utilization and Per Member/Per Month can present significant challenges when attempting to incorporate them into a multi-dimensional structure like OLAP Cube. For example, a common actuarial metric is the calculation of Per Member/Per Month cost, or PM/PM. The numerator in this ratio is total claims cost in dollars. The denominator is total members enrolled, including members who have no claim costs and are not represented in the numerator. This metric is a challenge in standard OLAP reporting tools because the numerator and denominator represent different populations at different levels of summation. If a user wants to look at the data across various levels of claims dimensions, such as CLAIM TYPE, the numerator will change depending on whether the user is looking at Inpatient, Outpatient, Professional or Drug claims. However, the denominator, the total population of members remains constant across these levels.

Qualex Solution:

There are several tools by the client to develop and surface OLAP cubes. To develop cubes, we used the latest technology available in the market. These tools assist the developer in defining the structure of the cube and handling big amounts of data in an effective way.

The developer defines dimensions and hierarchies, or drill paths, based on the anticipated approach an analyst might take to addressing business problems. The analysis variables or measures are also defined. To surface cubes to users there are several tools available. Each of these allows the user to analyze the data by examining slices, of the cube quickly and easily. However, Qualex can provide more than just tools. With our extensive experience using a variety of BI and ETL tools, we can not only develop a tool for analysis or reporting, but can help you better understand your data. Qualex can assist with designing data structures from the complex maze of data sources inside the typical insurers’ structure. We can work with your team to not only design a valuable reporting environment, but also provide training and expertise in a wide variety of areas.


  • Non-additive fields like Utilization and PMPM are key metrics in the health care industry to help spot trend in health care costs.
  • While actuaries have a wealth of OLAP tools available to them now to analyze the data in their organization, this important statistic is not available out of the box.
  • However, there are customizations that developers can perform to bring PMPM into the analysts’ arsenal of tools.
  • Qualex has proven experience in this area and understands the complex nature of these tasks.

Qualex Contact:


  1. borgata online casino promotions

    new vegas online casino https://onlinecasinos4me.com/

  2. ti casino online

    online casino games free https://online2casino.com/

  3. us casino online

    lotus casino online https://casinosonlinex.com/

  4. mature gay chat

    free chat gay man colorado https://newgaychat.com/

  5. free gay chat apps for windows

    sex chat. gay descreet pueblo https://gaychatcams.net/

  6. gay cam chat avenue

    gay chat cam ramdom https://gay-live-chat.net/

  7. teen chat rooms 13-16 gay
  8. sex gay chat

    free gay chat no sign up https://gaychatnorules.com/

  9. 702 gay chat number

    random gay video chat https://gaymusclechatrooms.com/

  10. best free gay chat for curious

    dirty gay video chat https://gayinteracialchat.com/

  11. help with papers

    pay someone to do my paper https://term-paper-help.org/

  12. instant paper writer

    order custom papers https://sociologypapershelp.com/

  13. thesis paper help

    paper writing services legitimate https://uktermpaperwriters.com/

  14. order paper online
  15. custom paper writing

    write my philosophy paper https://writepapersformoney.com/

  16. help with your paper
  17. buy papers for college

    best custom paper writing service https://doyourpapersonline.com/

  18. help writing my paper
  19. will someone write my paper for me

    help me write my paper https://cheapcustompaper.org/

  20. custom paper services

    where can i find someone to write my college paper https://writingpaperservice.net/

  21. write my psychology paper

    pay to write a paper https://buyessaypaperz.com/

  22. best paper writers

    cheapest paper writing service https://mypaperwritinghelp.com/

  23. where to buy writing paper
  24. pay someone to write your paper

    custom writing papers https://essaybuypaper.com/

  25. need someone to write my paper for me

    do my college paper for me https://papercranewritingservices.com/

  26. buy a literature review paper

    buying papers online https://premiumpapershelp.com/

  27. paper writing services for college students

    can i pay someone to write my paper https://ypaywallpapers.com/

  28. papers help

    pay for someone to write your paper https://studentpaperhelp.com/

  29. 1disagreed


Enter Your Details