You just finished listening to a really expensive Business Intelligence consultant tell you that you need to invest in an even more expensive data warehouse to reduce the load on your incredibly expensive ERP system. The reason you need to do this is that you need to use some data that is not directly available in your data sources but has to be calculated. You have three options:
- Do nothing and hope that downtime for the ERP system just goes away.
- Spend buckets of cash and hope for the best.
- Log on to Monster and start looking for a new job.
OR, you could just use Vizubi. With Vizubi you can create calculated columns after the import phase which are saved directly into your database. You can share the database with other users so that they don’t have to calculate the values again. This means that you get high performance without burdening your other systems. Vizubi’s calculated columns support a series of operations from simply adding or multiplying the values from two columns to extracting strings from fields and calculating new time dimensions.
Learn more:
- Adventureworks calculated colums
- Adventureworks calculated colums Text Tutorial
- How to work with columns
- How to work with columns Text Tutorial
Stay in Touch