250 likes | 391 Views
Web-Based Business Intelligence at LSU. Presented By Mark Kraner and Michael Dun. April 14, 2005. Objectives. Present opportunity for program enhancement Provide Framework for thought Results Improved Marketing Opportunities System Security enhancement. LSU System. 10 Campuses
E N D
Web-Based Business Intelligence at LSU Presented By Mark Kraner and Michael Dun April 14, 2005
Objectives • Present opportunity for program enhancement • Provide Framework for thought • Results • Improved Marketing Opportunities • System Security enhancement
LSU System • 10 Campuses • Baton Rouge • LSU A&M • LSU Ag Center • Hebert Law Center • Pennington Biomedical Center
Participating Campuses • LSU – Eunice • LSU Health Sciences Center – New Orleans
Campus Partners • LSU Health Science Center- New Orleans • Printing in Computer Labs • Food Service – Sodexho • Vending- Imperial Vending • Bookstore – Self-op
Campus Partners • LSU – Eunice • Printing in Computer Lab • Copiers • Vending • Dining Services – new contractor • Bookstore self - op
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?
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?
3 Goals • Provide Better Data for customers • Demographics • Male/Female • Class • On/Off Campus
3 Goals 2. Create Data Warehouse Use Extract- Sql Off site back up Security
3 Goals 3. Make it easy to access data • No one is in “live data” • Interface is “customer friendly” • Password protected
3 Goals • Limited data access determined by administrator (Users, Roles, Merchants)
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
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)?
Dining Services • What do your sales to off campus students look like? • Again, what are the demographics?
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?