rmug 2014 presentation kent brooks from data to insight
DESCRIPTION
During an 18 month ERP upgrade Casper College began a journey to learn how to effectively deploy Business Intelligence. As we began to more fully understand the scope of our project as well as the enormity of this new and growing field we began asking how we could more effectively utilize business analytics for our entire data set. We will cover the types of tools, costs and how you can begin your journey to learn about this amazing field. We will also touch on the almost untouched topic of analtyical ethics. This session will help you move from being knowledge free to a tenderfoot in the expanding field of Business Intelligence in education.TRANSCRIPT
![Page 1: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/1.jpg)
1
RMUG 2014Laramie County Community College
BI/ Analytics Observations & Review: Getting from Data to Insight
Kent BrooksIT Director Casper College
May 22, 2014
![Page 2: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/2.jpg)
2
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
e
Turn off cell phones #rmug2014 @ellucian @kentbrooks
Housekeeping
![Page 3: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/3.jpg)
3
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eOverview
![Page 4: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/4.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
− From Data to Insight
4
![Page 5: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/5.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
“We don’t have enough data….the sample size is too small”
-Moneyball
5
![Page 6: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/6.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
The Data Challenge (Part 1) We have Web Intelligence but are
lacking the ability to create reports from our whole data set.
SAP( for example) = good daily reports but no ad hoc, no visualization no dashboards
6
![Page 7: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/7.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
The Data Challenge (Part 2) We are being asked to be wise
stewards of state resources about a field that is brand new
The skills we are being asked to learn to do this right are in addition to all the other things we must know
7
![Page 8: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/8.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Overcoming the Data Challenge TDWI BI Scorecard = http://
tinyurl.com/l6u76yl Higher Ed BI Conference = NKU
HEDW = http://www.hedw.org
8
![Page 9: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/9.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Observations for the BI Tenderfoot Getting a common set of definitions is
important
9
![Page 10: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/10.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Observations for the BI Tenderfoot
We are decent at collecting data but not at turning data into useful and timely information
10
![Page 11: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/11.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Observations for the BI Tenderfoot Not one tool does everything Even if you say you have a Data
Warehouse you can only say you're doing Business Intelligence if you have tools to change data into useful information.
11
![Page 12: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/12.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Observations for the BI Tenderfoot We need collect more data more
rapidly and turn it into information There is never enough resources
allocated to education The perfect is the enemy of the good People matter more than technology
12
![Page 13: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/13.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Observations for the BI Tenderfoot Premise options give more options and
capabilities for customization than cloud options
This is all brand new, you need a data scientist but they are not common….yet
The only KPI that matters is user adoption
13
![Page 14: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/14.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
After all of this…
14
Source: http://thedoghousediaries.com/
![Page 15: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/15.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Other Observations: 100% BI utilization should be goal Immediate need is still real-time Ad Hoc
Reporting and analysis Ethics in Analytics is virtually ignored Whatever you do should be Data Source
Agnostic
15
![Page 16: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/16.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
CROA for daily reporting combined with other tools for:
Data VisualizationCharts/ Graphs Mobile Analysis
is a very reasonable solution.
16
![Page 17: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/17.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
CROA for daily reporting combined with other tools for: Data Visualization Charts/ Graphs Mobile Analysis
17
![Page 18: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/18.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
Resources about our experience: Casper College BI Learning Center
− http://bit.ly/1qWFX5C
Other Tools in Our View
18
![Page 19: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/19.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
19
Resources from our experience:
earn More About CROA . (You must be logged in to the Ellucian Live portal to view the recordings.)
Institutional Reporting at Lake Tahoe Community College: A Case Studyhttps://ellucianlive.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=1861
Creating Snapshots in Colleague Reporting and Operating Analyticshttps://ellucianlive.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=1862
![Page 20: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/20.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
eThe Experience
20
Resources from our experience:
earn More About CROA . (You must be logged in to the Ellucian Live portal to view the recordings.)
Institutional Reporting at Lake Tahoe Community College: A Case Studyhttps://ellucianlive.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=1861
Creating Snapshots in Colleague Reporting and Operating Analyticshttps://ellucianlive.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=1862
![Page 21: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/21.jpg)
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
e Integrated Student Success Dashboard
Other Interesting Things:
![Page 22: RMUG 2014 Presentation Kent Brooks From Data to Insight](https://reader035.vdocuments.us/reader035/viewer/2022070316/555d1342d8b42ac4258b49d3/html5/thumbnails/22.jpg)
22
RM
UG
2014
Lara
mie
Cou
nty
Com
mu
nit
y C
olleg
e
Any Questions?
Kent Brooks
Twitter: @caspercollege
www.kentbrooks.com
Questions