Ranking/Comparison of Data Visualization tools: Spotfire, Qlikview, Tableau, MS Stack

Adrei Pandre completed a “subjective quantitative” ranking of popular data visualization tools: Spotfire 4.0, Qlikview 11, Tableau 7.0 and Microsoft’s Business Intelligence Stack. So here it is – the updated and very subjective comparison of best Data Visualization tools, as I see them at the end of 2011. I know that many people will disagree with ...

Preventing Circular References in Qlikview

Circular references are common when building a data model.  A circular reference in a data model means that there is more than one way QV can resolve a query across 2 tables. There are a few good ways to avoid circular reference issues when creating a data model: Merge tables in to a single table using ...

Qlikview Scripting Tips: Connection Strings and Variables 2

When building and testing a QV application, you will typically use a production database (or live EDW) or a test database. It’s helpful to have a variable switch in the script to allow you to easily switch back and forth between the test and prod server. QQQ blog has a great explanation of how to ...

Qlikview 9 Server with IIS on a Windows 2003 Server

Microsoft IIS is often used as the webserver to serve up Qlikview pages using Qlikview Server. QQQ blog has some good tips for configuration of the Qlikview Server using IIS. This is applicable for QV 9 on a Windows 2003 Server. If your installation is fairly simple (no alternate websites, etc.), you may want to ...

Qlikview Scripting Tips: Comments

Using comments in a Qlikview script is good coding practice. Makes code easier to read and to debug. Develop a style for comments, for instance at the start of every load section. Here are some good tips, from the QQQ blog: There are several ways to create comments in your script. // is for single ...

How to Run QlikView in Excel

Industrial CodeBox has a great tool that allows users to work with Qlikview data and objects in Excel. As Qlikster says: Excel hell still predominates. IT might hate Microsoft Excel, but it really is the choice of tool for most businesspeople. They love the freedom and individual choice it confers on them – even though ...

QlikView What If Analysis with Sliders

A demonstration of doing simple what if analysis using variables and sliders within QlikView. Provided by Steve Dark at Quick Intelligence. See on www.youtube.com    

About tablespaces

A tablespace is a logical storage unit within an Oracle database. It is logical because a tablespace is not visible in the file system of the machine on which the database resides. A tablespace, in turn, consists of at least one datafile which, in turn, are physically located in the file system of the server. Btw, a datafile belongs ...

Exploring initialization parameters

The initialization parameters can be set in the init.ora file. There are two common ways to find out to what value an initialization parameter is set: show parameter <param_name> in sql*plus, or select value from v$parameter where name = lower(‘param_name’) The parameters can be changed for the currently connectedsession with a alter session set … command. If a parameter should be set in another session,dbms_system.set_bool_param_in_session ordbms_system.set_int_param_in_session can ...

Optimizing queries with SQL Hints

/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if alias names are used for table ...
Follow

Get every new post delivered to your Inbox

Join other followers: