BUSINESS


Customer perspective: Protecting the prairies with performance management

August 29, 2007

Saskatchewan Environment helps protect the province’s air, water and land from contamination, provides provincial forest fire suppression services and operates 34 provincial parks, 150 recreation sites, 22 protected areas, eight historic sites, and three ecological reserves.

To help manage this broad mandate, Saskatchewan Environment employs 1,300 people at over 52 field locations.

Virtual Archive Now Available

Executive oversight of such a geographically dispersed organization with such a broad mandate proved challenging.

Initial efforts for improvement involved development of a paper-based reporting system, which, while a step forward, was labor intensive and slow.

Saskatchewan Environment manages, develops, and protects more than 37 million hectares (94 million acres) of Crown resource lands, including 35.5 (88 million acres) million hectares of provincial forest.

Saskatchewan Environment chose to implement Cognos 8 Business Intelligence to provide a more efficient means of executive oversight and to help streamline reporting.

The challenge: improve efficiency

“We needed a solution that could produce reports rapidly,” explains Sarah Gammell, Strategic Planning and Corporate Assessment at Saskatchewan Environment.

“Our paper-based system was inefficient, so we were looking for a way to improve it.”

Prior to Cognos, all reporting was done through a word processing program.

Producing the organization’s seven yearly reports, specifically the quarterly reports, was labor intensive and required a great deal of interaction between Strategic Planning and Corporate Assessment and the other areas of the department.

Saskatchewan Environment

  • Industry: Government
  • Geography: Canada
  • Information needs: Web-based platform; Scalable; Self-service capabilities; Sorting capabilities; Ease-of-use and flexibility; Robust communication features
  • Platforms: Windows Terminal Server; Microsoft SQL Server
  • Solutions: Cognos 8 BI
  • Benefits: Improved communication within the organization; Enhanced executive oversight and governance over projects; Faster reporting process and the ability to address ad-hoc requests; Ability to sort data for multiple views of progress

Strategic Planning and Corporate Assessment would first request data from the 14 branches, compile each branch’s information into one document, and then send it back out to the branches for editing.

Equally important, Saskatchewan Environment is often approached by other agencies for updates on projects they are involved in.

These ad-hoc requests were creating a strain on the Strategic Planning and Corporate Assessment unit and the department.

The strategy: easy-to-use, Web-based, self-service reporting

Saskatchewan Environment sent out a request-for-proposal to evaluate BI vendors.

The agency wanted a scalable, flexible, easy-to-use Web-based offering that provided sorting and self-service capabilities. The agency also needed a solution with robust communication features.

After evaluating the submissions, the agency chose to implement Cognos 8 BI because it met the organization’s technical requirements and offered a timely deployment schedule. The organization entered the Cognos 8 BI beta program and was the first organization to go live with the product in North America.

“Cognos had everything we were looking for in a BI solution.

Strong communication features

“In addition to being easy to use, Cognos had the strong communication features that would help us improve access to information for staff across the department and gain a better understanding of how the organization was performing in terms of implementing our key projects,” states Rick Bates, Director of Strategic Planning and Corporate Assessment, Saskatchewan Environment.

Saskatchewan Environment went live with its Cognos solution in January 2006 and was able to roll out Cognos 8 BI to its department of 1,300 users ahead of schedule.

To help them get the most from their new solution, Saskatchewan Environment leveraged services from Cognos Consulting, Training, and Support.

The organization partnered with Cognos Consulting to determine the best way to convert its data from its old system. Cognos Consulting also conducted on-site training with 30 managers to get them up to speed quickly.

The organization partnered with Cognos Consulting to determine the best way to convert its data from its old system. Cognos Consulting also conducted on-site training with 30 managers to get them up to speed quickly.

“Cognos consulting was amazing,” praises Gammell.

“They spent the time to really learn our business and directly applied this information when mentoring our team. We learned quite a bit.”

Taking advantage of training

Saskatchewan Environment took advantage of five classes offered by Cognos Training to gain in-depth knowledge on topics such as metadata repositories, reporting, and scorecarding.

Saskatchewan Environment also relied on Cognos Support to help troubleshoot issues the organization experienced while updating its system.

“Cognos support has been great. They are very responsive and helped us resolve issues quickly,” notes Gammell.

Moving forward, Saskatchewan Environment plans to develop an executive dashboard and better integrate its measures and overall performance management system.

The benefits: improved oversight & communication

“There is a good appreciation for Cognos, with everyone benefiting from the improved oversight of department activities by our executive and improved communication on our plan between executive and staff,” explains Bates.

Leveraging Cognos, Saskatchewan Environment has been able to improve executive oversight and background information.

“There is a good appreciation for Cognos, with everyone benefiting from the improved oversight [...] by our executives and improved communication [...] between executives and staff.”

Executives are able to easily monitor project implementation and view metrics on a broad range of activities, which they were not able to do previously.

Saskatchewan Environment executives can quickly grasp a project’s status relative to objectives using the easy-to read graphic displays in Cognos 8 BI.

“With Cognos, we have improved executive oversight,” states Bates. “Now executives have a clear picture of the organization’s progress towards objectives on key projects.

“At a glance, they are able to view the status of key projects, and from there, determine next steps for projects that are off-track.”

More timely information

With Cognos, Saskatchewan Environment has been able to improve its reporting process and provide users with data that is more accurate, timely, and accessible.

With the self-service capabilities within Cognos, users are now able to enter information directly from the source, eliminating Strategic Planning and Corporate Assessment’s involvement in the process and saving the organization a significant amount of time.

“Cognos has saved us at least a couple of weeks per report,” says Gammell. “We are also able to produce ad-hoc reports very quickly.”

Another benefit Saskatchewan Environment has realized has been its ability to monitor initiatives by organizational structure as well as by goal or objective.

Another benefit Saskatchewan Environment has realized has been its ability to monitor initiatives by organizational structure as well as by goal or objective.

Immediate insight

Using the sorting feature, the organization can now gain immediate insight into a project’s progress and see how metrics in different branches relate to one another.

Prior to Cognos, Saskatchewan Environment had to manually scroll through results to find keywords, a time-consuming and frustrating process.

“With Cognos, results can be filtered by project, showing all metrics related to that plan and providing different views of the organization,” notes Gammell.

Gammell sums up the organization’s enthusiasm for Cognos. “We are happy with our Cognos solution and look forward to continuing to expand its functionality.”  


Find Out More



Numbers You Need

2,719

Average daily takeoffs and landings at Chicago O'Hare International Airport.

-Source: World in Figures, The Economist, 2006


More green facts

Decision Spotlight

Dan Gardner"Our only defence is to make a habit of questioning our judgments, no matter how plausible they feel."

International Editions

Other versions:

Email StoryEmail   Print StoryPrint   Digg This!