Deep behind the front lines of the Air Force, there is an unofficial mantra among the IT team in charge of the forces massive enterprise data warehouse and business intelligence initiative: Get the right information, at the right time, in the right place, for the right people.
Its been nearly four years since the birth of the AFKS (Air Force Knowledge Services) program, designed to consolidate and centralize data from the Air Forces nearly two dozen Combat Support divisions. Since its inception, the AFKS has integrated data from nearly 30 different legacy systems.
"There was lots of stovepipe data throughout the Air Force across finance, logistics, supplies and maintenance, and none of their systems talked to each other," said John Rusnak, chief architect of the AFKS, in Dayton, Ohio.
"At the end of the day, if a commander asked a question, say, for example, I want to know how many widgets we make, someone had to go to three or four different systems, put that into [Microsoft Corp.] Excel spreadsheets or into Access applications, and get that to a PowerPoint presentation. It used to take a commander between three to six weeks to get all the data pulled together."
That situation obviously wasnt going to fly with many Air Force brass—hence, the new AFKS program," he said.
"By using an enterprise warehouse for our data, we can pull it all together, integrate it, provide an authoritative source of data and use BI for end users to get the data," said Rusnak.
To help the thousands of Air Force systems users query, visualize and analyze all this data, the force is using BI tools from vendors Business Objects S.A., of San Jose, Calif., and Cognos Inc., of Ottawa.
The tools are used by employees across the force: from workers in a flight line, who can now monitor the inventory of parts or check on the status of ordered parts, to Air Force commanders, who can now quickly see which planes are mission-ready. If theyre not, commanders use a drag-and-drop tool to drill down and find out why they arent.
So far, of the Air Forces 22 Combat Support domains, the AFKS has pulled in data from domains including maintenance, supplies, finance, contracts and acquisitions and is currently working on integrating data from the civil engineering and training division.
"Weve pulled in data from six domains, not all of the data, but the data we do have we can provide a lot of different capabilities for end users, from a low-level flight manager to a four star," said Rusnak. "Were able to provide an easy-to-use tool set with a relatively authoritative view of data instead of a bunch of systems hamstrung together."