New York City Department of Health and Mental Hygiene Deploys Logi Ad Hoc to Empower Users
Logi enabled the NYC Department of Health and Mental Hygiene to build, create, and view analytical reports, resulting in significant time and cost savings.
With an annual budget of $1.6 billion and more than 6,000 employees throughout the five boroughs, The New York City Department of Health and Mental Hygiene is one of the largest public health agencies in the world, serving 8 million New Yorkers. The Department has a very clear mission, but a very daunting challenge — protect and promote the health of all New Yorkers.
The Department has an expansive information system infrastructure that stores data of every kind. With data coming in from multiple sources and populating various disparate systems, the Bureau of Informatics and Information Technology (BIIT) identified a need to empower users with innovative software tools to help achieve their business and public health objectives.
Specifically, BIIT sought a web-based, self-service reporting tool with a highly intuitive user interface. While The Department uses Business Objects for various business intelligence functions, the system did not meet the need for customized, ad hoc reporting.
The BIIT team has also been tasked with very specific program objectives such as helping clients in the Asthma Initiative Program. The team needed a better way for department users to analyze information about individuals with asthma. The program’s database contains statistical data on asthma cases in the city and information from medical providers to determine what services are available and where patients can access those services. The database system provides reliable data, but navigating the database structure is complex and this has made it difficult to query for non- technical users.
“If the IT team created all the queries the users currently require, it would not only take a long time but may not actually be all the queries needed and may not be the same queries they will need next week. These are sophisticated professionals who are experts on the data, so the ideal solution was to let the users develop their own ad hoc queries,” stated Alex Novoselsky, Client Manager, New York City Department of Health and Mental Hygiene.
Logi makes reporting easy for the users, while simultaneously eliminating any backlog of report requests for IT.
“We want to make reporting easy for the users, while simultaneously eliminating any backlog of report requests for IT. Logi helps us make this happen,” explains Mr. Novoselsky, who helps the largest part of Logi users.
“The solution was to provide users with Logi Analytics so they could construct their own reports. We trained them on database content and the software, since it is very easy for them to learn and use. Now, they go directly to their data to get the information they want for program planning and management reporting. No longer a task for IT, Logi created a virtually self-service operation,” continued Mr. Novoselsky.
Users are now able to build, create, and view reports, resulting in the creation of over 7,000 reports to date. Implementation of Logi has resulted in significant time and cost savings. The Department has created reports such as Google Map reports displaying the number of school children with the flu. Users are able to run reports based on school location, community, and region.
The Division of Mental Hygiene had a similar challenge. The Department utilizes a large quantity of service providers to meet the service need of patients. The process of tracking their work, their qualifications, and their compensation creates a huge amount of data that can yield important insights into service utilization and cost controls.
“Our users know the data. They just do not know SQL. We needed a way to empower our users to build their queries and generate the reports they need. Using Logi meant that the challenges of using complicated SQL syntax to build a report simply went away. And the fact that Logi can be accessed via a Web browser made the implementation a very simple process,” concluded Mr. Novoselsky.