Easy import

Vizubi’s import wizard simple yet sophisticated

Vizubi’s import wizard is so simple that whether you’re loading a text file or a table from an Oracle database, you’ll get the job done fast. Forget about SQL queries, joins and star schemas (what’s a star schema anyway?). Vizubi does the heavy lifting so that you can concentrate on what you do best; creating actionable information from data.
Once you’ve decided what to import, Vizubi will automatically relate the different pieces of data you bring into the database so that you can perform complex analyses across data sets easily. The wizard also automatically creates time dimensions which let you create time related views and do comparisons like this year vs. last year and this quarter vs. last quarter.

Use linked tables to quickly add and update data in your database

“I can’t finish the analysis because IT won’t updated my data until 2:00 am and I need to get this done today…”
“I can’t do the analysis I want because the cube isn’t ready…”
Every year doing the budget is a nightmare; I need to get data from my agents, consolidate it, get it into the system….. at the end of the day I hardly have time to spend on creating a strategy…”

How many times have you heard this?
How many times has it happened to you?
How many more hours are you going to spend waiting?

With Vizubi and linked tables, all that can be stuff of the past.

With linked tables you can put data into Excel tables and the load that data directly into your database. No more cutting and pasting. No more asking salesmen to enter data into the system. No more waiting.

Sounds too good to be true? It almost is.

Learn more:

• How to create linked tables
• How to create linked tables Text Tutorial
• How to create linked tables in Excel 2003 Text Tutorial

Import data from qvd (QlikView data files)

QlikView saves data in qvd format. They’re created by QlikView and read by QlikView only. Right? Wrong!!

Vizubi can import data directly from qvds.

Once you import your .qvd file, you can create relationships between your QlikView data and data from other sources to carry out complete analyses. The only limit is your creativity.

Learn more:

• Import a table from a qvd file
• Import a table from a qvd file Text Tutorial

Field formats

How much time have you wasted making sure fields are in the correct format. How much more time have you spent trying to figure out why the formatting has been changed after importing new data.

With Vizubi, the innovative BI plug-in for Excel, formats are set when data is imported. The Vizubi engine will take care of keeping everything consistent in your reports and analyses. Imagine how much more time you’ll have to spend doing analysis and how much less time you’ll have to spend on drudge-work.