SQL for Finance Professionals
Financial reporting from source data: revenue and margin, budget versus actual and variance reporting, trial balances and statement extracts, payment reconciliation, account activity and workforce costs. The capstones reconcile a bank statement to the ledger and analyse hotel revenue management metrics.
1. Tracks
2. Capstone projects
- Bank reconciliation for the year-end closeMatch two years of bank statement lines to Tahlia Trading's books, explain every difference and prove the reconciliation closes to the riyal.
- Hotel revenue managementAllocate room-nights to the right month, compute occupancy, ADR and RevPAR for seven hotels, and explain cancellations, channel mix, seasonality, repeat guests and ancillary spend.