Structured Query Language and Spreadsheet Analysis Questions

Focuses on hands-on ability to extract, clean, analyze, and present data using SQL and spreadsheet tools together. Expect discussion of writing SQL queries to join tables, filter and aggregate records, and compute business metrics relevant to the role (for example conversion rates, revenue by cohort, defect rates, or headcount and attrition, depending on domain). Cover data cleaning and validation techniques, building repeatable and parameterized queries, moving outputs into spreadsheets, and using pivot tables, lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH), formulas, and basic automation (macros or scripting) to summarize and present results. Candidates should also explain how they document and reproduce analyses and hand off artifacts for reporting or dashboarding.