The demo application provides a way of comparing a brand or companies' Twitter presence with that of competitors or other companies in their (or indeed any) sector, by using twitter account names or any search term.
The demo application allows you to quickly and easily reload your own choice of Twitter accounts and search terms for some powerful competitive analysis.
Download
You can download a zip file containing the demo QlikView application and associated config file here:
Twitter Demo Application V2.6.zipIf you are upgrading from a previous version please ensure that you review the config.txt file for any changes which you may need to translate into your own files.
NOTE: Some features of this demo require QVSource 1.1.1 or later. Please reply to your original download email if you do not already have this.
Usage
The demo download should be composed of a QVW file and a TXT file as illustrated below.
The idea is that all the configuration (for the Twitter accounts and search terms to load, turning on/off parts of the load script etc.) are contained in the config.txt file. This is commented up as shown below.
//Edit the following table so that the right column contains the
//Twitter search term and the left column contains a friendly name (which
//matches the TwitterAccounts table below) to be used in charts.
TwitterSearchTerms:
LOAD * INLINE [
SearchTag, Company, TwitterSearchTerm
QlikView, QlikView, @QlikView,
SAP, SAP, @SAP,
Business Objects, Business Objects, @businessobjects,
Spotfire, Spotfire, @TibcoSpotfire,
Spotfire, Spotfire, @SpotfireSupport,
Cognos, Cognos, @IBMCognosCTO,
LogiXML, LogiXML, @LogiXML,
PowerPivot, PowerPivot, @powerpivot,
Tableau, Tableau, @tableau,
MicroStrategy, MicroStrategy, @microstrategy
];
//Edit the following table so that the right column contains the
//Twitter accounts and the left column contains a friendly name
//to be used in charts.
TwitterAccounts:
LOAD * INLINE [
Company, TwitterAccount
QlikView, @QlikView,
SAP, @SAP,
Business Objects, @businessobjects,
Spotfire, @TibcoSpotfire,
Cognos, @IBMCognosCTO,
LogiXML, @LogiXML,
PowerPivot, @powerpivot,
Tableau, @tableau,
MicroStrategy, @microstrategy
];
//This assigns a friendly name to Sentiment APIs, which are used in the application,
//so that you can easily identify and select which sentiment you want to use
SentimentAPI:
LOAD * INLINE [
SentimentAPI, Sentiment_api
Repustate, 0
TwitterSentiment, 1
];
// This is the company from whose perspective you wish to view the
// dashboard. this is not used in the application at present.
let vCompany='QlikView';
Editing List of Twitter Accounts & Search Terms
You can easily specify a collection of Twitter accounts and search terms to reload the application with data. To change the Twitter accounts, locate the following section in the config file.
//Edit the following table so that the right column contains the
//Twitter accounts and the left column contains a friendly name
//to be used in charts.
TwitterAccounts:
LOAD * INLINE [
Company, TwitterAccount
QlikView, @QlikView,
SAP, @SAP,
Business Objects, @businessobjects,
Spotfire, @flybe,
Cognos, @IBMCognosCTO,
LogiXML, @LogiXML,
PowerPivot, @powerpivot,
Tableau, @tableau,
MicroStrategy, @microstrategy
];
To edit the search terms, locate the following section in the config file:
//Edit the following table so that the right column contains the
//Twitter search term and the left column contains a friendly name (which
//matches the TwitterAccounts table below) to be used in charts.
TwitterSearchTerms:
LOAD * INLINE [
Company, TwitterSearchTerm
QlikView, @QlikView,
QlikView, @qlikcommunity,
SAP, @SAP,
Business Objects, @businessobjects,
Spotfire, @TibcoSpotfire,
Spotfire, @SpotfireSupport,
Cognos, @IBMCognosCTO,
LogiXML, @LogiXML,
PowerPivot, @powerpivot,
Tableau, @tableau,
MicroStrategy, @microstrategy
];
In both cases, the left column is the 'friendly' name, which can be used in charts in the dashboards, and the right column is the either the search term or the account name.
Loading
Once you have edited the necessary script above and saved the config.txt file you should be able to reload the QVW file (don't forget to make sure QVSource is running).
Scheduled Reloads
This application is designed to be reloaded hourly (or less regularly if you prefer).
We would recommend scheduling a reload at the start of each hour (as much of the data is timestamped according to the date and hour (1 - 24) of the load.
See the instructions
here and
here for getting started on this.
Screen Shots
Schema
Note - The PeerIndex tables will only appear if the notes on the PeerIndex script tab are followed. This data is not currently used in the dashboard itself.
Connectors Used
This application uses the following QVSource Connectors:
Blog Posts
QlikMetrics has done some great
blog posts on how to set up a Twitter account and use this demo dashboards and also provides some extra information about how the brand influencer and detractor metrics are calculated.