Web-Based Business Intelligence at LSU

1
Web-Based Business Intelligence at LSU

• Presented By Mark Kraner and Michael Dun

April 14, 2005
2
Objectives

• Present opportunity for program enhancement
• Provide Framework for thought
• Results
• Improved Marketing Opportunities
• System Security enhancement

3
LSU System

• 10 Campuses
• Baton Rouge
• LSU AM
• LSU Ag Center
• Hebert Law Center
• Pennington Biomedical Center

4
Participating Campuses

• LSU Eunice
• LSU Health Sciences Center New Orleans

5
Campus Partners

• LSU Health Science Center- New Orleans
• Printing in Computer Labs
• Food Service Sodexho
• Vending- Imperial Vending
• Bookstore Self-op

6
Campus Partners

• LSU Eunice
• Printing in Computer Lab
• Copiers
• Vending
• Dining Services new contractor
• Bookstore self - op

7

• You may not be as varied as our system
• BUT.
• Think about who has access to your system
• Do you know where they store the password?

8
Questions to ponder

• Does your staff spend time generating reports for
  customers?
• Does your staff generate data for customers?
• Do customers run reports that drag the system
  performance?
• Do you have an off-site data backup?

9
3 Goals

• Provide Better Data for customers
• Demographics
• Male/Female
• Class
• On/Off Campus

10
3 Goals

• 2. Create Data Warehouse
• Use Extract- Sql
• Off site back up
• Security

11
3 Goals

• 3. Make it easy to access data
• No one is in live data
• Interface is customer friendly
• Password protected

12
3 Goals

• Limited data access determined by administrator
  (Users, Roles, Merchants)

13

• Merchants can be limited to any combination of
  locations

14
Simple menus
15
Reports are easy to configure
16
Solutions

• Work with Bb Consulting Services
• Michael Dun
• Extract Utility set up and automation
• Database configuration and extension
• Custom report requirements development
• Brent Ryan
• Web development, J2EE application
• User, Merchant roles and authentication

17
What does the program do?

• An Example
• Rec Center
• Who is the customer?
• Male/Female
• Class
• On or Off Campus
• Other Ideas
• When do they use the Center?
• What are your peak usage times (staffing)?

18
Rec Center Demographics
19
Drill down provides more visibility
20
How much detail do you want?
21
Dining Services

• What do your sales to off campus students look
  like?
• Again, what are the demographics?

22
Drill down by Reader and Tender
23
Or by Tender and UDF info
24
Card Office

• What do your deposits look like?
• Where are you spending money on marketing?
• Which partners do you have on the program?
• How do you help them?

25
How do you want it??