I'm looking for new and innovative ways/ideas to build a forecasting system that can forecast any number of transactions occurring in the next n number of days. Looking for ideas on database table design and structure to help tackle this problem.Also looking at application side how to achieve this, suppose one enters a future date and system should be able to display the forecasted balances with detailed transactions broken down into days, where the days will act as columns and rows will show the amounts and transactions which are affecting the balances.The technology being used is ASP.Net with C# 4.0 and SQL Server 2008.Would love to hear from you guys.
Forecasting system database design ideas [closed]
- Thread starter ring00
- Start date