Pharmacy research you can check.

A pharmacy dashboard is only as useful as the observations behind it. In this project, crowdsourced visits gathered information on medicine availability, prices, promotional materials and activity in pharmacies.

I led the work from field assignments through evidence review to client reporting.

Make the task clear

Auditors worked from a pharmacy address list, visit instructions and structured questionnaires. Each assignment specified what to observe and what evidence to collect.

A visit record linked the answers to a pharmacy, date, visit ID and photographs with location information. Reviewers could check what had been submitted and where it came from.

Review before reporting

Visits could be accepted or rejected. Submitting a questionnaire was one step; meeting the evidence standard was another.

That distinction mattered when many people were collecting data in different locations. The instructions, evidence requirements and review status helped keep the final dataset consistent.

Let clients see the evidence

We delivered visit records and photographs alongside a Power BI reporting portal. Clients could explore results by city, pharmacy network and audited product or material, then inspect the visits behind the figures.

The project connected fieldwork and reporting in one process. Its lesson extends beyond research: design how data will be collected and checked before designing the dashboard.