BUDGET AND FINANCIAL REPORTING FOR THE ENTERPRISE

Transcript:BUDGET AND FINANCIAL REPORTING FOR THE ENTERPRISE:
BUDGET AND FINANCIAL REPORTING FOR THE ENTERPRISE PRESENTED BY KENNETH BRIDGES & DAWN GAMADANIS KENNESAW STATE UNIVERSITY Agenda Session 1 – Learn about SAS® KSU Financial Data Mart (FDM) Discussion/Questions Break Session 2 – Budget Development and Position Management Discussion/Questions Break Session 3 – Comprehensive Financial Reports and Analytics Discussion/Questions Contact Us University Facts 24,600 Students $347m Budget with over 600 department accounts 2,200+ employees Five Major Divisions Eight Academic Colleges Purpose and Objectives STATEMENT OF PURPOSE Business intelligence is about effectively managing critical data assets and its transformation into information in such a way that drives strategic planning, executive decision-making, and management reporting throughout your organization. Thus, data drives our need to be well-informed. The statement of purpose is about pursuing continuous improvement to be well-informed, to provide self-servicing of information on the desktop, and positively effect decision support at all levels of the organization. CASE STUDIES Grants Post-Award office spent routinely up to two weeks, sometime longer, to data enter and reconcile grants in QuickBooks and compile reports to send to Principal Investigators. Business Managers ran multiple PeopleSoft reports and queries daily, data enter into QuickBooks, to reconcile accounts and summarize information into reports for Deans and Chairs. Budget and Planning Office spent most of time in data entry mode for Budget Prep instead of analyzing the data; lacked ability to track position funding changes during the year and unable to provide personal service changes to department managers. FACTOID With over 600 local public queries plus hundreds of private ones to choose from or model from more than 300+ BOR delivered queries, pulling data from PeopleSoft can be somewhat challenging for most users to navigate which on occasion results in…well, you know KEY OBJECTIVES Establish a robust, scalable, and practical alternative to meeting KSU’s institutional demands for enterprise intelligence and analytics Provide easy access to financial information and analytics for decision support, strategic initiatives, and executive management reporting Provide self-service functionality for users to build, customize, and share reports with common data dictionary, dimensions, and measures through a secure portal Focus on Customer Needs LISTEN TO OUR CUSTOMERS CUSTOMER-FOCUSED OBJECTIVES KSU COMMON CHALLENGES ERPs lack robust reporting tools and analytics Queries are hard to learn and very often require exporting to Excel for further aggregation and analyses Shadows systems proliferate as a means to track and reconcile accounts for business managers and grants post-award office Information not easily