Credit and Debit transactions record DashBoard

[blackheart]

The dataset contains the Credit and Debit transactions recorded by 100 fictional CB users. The CEO asks you to analyze the data and extract some insights from the dataset.
Requirment 1
Organize the data and give an understanding of how sticky these users are. Stickiness is to be measured by # of weekly transactions and weeks actively transacting. Identify the top 10 users of the group in terms of:
● Average transactions per active week
● # Weeks actively transacting Present the results in the way you think it’s most appropriate and easiest to digest.

Requirment 2
Analyze the credit cycle of the top 10 users. Understand if they are more on the lending or borrowing side. How financially exposed they are. From your discoveries make assumptions on what type of business they are running. Suppliers, wholesalers, retailers etc. and justify your answers.

Dataset information
● user_id : unique identifier of the user. business owner who registers the transaction
● customer_id: unique identifier for the customer. Customer with whom the business owner performs the specific transactions
● transaction_amount: transaction amount (PKR)
● transaction_type: defines a transaction either as a credit (the customer owes money to the shop owner) or debit (the business owner is buying something without immediately paying)
● transaction_date: date of the transaction

Dataset Donwload

dataset.csv

drive.google.com

 

[AlanSidman]

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

 

[AlanSidman]

James, this is not real life. It is a class room exercise to test a student's knowledge.