forecast-accuracy

Time Series Cross-Validation

A Time Series project from TripleTen

MySQL supply chain analytics project analyzing actual vs forecast sales, forecast accuracy, and business performance using CTEs, stored procedures, triggers, and advanced SQL.

风电光伏功率预测准确率统计工具：本地离线 Excel 自动化脚本，用于两个细则功率预测上报率、短期、超短期、中期准确率月度统计。

Time-series modelling of open-ocean temperature anomalies using stationarity testing, ARMA model comparison, residual diagnostics and holdout forecasting in R.

SQL-based ad hoc analytics project covering Finance and Supply Chain functions for AtliQ Hardwares. Features 11 business queries using advanced SQL concepts including stored procedures, CTEs, window functions, and views to analyze net sales, forecast accuracy, and supply chain performance across 5M+ records.

AI tool that evaluates forecast reliability using statistical diagnostics and AI insights.

Senior/Lead Power BI case study for forecast metric contracts, decision design, testing, operations, and governance.

Multi-page Power BI dashboard consolidating Finance, Sales, Marketing, Supply Chain & Executive KPIs — P&L, profitability, and forecast-accuracy analysis with vs-Benchmark/LY/Target comparisons.