Banking Dataset for Power BI

• accounts.customer_id →references customers.customer_idmany to one: each Accounts row points to one Customers row
• transactions.account_id →references accounts.account_idmany to one: each Transactions row points to one Accounts row

1. Visualize the distribution of account types by customer country.

   Join accounts and customers tables, then group by country and account_type.

   tables: accounts, customers

2. Create a dashboard showing monthly transaction volume and average transaction amount for each account type.

   Join accounts and transactions tables, extract month from transaction_date, and group by account_type and month. Calculate count and average of amount.

   tables: accounts, transactions

3. Identify the top 5 customers by total transaction value.

   Join all three tables, sum the amount for each customer, and order by the sum in descending order.

   tables: accounts, customers, transactions

4. Write a SQL query to find the total balance for each customer, including their first name and last name.

   Join accounts and customers tables, group by customer_id, first_name, and last_name, and sum the balance.

   tables: accounts, customers

Table names match the SQLite file and the SQL script.

SELECT c.first_name, c.last_name, SUM(a.balance) AS total_balance
FROM customers c
JOIN accounts a ON c.customer_id = a.customer_id
GROUP BY c.customer_id, c.first_name, c.last_name
ORDER BY total_balance DESC
LIMIT 20;

SELECT strftime('%Y-%m', t.transaction_date) AS transaction_month, a.account_type, COUNT(t.transaction_id) AS transaction_count
FROM transactions t
JOIN accounts a ON t.account_id = a.account_id
GROUP BY transaction_month, a.account_type
ORDER BY transaction_month, a.account_type
LIMIT 20;

SELECT c.first_name, c.last_name, SUM(t.amount) AS total_transaction_amount
FROM customers c
JOIN accounts a ON c.customer_id = a.customer_id
JOIN transactions t ON a.account_id = t.account_id
GROUP BY c.customer_id, c.first_name, c.last_name
ORDER BY total_transaction_amount DESC
LIMIT 5;

SELECT country, COUNT(customer_id) AS customer_count
FROM customers
GROUP BY country
ORDER BY customer_count DESC
LIMIT 20;

Power BI

Create relationships between customers and accounts (one-to-many on customer_id), and between accounts and transactions (one-to-many on account_id). Suggested DAX measures: Total Balance = SUM(accounts[balance]), Total Transactions = COUNT(transactions[transaction_id]).

• CSV (zip)One CSV file per table, zipped
• Excel workbookOne worksheet per table
• SQLite databaseA ready-to-query database file with every table
• Parquet (zip)One Parquet file per table, zipped
• SQL scriptCREATE TABLE with primary and foreign keys, then INSERTs
• CSVA single CSV file
• JSONA single JSON file