Which branches and currencies carry the most activity? How does behavior differ by credit-score band, account type, customer sector, and city? When are the peak transaction hours?
Banks act on branch, product, and customer-segment insights. Analysis built on data nobody has checked leads to confident but wrong decisions, so this project proves the data can be trusted before answering any business question.
A retail-banking analysis in SQL Server that answers questions such as which branches and currencies carry the most activity, how behavior differs by credit-score band, account type, sector, and city, and when transactions peak.
The workflow mirrors a real analyst engagement: first prove the data can be trusted (validation), fix what is broken (transformation), then analyze. A query-by-query walkthrough in the repository shows each SQL statement, its result, and what it means.