1 / 22

OMB Data Visualization Tool Requirements Analysis: QlikView

OMB Data Visualization Tool Requirements Analysis: QlikView. Dr. Brand Niemann Director and Senior Data Scientist Semantic Community http://semanticommunity.info/ AOL Government Blogger http://breakinggov.com/author/brand-niemann/ July 17, 2013

blaze
Download Presentation

OMB Data Visualization Tool Requirements Analysis: QlikView

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OMB Data Visualization Tool Requirements Analysis: QlikView Dr. Brand Niemann Director and Senior Data Scientist Semantic Community http://semanticommunity.info/ AOL Government Blogger http://breakinggov.com/author/brand-niemann/ July 17, 2013 http://semanticommunity.info/Data_Science/Free_Data_Visualization_and_Analysis_Tools/QlikView

  2. Background • DRAFT White Paper for OMB Pittsburgh, July 11, 2013. • Start With the End in Mind, Avoid Tool Wars, and Develop Well-designed Spreadsheets That Can be “Dragged and Dropped” Onto a Tool That Creates Statistics and Visualizations in the Public and Private Clouds. • Focus on Requirements Analysis by First Comparing Magic Quadrant Leaders on Common Data Sets. • Spotfire Was Able to Reproduce All the Tableau and Birst Data Visualizations With Dynamically Linked Visualizations. • Broaden This Requirements Analysis to Include More Sample Data Sets and Tools. • QlikView Is a Leader in the Gartner Magic Quadrant.

  3. QlikView: Personal Edition Register http://www.qlikview.com/us/explore/experience/free-download?ga-link=hero

  4. QlikView: Download http://us.demo.qlikview.com/download/

  5. QlikView Personal Edition: Client My Note: Complicated User Interface

  6. QlikCommunity: Welcome http://community.qlikview.com/community/new-to-qlikview

  7. QlikCommunity: Connectivity and Data Sources My Note: I did not find Data Sources here. http://community.qlikview.com/community/connectivity

  8. QlikCommunity: First Application • My Note: I found four Data Sources here: • Northwind.mdb – A Microsoft Access database that is freely and publically available. It contains data based on a fictitious product sales organization. • CustomerMaster.csv – A comma-separated values file containing a list of customers and their details. • ProductMaster.xls – A Microsoft Excel spreadsheet containing a list of products sold by the fictitious sales organization. • ProductCategory.txt – A text file containing the product to product group relationships. http://community.qlikview.com/docs/DOC-4345

  9. QlikView Personal Edition: Build Your First Application and Help My Note: Cannot load multiple tab spreadsheets and Access. Requires scripting and 47 pages of documentation. Do this in Spotfire and re-create the visualization types. http://semanticommunity.info/@api/deki/files/24992/Build_Your_First_Application_in_QlikView_FINAL.pdf http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf

  10. NwindDatabase: Access http://semanticommunity.info/@api/deki/files/24994/Nwind.mdb

  11. Nwind Database: Excel http://semanticommunity.info/@api/deki/files/25011/Nwind.xlsx

  12. Nwind Database: Spotfire https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?Nwind-Spotfire

  13. QlikView Personal Edition:Comparison With Spotfire

  14. HPN Health Prize: Knowledge Base My Note: See multiple visualization types. http://semanticommunity.info/HPN_Health_Prize#Spotfire_Visualizations

  15. HPN Health Prize: Spotfire https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?HPNHealthPrize-Spotfire

  16. Qlik Demos: Image Gallery http://us.demo.qlikview.com/images.aspx

  17. Qlik Demos: Image Gallery – World Heat Map

  18. QlikView: Global Games http://us.demo.qlikview.com/detail.aspx?appName=Global%20Games.qvw

  19. QlikView Personal Edition: Global Games http://us.demo.qlikview.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Global%20Games.qvw&host=Demo11&anonymous=true

  20. The Guardian Data Journalism: Knowledge Base http://semanticommunity.info/AOL_Government/The_Guardian_Data_Journalism

  21. Guardian Olympic Medals-Spotfire https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?GuardianOlympicMedals-Spotfire

  22. Some Conclusions and Recommendations • Semantic Community Was Able to Build the QlikView Personal Edition: Build Your First Application More Readily With Spotfire Using the Nwind Access Database. • Spotfire Is Able to Match or Exceed the Visualization Types and Their Options in QlikView. • Semantic Community Will Continue to Use The Gartner Magic Quadrant Leader Tools and Their Sample Data Sets and to Recreate Visualizations and Dashboards.

More Related