Pinned Repositories
Chi-Squared-Test-Mortgage-JSON
The data has mortgage-level data and provides information on the borrower such as race/ethnicity, gender, and loan purpose. This analysis explores the data, makes transformations, and performs chi-squared tests on variables to see if there are relationships between them.
credit-risk-model-using-statistics
Donor-Personas-k-means-clustering
As a team of volunteer data scientists, we cleaned and transformed a dataset from a nonprofit client containing donor demographics, behavior, and donations. Then we conducted a k-means clustering analysis to group donors which resulted in 3 significant clusters. I took these clusters and developed 3 donor personas based on their demographics and historical behaviors and presented them to the client and other Data Science and Analytics leaders in Atlanta.
Loan-Approval-Prediction-Random-Forest-Web-App
Web App and Random Forest - Loan Approval Prediction
Loan-Limits-by-County
This project analyzes the 2022 Loan Limits by county. Definitions and background are included in the ReadMe and main document!
Product-Funnel-SaaS-FinTech
Shows how to maximize order success and optimize revenue for our current product based on certain points in our software workflow. This helps identify where the opportunity is to create the biggest lift in revenue for the smallest lift in workflow completion metrics.
Reports-Dashboards-Visualizations-PowerBI-KPIs-Metrics
Features sample reports, dashboards, metrics, and KPIs built in Power BI. Note: all data labels, number, names, graph axes, etc. have been either hidden or blacked out to maintain privacy. These are only to be viewed as samples of my visualization style and metric-building capabilities. The real ones with labels and numbers look even better! The real ones are also dynamic and filterable.
SQL-Practice
SQL-Query-Samples
This space includes sample SQL queries that have been adjusted and anonymized from the originals to maintain privacy. Included are queries on orders, products, software performance, order statuses, bank accounts, financial institutions, workflow fallout points, client reports, and more! It is a small snapshot of my work in SQL, but I chose these to share based on their simplicity and readability.
UGA-Football-HTML-Scrape-Clean-and-Vis
This project features an HTML scrape off of the UGA Football website (works as of 2022). The data consists of players, height, weight, hometown, and more. Throughout the data cleaning and transformation process, I appropriately deal with nulls, dups in a should-be-unique column, and string data that should be split into multiple columns. I create dictionaries, functions, and visualizations that help me understand the distribution and values of data. I finish it off with some visualizations that show BMI and weight class! I do not know anything about football or BMI, but I am able to show a story with my code and visuals.
jessramosdata's Repositories
jessramosdata/Product-Funnel-SaaS-FinTech
Shows how to maximize order success and optimize revenue for our current product based on certain points in our software workflow. This helps identify where the opportunity is to create the biggest lift in revenue for the smallest lift in workflow completion metrics.
jessramosdata/Loan-Approval-Prediction-Random-Forest-Web-App
Web App and Random Forest - Loan Approval Prediction
jessramosdata/SQL-Query-Samples
This space includes sample SQL queries that have been adjusted and anonymized from the originals to maintain privacy. Included are queries on orders, products, software performance, order statuses, bank accounts, financial institutions, workflow fallout points, client reports, and more! It is a small snapshot of my work in SQL, but I chose these to share based on their simplicity and readability.
jessramosdata/SQL-Practice
jessramosdata/Reports-Dashboards-Visualizations-PowerBI-KPIs-Metrics
Features sample reports, dashboards, metrics, and KPIs built in Power BI. Note: all data labels, number, names, graph axes, etc. have been either hidden or blacked out to maintain privacy. These are only to be viewed as samples of my visualization style and metric-building capabilities. The real ones with labels and numbers look even better! The real ones are also dynamic and filterable.
jessramosdata/Donor-Personas-k-means-clustering
As a team of volunteer data scientists, we cleaned and transformed a dataset from a nonprofit client containing donor demographics, behavior, and donations. Then we conducted a k-means clustering analysis to group donors which resulted in 3 significant clusters. I took these clusters and developed 3 donor personas based on their demographics and historical behaviors and presented them to the client and other Data Science and Analytics leaders in Atlanta.
jessramosdata/UGA-Football-HTML-Scrape-Clean-and-Vis
This project features an HTML scrape off of the UGA Football website (works as of 2022). The data consists of players, height, weight, hometown, and more. Throughout the data cleaning and transformation process, I appropriately deal with nulls, dups in a should-be-unique column, and string data that should be split into multiple columns. I create dictionaries, functions, and visualizations that help me understand the distribution and values of data. I finish it off with some visualizations that show BMI and weight class! I do not know anything about football or BMI, but I am able to show a story with my code and visuals.
jessramosdata/credit-risk-model-using-statistics
jessramosdata/Loan-Limits-by-County
This project analyzes the 2022 Loan Limits by county. Definitions and background are included in the ReadMe and main document!
jessramosdata/Chi-Squared-Test-Mortgage-JSON
The data has mortgage-level data and provides information on the borrower such as race/ethnicity, gender, and loan purpose. This analysis explores the data, makes transformations, and performs chi-squared tests on variables to see if there are relationships between them.
jessramosdata/Cult-Terry
intro tutorials for python and data science
jessramosdata/SnakeGamefromScratch
A classic snake arcade game from scratch built by various functions and design elements🐍