Interactive Analytics & Reports

1. Interactive Analytics & Reports An Interactive Multidimensional Reporting & Analysis with in PeopleSoft By Athi Shanmugam Enterprise Integration Tech Corp. Athi.shanmugam@eintegtech.com 610-348-0389

2. Interactive Analytics & Reports Agenda • Introduction to Company 5 minutes • HR Analytics 15 minutes • Q/A 5 minutes • FSCM Analytics 15 minutes • Q/A 5 minutes

3. Enterprise Integration Tech Corp

4. Enterprise Integration Tech Corp Overview Helps PeopleSoft Customers to Implement & Upgrade PeopleSoft FCM, HCM and EPM applications.

5. Interactive Analytics & Reports • What is Interactive Analytics & Reports? • How is it useful for Analytical Reporting without any BI tools?

6. Interactive Analytics & Reports Built with new technology delivered with PT 8.46 and above Multi-dimensional reporting from PeopleSoft transactional Data base True Slice and Dice in PeopleSoft Internet Page End users can view and Analyze important actionable KPIs

7. Current Reporting Options • SQR, PSQuery - many pages of reports to go through - not analytical in nature - cost of code maintenance • BI Reporting Environment (Data Warehouse & Reporting) - millions of $$$$ to implement - Huge maintenance

8. Another Reporting Option • Simple Analytical Interactive Reporting Model • Easy to build and maintain • Downloadable into Excel Spreadsheets • Commonly used KPI for HR, Finance and CRM can be built within the models • Uses PeopleSoft Trees for dimensional Hierarchy and row level security • Cost = cost of SQR

9. HR Analytics • Head Count Trend Analysis • Workforce Movement Analysis • Employee Compensation Analysis • Recruiting Effectiveness Analysis • Workforce Composition Analysis We can do it all within PS

10. Head Count Analytics • KPIs Head Count • Dimensions Department, Location, BU, Time etc …… • Common Business Questions Answered What are the monthly, Quarterly and Annual HC for last X number of years by Dept, BU,Location etc?

11. Current Head Count

12. Department wise HC

13. Department wise HC

14. Department Vs Month HC

15. More Slice & Dice on HC

16. Workforce Movement Analytics • KPIs Voluntary and Involuntary Separation Counts Hire, Termination, Promotion, Transaction and other Action Counts • Dimensions Department, Location, BU, Action,Time etc …… • Common Business Questions Answered - What are the monthly, Quarterly and Annual Various Action Counts for last X number of years by Dept, BU,Location etc? - Attrition Reporting

17. Workforce Movement Analysis

18. Workforce Movement Analysis

19. Separation Counts on WFMA

20. Quarterly Hire Count on WFMA

21. More Slice and Dice on WFMA

22. More Slice and Slice on WFMA

23. Employee Comp Analysis • KPIs Salary • Dimensions Dept, Location, BU and Time etc • Common Business Questions Answered Employee Compensation History By Dept, BU and Location etc

24. Employee Comp Analysis

25. More Slice & Dice

26. More Slice & Dice

27. FSCM Analytics • Profitability Analysis • Procurement Analysis • Spend Analysis • Payable Analysis • Finance Control Analysis We can do it all within PS

28. GL & Profitability Analysis

29. Actual Vs Budget Analysis

30. More Slice & Dice

31. Payment Analysis

32. Payment Analysis (More)

33. Payment Analysis (More)

34. FSCM Analytics Q & A Athi Shanmugam Enterprise Integration Tech Corp. Athi.shanmugam@eintegtech.com 610-348-0389

35. Interactive Analytics & Reports • Wants to thank you for your time • For more information/Demo visit our booth on the 2nd floor, turn left after exiting the elevators, next to the Executive offices. • Or contact: Athi Shanmugam Enterprise Integration Tech Corp. Athi.shanmugam@eintegtech.com

36. Benchmark