Sample warehouse · Kimball · SQL · Tableau

ABC Bank data warehouse

A governed star schema for a fictional bank. Coursework, not a client engagement.

• DePaul coursework
• SQL
• Tableau
• Kimball

Sample warehouse case. ABC Bank is fictional. This did not ship for a real bank.

1. 01 · The ask

   Build a governed single source of truth for KPI reporting from scratch.

2. 02 · What I modeled

   A Kimball star schema for the sample bank, with the CSVs that sit in the repo.

3. 03 · What they used

   Tableau on top of the model, with a Power BI comparison in the writeup.

4. 04 · What I taught

   Grain, facts versus dimensions, and why the warehouse comes before the chart.

All work