Docstoc

Looking for Information on the Gap Inc. Business Strategy

Document Sample
Looking for Information on the Gap Inc. Business Strategy Powered By Docstoc
					          Using Business Intelligence Wisely

  Improve analysis and strategic business decisions within
            your student financial services office

Presenters:
Elizabeth Mendez, Broward Community College
Brett Perlman, SAS Institute, Inc.
               The Intelligence Gap
• Many Higher Education Institutions:
   – Cannot generate the intelligence they need.
   – Cannot generate intelligence fast enough to act on it.
   – Continue to incur huge costs due to uninformed
     decisions and misguided strategies.
• The opportunities afforded by a successful
  intelligence strategy have never been greater
Background on BCC:
 • BCC is the 2nd largest community college in Florida, 6th in
   the nation.
 • BCC has 3 main campuses and 3 major centers.
 • BCC headcount is approximately 65,000.
 • BCC runs a fully integrated database (homegrown) to
   support operational systems, which include Finance,
   Student, Human Resources and Payroll systems.
 • This database was developed through a collaborative
   partnership with SAG and is deployed in 8 institutions that
   collectively represent more than 50% of the community
   college FTE in the state of Florida
Symptoms:
• Tactical decisions are made every minute. Because of the
  speed at which these decisions must be made, some
  decisions are taken by the system with little or no human
  intervention.
• Strategic decisions require more information.
• BCC’s operating system is ill prepared to support strategic
  decision making. So was the culture of our staff.
• BCC did not have an alternative way of obtaining
  information designed specifically to provide support for
  decision making at the strategic level.
• An initiative to alleviate some of the demand for information
  began. The new president wanted “fact-based” decision
  making.
1st Attempt at supporting decision making:

 • A mirror image database was created, which was a copy of
   the operational database.
 • Crystal Reports was purchased to query against the mirror
   image database.
 • Power users were selected from the BCC community to
   receive technical training.
 • Users could build and view reports via Crystal Enterprises.
Reporting Obstacles:
-   Querying the database was extremely complicated. The
    database structure was complex.
-   Data experts would have to review the reports generated
    for accuracy & interpretation due to the complexity of the
    data.
-   Data integrity issues
-   Refreshing the data took too long, approximately 6 hours
    for less than ¼ of the operational database.
-   We were still only generating operational or transaction
    based reports and analyses.
Trends
Business Intelligence
• “The big trend in 2006 will be bringing BI
  to the masses and getting beyond the
  power users.”

• “The whole trend is not use of BI in
  executive offices, but BI capabilities that
  can be used by any executive line
  manager or employee.”
                                        » --Dan Vesset, Analyst, IDC
                                 »   (Computerworld, January 2, 2006)
Defining a BI Solution:

• Define what BI means to the institution
   – Supports continuous improvement and strategic
     planning
   – Support decision making at the College.
   – Support user needs
   – Information is easy to obtain/query and accessible via
     user-friendly tools.
   – The data speaks to the business.
   – Information is accurate and up-to-date.
Defining a BI solution:


  “Turn raw data into information, and
       information into knowledge”
                     Patti Barney, VP Information Technology
                                 Broward Community College
Defining the BI Solution:

 • Select the software:
    – Allows for the delivery of the data to the data
      warehouse to the user’s desktop.
    – Fast and stable, high performance and reliable.
    – One integrated product from a single vendor
    – Vendor solution that was fully customizable
    – A good price
Defining the BI Solution:
- BCC selected SAS® software to provide the extraction,
  transport, loading (ETL) and data presentation services.
  SAS® offers a data warehousing/Business Intelligence suite
  that provides the majority of tools required.
- SAS® partnership with education
- BCC has chosen 2 products from SAS® and is looking into a
  third.
         SAS® Enterprise Intelligence Platform
         SAS® Financial Intelligence
Building a BI Team:

• Selection of teams and team members
            » IT team
            » User teams
            » Virtual competency center
• Team understanding of the BI concept
• Accountability at various levels
• Allow the team time to absorb the concept
  and ask many questions.
BI teams at BCC:
• 3 teams were built representing the key user areas
  of the College (Student, Business, Academic)
      • Each team had a team leader well versed on the
        College operational system.
      • Each key area had functional users assigned
      • Each functional area had a data auditor assigned
      • Each functional user was expected to include
        additional focus groups as needed
                  Business Team

                             Lead




                                        Student
Campus                     Financial                Human
             Procurement                Business
Financials                 Operations              Resources
                                        Services
                      Student Team


                                   Lead




                                          Services
 Demo-     Course      Financial                       Tech   Gen
                                              &
graphics   Enrollmt       Aid                          Educ   Educ
                                          Activities
                 Academic Team


                            Lead




                                       Course     Books
             Instructor   Community
Scheduling                               &           &
             Resources    Developmt
                                      Programs   E-content
    Virtual Competency Center

• See handout
Further Defining BI Opportunities
• Each team/functional area tasked with the following:
   – Where can BI be applied in their organization?
   – Who will benefit?
   – What College strategic goals will the BI request support?
   – What question(s) need be answered.
   – Define measurements and dimensions
   – Reality check must take place to verify the data needed
     is available
   – Evaluate alternatives within and among teams
Business Intelligence Request
Requestor Name: April Townsend              Phone: 7418
Responsible Area: Student Business Services             Date: 9/23/05
Business Intelligence Team(s): Business
Focus group members:

Request supports which of the following strategic goals:
_ Student & learning centered                _ Public schools relationship
_ Ethnicity                                  _ Course delivery
X Success rates                              _ Instructional programming &
_ Workforce training                         resources
_ Entrepreneurial actions                    _ Communication

Question?: Collections: How can we monitor trends and areas for improvement in the collection
process?

Measurement(s):
1. How many students are sent to collections compared to the student population?
2. What types of debts are being sent to collections and when (looking for a pattern)?
3. How many students who are sent to collections satisfy their debt? In full or part.
      a. What is the debt?
      b. Does the student return to BCC?
4. How many students sent to collections are financial aid students, 3rd party coverage, cash paying?
5. How often does financial aid pay off a collection debt?
6. How many in collection debts are written off?
Business Intelligence Request
Requestor Name: April Townsend                                        Phone: 7418
Responsible Area: Student Business Services                           Date: 9/22/05
Business Intelligence Team(s): Business
Focus group members:

Request supports which of the following strategic goals:
X Student & learning centered                       _ Public schools relationship
_ Ethnicity                                         _ Course delivery
_ Success rates                                     _ Instructional programming &
_ Workforce training                                resources
_ Entrepreneurial actions                           _ Communication

Question? Cashiering: How can we monitor trends in payment methods and assess customer service needs?

Measurement(s):
1. Track the trend of student payment methods (cash, check, credit) by location, by term, by cashier (by headct, by $ amt).
2. Track customer (non-student) payments by payment type, by location, by term, by cashier (by headct, by $ amount).
3. Track the total number of students served by a cashier by campus, by term (by head count, by dollar amount).
4. Monitor voided and cancelled receipts by cashier, by location, and by payment type.
5. Monitor payments processed for an employee, student, vendor, individual on all receipt types.
6. Monitor insurance payments by year, by date, by payee, by glc.
7. Extract deposits made into specific CCN/GLC’s.
8. Report for specific periods that link overages/ shortages to specific cashier sessions, campus, dollar amounts.
Business Intelligence Request
Requestor Name: April Townsend                                       Phone: 7418
Responsible Area: Student Business Services                          Date: 9/22/05
Business Intelligence Team(s): Business
Focus group members:

Request supports which of the following strategic goals:
X Student & learning centered                       _ Public schools relationship
_ Ethnicity                                         _ Course delivery
_ Success rates                                     _ Instructional programming &
_ Workforce training                                resources
_ Entrepreneurial actions                           _ Communication

Question?: Financial Aid: How can we monitor trends and the impact financial aid awards and disbursements have on
students and business practices?

Measurement(s):
1. Financial aid disbursement summary and detail. Total amount of financial aid accepted and disbursed by academic
year, term, fund, student. Compare current year to prior years.
2. Analyze what debt was paid by the financial aid money disbursed. Student schedule, books, receivables, obligations,
net payable to the student. By academic year, term (prior, current, future), fund, student.
3. Analyze the volume of students that have outstanding debt prior to and after disbursement.
4. Analyze Financial aid awarded and disbursed by category (federal, state, foundation etc).
   SAS® Solution and Definitions proposal:

• Business process information gathering
  meetings
• Understanding of systems involved
• Understanding of business objectives
• High level customer deliverables
SAS® requirements definition
System Design:
  Data source           Data models
  Data extraction       Reporting
  Data refresh cycle    KPI’s
  Data dimensions       Portals
  Data hierarchies      Security
  Data preparation
SAS® requirements definition (con’t)

-   Project resources
-   Training recommendations
-   Project risks
-   Critical success factors
-   Project schedule
Use of data via SAS® Enterprise

            Software demo
So what?
       Top 5 Business Intelligence Trends
•   Predictive analytics are being embedded in many BI applications,
    creating clearer views of opportunities and trends.
•   Dashboards and scorecards are proliferating through the enterprise,
    offering interactive drill-down capabilities.
•   New integration technology is feeding real-time data into BI applications,
    enabling real-time decision-making.
•   BI front ends are working their way lower in organizations’ hierarchies,
    fueling changes in business processes.
•   Staffing needs are shifting, as more staff with analytical, statistical, and
    business domain experience are required.
                                                   » Source: InfoWorld (August 22, 2005)

				
DOCUMENT INFO
Description: Looking for Information on the Gap Inc. Business Strategy document sample