OMB Data Visualization Tool Requirements Analysis: QlikView - PowerPoint PPT Presentation

blaze
omb data visualization tool requirements analysis qlikview n.
Skip this Video
Loading SlideShow in 5 Seconds..
OMB Data Visualization Tool Requirements Analysis: QlikView PowerPoint Presentation
Download Presentation
OMB Data Visualization Tool Requirements Analysis: QlikView

play fullscreen
1 / 22
Download Presentation
OMB Data Visualization Tool Requirements Analysis: QlikView
310 Views
Download Presentation

OMB Data Visualization Tool Requirements Analysis: QlikView

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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.