Interactive Analytics

1
Interactive Analytics Reports
An Interactive Multidimensional Reporting
Analysis with in PeopleSoft By Athi
Shanmugam Enterprise Integration Tech
Corp. Athi.shanmugam_at_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_at_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_at_eintegtech.com

36
Benchmark
Single Users 150 users 300 Users 450 Users
Avg Response time (seconds) 6.71 7.13 7.69 7.83
App server (Memory Used) 3.44 GB 3.44 GB 3.69 GB 6.67 GB
App server (Memory Swap per User) 23.5 MB 23.5 MB 19.4 GB 22.5 MB