A computer-implemented method prepares data for modeling. The method comprises storing data from customer sales transactions in a database and retrieving a dataset of the data from the database. The dataset may include promotion and merchandizing entries. The method includes cleansing the dataset to remove erroneous and anomalous entries. Cleansing the dataset may include determining a threshold value from the dataset and determining whether a value of the dataset exceeds the threshold value, and determining an out-of-stock status for a product from the dataset. The method includes aggregating the dataset over a plurality of dimensions of the transactional space including store, product, and time dimensions, and analyzing the dataset following the cleansing and aggregating steps within a model to predict attributes of subsequent sales transactions.