YvonneLiu's Blog

Shoot for the moon

Improving Procure-to-Pay Discipline Through Data Analytics

(Power BI) Building a Scalable Spend Governance and Payment Efficiency Framework

Summary In large organizations, Procure-to-Pay (P2P) process discipline is critical for: Budget control Spend forecasting accuracy Cash flow optimization Audit and compliance However, i...

Posted by Yvonne Liu on May 31, 2024

Building a Data-Driven SOX Control Testing Management Dashboard

(Power BI) Turning SOX execution, coverage, and quality into management-level visibility

Background In large, multi-process organizations, SOX and internal control testing is not just a compliance exercise — it is a project management, resource allocation, and risk prioritization prob...

Posted by Yvonne Liu on May 31, 2023

Austin-Bergstrom International Expansion Plan

(Tableau) Using visualizations developing business strategies

**This is a team project. Co-authors are Aly Hu, Jiali Yin, Xinyi Zhu, Linsay Trinh and Shangyun Song. The original tbwx file exceeds the size limitation on Tableau Public, so I used gif images to ...

Posted by Yvonne Liu on December 9, 2019

SQL Gaps & Islands Problems

Identify continuous and missing values in a sequence

Description of Gaps & Islands Problems Gaps and islands problems involve missing values in a sequence. Solving the gaps problem requires finding the ranges of missing values, whereas solving t...

Posted by Yvonne Liu on October 20, 2019

Predicting Diamond Prices

(R) Linear regression, quantile regression, PCA

The original dataset can be found on Kaggle. Business Understanding The business problem we wanted to address was how to be able to quickly, efficiently, and consistently price new diamonds coming...

Posted by Yvonne Liu on October 14, 2019

Model Selection

(R) OOS performance and cross validation

Now we have several models to make prediction for us. But how do we evaluate them? Out of Sample(OOS) Metrics In-sample metrics, such as in-sample R square, always increase with more coefficients...

Posted by Yvonne Liu on October 9, 2019

The Simpsons - Fun SQL Problems

(SQL) Hidden fun facts in The Simpsons

The Simpsons database consists of 4 main tables: characters, episodes, locations and script_lines. The script_line table has following fields: id (primary key), episode_id (foreign key), number, ch...

Posted by Yvonne Liu on August 20, 2019

FEATURED TAGS
SQL OOS Cross Validation Project R Data Visualization Management Reporting Power BI
ABOUT ME

Jingwen(Yvonne) Liu, CPA, Graduate student at Duke University, MQM Business Analytics, MBA at Sofia University

✉️ yvonneliu0329@outlook.com