Community Medical Centers (CMC) is a network of 22 neighborhood health centers based in Stockton, California. Started as a volunteer effort in the 1960s to serve agricultural workers, it has grown into a thriving nonprofit providing vital care to men, women, and children, regardless of ability to pay. CMC offers a wide range of services, including medical care, health outreach and education, behavioral health services, dental care, and HIV early intervention. Last year, CMC served over 100,000 patients across three counties and continues to grow.
In 2017, CMC had very limited capabilities for analyzing their data and presenting insights—or even the raw data itself—to the users who needed it. Developing solutions on their existing SQL Server Reporting Services platform took too long for each project to achieve real value, leading to a backlog of analytics requests and many challenges for delivering timely executive reporting. After searching the market for visualization tools, CMC landed on Tableau, which had a pricing model and on-premises option that fit well with the health center's needs. To date, CMC has built more than 70 Tableau dashboards and conducted in-house orientation classes that have helped Tableau adoption reach leadership teams and other personnel in all of their facilities.
The onset of the COVID-19 pandemic has made this access to analytics more vital than ever before, in part because of the increased reliance on telehealth visits. As a community health center, CMC relies heavily on in-person patient visits to sustain its operating budget. But the coronavirus crisis drastically reduced CMC’s number of in-person visits, threatening to decimate the organization’s operating budget. But this year, the virus threatened to decimate those revenues due to the risks of seeing and treating patients face-to-face. In April 2020, the National Association of Community Health Centers projected 34 million fewer in-person visits in the community health subsector over six months, resulting in $7.6 billion in lost revenue and more than 100,000 lost jobs. California was the U.S. state predicted to lose the most revenue by far, with more than twice the projected losses of the second state on the list, New York.