Skip to content

A Power BI and PostgreSQL dashboard analyzing 15+ years of rental property financial data. Tracks key performance metrics such as income, expenses, NOI, and late payments to optimize property management and investment decisions.

Notifications You must be signed in to change notification settings

YSayaovong/PropTech-Analytics-Platform-ETL-Forecasting-KPI-Engine

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Retail Sales Forecasting & KPI Analytics

This project applies data analytics and machine learning techniques to forecast retail sales and generate KPI insights. It highlights skills in data preprocessing, exploratory analysis, feature engineering, and predictive modeling.


Overview

The project analyzes retail datasets to uncover trends, understand seasonality, generate key business performance indicators, and build forecasting models. It demonstrates end-to-end analytics workflow from raw data to actionable insights.


Tech Stack

  • Python
  • Pandas, NumPy
  • Matplotlib, Seaborn
  • Scikit-learn
  • Jupyter Notebook

Features

  • Data cleaning and preprocessing
  • KPI generation (sales totals, growth, category performance, etc.)
  • Exploratory data analysis with visualizations
  • Feature engineering for forecasting
  • Machine learning forecasting models
  • Evaluation metrics and model comparison

Project Structure

.
├── data/                 # Raw and processed datasets
├── notebooks/            # Jupyter notebooks for analysis
├── models/               # Saved models (if included)
├── visuals/              # Generated plots
└── README.md             # Documentation

Getting Started

1. Clone repository

git clone https://github.com/YSayaovong/retail-sales-forecasting-kpi-analytics.git
cd retail-sales-forecasting-kpi-analytics

2. Install dependencies

pip install -r requirements.txt

3. Open notebooks

jupyter notebook

Potential Enhancements

  • Deploy forecasting model as an API
  • Add dashboard for KPI visualization
  • Integrate automated data pipelines
  • Add hyperparameter tuning & advanced ML models

License

This project is open-source under the MIT License.

About

A Power BI and PostgreSQL dashboard analyzing 15+ years of rental property financial data. Tracks key performance metrics such as income, expenses, NOI, and late payments to optimize property management and investment decisions.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published