Analytics Powered by Tableau

naivenorthAI and Robotics

Nov 8, 2013 (3 years and 9 months ago)

110 views

Analytics Powered by Tableau

Rachel
Link / Joe Mantione

Office of Institutional Analysis

University at
Buffalo


Presentation and reference materials
available
at
http://apb.buffalo.edu/



What you will learn today:



What is Tableau?


What is Visual Analytics?


What problems would I solve with Tableau?


Why Tableau?


Seeing Tableau in action


Costs and Benefits


UB’s Deployment
model


Next steps


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
.


Examples:
Texas
A&M University
-

Student Retention and Graduation




New Jersey
-

SAT
Scores and Per Pupil Spending


What is Visual Analytics?



Visual
analytics is "the science of analytical reasoning facilitated
by visual interactive interfaces."
It
can attack certain problems
whose size, complexity, and need for closely coupled human and
machine analysis may make them otherwise
intractable.



The Process


Data
Clustering


Data
Correlation


Data
Classification


Anomaly
Detection





What is Visual Analytics?



The Process (put another way)


Make the data simpler


Find the relationships


Find
the weird
stuff (What Tableau does best)


Make
predictions



It’s no more complicated to understand than the weather forecast.




What is Visual Analytics?

Top
10 IT Issues for
2012


EDUCAUSE


1.
Updating
IT Professional
Skills

2.
IT
Consumerization, BYOD

3.
Cloud
Strategy

4.
Improving
Operational Efficiency

5.
Integrating
IT into Institutional decision
-
making

6.
* Using
analytics to support critical institutional outcomes

7.
Funding
IT

8.
Transforming
the institution's business with IT

9.
Supporting
the research mission through high
-
performance
computing, large data and analytics

10.
Governance
, Portfolio Management, Organization, Service Delivery
Models


Source: EDUCAUSE Top Ten Issues 2000
-

2013
InfoGraphic



What problem would I solve
with
Tableau?


Too
much operational data,
too
little strategic analytics
.


OBIEE (Oracle)
and
iStrategy (Blackboard)
power UB's
operational

reporting,
and while
we leverage their
data modeling capacity, they lack the ability to
easily

support the modern visualization efforts


necessary for today's
strategic

policy discussions.




This challenge is by no means unique to UB. Institutions throughout higher
education face the same problem every day


and it’s only getting
worse
!




What
problems
would I solve
with Tableau?


Data comes from ever increasing # of
internal
sources:



Service



Platform



Business
Intelligence

Oracle
Business
Intelligence Enterprise
Edition

Collaboration


SharePoint

Database
Management

Oracle
/ MS
-
SQL

Digital
Library


ContentDM
, dSpace

Document
Imaging


ImageNow

Geocoding


ArcGIS

Learning Management
System

BlackBoard

OnLine Analytical
Processing

Blackboard
iStrategy

Student
Systems


PeopleSoft

Web
Content
Management

Adobe
CQ5



What
problems
would I solve
with
Tableau?


Data is also coming from a growing list of
external

hosted systems with their
own set of challenges



Service




Vendor

Accreditation Management


Campuslabs
-

Compliance Assist

Benchmarking



Academic Analytics

Course Evaluations



ConnectEDU
-

Course Eval

Emergency Notification


Rave

Events Management



ComputerSOS
-

Special Events

Faculty Annual Reporting


Digital Measures


Activity Insight

Grants Management



COEUS

Recruitment Management


PeopleAdmin



Student Engagement


Campuslabs
-

CollegiateLink

Surveys




Campuslabs
-

Baseline




Why Tableau?

Gartner 2013:
Magic
Quadrant
for Business Intelligence and
Analytics
Platforms



It’s Cheap(
er
)

It’s Easy(
er
)

It’s Fun (almost)


Tableau in action







Live
demo
using data from
IPEDS


Graduate
Admissions


Scholarly Benchmarking


Transfer Analysis
2004
-
2012


Transfer Analysis Dashboards


Enrollment Reporting and Analysis



Costs
and
Benefits


Data Connections



Connections to over 32 data sources

and
Drivers


Oracle, Microsoft SQL, MySQL, DB2


Microsoft Access, Excel,
PowerPivot

and Text


Any ODBC Compliant data source



Actian

Vectorwise
, Amazon Redshift,
Cloudera

Hadoop
,
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






Costs
and
Benefits
-

Graphics



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

Costs
and
Benefits



Licensing and Costs


Building Dashboards


Using
ArcGIS for converting Shapefiles and GeoCoding


Filtering data using Tables


Server


Multiple Sites


License Management


Distributing reports



PDF,
Reader



Server,
iPad App
, Tableau Public



Camtasia


Video recording


UB’s Deployment Model



Free Trial of Publishing Software


On
Demand Video Training


Developed
a few concept pieces
(Build
confidence in
your abilities)


Purchase
Publishing Software


Convert
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


Next Steps




Strategic
reporting by
School


Additional
licensing for wider distribution


Departmental Profiles


Faculty Annual Report


Integration
with other data sources


Research


HR


Digital
Measures


Physical
Space Inventory


What did we forget to mention?


Rachel Link



Joe Mantione

Office of Institutional
Analysis

Office
of Institutional Analysis

University
at Buffalo


University
at Buffalo

rlink2@buffalo.edu


mantione@buffalo.edu

(
716)
645
-
2793



(
716) 645
-
3938


Presentation and reference materials available at
http://apb.buffalo.edu/

Use the following suggested text formatting to define different levels of text:

Main title (Georgia 30pt)

Subhead (Trebuchet 18pt)

Subhead (Georgia 18pt)

Body Text (Trebuchet 16pt)

The quick brown fox jumped over the lazy dog.

Body Text (Georgia 16pt)

The quick brown fox jumped over the lazy dog.



Bulleted Text (Trebuchet 16pt)

1.

Numbered Text (Trebuchet 16pt)