Business model for www.Cognos-BI.Info & ETL-Tools.info tutorials

The example business scenario is a typical manufacturing company which needs a datawarehouse with sales, planning and costs management.
It is a plants nursery (palms and tropical plants) which is dedicated to the cultivation of plants and trade seeds and other products to individual customers, retailers and wholesalers.


We have made the following assumptions to this business model:

  • The complany cultivates palms, cycads and other plants
  • The complany is seeds and plants distributor. The plants sold are grouped into age ranges.
  • It's open 7 days a week, however most of the sales is performed during weekdays.
  • Price of the products depends on its age - the older the more expensive. Seeds are cheaper than plants and sold in the packets of 10.
  • Seeds are sold in greater quantities than plants and young plants sell better as well
  • We keep three years of sales data, the lowest detail is on the day level
  • We also store costs data (variable and fixed cost) which are provided. Fixed cost is provided once a year and variable cost is calculated on the monthly basis


    Please refer to the SAS tutorial below to see how the source data structures and how it has been populated. SAS Guide & Tutorial



    The data model, structure and sample figures stored in the datawarehouse are as follows:
    The data model, structure and sample figures stored in the datawarehouse are as follows