BFSI sector in Analytics is booming and is one of the biggest market piece of the total pie.A famous credit card company called CC Ltd has innovated a new solution you have been provided with the account level data of daily credit card transaction aggregates of CC Ltd. For security reasons, students have not been given account numers as a unique ID.
The following fields are listed in the data:
1. Customer Type - What kind of customer does the particular account belong to.2. $ Spent per day - How many dollars have been spent in one single day in that account.
3. # of transactions per day - How many times was the card used for a financial transaction in a single day. (Note that checking balance, crediting money and other activities do not count. Only cash debit is counted.)4. $ credited per day - How many dollars were credited in the account during the whole day. 5. Day - What day of the month does the aggregate belong to.6. Month - What month does the aggregate belong to.7. Year - What year does the aggregate belong to. 8. $ surcharge levied - How many $ have been levied on the account as a surcharge.
You have been given the following problem statement:CC Ltd. has lost its mainframe which used to calculate surcharge amounts for each account at the end of the day. The surcharge is levied on the account at the end of each day.1. Use the data to train your model. Discuss what insights you gained from the equation?2. Using the equation, predict what will be the surcharge amount on the prediction data for the [login to view URL] observations do you have on the data? Discuss using segmentation or trends that you can find in the historical data.
PRoject must be in excel
22 freelanceria on tarjonnut keskimäärin 1856₹ tähän työhön
Hi, I am Ibrahim and I am a data scientist, I think this would have a dataset or a set of instructions, please share it, so that it could be discussed further. Regards, Ibrahim Anjum
Hi dear, Please i am a data analyst, and data scientist, i can help you with you tasks, i am expert with excel, and if you need to use other data analysts tools i will be here for your need. KR.
We have a team of Power Bi experts; you will always have a back up. Use Cases - [login to view URL]!Av2Qt7JScAjxl7hlrMHz3OOMkDb0yg. Sample Dashboards - [login to view URL]
Hello. the description is in my area of expertise. I'd love to proceed with this project. also i just start working here so i'll do my best to collect perfect reviews!
I worked in Excel and I working as Data analyst in big MNC and I worked past as DA in many MNCs I would like to work for this project .. please let me know when we can discuss