The Lake County Health Department and Community Health Center is a combined statutory public health entity and health service provider serving more than 700,000 residents of Lake County, a suburban area of Chicago and the third most populated county in Illinois. When the Health Department implemented Tableau Online in 2017, adoption was slow, mostly due to data limitations: With more than 20 disparate data sources and 36 different applications tracking everything from patient data and community events to behavioural health and infectious diseases, Tableau users struggled to access the data required for making strategic and tactical decisions that would drive the organisation forwards.
The department came up with a strategic plan to centralise its analytics activities, drive self-service analytics so all employees could make informed decisions based on relevant data, and curate highly visible reports that would help drive organisational improvement. Previous methods for producing these reports required intensive allocation of engineering, computing and planning resources. By implementing Tableau Server and using Tableau Prep Conductor, part of Tableau's Data Management Add-on that automates data flow scheduling and enables easy flow monitoring and administration, the department reduced the burden of creating and managing the reports to the point that they now require almost no resources to maintain. This frees up time for patient care teams, creating opportunities for them to help more patients in the communities they serve.