Discover jessramosdata/SQL-Query-Samples Open Source project

Stars
12
Rank 1,597,372 (Top 32 %)
Language TSQL
Created over 2 years ago
Updated about 2 years ago

jessramosdata

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

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.

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.

Jupyter Notebook

Loan-Approval-Prediction-Random-Forest-Web-App

Web App and Random Forest - Loan Approval Prediction

Jupyter Notebook

SQL-Practice

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.

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.

Jupyter Notebook