20130131

Tableau Readings, January 2013

Best of the Tableau Web... December 2012:
http://www.tableausoftware.com/about/blog/2013/1/best-tableau-web-december-2012-20758
Top 100 Q4 2012 from Tableau Public:
http://www.tableausoftware.com/public/blog/2013/01/top-100-q4-2012-1765
eBay's usage of Tableau as the front-end for big data, Teradata and Hadoop with 52 petabytes of
data on everything from user behavior to online transactions to customer shipments and much more:
http://www.infoworld.com/d/big-data/big-data-visualization-big-deal-ebay-208589
Why The Information Lab recommends Tableau Software:
http://www.theinformationlab.co.uk/2013/01/04/recommend-tableau-software/
Fun with #Tableau Treemap Visualizations
http://tableaulove.tumblr.com/post/40257187402/fun-with-tableau-treemap-visualizations
Talk slides: Tableau, SeaVis meetup & Facebook, Andy Kirk's Facebook Talk from Andy Kirk
http://www.visualisingdata.com/index.php/2013/01/talk-slides-tableau-seavis-meetup-facebook/
Usage of RAM, Disk and Data Extracts with Tableau Data Engine:
http://www.tableausoftware.com/about/blog/2013/1/what%E2%80%99s-better-big-data-analytics-
memory-or-disk-20904
Migrating Tableau Server to a New Domain
https://www.interworks.com/blogs/bsullins/2013/01/11/migrating-tableau-server-new-domain
SAS/Tableau Integration
http://www.see-change.co/services/sastableau-integration/
IFNULL - is not "IF NULL", is "IF NOT NULL"
http://tableaufriction.blogspot.com/2012/09/isnull-is-not-is-null-is-is-not-null.html
Worksheet and Dashboard Menu Improvements in Tableau 8:
http://tableaufriction.blogspot.com/2013/01/tv8-worksheet-and-dashboard-menu.html
Jittery Charts - Why They Dance and How to Stop Them:
http://tableaufriction.blogspot.com/2013/01/jittery-charts-and-how-to-fix-them.html
Tableau Forums Digest #8
http://shawnwallwork.wordpress.com/2013/01/06/67/
Tableau Forums Digest #9
http://shawnwallwork.wordpress.com/2013/01/14/tableau-forums-digest-9/
Tableau Forums Digest #10
http://shawnwallwork.wordpress.com/2013/01/19/tableau-forums-digest-10/
Tableau Forums Digest #11
http://shawnwallwork.wordpress.com/2013/01/26/tableau-forums-digest-11/
implementation of bandlines in Tableau by Jim Wahl (+ Workbook):
http://community.tableausoftware.com/message/198511

20130121

Advizor Visual Discovery, Part 2

This is the Part 2 of the guest blog post: the Review of Visual Discovery products from Advizor Solutions, Inc., written by my guest blogger Mr. Srini Bezwada (his profile is here: http://www.linkedin.com/profile/view?id=15840828 ), who is the Director of Smart Analytics, a Sydney based professional BI consulting firm that specializes in Data Visualization solutions. Opinions below belong to Mr. Srini Bezwada.

ADVIZOR Technology


ADVIZOR's Visual Discovery™ software is built upon strong data visualization tools technology spun out of a distinguished research heritage at Bell Labs that spans nearly two decades and produced over 20 patents. Formed in 2003, ADVIZOR has succeeded in combining its world-leading data visualization and in-memory-data-management expertise with extensive usability knowledge and cutting-edge predictive analytics to produce an easy to use, point and click product suite for business analysis.

ADVIZOR readily adapts to business needs without programming and without implementing a new BI platform, leverages existing databases and warehouses, and does not force customers to build a difficult, time consuming, and resource intensive custom application. Time to deployment is fast, and value is high.

With ADVIZOR data is loaded into a "Data Pool" in main memory on a desktop or laptop computer, or server. This enables sub-second response time on any query against any attribute in any table, and instantaneously update all visualizations. Multiple tables of data are easily imported from a variety of sources.

With ADVIZOR, there is no need to pre-configure data. ADVIZOR accesses data "as is" from various data sources, and links and joins the necessary tables within the software application itself. In addition, ADVIZOR includes an Expression Builder that can perform a variety of numeric, string, and logical calculations as well as parse dates and roll-up tables - all in-memory. In essence, ADVIZOR acts like a data warehouse, without the complexity, time, or expense required to implement a data warehouse! If a data warehouse already exists, ADVIZOR will provide the front-end interface to leverage the investment and turn data into insight.
Data in the memory pool can be refreshed from the core databases / data sources "on demand", or at specific time intervals, or by an event trigger. In most production deployments data is refreshed daily from the source systems.

Data Visualization


ADVIZOR's Visual Discovery™ is a full visual query and analysis system that combines the excitement of presentation graphics - used to see patterns and trends and identify anomalies in order to understand "what" is happening - with the ability to probe, drill-down, filter, and manipulate the displayed data in order to answer the "why" questions. Conventional BI approaches (pre-dating the era of interactive Data Visualization) to making sense of data have involved manipulating text displays such as cross tabs, running complex statistical packages, and assembling the results into reports.

ADVIZOR's Visual Discovery™ making the text and graphics interactive. Not only can the user gain insight from the visual representation of the data, but now additional insight can be obtained by interacting with the data in any of ADVIZOR's fifteen (15) interactive charts, using color, selection, filtering, focus, viewpoint (panning, zooming), labeling, highlighting, drill-down, re-ordering, and aggregation.

AdvizorCharts
Visual Discovery empowers the user to leverage his or her own knowledge and intuition to search for patterns, identify outliers, pose questions and find answers, all at the click of a mouse.

Flight Recorder - Track, Save, Replay your Analysis Steps


The Flight Recorder tracks each step in a selection and analysis process. It provides a record of those steps, and be used to repeat previous actions. This is critical for providing context to what and end-user has done and where they are in their data. Flight records also allow setting bookmarks, and can be saved and shared with other ADVIZOR users.
The Flight Recorder is unique to ADVIZOR. It provides:
• A record of what a user has done. Actions taken and selections from charts are listed. Small images of charts that have been used for selection show the selections that were made.
• A place to collect observations by adding notes and capturing images of other charts that illustrate observations.
• A tool that can repeat previous actions, in the same session on the same data or in a later session with updated data.
• The ability to save and name bookmarks, and share them with other users.

Predictive Analytics Capability


The ADVIZOR Analyst/X is a predictive analytic solution based on a robust multivariate regression algorithm developed by KXEN - a leading-edge advanced data mining tool that models data easily and rapidly while maintaining relevant and readily interpretable results.
Visualization empowers the analyst to discover patterns and anomalies in data by noticing unexpected relationships or by actively searching. Predictive analytics (sometimes called "data mining") provides a powerful adjunct to this: algorithms are used to find relationships in data, and these relationships can be used with new data to "score" or "predict" results.

AdvizorPredictiveModel

Predictive analytics software from ADVIZOR don't require enterprises to purchase platforms. And, since all the data is in-memory, the Business Analyst can quickly and easily condition data and flag fields across multiple tables without having to go back to IT or a DBA to prep database tables. The interface is entirely point-and-click, there are no scripts to write. The biggest benefit from the multi-dimensional visual solution is how quickly it delivers analysis, solving critical business questions, facilitating intelligence-driven decision making, providing instant answers to "what if?" questions.

Advantages over Competitors:


• The only product in the market offering a combination of Predictive Analytics + Data Visualisation + In memory data management within one Application.
• The cost of entry is lower than the market leading data visualization vendors for desktop and server deployments.
• Advanced Visualizations like Parabox, Network Constellation in addition to normal bar charts, scatter plots, line charts, Pie charts…
• Integration with leading CRM vendors like Salesforce.com, Blackbaud, Ellucian, Information Builder
• Ability to provide sub-second response time on query against any attribute in any table, and instantaneously update all visualizations.
• Flight recorder that lets you track, replay, and save your analysis steps for reuse by yourself or others.

Update on 5/1/13 (by Andrei): Avizor 6.0 is available now with substantial enhancements: http://www.advizorsolutions.com/Bnews/tabid/56/EntryId/215/ADVIZOR-60-Now-Available-Data-Discovery-and-Analysis-Software-Keeps-Getting-Better-and-Better.aspx

20130111

Advizor Visual Discovery, Part 1

If you visited my blog before, you know that my classification of Data Visualization and BI vendors are different from researchers like Gartner. In addition to 3 DV Leaders - Qlikview, Tableau, Spotfire - I rarely have time to talk about other "me too" vendors.

However, sometimes products like Omniscope, Microstrategy's Visual Insight, Microsoft BI Stack (Power View, PowerPivot, Excel 2013, SQL Server 2012, SSAS etc.), Advizor, SpreadshetWEB etc. deserve attention too. However, it takes so much time, so I am trying to find guest bloggers to cover topics like that. 7 months ago I invited volunteers to do some guest blogging about Advizor Visual Discovery Products:

http://apandre.wordpress.com/2012/06/22/advizor-analyst-vs-tableau-or-qlikview/

So far nobody in  USA or Europe committed to do so, but recently Mr. Srini Bezwada, Certified Tableau Consultant and Advizor-trained expert from Australia contacted me and submitted the article about it.  He also provided me with info about how Advizor can be compared with Tableau, so I will do it briefly, using his data and opinions. Mr. Bezwada can be reached at

sbezwada@smartanalytics.com.au , where he is a director at

http://www.smartanalytics.com.au/

Below is quick comparison of Advizor with Tableau. Opinions below belong to Mr. Srini Bezwada. Next blog post will be a continuation of this article about Advizor Solutions Products, see also Advizor's website here:

http://www.advizorsolutions.com/products/



































































































































































































CriteriaTableauADVIZORComment
Time to implementVery FastFast, ADVIZOR can be implemented within DaysTableau Leads
ScalabilityVery GoodVery GoodTableau: virtual RAM
Desktop License$1,999$ 1,999$3,999 for AnalystX with Predictive modeling
Server License/user$1K, min 10 users, 299 K for EnterpriseDeployment license for up to 10 named users $8 KADVIZOR is a lot cheaper for Enterprise Deployment $75 K for 500 Users
Support fees / year

20%



20%


1st year included
SaaS PlatformCore or DigitalOffers Managed HostingADVIZOR Leads
Overall CostAbove AverageCompetitiveADVIZOR Costs Less
Enterprise ReadyGood for SMBCheaper cost model for SMBTableau is expensive for Enterprise Deployment
Long-term viabilityFastest growthPrivate company since 2003.Tableau is going IPO in 2013
MindshareTableau PublicGrowing FastTableau stands out
Big Data SupportGoodGoodTableau is 32-bit
Partner NetworkGoodLimited PartnershipsTableau Leads
Data InteractivityExcellentExcellent
Visual DrilldownVery GoodVery Good
Offline ViewerFree ReaderNoneTableau stands out
Analyst's DesktopTableau ProfessionalAdvizor has Predictive ModelingADVIZOR is a Value for Money
Dashboard SupportExcellentVery GoodTableau Leads
Web ClientVery GoodGoodTableau Leads
64-bit DesktopNoneVery GoodTableau still a 32-bit app
Mobile ClientsVery GoodVery Good
Visual ControlsVery GoodVery Good
Data IntegrationExcellentVery GoodTableau Leads
DevelopmentTableau ProADVIZOR Analyst
64-bit in-RAM DBGoodExcellentAdvizor Leads
Mapping supportExcellentAverageTableau stands out
Modeling, AnalyticsBelow AverageAdvanced Predictive ModellingADVIZOR stands out
Predictive ModelingNoneAdvanced Predictive Modeling Capability with Built in KXEN algorithmsADVIZOR stands out
Flight RecorderNoneFlight recorder lets you track, replay, save your analysis steps for reuse by yourself or others.ADVIZOR stands out
Visualization22 Chart typesAll common charts like  bar charts, scatter plots, line charts, Pie charts are supportedAdvizor has Advanced Visualizations like Parabox, Network Constellation
Third party integrationMany Data Connectors, see Tableau's drivers pageADVIZOR integrates well with CRM software: Salesforce.com, Ellucian, Blackbaud and others.ADVIZOR leads in CRM area
TrainingFree Online and paid ClassroomFree Online and paid via company trainers & PartnersTableau Leads