UKG People Analytics and Reporting

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.