Excel and Structured Query Language Questions

Assesses practical data analysis ability using spreadsheet software and structured query language. Candidates should demonstrate comfort with spreadsheet features such as formulas, pivot tables, lookup and aggregation functions, data cleaning and tabular modeling, and creating charts and executive ready summaries. For structured query language, candidates should be able to write queries that join tables, filter and aggregate data, compute running and windowed metrics, and perform cohort or funnel analyses; they should also understand extract transform and load workflows and how to extract sales data from customer relationship management systems or data warehouses. Interview tasks typically include writing queries or spreadsheet formulas to compute pipeline health, conversion rates, ramp estimates and other sales metrics.