Hudson's Bay Company Wfm Real Time Analyst Interview Questions and Answers

Occupancy, conformance, and SL target calculations in Excel

• Occupancy calculation: divide total handle time by total available time

• Conformance calculation: divide total scheduled time by total worked time

• SL target calculation: determine the percentage of interactions meeting the service level target

• Use formulas like =SUM(range)/COUNT(range) for calculations

• Format cells as percentages for SL target calculation

Real-time analysts must have strong decision-making capabilities to quickly assess situations and make informed choices.

• Ability to analyze data quickly and accurately

• Prioritizing tasks based on urgency and impact

• Adapting to changing situations and making decisions under pressure

• Utilizing technology and tools effectively to make informed decisions

• Communicating decisions clearly and effectively to stakeholders