Find Jobs
Hire Freelancers

Exploratory Data Analysis

₹600-1500 INR

Lukket
Slået op 3 måneder siden

₹600-1500 INR

Betales ved levering
Description: You are a data analyst at a finance company that specializes in lending various types of loans to urban customers. Your company faces a challenge: some customers who don't have a sufficient credit history take advantage of this and default on their loans. Your task is to use Exploratory Data Analysis (EDA) to analyze patterns in the data and ensure that capable applicants are not rejected. When a customer applies for a loan, your company faces two risks: If the applicant can repay the loan but is not approved, the company loses business. If the applicant cannot repay the loan and is approved, the company faces a financial loss. The dataset you'll be working with contains information about loan applications. It includes two types of scenarios: Customers with payment difficulties: These are customers who had a late payment of more than X days on at least one of the first Y installments of the loan. All other cases: These are cases where the payment was made on time. When a customer applies for a loan, there are four possible outcomes: Approved: The company has approved the loan application. Cancelled: The customer cancelled the application during the approval process. Refused: The company rejected the loan. Unused Offer: The loan was approved but the customer did not use it. Your goal in this project is to use EDA to understand how customer attributes and loan attributes influence the likelihood of default. Business Objectives: The main aim of this project is to identify patterns that indicate if a customer will have difficulty paying their installments. This information can be used to make decisions such as denying the loan, reducing the amount of loan, or lending at a higher interest rate to risky applicants. The company wants to understand the key factors behind loan default so it can make better decisions about loan approval. Note: To better understand this project, you might want to research a bit about risk analytics in banking and financial services. Understanding the types of variables and their significance should be enough. Data Analytics Tasks: A. Identify Missing Data and Deal with it Appropriately: As a data analyst, you come across missing data in the loan application dataset. It is essential to handle missing data effectively to ensure the accuracy of the analysis. Task: Identify the missing data in the dataset and decide on an appropriate method to deal with it using Excel built-in functions and features. Hint: Utilize Excel functions like COUNT, ISBLANK, and IF to identify missing data. Consider using functions like AVERAGE or MEDIAN for imputation or other appropriate methods available in Excel. Graph suggestion: Create a bar chart or column chart to visualize the proportion of missing values for each variable. B. Identify Outliers in the Dataset: Outliers can significantly impact the analysis and distort the results. You need to identify outliers in the loan application dataset. Task: Detect and identify outliers in the dataset using Excel statistical functions and features, focusing on numerical variables. Hint: Utilize Excel functions like QUARTILE, IQR, and conditional formatting to identify potential outliers. Consider applying thresholds or business rules to determine if the outliers are valid data points or require further investigation. Graph suggestion: Create box plots or scatter plots to visualize the distribution of numerical variables and highlight the outliers. C. Analyze Data Imbalance: Data imbalance can affect the accuracy of the analysis, especially for binary classification problems. Understanding the data distribution is crucial for building reliable models. Task: Determine if there is data imbalance in the loan application dataset and calculate the ratio of data imbalance using Excel functions. Hint: Utilize Excel functions like COUNTIF and SUM to calculate the proportions of each class. Compare the class frequencies to assess data imbalance. Graph suggestion: Create a pie chart or bar chart to visualize the distribution of the target variable and highlight the class imbalance. D. Perform Univariate, Segmented Univariate, and Bivariate Analysis: To gain insights into the driving factors of loan default, it is important to conduct various analyses on consumer and loan attributes. Task: Perform univariate analysis to understand the distribution of individual variables, segmented univariate analysis to compare variable distributions for different scenarios, and bivariate analysis to explore relationships between variables and the target variable using Excel functions and features. Hint: Utilize Excel functions like COUNT, AVERAGE, MEDIAN, and statistical functions for descriptive analysis. Utilize Excel features like filters, sorting, and pivot tables for segmented and bivariate analysis. Graph suggestion: Create histograms, bar charts, or box plots to visualize the distributions of variables. Create stacked bar charts or grouped bar charts to compare variable distributions across different scenarios. Create scatter plots or heatmaps to visualize the relationships between variables and the target variable. E. Identify Top Correlations for Different Scenarios: Understanding the correlation between variables and the target variable can provide insights into strong indicators of loan default. Task: Segment the dataset based on different scenarios (e.g., clients with payment difficulties and all other cases) and identify the top correlations for each segmented data using Excel functions. Hint: Utilize Excel functions like CORREL to calculate correlation coefficients between variables and the target variable within each segment. Rank the correlations to identify the top indicators of loan default for each scenario. Graph suggestion: Create correlation matrices or heatmaps to visualize the correlations between variables within each segment. Highlight the top correlated variables for each scenario using different colors or shading. How to do this Project? Download the dataset: Begin by downloading the dataset provided for the project. Ensure that you have access to Microsoft Excel for data analysis. Perform Analysis: Use Excel to perform the analysis and answer the questions mentioned in the project details. Submit a Report: Create a report (PDF/PPT) to present your findings to the leadership team. The report should include the following sections: Project Description Provide a brief overview of the project, its objectives, and the approach you followed. Approach Explain your approach to the project and how you executed it, including the specific techniques and tools used. Tech-Stack Used Specify the software and its version (e.g., Microsoft Excel 2022) and mention the purpose of using it. Insights Summarize the insights and knowledge gained during the project. Discuss key findings and any meaningful trends or patterns discovered. Result Describe what you achieved through the project and how it has contributed to your understanding of the Bank Loan Case Study. You are required to submit the Final cleaned Data set and explain the process you took in a word or pdf document.
Projekt-ID: 37475914

Om projektet

23 forslag
Projekt på afstand
Aktiv 2 måneder siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
23 freelancere byder i gennemsnit ₹4.500 INR på dette job
Brug Avatar.
Hi There, Good evening! I have gone through your requirement. I have worked on the similar type of requirement in past. Please ping to discuss more on the project. Below is my intro - "First use then believe". I don't want to mention much here but I have 8+ years of extensive experience in different types of data analytics & visualization tools along with Power BI, Excel, SQL, Tableau, Power Apps, Power Automate, Python & AWS with total 10+ years of IT experience. I am not intelligent, but I try to complete the work ASAP as I don't believe in deadline. I don't believe in saying rather my work speaks. It's our first collaboration that's why I have to describe my proposal or else I prefer not to as it won't be needed next time. ✅ You can go through my profile to see my past works in Freelancer site ==> https://www.freelancer.com/u/Akmanyu
₹5.000 INR på 1 dag
5,0 (35 anmeldelser)
6,2
6,2
Brug Avatar.
Highly skilled and experienced Power BI expert with a passion for transforming complex data into meaningful insights. Over 7 years of hands-on experience in developing interactive dashboards and reports using Power BI. Proficient in data modeling, DAX (Data Analysis Expressions), and ETL (Extract, Transform, Load) processes. Proven track record of delivering actionable business intelligence solutions to drive data-driven decision-making. Strong analytical and problem-solving abilities with excellent communication and collaboration skills.
₹60.000 INR på 20 dage
4,9 (10 anmeldelser)
4,2
4,2
Brug Avatar.
Dear Dineshwar R., Hope you doing well. I am excited to offer my expertise in statistical analysis, offering a range of services covering both basic and advanced statistical techniques. With proficiency in SPSS, Stata, Eviews, and Python, I am well-equipped to handle diverse data analysis projects. My expertise include but not limited to: Descriptive Statistics: Summarizing data using mean, median, and mode, along with standard deviation and variance. Hypothesis Testing: Employing t-tests, ANOVA, and Chi-Square tests to draw inferences. Correlation Analysis: Evaluating relationships between variables using Pearson, Spearman, or Kendall correlations. Advanced Statistical Analysis: Regression Analysis: Building predictive models with linear and logistic regression. Time Series Analysis: Identifying trends and patterns in time-based data. Factor Analysis and Principal Component Analysis: Reducing dimensionality for data simplification. Multivariate Analysis: Exploring complex relationships among multiple variables. I am reviewing attached documents and will discuss once we start conversation Sincerely Sajid Hussain
₹1.103 INR på 1 dag
4,4 (16 anmeldelser)
4,3
4,3
Brug Avatar.
hi I did a project like this before in UDACITY Let me show you my skills in Python , EDA using Dax & power query & Power BI you can check my portfolio https://www.freelancer.com/u/mohammednabil90 I am sure you will find what you need in my portfolio waiting for you
₹5.000 INR på 7 dage
5,0 (3 anmeldelser)
2,5
2,5
Brug Avatar.
Dear, client I am a full stack and AI developer with more 10 years of professional experience in React, Node, Next, Django, Flask, MernStack, Computer vision and natural language processing.... I mainly use Javascript, typescript and python program language. I can finish your project within your deadline with reasonable budget. Thanks
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hello! My name is Abdul and I am a data analyst with over 8 years of experience in data processing, data visualization, Excel, Powerpoint and other related applications. I understand that your company faces a challenge: some customers who don't have a sufficient credit history take advantage of this and default on their loans. Your goal in this project is to use EDA to understand how customer attributes and loan attributes influence the likelihood of default. I believe my proficiency in data analysis makes me the perfect fit for this project. My skillset includes an array of data processing tools such as Excel, Word, PowerPoint and G-Suite which make it easy for me to work with large datasets. Additionally, I'm available 24/7 via freelancer messenger which makes it easy for me to respond to customers' queries at any time of the day. As part of my commitment to customer satisfaction, I offer free samples before starting any work so they can ensure quality before proceeding further with me. In addition to this, I aim to deliver projects on time and budget so that you don't have to worry about any delays or unexpected costs during the process. If you'd like more information about me or my services please don't
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hello there! My name is Asharib, and I'm a data analyst at a finance company that specializes in lending various types of loans to urban customers. With my diverse skill set of Excel proficiency, PHP programming skills, WordPress wizardry, and an eye for eBook design, I bring a diverse set of talents to the table that make me an excellent candidate for this project. As an experienced data analyst, I have the expertise necessary to identify patterns in the data that indicate if a customer will have difficulty repaying their installments. This information can be used to make decisions such as denying the loan, reducing the amount of loan or lending at a higher interest rate to risky applicants. My goal in this project is to use EDA to analyze how customer attributes and loan attributes influence the likelihood of default. By understanding these key factors we can ensure that capable applicants aren't rejected due to inaccurate analysis of their likelihood of default. I would be more than happy to discuss further how my skillset would benefit you and discuss any further needs you may have regarding this project. Please feel free to reach out if you have any questions or would like to discuss further about this project!
₹1.000 INR på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I sir I'm a bsc graduate and I have 4 years experience. I'll provide you quality work according to you requirements please award me the project... thanks
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
HELLO DEAR CLIENT I have gone through your project details, and have all the required skills, and VAST EXPERIENCE.I confirm to you that the project is doable since it's within my area of EXPERTISE i.e Python (ML, DS, AI,NLP, Web(Flask), API Dev), R, Android(Java, Kotlin), Database (Mysql, PostgreSQL, Ms Access), C/C++,C#, Java, JavaScript, HTML and CSS (Tailwindcss) e.tc. Timely and Good work is 100% guaranteed. I present my bid to you and thanks in advance as you consider me
₹2.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi , I can provide a cleaned dataset as well as PDF after performing complete EDA (including finding data imbalance ,outliers etc. and Uni, Bi, multivariate analysis including graphs)and the insights gained from it. Had already done same kind of project earlier.
₹3.000 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I am reaching out to propose an in-depth Exploratory Data Analysis (EDA) project focused on uncovering critical patterns within our customer data that may indicate challenges in loan repayment. This analysis aims to provide actionable insights to facilitate more informed decision-making in our lending processes. Moreover, as an additional value proposition, I propose to complement this analysis with a comprehensive set of data visualizations. These visualizations will not only enhance our understanding of the identified patterns but also serve as a valuable tool for communicating complex data insights across our teams.
₹1.200 INR på 5 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Dear Client, I am excited about the opportunity to work on the data analytics project aimed at leveraging Exploratory Data Analysis (EDA) techniques to understand loan default patterns for your finance company specializing in urban lending. With a strong foundation in data analysis, Excel proficiency, and a background in financial analytics, I bring: - Extensive experience in utilizing Excel functions and features for data analysis, including handling missing data, outlier detection, and statistical analysis. - Understanding of risk analytics in banking and financial services, which aligns well with the objectives of this project. I will provide a cleaned and processed dataset in Excel format. And a comprehensive report (PDF/PPT) detailing the project overview, approach, tech-stack used, insights gained, key findings, and their significance to your company's loan approval strategies. I am fully equipped with Excel 2022 and ready to start immediately, ensuring timely completion within the proposed budget. I would be happy to share my plans on executing the project via DM. Thank you for considering my proposal. I am enthusiastic about the prospect of contributing to your company's loan approval strategies through insightful data analysis. Best regards, Maryna Tetelbaum
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I'm new to this field and I understand that you are looking for someone who can analyze data and identify patterns that indicate if a customer will have difficulty paying their installments. I have extensive experience in data analysis and the necessary skills to complete this project. My background in finance and data analysis makes me uniquely qualified to tackle this project. I am a data analyst at a finance company that specializes in lending various types of loans to urban customers. We face two major challenges when it comes to loan applications: we want to make sure that customers with insufficient credit history don't abuse the system by defaulting on their loans, but we also need to ensure that customers who can repay the loan aren't rejected due to missing information in the application. When a customer applies for a loan, there are four possible outcomes: approved, cancelled, refused or unused offer. Our goal is to use EDA to understand how customer attributes and loan attributes influence the likelihood of default so we can make better decisions about loan approval. I would love the opportunity to discuss this project further. Please feel free to contact me if you have any questions or would like more information about my skillset and experiences in data analysis. Thank you for considering me for this position
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Dear Client, I am excited about the opportunity to work on the data analytics project aimed at exploration data analysis(EDA) techniques to understand loan default patterns for your finance company specializing in urban lending. I have experience in data analysis and the necessary skills to complete this project. If given a a chance I will give my best to do the job. Thankyou Swapnil Das
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
You know that data analysis is crucial for making decisions that ensure the company's success in lending. But you also recognize that some customers with payment difficulties can still be approved for loans if the right patterns are detected in the data. With my expertise in data analysis, I am confident that I can help you identify those patterns so you can ensure that capable applicants aren't rejected due to default risk. I understand how important it is for you to have accurate results from your project that can be used to make decisions about loan approval. That's why I take pride in providing quality work as the cornerstone of my services so that you get results within deadline and budget constraints without compromising on quality.
₹1.050 INR på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
dear sir and madam, i am going to start freelance work and i am a genuine person to do work like this. i am ready to work at minimum amount as i am looking to freelance work and leaved 10years full time job due to medical and startup. Having Required Complete Skills Data Processing Data Entry Excel Word etc Thanks
₹1.050 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Project Title: Enhancing Loan Approval Decisions through Exploratory Data Analysis (EDA) To address the challenge faced by your finance company in ensuring the optimal approval of loans while minimizing the risk of defaults. Aanalysis will provide insights into the distribution of variables, comparisons across different scenarios, and relationships between variables and loan default. These findings will guide decisions on loan approval, helping your company refine its risk assessment strategies. The final deliverables will include a cleaned dataset and a detailed report presenting my methodology, key insights, and recommendations. Look forward to the opportunity to collaborate on this project, delivering actionable insights to optimize your loan approval process.
₹1.400 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I'm new to this application, but if I am given the opportunity to work on it, I will give 100 percent of my skills in completing the work given
₹600 INR på 4 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Bangkok report services Strong skill in data with expert in Excel power Query- Macro Qlik PowerBi and Tableau
₹2.000 INR på 10 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi welcome to my profile, I am Raghavendra Joshi having 10 years of experience, I am Data Analyst having same experience in Data cleaning and EDA with graphs and chart and using ML Algorithms performing various analysis. Skills having Excel, Advanced Excel, power BI, python, SQL
₹1.050 INR på 3 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for INDIA
Hyderabad, India
0,0
0
Medlem siden nov. 26, 2023

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.