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 [...]
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 [...]
Step by Step guide for creating Vizubi report from AdventureWorksDW SQL tables
This lesson is a step by step guide on how to create a Vizubi workbook from the AdventureWorks DW database that Microsoft ships with SQL Server 2008 R2. Download the DB Note1: This guide assumes that you have access to SQL Server 2008R2 with the AdventureWorksDW database installed (you can download it here. In this [...]
How to sort data
In Vizubi there are two different types of sorts: -You can sort the data in the columns of the tables loaded in the Vizubi Editor. -You can sort the data in the columns of your reports in Excel. These two types of sorts are totally independent of each other. This means that when you sort [...]
Vizubi User Interface
Elements of Vizubi in the add in of Excel and in the Vizubi Editor. The add-in in Excel
How to use groups with your reports
A group, like a slicer is a set of fields. You can create reports with groups in the columns instead of fields. Each time you click on the column header in which there is a group, the data in that column will cycle through each field in the group, allowing you to see the same [...]
How to create a Panel
Panels are groups of slicers. They are used so that you can select slicers to filter your report. You can only use one panel at a time, but you can put as many slicers into a panel as you want and the same slicer can be put into as many panels as you want. [...]
Stay in Touch