Undervalued Stock Scanner 2.0: From Spreadsheet Automation to Scalable Python Pipelines

Undervalued Stock Scanner 2.0: From Spreadsheet Automation to Scalable Python Pipelines

Python (os, glob, pandas, numpy) • Power BI • DAX • Deneb visuals • Power Query • ETL pipeline

This new version of Undervalued Stock Scanner is a complete architectural shift from my original system. What began as financial spreadsheet modeling has evolved into modular Python pipelines that automate data ingestion, statistical processing, valuation screening, and exit monitoring.

Undervalued Stock Scanner: From Raw Data to Smart Insights

Undervalued Stock Scanner: From Raw Data to Smart Insights

Advanced Excel • Power Query • Power BI • VBA (Visual Basic for Applications) • Financial analytics • Stock fundametal analytics

Like many aspiring investors, my husband and I were drawn to the challenge of identifying undervalued stocks because they are like hidden gems with solid fundamentals that the market hasn’t caught up with yet. What started as a weekend project in Excel became a fully automated pipeline combining Power Query, VBA, and Power BI dashboards.

Socioeconomic Factors Impacting Poverty in U.S. Counties: A Regression Approach

Socioeconomic Factors Impacting Poverty in U.S. Counties: A Regression Approach

Python (matplotlib, pandas, numpy, Requests, scikit-learn, scipy, seaborn, statsmodels) • Multiple linear regression • Hypothesis testing • Model validation • Robust standard errors (HC3) • API requests • JSON data parsing • EDA

This post summarizes my capstone project for my program in Data Analytics at WGU. I used multiple linear regression to investigate how socioeconomic factors influence poverty rates across U.S. counties.

Power BI Report: Analyzing LapCat vs LapDog Performance at Waggle

Power BI Report: Analyzing LapCat vs LapDog Performance at Waggle

Power BI • DAX • Power Query • Data visualization • Branding

In this project, I analyzed user and pet data from Waggle, a pet-tech startup known for its innovative smart devices for pets. After the success of the LapDog fitness collar for dogs, Waggle launched a field test of its feline counterpart called “LapCat”. My report aims to help stakeholders understand how the new device is performing and whether it justifies further development.

Preparing Data for Reporting Using PostgreSQL

Preparing Data for Reporting Using PostgreSQL

PostgreSQL • PL/pgSQL • Data extraction • DDL (Data Definition Language) • DML (Data Manipulation Language) • Joins • Subqueries • Triggers • Stored Procedures

This project demonstrates how SQL and PostgreSQL can be used to transform raw transactional data into structured, analysis-ready tables. Using the DVD Rental Dataset, I built a structured workflow to extract, transform, and organize rental data for future insights and analysis.

U.S. YouTube Video Trends: A Tableau Dashboard & Story

U.S. YouTube Video Trends: A Tableau Dashboard & Story

Tableau dashboard • Tableau story • Storytelling

What do trending YouTube videos reveal about American viewers? In this Tableau project, I analyzed U.S. YouTube trending data to uncover patterns in viewer sentiment, identify top-performing creators, and explore regional content preferences.

Pagination