Payment Risk and Payment Fraud: Data Science and Analytics

Learn payment basics, including open loop vs closed loop systems, push vs pull payments, and methods like cards, ACH, checks, cash, wire, and PayPal.

Learn about payment risk and fraud across buyers and sellers, including account takeover and non-sufficient funds, and how 3DS2.0 and PSD2 regulate this landscape.

Learn how stolen financial information enables fraudsters to use card or bank data for online purchases, and examine non sufficient funds scenarios, data breaches, malware, and fraud signals.

Identify family fraud by analyzing signals from account profiles, purchase patterns, and linkages; expect long-tenure accounts using the same card on the same device, unusual purchases, and low cross-account linkages.

Explore merchant risk by distinguishing credit risk from fraud risk, and learn how bankruptcy, items not received (INR), and significant not as described (SNAD) affect payments.

Define hypothesis testing with null and alternative hypotheses, learn how to use rejection rules in fraud detection, and explore its role in modeling, confusion matrices, and AB testing.

Explore linear regression fundamentals, including simple and multivariable models, ordinary least squares, slope and intercept, residuals, and minimizing sum of squared errors to predict outcomes.

Explore how r-squared, adjusted r-squared, and p-values assess linear regression models, compare them to the mean model, and interpret f values for statistical significance.

Learn how to estimate logistic regression parameters using maximum likelihood, compare models with McFadden's pseudo r-squared, and compute the r-squared and p value via the chi-squared test to assess significance.

Explore how a decision tree uses nodes to split data, with age over 60 and saving over $70,000, and discuss its basis in machine learning models and the outfitting issue.

Build and evaluate a fraud-detection decision tree using purchase velocity and account age, applying Gini impurity to split nodes and assessing performance with a confusion matrix.

Learn how gradient boosting builds a regression model by starting with an initial prediction, iteratively fitting trees to residuals, applying a learning rate, and combining trees for improved profit predictions.

Builds an Xgboost regression tree by calculating residuals, similarity scores, and gains to choose optimal splits, applies regularization to prune branches, and updates predictions with the learning rate.

Discover how the SQL select distinct statement returns only unique values, including when used with aggregate functions, with a concrete example selecting distinct emails from a person table.

Learn to filter data in SQL with the where clause, using syntax and conditions such as salary greater than 100K and major equals statistics from the employee table.

Explore how the SQL join clause combines data from multiple tables using inner, left, right, and full outer joins, including self joins, with practical examples.

Discover how the not equal operator in SQL filters data by excluding a value, shows two equivalent forms, and applies to a Location table example not equal to US.

Learn how the datediff function in SQL computes differences between dates, using day, week, month, or year intervals, to filter transactions in the last 30 days.

Learn how the case when statement in SQL evaluates conditions to return values, illustrated by a transaction example where approval occurs only when both model and manual decisions are approved.

Master how to convert data types in SQL with the cast function. Apply cast to change salary to number and enrollment timestamp to date, with practical syntax and examples.

Explore how window functions operate in SQL using the over clause, including partition by and order by, and compare row_number, rank, and dense_rank with a third-highest salary example.

Explore subqueries in SQL, using the where clause and in operator to restrict results across multiple tables, and compare subqueries with joins through practical examples.

Learn to perform a complex join across two tables using group by, window or aggregate functions, count votes, order by, and limit to identify winning candidate and reveal the name.

Learn how to apply join and aggregate functions to combine tables, group by department, and count people per department using the person and department tables.

Learn to use having and where together to filter movie sales by date, group by movie id, sum quantities, and apply having over ten copies sold.

Learn how to find and remove duplicates using window functions, partition by email, order by id, and row number, with alternatives like having, join, and group by.

Boost SQL query efficiency by reducing dataset size, using targeted where filters, and selecting specific columns. Understand the SQL execution order to improve day-to-day query performance.

Define and call Python functions to perform tasks and reuse code, using def function_name(parameters) and indentation; explore nested functions through a greet example that prints a personalized message.

Explore Python operators, including the remainder of division, the rounding and exponent operators, comparison and logical operators, and assignment plus in and not in membership tests.

Explore Python's while loop, its syntax and condition-driven execution, and compare it with the for loop. Learn when to use while loops and how break affects control flow.

Master indexing and slicing in Python lists, including negative indices; understand mutability via assignment, and remove items via delete, remove, or pop, including clearing the list.

Master numpy 101 and learn how arrays enable fast, memory-efficient data operations with homogeneous types, using numpy as np to create and access elements by index or slice.

Learn to reshape a 1D numpy array into a 2D array with rows and columns, index and iterate elements, sort rows, and filter with boolean indexing in a Jupyter Notebook.

Master Python Pandas 101 to explore DataFrame structures, indexing, and how to read data from CSV and JSON files for data analysis.

Learn how to join dataframes in pandas with the merge function, perform inner and left joins on shared columns, and review calories, weight, and height examples.

Explore matplotlib, a powerful Python library for data visualization that supports plots, histograms, 3D surfaces, and other charts with various settings; learn its easy syntax.

Explore matplotlib 201 basics: plot data with lines or dots, create histograms from random data with mean 100 and standard deviation 40, and display charts in Jupyter notebooks.

Apply a three-step data thinking process: reveal overall trends with sales and price, dive into segmentation by house type and repeat sales, then present data-driven recommendations using statistics and SQL.

Query Nashville housing data with sql by joining house, house details, and seller tables to compute sales metrics. Identify areas, price versus value trends by bedroom count and build year.

Analyze two years of revenue and cost data using SQL to compute net revenue, identify drivers, and present actionable solutions, highlighting fraud cost reductions as the main revenue driver.

Build a Python decision tree to predict default and reduce fraud costs, using features like age and linking accounts, and quantify impact on net revenue.

Master the fundamentals of payment risk with data science and analytics, applying statistics, modeling, machine learning, sql, and python to analyze data and build models through two case studies.