PLATFORMS: Foster Parents Plan utilizes legacy data from an IBM AS/400 with new information from a Microsoft Windows NT SQL Server data mart in a Microsoft BackOffice environment that is updated weekly. Cognos' PowerPlay is used for multidimensional analysis of recruiting, costs, sponsors, retention and other data; and Impromptu is used to extract data from the data mart for creating reports and for use with PowerPlay.

BACKGROUND: Foster Parents Plan of Canada is the leading Canadian child-focused development organization and works at a grassroots level in more than 40 developing countries to enable families to help themselves. Canadians, through Foster Parents Plan, sponsor almost 100,000 of the 1,000,000 children helped directly by Foster Parents Plan worldwide through initiatives such as shelter improvement, literacy, AIDS awareness and vaccinations. In 1996, we reviewed our goals and systems and decided to implement a data mart and deploy business intelligence tools from Cognos, ensuring a solid technology infrastructure for the future and delivering quick and easy access to information necessary for optimal use of our resources.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access