This tutorial shows you how to import data from a qvd file. Open Import Wizard Open Excel. (1) Click on the Vizubi Tab in the ribbon bar. (2) Click on the Edit button in the database group. (3) This will open the Import Data window. Selecting the data you want to import (1) Select [...]
Excel Sales Dashboard: more functions
In this tutorial you will learn how to use three other different Vizubi functions: – GetVizubiFilters() – GetVizubiVariableValue(Variable[,Type]) – GetVizubiFieldValues(Field [,Status [,Filter [,Sort]]]) Before reading this tutorial it is useful to have followed these tutorials: – Excel Sales Dashboard: an example of dashboard using Vizubi Functions – Excel Sales Dashboard: behind the scenes Open Excel_Dashboard_Vizubi.xlsx [...]
Excel Sales Dashboard: behind the scenes
In this tutorial you will learn how to build some of the elements included in the Excel Sales Dashboard using Vizubi Formulas. Before reading this tutorial it is useful to read the following tutorials: – Excel Sales Dashboard: a sample dashboard using Vizubi Functions – Creating and Using Pivot Charts Open Excel_Dashboard_Vizubi.xlsx Download the Excel_Dashboard_Vizubi.zip [...]
Excel Sales Dashboard: an example of dashboard using Vizubi Functions
A dashboard is a user interface that organizes and presents information in a way that is easy to read. In this tutorial you can view an example of a Sales Dashboard built with some Vizubi Functions. Details on how to build the dashboard will be explained in the tutorial called: Excel Sales Dashboard: behind the [...]
How to create and use report specific filters
Vizubi allows users to apply filters to all of the reports in a workbook or to single reports. Report specific filters lock the report from global filters which are applied to fields which are in the report specific filter. For example if you create a report with a report specific filter for Canada in the [...]
How to manage favorites lists for reports, panels and bookmarks
Load one of your ndb files Load one of your ndb files previously created. Open excel. (1) Click on the Vizubi tab. (2) Click on the Open button in the Database group of the ribbon and open the ndb file. List view for Most Recently and Most Frequently Used If you click on the down [...]
How to create and use bookmarks
Bookmarks are used to save filters that you think you will use frequently. Bookmarks contain fields and the values for those fields against which you want to filter. There are two types of bookmark: Type 1) Applying the bookmark will remove all active filters and apply the filters in the bookmark. Type 2) Applying the [...]
Outer join: a quick overview
Vizubi now treats relationships between tables as outer joins while previously relationships were treated as inner joins. That means that you will now see all the values for all fields in the database. Products which have never been sold will be shown in reports with the product field and Countries where you have never made [...]
Creating and using pivot charts
Pivot charts are graphical representations of the data in pivot tables. In Vizubi you can create pivot charts without having to create a report first. The underlying data for pivot charts is contained in a separate worksheet which is automatically named: Data for Vizubi_Chart_1 and is numbered sequentially. Load the AdventureWorksDW.ndb Open the Vizubi database [...]
How to create a calculated column
This lesson is a step by step guide on how to create calculated columns in a report. Calculated columns are columns you add to a table in your database. The data in calculated columns is derived from the data in one or more columns in the table and can contain operators and constants. For instance, [...]
Stay in Touch