1 / 32

AIRPO – June 5, 2014

AIRPO – June 5, 2014. Dynamically Displaying Survey Results With Tableau Amy Guthrie Joseph Mantione Michael Randall University at Buffalo. UB Surveys- web presence. Main objectives of the project are: Response Results for major in-house surveys Interactive

maxine
Download Presentation

AIRPO – June 5, 2014

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. AIRPO – June 5, 2014 • Dynamically Displaying Survey Results With Tableau • Amy Guthrie • Joseph Mantione • Michael Randall • University at Buffalo

  2. UB Surveys- web presence • Main objectives of the project are: • Response Results for major in-house surveys • Interactive • Common formats (same Likert scales or other coding schemes when possible) • User friendly • Stimulate new questions from response info • Interactive search tool for finding topical area questions from various surveys

  3. Main Surveys to include

  4. Results: • Most of the main surveys from objectives are now in our web presence • Selected surveys were tabled for either low response n’s or sensitive info not appropriate for general public • Interactive search lookup is yet to be developed • Additional requests are starting to come in based on the info now on our web pages (e.g. more detailed questions or several time-frame comparisons).

  5. AIRPO – June 5, 2014 • Dynamically Displaying Survey Results With Tableau • Amy Guthrie • Joseph Mantione • Michael Randall • University at Buffalo

  6. Student Surveys on the web: http://www.buffalo.edu/provost/admin-units/apbe/reports-documents/institutional-analysis-briefs.html

  7. AIRPO – June 5, 2014 • Dynamically Displaying Survey Results With Tableau • Amy Guthrie • Joseph Mantione • Michael Randall • University at Buffalo

  8. What is Tableau ? Tableau is easy-to-use business intelligence software used for data analysis. Tableau natively connects to dozens of data sources, including Oracle and MS-SQL, as well as local sources like MS-Access and Excel. Once connected you use drag and drop tools to visualize and create interactive dashboards. Visualizations can be presented to your audience via PDF, Tableau Reader, Tableau Server or Tableau Public. For more information: http://www.buffalo.edu/provost/admin-units/apbe/reports-documents/tableau-analytics/Tableau-Resources.html

  9. UB’s Deployment Model • Free Trial of Publishing Software • On Demand Video Training • Developed a few concept pieces (Build confidence in your abilities) • Purchased Publishing Software • Converted legacy strategic reporting to Tableau (You know those reports, you know your numbers: it builds trust) • Integrate with Data Warehouse - Visualization can highlight bad data • Free Trial of Server Software installed on test virtual environment • Purchase Server Software • Developed institutional strategic reporting • Built multi-site environment for unit specific reporting

  10. Tableau Desktop – Data Connections • Connections to over 32 data sourcesand Drivers • Oracle, Microsoft SQL, MySQL, DB2 • Microsoft Access, Excel, PowerPivot and Text • Any ODBC Compliant data source • ActianVectorwise, Amazon Redshift, ClouderaHadoop, Cloudera Impala, DataStax, EMC Greenplum, Firebird, Google Analytics, Google BigQuery, Hortonworks, HP Vertica, BM DB2, IBM Netezza, MapR Distribution, Microsoft Access, Microsoft Excel 2003, Microsoft PowerPivot, Microsoft SQL Server, Microsoft SQL Server Analysis Services, Microsoft Windows Azure, MySQL, OData, Oracle, Oracle Hyperion Essbase, ParAccel Analytic Database, PostgreSQL, Progress OpenEdge, Salesforce.com, Force.com, Database.com, SAP HANA, SAP NetWeaver Business Warehouse, SAP Sybase, Teradata, Teradata Aster Data nCluster

  11. Tableau Desktop - Graphic Types • Graphic (over 90 types) • Area Chart • Bar Chart • Bubble Chart • Bullet Graph • Box Plot (w/ Whiskers) • Gantt Chart • Dot Plot • Histogram • Line/Area Chart • Maps (Geographical and Heat) • Pie • Scatter Plot • Text Table/Crosstab • Tree Map • Word Cloud

  12. Tableau Desktop – Distributing Reports • PDF • Tableau Reader • Camtasia – Video recording • Tableau Server • Tableau Public

  13. Tableau Server • Licensing and Costs • Building Dashboards • Using ArcGIS for converting Shapefiles and GeoCoding • Filtering data using Tables • Server – Multiple Sites – License Management

  14. Tableau Server

  15. Tableau Public

  16. Tableau Public

  17. Tableau Public

  18. AIRPO – June 5, 2014 • Dynamically Displaying Survey Results With Tableau • Amy Guthrie • Joseph Mantione • Michael Randall • University at Buffalo

  19. AIRPO – June 5, 2014 • Dynamically Displaying Survey Results With Tableau • How to download the Senior Exit Survey • http://www.buffalo.edu/provost/admin-units/apbe/reports-documents/institutional-analysis-briefs/undergraduate-senior-exit-survey.html • For more information • http://www.buffalo.edu/provost/admin-units/apbe/reports-documents/tableau-analytics/Tableau-Resources.html

  20. AIRPO – June 5, 2014 • Dynamically Displaying Survey Results With Tableau • Amy Guthrie • Joseph Mantione • Michael Randall • University at Buffalo

More Related