![Red Three Blog](https://i1.feedspot.com/5494209.jpg?t=1673872867)
Red Three Blog
3 FOLLOWERS
Red Three Blog reviews data integration challenges for SAAS solutions, with a particular emphasis on UKG solutions. The Red Three solves your challenge with their integration, analysis, and reporting support services. So, your data can be where you need, when you need it.
Red Three Blog
2w ago
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 ..read more
Red Three Blog
1M ago
In California if a person doesn’t take a break after five hours, they receive extra pay. Unless they attest that it was their choice to skip the meal. A similar rule applies for rest breaks.
UKG has standard functionality to handle this but it’s not straightforward. Our client had an added challenge. Some of their employees use a different system to enter time and attestations. that data needed to be interfaced.
I thought about writing up the entire process in detail. But it’s just too much for a blog post. Here are some key lessons learned:
There are many ways to create the pay code edit for ..read more
Red Three Blog
3M ago
Here’s a list of all our UKG Pro related posts. Let us know if you have questions or other topics you’d like to see covered.
UKG Data Integration
UKG Pro
UKG Pro Rest API Example in Postman and PowerShell
UKG Pro – Reports as a Service vs Rest API
UKG Reports as A Service in Postman
UKG Pro – Assigning Platform Configuration Field Values to Business Rules
UKG Pro – Importing Simple Business Rule Values
UKG Pro WFM
Kronos – UKG Dimensions API Postman Example
Kronos Workforce Central to UKG Dimensions: Does SQL Still Matter?
Data Warehouse – Power BI/Other Tools
UKG Pro
Using Power BI ..read more
Red Three Blog
4M ago
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:
For business users:
This works on a fiscal year, not a calendar year. You can do analy ..read more
Red Three Blog
9M ago
Our last post discussed payroll history challenges and your data warehouse.
Today, you’ll learn about challenges with Employee Job History
You know that it’s not enough to know what your job counts and job titles are today. You need to know what they were last month, last quarter, and last year.
This data presents several key challenges:
Changes made after the effective date.
UKG Pro allows you to back date your effective date changes. For example, Jill was promoted on July 1st, but Jack forgot to enter the promotion until August 1st. This creates two issues. First, your headcount has changed ..read more
Red Three Blog
9M ago
You want your UKG Pro data in your Data Warehouse. We’ve touched on why we -recommend reports as a service purpose here. You should remember that you’ll never pull all your UKG data in to your data warehouse. It’s too large and too much of it serves a narrow audience for benefits, HR and other compliance purposes.
So, what should you put in your data warehouse?
The two key starting points are Payroll Detail with all allocations.
And Employee Job History – so you can who was in what job at what time.
Building the key reports isn’t hard. But that’s only the beginning.
You’ll have challenges wi ..read more
Red Three Blog
11M ago
Why We Use Reports as a Service over Rest APIs with UKG Pro
You need to decide how to get your data from UKG Pro. We recommend Reports as a Service (RAAS) even as we also support Rest APIs. Here’s the data.
It provides the most data
We’ve found all the data we need in People Analytics. While the API list is long, it’s not FULLY comprehensive. For example, the Employee Pay Statement shows everything the employee sees on their check. It doesn’t show Org Level Job allocations. If you do a lot of payroll analysis, this doesn’t work. If you’re like all my customers, you have at least SOME people t ..read more
Red Three Blog
11M ago
You want to understand how to run People Analytics Reports as A service (RAAS). If you just want the sample Postman code, you can request that here. Please note that the last step of the process requires a few lines of PowerShell outside of Postman. For your reference, here’s the UKG documentation.
If you’re new to UKG APIs, you might start with our RestAPI example. It’s simpler and relies on some of the same setup.
Let’s dive in step by step.
Gather the values you need: Environment Variables in Postman
We have created six environment variables in an environment called UKG RAAS. You’ll need to ..read more
Red Three Blog
11M ago
If you work with HR data, you want it be useful for the business. And so, if you’re like me, you keep up on the latest in People analytics. Here’s a worthwhile article from SHRM reassuring you that lots of folks aren’t where they want to be in People Analytics.
We’re nuts and bolts data consultants. So, we keep up with the latest but focus on the basics. To be successful in People analytics, your data must be:
Clean
The article lists several excellent best practices for people analytics. First on the list: Examining the quality of your data. If you gave your company an HONEST grade on data cl ..read more
Red Three Blog
11M ago
There are many UKG Pro/UltiPro/Kronos/Dimensions consultants out there. And if you’re searching for help, all the websites may have started to merge together.
Everyone has years of experience, focuses on their client and delivers great results.
Why would you choose us?
Focus
We focus on Data Integration and Analytics. We understand the UKG applications. You can’t work with the data if you don’t understand the application. But you come to us because you have data issues. You need to send your data to a different system. You need to import data into the system. You want to use your data with a ..read more