Food and Drug Retailer Company - Netwoven
Case Studies

A health care service provider innovates solutions for optimizing appointments and vaccination schedules

Customers
Customer Food and Drug Retailer Company IndustryFood and Drug RetailerCountryUnited States
Solutions Provided
  • Dynamics 365
About Food and Drug Retailer Company This company is one of the largest food and drug retailers in the United State. With both a strong local presence and national scale, this company operates across 35 states with over 2,200 stores, 22 distribution centers, and 19 manufacturing plants.

Assessing Appointment Trends with actionable insights using Dynamics 365 and Power BI Case Study

Overview

The company developed an approach to capture snap-shot of daily appointments for identify trends and to help stores in forecasting participants/customers and vaccine inventory .

Challenges

The company’s management would like to identify if their investment efforts in improving the company website and scheduling online form have resulted in monthly increase in number of B2C vaccines appointments. They needed insight on which geographical region and store location are profitable and which ones may need assistance.

Solution

  • Power Automate flow that runs nightly was developed to capture aggregate number of daily appointments submitted in an online form and captured in Dynamics 365 Field Service.
  • Custom table in Dynamics 365 Field Service was created to store aggregate data.
  • Power BI dashboard with filters was developed to compare number and percentage of available appointments versus booked appointments by date range (weekly, monthly), by location (state, business region), and by team responsible for managing each stores.
  • Visuals in Power BI reports provided insight to overall state of the business and allows management to drill down to more granular information in a single report.

Assessing Appointment Trends Using Dynamics 365

Outcomes

  • Data-Driven Decision Making: providing valuable insights into the website and scheduling improvement efforts, enabling better strategic planning going forward.

Business Impact

  • Decrease financial loss by providing valuable insights on where to focus appointment efforts
  • Decrease financial loss forecasting participants/customers and vaccine inventory for each store
  • Improved productivity and efficiency in store operations by having granular information
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Unravel The Complex
Stay Connected

Subscribe and receive the latest insights

Netwoven Inc. - Microsoft Solutions Partner

Get involved by tagging Netwoven experiences using our official hashtag #UnravelTheComplex