Structured Query Language and Spreadsheet Analysis Questions

Focuses on hands on ability to extract, clean, analyze, and present human resources data. Expect discussion of writing queries in structured query language to join tables, filter and aggregate records, and compute common workforce metrics such as attrition, headcount by cohort, time to hire, and tenure distributions. Cover data cleaning and validation techniques, building repeatable queries, moving outputs into spreadsheets, and using pivot tables, lookup functions, formulas, and basic automation to summarize and present results. Candidates should also explain how they document and reproduce analyses and hand off artifacts for reporting or dashboarding.