Financial Statement Weakness Analysis | Dataford Interview Questions

Analyze quarterly financial statements across business units and return only the periods that indicate operational weakness. Your query should combine income statement, balance sheet, and cash flow data, compare each quarter to the prior quarter, and assign a primary_issue label based on worsening margin, liquidity, or operating cash flow.

Schema

Tables

business_units
income_statements
balance_sheets
cash_flow_statements

What This Tests

Joining multiple financial statement tables at the same reporting grain
Using CTEs to structure a multi-stage analysis
Applying LAG() for quarter-over-quarter comparisons
Using CASE WHEN to classify business issues from financial metrics

Your question is Financial Statement Weakness Analysis. Start with the requirements and the four tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Schema

Tables

business_units
income_statements
balance_sheets
cash_flow_statements

What This Tests

Joining multiple financial statement tables at the same reporting grain
Using CTEs to structure a multi-stage analysis
Applying LAG() for quarter-over-quarter comparisons
Using CASE WHEN to classify business issues from financial metrics

Your question is Financial Statement Weakness Analysis. Start with the requirements and the four tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.