Pivot tables in Excel can only use data from a single table. You can use VLookup as a workaround, but it’s time-consuming and slow. In Vizubi you can put fields from any table in your database into the same pivot table or pivot chart. Performance is exceptional even when you’ve got a ton of data [...]
Relationships eliminate VLookup problems
June 12, 2010 By
VLookup. You’re either living in ignorant bliss, or cursing the very name. In any case, Vizubi can help you spend more time doing analysis and less time trying to figure out how to get the right data into an analysis or report. Vizubi uses a simple and intuitive system for managing the relationships between the [...]
Actionable information with calculated columns
June 12, 2010 By
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 [...]
Only show the data you want in the database and reports
June 4, 2010 By
One of the biggest problems in doing analysis is ensuring that the data you use is clean. In Vizubi, part of the import process revolves around ensuring that the data you work with will give you reliable results. You can choose to import only the fields that you are interested in using. You can hide [...]
Automatically create Time Dimensions: avoid time consuming, repetitive tasks
May 27, 2010 By
Creating Time Dimensions is one of the most repetitive tasks in business intelligence projects. Usually, BI tools leave this work to users. Our self-service software takes the drudgery out of this by automatically creating time dimension tables for date/time fields. Our import wizard recognizes date and time fields and asks users if they want to [...]
Stay in Touch