100 likes | 371 Views
Introducing COGNOS BI & HR Data Warehouse Pilot . Elora M. Paik, HR Systems Manager In conjunction with OIT Shellie Brattain, Sr. Software Engineer. Overview. Overview of COGNOS BI for Higher Ed (video).
E N D
Introducing COGNOS BI &HR Data Warehouse Pilot Elora M. Paik, HR Systems Manager In conjunction with OIT Shellie Brattain, Sr. Software Engineer OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
Overview • Overview of COGNOS BI for Higher Ed (video). • Discuss the advantages of using COGNOS to build the metadata for broader access to information. • Describe the OIT and HR pilot to model data • Demonstrate the HR Package in Query and Report Studio. OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
COGNOS for Higher Education OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
Metadata • Shark [noun]: dangerous • Shark: Sharks (superorder Selachimorpha) are a type of fish with a full cartilaginous skeleton and a streamlined body. They respire with the use of five to seven gill slits. Sharks have a covering of dermal denticles to protect their skin from damage and parasites and to improve fluid dynamics; they also have replaceable teeth.[1] Shark teeth are prized by collectors for their beauty, and because they are the only surviving relics of ancient sharks that are now extinct. Sharks range in size from the small pygmy shark, Euprotomicrus bispinatus, a deep sea species of only 22 centimetres (9 in) in length, to the whale shark, Rhincodon typus, the largest fish, which grows to a length of approximately 12 metres (39 ft) and which, like baleen whales, feeds only on plankton, squid, and small fish through filter feeding. The bull shark, Carcharhinus leucas, is the best known of several species to swim in both salt and fresh water and in deltas.[2] ~Wikipedia OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
What is COGNOS? • Business Intelligence & Performance Management Software • Metadata Modeling • Provides single version of the Truth • Taking right actions at the right time OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
Who is using COGNOS? & How? • University of Texas at Austin • Georgia Department of Education • University of Colorado • European Institutions • NACUBO • 1,300 institutions worldwide ~ Managing the Business of Education 10/2007 OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
How is UNLV using COGNOS? • Human Resources Pilot • Step 1: Modeling the data • Step 2: Testing the model to ensure accuracy • Step 3: Securing the data • Step 4: Pilot release OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
UNLV Human Resources • Data is grouped into recognizable subjects • Standardized calculations • Convenient filters • Drillable dimensions OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
Demonstration • Web-Based Environment • Security • Ad-Hoc Query • Sample Reports OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS
Where do we go from here? • Knowledge • Collaboration • Resources • Questions? OFFICE OF INFORMATION TECHNOLOGY UNIVERSITY OF NEVADA, LAS VEGAS