Pivot tables in Excel can only use data from a single table. You can use VLookup as a work around, 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 and best of all you don’t have to maintain complex formulas because your data is all connected.

Data in Vizubi is on one virtual table which is dynamically created as necessary to publish the output you need.

You make a presentation on lean manufacturing with data about bill of materials inventory levels. Two weeks later you’re asked to present the data again. You run the reports but in the mean time, new products have been added, the bill of materials has changed, the data has been updated and the numbers are different. There’s no way to go back and the participants in the meeting have the old data. You’re up the creek.

Unless you’re using Vizubi. In Vizubi, when you create reports, you can detach them from the database. This creates static views which are not modified when you update your data.

You’re in the midst of an analysis and you find some really interesting results. You want to do more but you also want to be able to look at the information you’ve just uncovered. With most BI tools you’ll have to create a new file or save the view and move on.

With Vizubi, just detach the report. Then reproduce it on the same worksheet. This creates a static view, with a dynamic view right next to it. You can go on with your analyses and continue to see the report you detached. And you can re-attach your report at any time.

Learn more:

• How to attach and detach a report
• How to attach and detach a report Text Tutorial
• How to create a report
• How to create a report Text Tutorial

You’ve got a big presentation and only a few hours to prepare. Then you realize you’ve got last week’s data in your reports. If you’ve done everything in Excel, you can kiss your job goodbye. With Vizubi, you’re one click away from being saved.

When you save the import parameters of the data you import with Vizubi, reloading data literally takes a single click. No waiting for IT, no worrying about whether the data in your spreadsheets is all from the same sources and has been updated at the same time.

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 tables you import. Relationships between fields with the same names on different tables are automatically identified during the import phase (you choose whether to create the relationship or not). You can also manually create relationships between tables even if the fields you’re using in the relationship aren’t the same. And you can drop VLookup forever.

Learn more:

• How to create relationships between tables
• How to create relationships between tables Text Tutorial

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.

Oh yeah 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

The intelligent part of business intelligence is people. So we make people shaped software, so you don’t have to be a software shaped person to use it. With Vizubi, turning data into actionable information is just one click away.

Filtering data is one of the most frequent actions when doing data analysis so in Vizubi we tried to keep it simple and intuitive. They say all roads lead to Rome (I’ve got my doubts); what I DO know is that in Vizubi, many paths can lead to the filter you want.

With Vizubi, you can filter on any value (even null values)
visible in your report just by clicking on them. You can double click to filter on a single value or select multiple values. In either case, you get instant filters.

You can save filters you think will be useful to use in the future as bookmarks, and you can also create panels of groups of fields you frequently want to use as filters. Our Panels display field values in easy to read grids or lists depending on what you prefer, so there’s no need to get the binoculars out to select the right checkbox.

So feel free to choose the road less traveled. Vizubi will take you where you want to go.
Learn more:

• How to filter data
• How to filter data Text Tutorial
• How to create a panel
• How to create a panel Text Tutorial

You’re analyzing purchasing seasonality and product rotation and you notice unusual information for products in warehouses in a certain region. You want to take a look at more detailed information but you want to keep your high level view as well. Stuck. Not if you have Vizubi.

Vizubi drill down lets you open reports or database tables from within a report and then publish them to an Excel table maintaining the filters applied to the original report. This lets you create hierarchies of reports which can progressively get you to greater levels of detail. When you like what you see, export the data to a table in Excel so you can see both the detailed information and the high level view that you started with.

One of the most time consuming and errror prone aspects of using Excel as a self service business intelligence tool is that you find yourself starting from scratch time and time again.

Vizubi saves reports within the database so you can use them again and again. When you open a report in an Excel workbook, and save the workbook, the next time you open it, the report will be updated with any new data in the Vizubi database

Reports can also be cloned so that you can create modified versions while saving the originals in the DB. You can also detach reports from the database to create static views in Excel.

All your reports can be saved to folders within your database so that you can find and open them quickly. You can also add detailed descriptions of reports so that you can share them with others.

Learn more:

• Your first report in Excel with Vizubi
• Your first report in Excel with Vizubi Text Tutorial
• How to create a report
• How to create a report Text Tutorial

Not really satisfied with your current business intelligence tool, but you’re worried that switching will be more painful than sticking with what you have?

Looking for a business intelligence tool but you’re worried that implementation related stress will take a decade off your life?

We’ve been working in the business intelligence space for over a decade both as implementers and as users and we know how to make things easy.

That’s why we developed Vizubi with the following features:

• based on Excel so you’re using a pretty much universal tool
• compatible with Excel 2003, 2007 and 2010 so you can choose the interface you’re most familiar with
• ribbon style toolbar with all features immediately accessible
• video and text based tutorials with sample data files you can download to make learning easy, fast and self-service
• but if you can’t find what you’re looking for online, our help desk will answer queries in 24 hours.
• user forum to exchange ideas with other users

Office 2010 has new functionality which can help users do analysis, but  you may not want to spend all the money for new and the hardware upgrades you may need.

But there’s no need to get left behind. You too can access the latest technologies in self-service business intelligence, column oriented databases and in-memory analysis: that’s why we created Vizubi and made it compatible with Excel 2003 and 2007.

Learn more:

• Your first report in Excel 2003 Text Tutorial
• Your first report in Excel 2007 Text Tutorial
• Business intelligence for all version of Excel (2003, 2007 and 2010)