Scribd
Upload
6 views11 pages

Credit Card Transactions Data Analysis

The document outlines a data analysis case study focused on credit card transactions, detailing various queries to extract insights from a single table of credit card usage data. Key queries include identifying top spending cities, analyzing monthly spending by card type, and examining transaction details and growth metrics. The study aims to uncover patterns in spending behavior across different demographics and timeframes.

Uploaded by

shivani singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views11 pages

Credit Card Transactions Data Analysis

The document outlines a data analysis case study focused on credit card transactions, detailing various queries to extract insights from a single table of credit card usage data. Key queries include identifying top spending cities, analyzing monthly spending by card type, and examining transaction details and growth metrics. The study aims to uncover patterns in spending behavior across different demographics and timeframes.

Uploaded by

shivani singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Credit Card

Transactions
Data Analysis Case
Study
DATA UNDERSTANDING
There is only one table

credit_card_transcations: contains information about credit


card usage

This is just as small part of table


• Write a query to print top 5 cities with highest spends
and their percentage contribution of total credit card
spends

Result
•
• Write a query to print highest spend month and amount
spent in that month for each card type

Result
• Write a query to print the transaction details(all columns
from the table) for each card type when-- it reaches a
cumulative of 1000000 total spends

Result
• Write a query to find city which had lowest percentage
spend for gold card type

Result
• Write a query to print 3 columns: city,
highest_expense_type , lowest_expense_type

Result
• Write a query to find percentage contribution of spends
by females for each expense type

Result
• Which card and expense type combination saw highest
month over month growth in Jan-2014

Result
• During weekends which city has highest total spend to
total no of transactions ratio

Result
• Which city took least number of days to reach its 500th
transaction after the first transaction in that city

Result

You might also like