|
1
|
|
|
2
|
- CPM Management Studio is a comprehensive Workforce Management Reporting
Solution. In an age where timely
and accurate Workforce Analytics has never been more important, CPM
Management Studio has set about meeting that challenge.
- CPM Management Studio is the natural evolution of Human Resource
Information Technologists (HRIT) original Management Reporting Solution,
EIS Reporter Central, which has been in use by a number of New Zealand’s
leading organisations:-
- Fisher & Paykel Appliances Limited
- Fisher & Paykel Healthcare Limited
- Fletcher Building Holdings Limited
- Fletcher Construction Limited
- Goodman Fielder New Zealand Limited
- Tauranga City Council
- Westpac
- The challenge was to take the complex reporting and trending needs of
these, and many other clients, and be able to deliver them to all levels
of management in a simple and easy to interpret format.
- With CPM Management Studio, this has been achieved.
|
|
3
|
- CPM Management Studio, being a reporting framework, is capable of
delivering a wide range of key Workforce Metrics, Analyses and
Trends. The focus of the Metrics
are on the core operational aspects an organisation’s workforce such as
-
- Staff Attrition
- Labour Cost
- Absenteeism
- Workforce Hours Analysis
- Leave Liability
- Staff Demographics
- Workforce Modeling
- The framework provides for many views and methods of analysing the
Metric information.
- Using Staff Attrition as an example, the framework provides for the
reporting of the %age of Leavers for a specified Month or for a rolling
12 Month period. In addition it can trend these %age’s over several
years. As well as the %age
turnover, the Metric Models also provide the Average Service of the
Leavers, the Average Service of all Staff and the Nett Movement.
- The Attrition Metrics can be summarised by Organisational Layers,
Gender, Salary Bands, Age Bands, Employment method, Region, City, etc..
|
|
4
|
- CPM Management Studio is a sophisticated Web Based Workforce Metric
Reporting System built on the latest Microsoft Web Technologies.
- At the heart of the system is a Data Warehouse. A key component of CPM Management
Studio is it’s Data Warehouse Engine which can dynamically import
information from any range of systems in varying formats.
- The Import Studio manages the importing of information from any number
of external systems. The source
information can be in any manner of formats, direct connection to a SQL
Database, Excel Spreadsheets or flat files.
- The Database Studio manages the configuration and storage of all the
Master Data imported by the Import Studio. The Master Data is available for
Reporting without needing to be transformed into Metric Data.
- The Metric Studio manages the definition and creation of the Workforce
Metrics. Metrics can be created
for any number of periods, Weekly, Monthly, Year-to-date or Rolling 12
Month.
|
|
5
|
- From the Metric Studio and the Database Studio, the Report Studio manages
the on-line viewing and analysis of the information. The Report Studio is built around a
library of Report and Chart definitions.
From this library, any number of specified Workforce Reports and
Charts can be established and deployed.
- Integral to the deployment the Metric Reporting is the Security Studio.
The Security Studio controls the access to the array of Metric Reporting
Models available and the information to be presented.
- Each user is setup in the system and associated with both an Entity
Profile and a Menu Profile. The Entity profile determines what areas of
the organisation can viewed and level of Staff(Managerial, Salaried,
Waged, etc).
- The Menu Profile defines what Menu Options are available and what
Reports/Models can be viewed.
|
|
6
|
- The CPM Management Studio has been built on Microsoft’s latest Web
Technologies.
- The system uses SQLServer2005 for it’s Data Warehouse.
- The Web Application has been developed for ASP.Net2 using Microsoft’s
Visual Studio 2005.
- Reporting is delivered using Microsoft’s Reporting Services for
SQLServer2005.
- The technologies used should fit comfortably in any organisations IT
infrastructure.
- Whilst the User Interface has been developed in ASP.Net2, almost all of
the core business logic sits within the Data Warehouse.
- System Requirements :-
- Microsoft Server 2003 or greater
- ASP.Net2 or greater
- SQL Server 2005 or greater
- SQL Server 2005 Reporting Services
|
Notes
