We will use Egeria to compute the revenue of a lemonade store in this tutorial. We will start with a simple sheet for 31 days and a single product and than extend the model to support multiple products and points of sale. Finally we will export the data to a pivot table to analyze it.
Advanced example: Sales planning
This video shows a sales planning model for a fictional globally active bicycle manufacturing company. The system collects company's sales data and costs from several hundreds of shops scattered around the globe. The manufacturing cost figures are imported from a relational database. This data is aggregated in real-time to produce a company-wide income statement. The sales figures are collected in shop's local currency for each shop and the results are converted into company's currency (USD). This allow for easy simulation of how exchange rate changes affect the company's income statement.