Data Ninja:

Data & Visual Analytics
Software Development
Hardware



VizDesigner Professional v2.3



Overview

VizDesigner Professional is a modern windows app for interactive data exploration. Understand the data by interact with the data through visually intuitive controls. Many of these normally complex tasks can be accomplished with a simple drag-and-drop operation, allowing users to start creating interactive visualizations immediately. Use powerful queries (e.g. aggregating, groupby, join table, and filter) with simple UI, no programming required. VizDesigner is on par with start-of-the-art commercial visual analytics products, such as Tableau, IBM Cognos Insight, and SAS Visual Analytics.

How i'm using it. I use VizDesigner to develop interactive visualizations for my audiences. This is one of my daily tool for producing interactive visualizations for the audiences. Instead of giving´em a static and boring chart in Power Point. I can send them a self-contained package that contains multiple coordinated visualizations. The audiences can directly interact with the data visualizations. It helps them to better understand the story that I intended to convey.


Main Features:

  • Drag-n-drop to create powerful & interactive visualizations
  • Touch-screen ready: use it on tablet, phone, or desktop
  • Load data from CSV or Excel Files
  • Or directly connect to a SQL server
  • Rich collection of charts at your disposal
  • Apply complex query, filter, and calculation with simple clicks
  • Publish and share works with colleagues easily

The goal of the interactive dashboard creation is to empower the users with the flexibility to create the custom queries to answer the questions that they have, by utilizing the rich number of datasets that StockSys provided from the backend (the datasets are discussed in the later section). B y combining relevant visualizations, users can create an interactive dashboard that provide a comprehensive picture of multiple phenomena represented by the data in a single visualization. The visualization dashboard supports all common interaction techniques, such as brushing, demand-on-details, filter, and aggregation, and annotation, required for effective data exploration. The types of visualization can be created included but no limited to bar charts, line charts, histogram, scatter plot, heatmap, pivot table, spreadsheet, and map.

Types of Visualization Available

Create custom data variables with Expression Editor Even with the rich and comprehensive datasets provided by StockSys, investors often have some very specific data variable that they derived from existing data variables. The expression editor in StockSys allows users to create new variable, such as technical indicators, threshold indicators, and complex financial ratios, using simplified user interface. Similar feature is available in Guorn (www.guorn.com). Nevertheless, StockSys provides more comprehensive set of operators and tools for the users to flexibility express their logic.


Highly customizable data visualizations Various features are available for the users to create visualizations as they imagined. Users have directly access to custom the axes, color, weight, sorting, legend, and data points properties of the visualization.

Highly Customizable Data Visualizations

Create coordinated visualizations This feature allows the users to simultaneous interactions with multiple coordinated visualizations. For instance as shown in the figure below, the selected elements in the scatter plot, will be used to filter the bar chart which in turn its selected elements will be used to defined the data table at the bottom. Such enquiries allow the relations or patterns between multiple data perspective to be uncovered. Such an implicit information is implicit characteristic of the data that analysts derive from their rich interaction with the multimodal enquiry. The ability to discover implicit findings from data is critically important in the complex problem, where the key information is often not explicitly observable from the data. Green et al. (2009) suggested that multi-modal enquiries encourage analysts to derive deeper and more multi-faceted understanding of the data. This allows the users to understand the true nature of the data. With the divergent enquiry, the users will be more effective in discovering implicit relationships between data elements, which in turn will enable them to identify and use more relevant data elements to enhance the quality of their data exploration.

Create coordinated visualizations

Tutorial


Last Update: 26 April 2017

Getting Started

Loading Data (Excel File)

The following is the view in the ribbon menu once the VizDesigner Professional is completed initialized. The home tab provides access to all the major features in the VizDesigner. The theme of the application can be changed using the appearance setting. To use VizDesigner, click on Data Source tab on the ribbon menu.

On the Data Source tab, select New Data Source. The Data Source Wizard will appear, select "Microsoft Excel workbook / CSV File. For the next dialog, just use the default value. Then, select which workbook to be imported from the Excel file. The excel file used in this example can be downloaded from here.

The last dialog is where the types of the data imported can be changed.

Create a Simple Visualization (Grid)

To test out the newly imported data, create a grid (one of the visualizations) by selecting the Grid button VizDesigner tab. Next, drag the data variables (displayed on the left-panel) into the New Column. As soon as a data variable is dropped into the New Column field, the Grid display will be updated instantly to reflect the change.

As the result, you will have the grid filled up with data. There are a series of interaction allowed by each of the visualizations. For grid, it supports filtering, sorting, search, format rules, and aggregation. Try to discover these features by clicking on different parts of the Grid.

For now, let's change the aggregation of the data displayed in the Grid. For example, data variables such as "Age", :"PClass", and "Fare" are more accurate if they are presented in "average" rather than the default "sum" aggregation. Go to the fields where the data variables are dropped, click on the tiny drop-down arrow, and select "average" from the list.

Create Coordinated Visualizations

One major feature of VizDesigner is to create coordinated visualization. It means when the records in one visualization is selected / filtered / sorted, the effects of such operation will be to other visualizations on the same page. For demonstrating this, let's create a scatter chart by clicking on the icon on the VizDesigner tab. A new blank scatter chart will be created besides the Grid.

Click on the blank scatter chart and notice that the data fields have changed to reflect those data fields specific to the scatter chart (from previously Grid's data field). Now there are X-axis, Y-axis, Weight, and Argument. For this example, the Age is dropped to the X-axis, the Fare is dropped to the Y-axis. Then, their aggregation type is set to be "average". PassengerId is dropped to the Argument. Argument is the data field that will be displayed in the Legend.

Now the scatter chart is filled with the data points to show the Age and Fare interceptions of ALL passengers. To demonstrate the coordinated visualizations, this example want to achieve a cleaner and interactive scatter plot by only showing the passengers that are selected in the Grid. To do this, select the Grid and make it an active selection. Go to the Data tab that appear under "Grid Tools" section of the ribbon menu. Select Mutliple Master Filter. Now try to select just a few passengers from the Grid. Multiple records (i.e. passengers) can be selected while holding the CTRL key on your keyboard. Notice how the scatter chart is updated instantly to reflect the selections. You just created your first coordinated visualizations.

Let's improve the visualizations. Click on the Scatter Chart, and now drag and drop "PClass", which represents the class of the cabin, into the argument (as a second argument). Move the mouse cursor to the data field where the "PClass" is just dropped, navigate to the drop-down arrow and select Color by > Hue. Now the data points displayed in the Scatter Chart is colored according to the cabin class of the passengeers.

Download & Change Log

Download

Download a Free Copy

Supports: Windows 7, Windows 8.1, Windows 10

Architecture: 64-bit Windows

Installer Type: Executable (.exe) File

Requirement: .Net Framework 4.7 and above


Note: A valid serial key is needed for installing the software.

Get a free serial key from nicdatalab@outlook.com

No question asked. No information Required. Just for Protection Purposes

Terms of Use: VizDesigner Professional is only can be used for educational and learning purposes. The software cannot be used for commercial or organizational use that is for direct or indirect economic advantage. For example, for the production of commercial training materials; analysis for paying clients; and any other activities that involve any kind of economic advantage. Nic's Data Lab cannot be held liable for any misuse, abuse, or non-permitted usage carried out by the users or the downloaders of this software.


Change Log

[2019.02.02] Version 2.3 (20190202)
  • Rebased in .Net Framework 4.7
  • Increased database connection options
  • x86 version is fully decommissioned

[2017.04.24] Version 1.5 (20170424)
  • First non-beta release
  • Serial key regenerated for security purpose
  • Only x64 version is published
  • Admin access required for installation

© 2020 - DataNinja.ml