UKG People Analytics and Reporting

If you’re like me, you may find cardinality settings in UKG Cognos BI aka People Analytics less than intuitive. Even if you can do a SQL left outer join in your sleep. This post should help. It will help answer key reporting challenges, including:

Show me all active employees and their medical plans.

Show me all active employees and their highest level of education.

Show me all active employees and any bonus they received in March.

Companies implement Advanced Scheduler in UKG Pro WFM to control overtime.

But having the system isn’t enough. Payroll told you THAT you had overtime.  Now, you want to know why.  Where to start?

Here are some key metrics we’ve developed  to help you drive overtime down.      

• Worked vs Scheduled:
  You know someone’s schedule.  You know each day how much they worked.
  you schedule Joe for eight hours on Monday. He worked twelve.  There’s a good chance he’ll be receive overtime by the end of the week.
• Early in/late out.
  Yes, employees have grace periods.  But some folks are consistently 14 minutes early and 14 minutes late out.  Do that five days in a row and you have 2.5 hours a week.  That adds up.
• Working but not Scheduled
  Getting folks scheduled is the cornerstone of successful management.  Lots of unscheduled time points to process issues.  The systems not helpful if you have lots of unscheduled time.
• Hours entered without swiping
  Time keeping devices aren’t perfect.  But they are consistent.  When some folks are consistently worse at swiping in than others, you have a problem.
• Short Staffing
  It’s sad when folks try to cut overtime when they’re short staffed.  Position control, applicant tracking and open shifts in Advanced scheduler identify this problem.  And if you have it, advanced scheduler can help, but it won’t solve your underlying problem.

These are just some things our clients have found useful.  What have you used to get your overtime down?

You’re here because you want to use Power BI with UKG Pro Data.

You’re not the only one. Here’s a solution that might interest you.

The solution comes with all the code you need to run reports in UKG People Analytics and have the data show up in Power BI. The Power BI model has measure based on payroll amounts and hours. We’ll be adding head count statistics shortly. All the basics are included – like Job and org Level information.

So, let’s point out a few key things for business users and technical folks:

In today’s tip, we’re going to show you how to label data items and pages in UKG People Pro Analytics aka Cognos BI.

Has this happened to you?  You’ve spent time developing a complex query and then fields go missing.   And you wonder why.

I made this mistake several times.  So, it’s worth a blog post.  At the least, it will help me remember not to make the mistake again.

As I’m sure is true for many of you, UKG People Analytics (formerly known as Cognos Business intelligence) is not my first reporting tool.

That’s good – because you understand data and reporting. 

That’s bad – because your learned behavior may mislead you.  And if you’re really like me, you have no hair left to pull out.

A client has both UKG Pro and UKG Kronos Dimensions.  They want to see punch back up for each pay check.

The challenge is figuring out the apply date.  Which is clearly on the screen but not to be found in the Data Hub Database.    Here is what we did to figure out this key piece of information.

Recently, UKG has started supporting Dimensions data in People analytics.   Our clients’ experience indicates that DataViews are cool for manager and employee self-service but don’t work well organization wide analysis.  As for the BIRT reporting tool – I’ll invoke the thumper rule.*

Before you start training in UKG People Analytics

You know you have a lot of data in your UKG Pro (and now UKG Dimensions) system which you can access with People Analytics.