Business Intelligence Advisory Committee June 12, 2018 Agenda - - PowerPoint PPT Presentation

▶
business intelligence advisory committee
SMART_READER_LITE
LIVE PREVIEW

Business Intelligence Advisory Committee June 12, 2018 Agenda - - PowerPoint PPT Presentation

Nov 07, 2023 279 likes •639 views

Business Intelligence Advisory Committee June 12, 2018 Agenda Introductions Andrea Pluckebaum S AP Transformation Aaron Walz BI S trategic Priorities Update - Aaron Walz HotS eat - BI-S PC S ub-Committees Feedback -

slide-1
SLIDE 1

June 12, 2018

Business Intelligence Advisory Committee

slide-2
SLIDE 2

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

2

Agenda

  • Introductions –Andrea Pluckebaum
  • S

AP Transformation –Aaron Walz

  • BI S

trategic Priorities Update - Aaron Walz

  • HotS

eat - BI-S PC S ub-Committees Feedback - Paula Kayser

  • Data Cookbook & Official S

eal Updates – S arah Bauer

  • Update on Top Priorities for the CDO – Diane Beaudoin
  • New BICC website - Kelsie Newberry
  • Cognos New Features Q&A – Ryan Bousman
slide-3
SLIDE 3

BUS

INES S

INTELLIGENCE COMPETENCY CENTER

Business Intelligence Strategic Priorities Committee

Update for BI-AC: June 2018

slide-4
SLIDE 4

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

4

Membership

NAME TITLE AREA Diane Beaudoin

Chief Data Officer OIRAE

Jeff Bolin

Associate Vice President for Research Centers, Cores, and Research Development S ervices EVPRP

Thomas Frooninckx

Managing Director, Purdue Polytechnic Institute Purdue Polytechnic Institute

Cherise Hall

Assistant Provost for Finance and Administration Office of the Provost

Eva Nodine

Director for Financial Planning and Analysis Financial Planning and Analysis

Andrea Pluckebaum

Director of Data Analytics and Program Assessment Krannert S chool of Management

David Robledo

Director of Data Analytics and Information College of Engineering

Aaron Walz

Director, Business Intelligence Competency Center BI Competency Center

Kris Wong Davis

Vice Provost for Enrollment Management Enrollment Management

Tonya Yoder

Assistant Director/ S enior Analyst of Financial Planning and Analysis Financial Planning and Analysis

slide-5
SLIDE 5

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

BI Strategy Framework

What does a BI S t rat egy look like?

5

slide-6
SLIDE 6

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

6

BI Strategy Framework

Concrete Avoid technical j argon Understandable and easy to communicate Focused on institutional obj ectives, not technology for its

  • wn sake

Guides which initiatives and proj ects we should undertake,

and which we should defer or deny

S

parks ideas for initiatives and proj ects that may not already be on the list

  • Is practically perfect in every way
slide-7
SLIDE 7

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

7

E nterprise Information Supply Chain

Enterpris e S ystems Data Warehous e BI Tools Information Consumers Data Professionals Technology Reports and Dashboards Analysis and Answers Questions

slide-8
SLIDE 8

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

8

Info Supply Chain: Possible Challenges

Enterpris e S ystems Data Warehous e BI Tools Information Consumers Data Professionals Technology Reports and Dashboards Analysis and Answers Questions

Is t here an level of accept able dat a quality in t he source? Is t he dat a we need available in t he Warehouse? Is t he dat a we need being capt ured in an ent erprise syst em? Do our dat a professionals have t he ent erprise BI t ools t hey need? Do our dat a professionals have t he skills and expert ise t hey need t o produce information and answer quest ions? Do our information consumes have t he skills and expert ise t hey need t o ask good quest ion and int erpret answers? Do our information consumers have t he self-service answers t hey need (e.g. report and dashboards), wit h an accept able level of dat a qualit y and consist ency?

slide-9
SLIDE 9

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

9

BI Strategy Framework

  • Which data topics are

we going to focus on?

  • Which parts of the

supply chain are we going to strengthen?

slide-10
SLIDE 10

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

10

Where are we currently headed?

Enterpris e S ystems Data Warehous e BI Tools Information Consumers Data Professionals Technology Reports and Dashboards Analysis and Answers Questions

Is t here an level of accept able dat a quality in t he source? Is t he dat a we need available in t he Warehouse? Is t he dat a we need being capt ured in an ent erprise syst em? Do our dat a professionals have t he ent erprise BI t ools t hey need? Do our dat a professionals have t he skills and expert ise t hey need t o produce information and answer quest ions? Do our information consumes have t he skills and expert ise t hey need t o ask good quest ion and int erpret answers? Do our information consumers have t he self-service answers t hey need (e.g. report and dashboards), wit h an accept able level of dat a qualit y and consist ency?

Get the data into Warehouse Improve data validation Mature dashboard design and development Provide self-service data for unit leaders Build more Management Dashboards

slide-11
SLIDE 11

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

11

What are our peers focused on?

Enterpris e S ystems Data Warehous e BI Tools Information Consumers Data Professionals Technology Reports and Dashboards Analysis and Answers Questions

Is t here an level of accept able dat a quality in t he source? Is t he dat a we need available in t he Warehouse? Is t he dat a we need being capt ured in an ent erprise syst em? Do our dat a professionals have t he ent erprise BI t ools t hey need? Do our dat a professionals have t he skills and expert ise t hey need t o produce information and answer quest ions? Do our information consumes have t he skills and expert ise t hey need t o ask good quest ion and int erpret answers? Do our information consumers have t he self-service answers t hey need (e.g. report and dashboards), wit h an accept able level of dat a qualit y and consist ency?

New Data Warehouse technologies Data Governance Self-service BI tools Student Success Advanced Analytics Cloud

slide-12
SLIDE 12

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

12

New Cognos functionality

Enterpris e S ystems Data Warehous e BI Tools Information Consumers Data Professionals Technology Reports and Dashboards Analysis and Answers Questions

Is t here an level of accept able dat a quality in t he source? Is t he dat a we need available in t he Warehouse? Is t he dat a we need being capt ured in an ent erprise syst em? Do our dat a professionals have t he ent erprise BI t ools t hey need? Do our dat a professionals have t he skills and expert ise t hey need t o produce information and answer quest ions? Do our information consumes have t he skills and expert ise t hey need t o ask good quest ion and int erpret answers? Do our information consumers have t he self-service answers t hey need (e.g. report and dashboards), wit h an accept able level of dat a qualit y and consist ency?

Data Sets Uploaded Files & Data Modules Dashboards Stories

slide-13
SLIDE 13

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

13

What are today’s institutional priorities?

slide-14
SLIDE 14

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

14

What are today’s institutional priorities?

  • Financial dashboards/ reporting for unit leaders
  • Enrollment trends and predictors, modeling, course

availability

  • Data quality*
  • S

tudent success

  • S

upporting our data professionals and staff*

*sub-committee already formed

slide-15
SLIDE 15

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

15

Info Supply Chain: Possible Challenges

Enterpris e S ystems Data Warehous e BI Tools Information Consumers Data Professionals Technology Reports and Dashboards Analysis and Answers Questions

Is t here an level of accept able dat a quality in t he source? Is t he dat a we need available in t he Warehouse? Is t he dat a we need being capt ured in an ent erprise syst em? Do our dat a professionals have t he ent erprise BI t ools t hey need? Do our dat a professionals have t he skills and expert ise t hey need t o produce information and answer quest ions? Do our information consumes have t he skills and expert ise t hey need t o ask good quest ion and int erpret answers? Do our information consumers have t he self-service answers t hey need (e.g. report and dashboards), wit h an accept able level of dat a qualit y and consist ency?

slide-16
SLIDE 16

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

16

BI Strategy part 2: What needs to be done

slide-17
SLIDE 17

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

17

BI Strategy part 2: What needs to be done

slide-18
SLIDE 18

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

18

BI Strategy part 2: What needs to be done

slide-19
SLIDE 19

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

19

BI Strategy part 2: What needs to be done

slide-20
SLIDE 20

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

20

BI Strategy part 2: What needs to be done

slide-21
SLIDE 21

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

21

Next Steps

  • Review and consolidate the items identified for each area to

determine where we should focus

  • Consider what we have the capacity to take on
  • Identify new proj ects and initiatives where needed
  • Establish priorities
slide-22
SLIDE 22

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

22

HOTSE AT - BI-SPC Sub-Committees Feedback

From a computer or your phone:

  • https:/ / www.openhotseat.org/ Login
  • Login in with your Purdue career account
  • Click on the Public S

paces Icon

  • S

croll down to ********BI Advisory Committee – June 12, 2018*********

  • Click on “ BI-S

PC S ubcommittee on Data Quality” to begin

slide-23
SLIDE 23

Data Governance Update

Office of Inst it ut ional Research, Assessment & Effectiveness

BI-Advisory June 2018

slide-24
SLIDE 24

We are a data community. We ALL do ‘data governance.’

  • Data an institutional asset
  • Quality data for decision-making
  • Clear definitions and report/ dashboard specs
  • Documentation of reporting business logic (move toward

common understanding across the community)

  • Effective use of this university asset

http://www.purdue.edu/oirae/DataGovernance.html

slide-25
SLIDE 25
slide-26
SLIDE 26

Official S eal - Data Certification Task Force

slide-27
SLIDE 27

Official S eal – Certified Data

  • Task Force
  • Data will be vetted, reproducible, clearly defined
  • Definitions and reports/ dashboards documented in Data

Cookbook

  • Reports have been identified by upper executives
  • Admissions, S

t udent , Finance, Capit al, HR, Research

  • Process and Education subcommittees
  • First reports:
  • Enrollment
  • Retention and Graduation Rates
  • Next reports are:
  • Admissions
  • Degrees Awarded
  • Time-to-Degree
slide-28
SLIDE 28

Official S eal – Data Quality

  • First reports – Enrollment and Retention/ Graduation Rate
  • Call went out for Dat a Qualit y Issues
  • Collect ed from dat a managers, cent ral offices, known issues
  • S

ame process for Admissions, Degrees and Time-t o-Degree (due June 15)

  • If ot hers want t o submit dat a qualit y it ems, a running list of t he report s being

worked on is locat ed on t he Dat a Governance websit e: ht t ps:/ / www.purdue.edu/ oirae/ Dat aGovernance.ht ml

slide-29
SLIDE 29

Data Cookbook

Data Cookbook software

  • Part of the bigger Data Governance effort
  • Enterprise source of data definitions, standard reports and dashboards
  • S
  • urce of official certified data definitions and reports/ dashboards

In Progress

  • Upgrade including enhanced report / dashboard documentation functionality
  • Evaluating additional functionality for a future release
  • New definitions, report/ dashboards, subj ect areas being added

Value of Data Cookbook

  • Enterprise repository of institutional (tribal) knowledge
  • Anyone with a Purdue career account can use, add comments
  • Great resource for new and current staff

Create an Account (Purdue career account)

https:/ / purdue.datacookbook.com Or Google ‘ Purdue Data Cookbook’

slide-30
SLIDE 30

Functional Data Owners

  • Admissions – S

teve Lipps

  • Alumni/ UDO – Greg Kapp
  • Finance –Transformation Team
  • Financial Aid – Joel Wenger
  • Human Resources –Transformation Team
  • Instructional Activity – Monal Patel
  • Physical Facilities –Transformation Team
  • Research – S

tephanie Willis

  • S

pace – Kim Rechkemmer

  • S

tudent – Kylie Edmond, S teve Lipps

  • S

tudent Life – Kevin Maurer

slide-31
SLIDE 31

Data Cookbook by the Numbers

slide-32
SLIDE 32

Data Governance / Data Cookbook

https://www.purdue.edu/oirae/DataGovernance.html

Create a Data Cookbook account: ht t ps:/ / purdue.dat acookbook.com Also available under OneCampus Or Google ‘ Purdue Dat a Cookbook’

Feedback or questions: datagovernance@ purdue.edu sarah@ purdue.edu

slide-33
SLIDE 33

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

New BICC Website

33

  • www.purdue.edu/ bicc
  • Mostly same content, j ust redesigned
  • S

treamlined layout

  • More intuitive
  • Email bicc@

purdue.edu if need assistance with finding former favorites or if have questions

slide-34
SLIDE 34

Common View – Deep Understanding – Better Decisions

purdue.edu/BICC

Questions?

34