Applied LLMs in Pharmacy Practice

We are presenting novel AI capabilities in support of the Collaboration to Harmonize Antimicrobial Registry Measures (CHARM), whose centralized dashboard is hosted and supported by the Ferris State University College of Pharmacy.

The first of two completed projects extends that dashboard — a web-based Power BI environment — with a conversational interface. Instead of drilling through filters and report screens, users simply ask a question in plain language. Behind the scenes, a text-to-SQL layer paired with a large language model interprets the question, translates it into a valid query, and returns the matching data. Every request is validated before it runs, and privacy safeguards are built-in to keep patient data protected and HIPAA-compliant, so faster access never comes at the cost of trust.

‍
The second project applies the same technology to the business side of pharmacy practice. It automates the groundwork behind pharmacy service planning: prospect identification, market analysis, and the assembly of a comprehensive report that a pharmacy owner or health-system leader can review and act on. Work that once consumed many hours of manual research now takes a fraction of the time, freeing pharmacists and administrators to focus where their expertise actually matters — judgment, strategy, and patient care.

Together, the two projects illustrate a practical pattern we would like to share at Tech Week: AI as an accelerator for domain experts, not a replacement for them.