
Need analysis and pivots completed on a data set
- or -
Post a project like this215
$20/hr
- Posted:
- Proposals: 28
- Remote
- #4374326
- OPPORTUNITY
- Awarded
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing

Digital Web & AI Automation Agency | Expert in WordPress, Shopify & Custom Development



⭐ Graphic Designer ⭐| Digital Marketing | Social Media Marketing | Web Developer | Virtual Assistant.

Senior Administrator | Experienced IT Support & Microsoft Tools Specialist | 10+ Years Industry Experience
⭐⭐⭐⭐⭐ Social Media marketing Manager/Top Website &Graphics Designer| Shopify | Video Animator | Web Design& Development

Social Media Marketing Manager & Content Creator | Facebook, Instagram & LinkedIn Growth Expert
Top-Rated Web & Graphic Designer | Database Expert | Business Analysis| Python Developer


Data entry, Data analysis, data visualization, access and excel job , database administrator etc
111412822748041229106211944960121260121230023011946305123151191230321410217969504159112311477
Description
Experience Level: Entry
I have two files- the driver file was @2.2mm records of consumers in the US- it contains information from estimates they received from a home improvement contractor- those data points include things like zip code, state, type of services, if sold or not, if financed or not, salespersons name, office, etc....
The second file is the results file that contains @1.6mm records- the results file is driver file where a credit file hit was matched. The results file has credit score, DTI, income, property value, cltv, equity position and a bunch of other credit data. this information is anonymized so no PII.
I am looking for someone to take this data and drive valuable insights by assessing both files individually, conversion rate, by sales person, average sale price, etc... on the driver file at a zip, agent and office level. Then perform a similar exercise on the results file to see what credit demographics exists at a zip level, also agent and office level. then merge the data at each levelt o create success metrics and insights from the combination of sales and credit information.
It can be as simple as a glorified pivot table up to a more in depth analysis to include some weighted scores and enriched data from other sources like census data.
I can work in an iterative manner and spend time with the consultant to refine results daily with new marching orders until it is complete. I may have other on-going work for the right person. I can provide detailed layouts, results and cuts that need to be performed. I would prefer someone with some knowledge of credit demographic data or they may not be able to contribute or the learning curve may be more dramatic.
The second file is the results file that contains @1.6mm records- the results file is driver file where a credit file hit was matched. The results file has credit score, DTI, income, property value, cltv, equity position and a bunch of other credit data. this information is anonymized so no PII.
I am looking for someone to take this data and drive valuable insights by assessing both files individually, conversion rate, by sales person, average sale price, etc... on the driver file at a zip, agent and office level. Then perform a similar exercise on the results file to see what credit demographics exists at a zip level, also agent and office level. then merge the data at each levelt o create success metrics and insights from the combination of sales and credit information.
It can be as simple as a glorified pivot table up to a more in depth analysis to include some weighted scores and enriched data from other sources like census data.
I can work in an iterative manner and spend time with the consultant to refine results daily with new marching orders until it is complete. I may have other on-going work for the right person. I can provide detailed layouts, results and cuts that need to be performed. I would prefer someone with some knowledge of credit demographic data or they may not be able to contribute or the learning curve may be more dramatic.
Craig J.
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
56%
Last project
20 Oct 2025
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies