shelly-yang Goto Github PK

baltimore-crime-incidence-plot

Tool: R. Data Visualization of Baltimore Crime Incidence Plot

data-cleaning-in-etl-processing

Tool: MySQL. There are several ways to turn raw data into technically correct data: convert dates/standardize units, check for/eliminate duplicate records, and standardize strings for integration. Let's do it in MySQL.

data-science-for-business

This book introduces the fundamental principles os data science and and walks you through the "data-analytic thinking" necessary for extracting useful knowledge and business value from the data you collect, including data mining methods, machine learning, predictive modeling and more details.

data-warehousing-with-long-data

data-warehousing-with-wide-data

graph-database-application-using-neo4j

Tool: Neo4j. Neo4j delivers the lightning-fast read and write performance you need, while still protecting your data integrity. It is the only enterprise-strength graph database that combines native graph storage, scalable architecture optimized for speed, and ACID compliance to ensure predictability of relationship-based queries.

outlierdetection

predictive-modeling-for-direct-marketing

Tool: R. To maximize expected profit, the bank is expected to employ a predictive model to predict whether or not a potential customer is a likely buyer. Decision tree will be used in this case to build the classifier in R. After data set is adjusted and decision tree is calibrated using complexity parameter and optimal cutoff, maximized profit is $2261.017.

pricing-analytics-of-kiwi-bubbles

Tool: R. This project utilized machine learning to implement customer segmentation based on demographics data, to build heterogenous pricing strategies to different groups in order to maximize the profit.

risk-prediction-for-home-equity-line-of-credit

Tool: Python. The goal of the project is to develop a predictive model and a decision support system (DSS) that evaluates the risk of Home Equity Line of Credit (HELOC) applications. In addition, an interactive interface designed for bank/other credit lender employees to use is built using Streamlit in Python.

toy-horse-conjoint-analysis

Tool: R. Conjoint analysis helps launch new products. This project helps us deeply understand how conjoint analysis gets consumers preference and segmentation, and how to simulate market to maximize profit and sustainability. It turns out that mutual cooperation yields better outcome than mutual defections.