Skip to main content
Contact Sales Support Careers
United States (English)
Americas
  • United States (English)
  • Canada (English)
  • Canada (Français)
  • Mexico (Español)
Europe, Middle East & Africa
  • United Kingdom (English)
  • France (Français)
  • Deutschland (Deutsch)
  • Nederland (Nederlands)
  • Other EMEA Locations
Asia/Pacific
  • India (English)
  • Australia (English)
UKG logo UKG logo
Search
Get started Get started
    • Solutions
      Solutions by Need
      People icon
      Human Resources
      Payroll icon
      Payroll
      Talent icon
      Talent
      People connected icon
      HR Service Delivery
      Clock with Person
      Time & Attendance
      Calendar day icon
      Scheduling
      Document check shield icon
      Compliance
      Chart bar statistics icon
      Reporting and Analytics
      Product Suites
      UKG Pro

      A culture-driven HCM suite designed to support your enterprise organization's needs.

      UKG Dimensions

      Workforce Management solution helping you redefine the work experience for your people.

      UKG Ready

      HR solution to help small and mid-size organizations focus on growth and making a difference for your people, every time.

      View all products
      Find the product that best fits your needs.
      Get started Get started
      get started
    • Customer Experience
      The UKG Promise

      With over 70 years of expertise with BOTH people systems and systems of work, no one knows people and how they work better than UKG.

      Our Promise
      Customer Experience

      We think you’re pretty special when you’re a UKG Customer. That’s why we build products designed to inspire your people — and your organization — to grow and thrive.

      Partner for Life
      Implementation
      Support Experience
      UKG Community
      Working Smarter Café
      Customer Stories
      Belle Tire

      UKG Pro streamlines and automates administrative and HR tasks, so that field teams and managers can spend more time with customers, and coach, train, and listen to their people.

      Eventide Senior Living Communities

      Eventide Senior Living Communities uses UKG to drive employee engagement and streamline workforce management and HCM, including cutting PBJ reporting time by 99%.

      See all customer stories
      Collaborate, learn, and get support for your UKG solution!
      Visit UKG Community Visit UKG Community
    • Resources
      • Research & Insights
        Research & Insights
        • By Business Need
        • By Type
        See all
        Growth icon
        Human Capital Management
        People icon
        Human Resources
        People connected icon
        HR Service Delivery
        Payroll icon
        Payroll
        Talent icon
        Talent
        Chart tree people icon
        Workforce Management
        Clock with Person
        Time & Attendance
        Calendar day icon
        Scheduling
        Document check shield icon
        Compliance
        Chart bar statistics icon
        Reporting and Analytics
        Lightbulb icon
        Product Info
        Video player icon
        Product Tour
        Article featured icon
        Analyst Report
        Document icon
        White Paper
        Book icon
        eBook
        Organization icon
        Industry Brief
        Chart bar icon
        Infographic
        News people icon
        Article
        Video player icon
        Webinar Replay
        Interactive
      Research & Insights
      • By Business Need
      • By Type
      See all
      Growth icon
      Human Capital Management
      People icon
      Human Resources
      People connected icon
      HR Service Delivery
      Payroll icon
      Payroll
      Talent icon
      Talent
      Chart tree people icon
      Workforce Management
      Clock with Person
      Time & Attendance
      Calendar day icon
      Scheduling
      Document check shield icon
      Compliance
      Chart bar statistics icon
      Reporting and Analytics
      Lightbulb icon
      Product Info
      Video player icon
      Product Tour
      Article featured icon
      Analyst Report
      Document icon
      White Paper
      Book icon
      eBook
      Organization icon
      Industry Brief
      Chart bar icon
      Infographic
      News people icon
      Article
      Video player icon
      Webinar Replay
      Interactive
      Events
      Tradeshows
      Conferences
      Webinars
      See all events
      Blogs
      The People Purpose Blog

      Your source for the latest life-work trends and ideas from UKG experts and leaders. Stay informed and put people first in all you do.

      Workforce Institute

      Think tank that helps organizations drive performance by addressing HCM and workforce management issues.

      Workplace Resources
      Great Place To Work
      Pay Equity Resources
      Human Insights
      UKG Developer Hub
      UKG Pro Ranks Highest in 2022 Gartner Critical Capabilities for Cloud HCM Suites for the North American Midmarket Use Case
      Get The Report
      Get The Report
      Reference Image
      UKG Ranks Highest in 2022 Gartner Critical Capabilities for Cloud HCM Suites

      Read the Gartner® Critical Capabilities analysis for UKG Pro®.

    • About Us
      About UKG

      Learn more about UKG and how our HR solutions inspire workforces and businesses around the world to drive people-focused results.

      About Us
      Why UKG
      UKG Leadership
      Newsroom
      Awards & Recognition
      UKG Ambassadors
      Culture
      Our ESG Program
      Partners
      UKG Marketplace
      Analyst Reports
      Careers

      Look to your future. If you're interested in working for a company that truly invests in their people to create a culture of belonging and innovation, we want you on our team.

      Careers at UKG
      Early Career & Internships
      Benefits
      Life at UKG
      Featured Locations
      FAQs
      Experience awesome at work.
      Search jobs at UKG Search jobs at UKG
    Contact Sales Support Careers
    United States (English)
    Americas
    • United States (English)
    • Canada (English)
    • Canada (Français)
    • Mexico (Español)
    Europe, Middle East & Africa
    • United Kingdom (English)
    • France (Français)
    • Deutschland (Deutsch)
    • Nederland (Nederlands)
    • Other EMEA Locations
    Asia/Pacific
    • India (English)
    • Australia (English)
    Find the product that best fits your needs.
    Get started Get started
    get started
    Search Get started Get started
    Timesheet clock people icon
    Workforce Management

    How Can Data Hub Help Steer Your Analytics Back on Track After COVID-19?

    April 8, 2021
    Data Hub Analytics During COVID-19
    • Share
    See all blog stories See all blog stories
    Stay up to date with The People Purpose Blog
    Subscribe via email Subscribe via email
    Subscribe via RSS

    Written By

    Patrick McCaffrey
    Patrick McCaffrey
    Manager, Data Science Practice

    Topics

    UKG Dimensions UKG Dimensions HR Technology HR Technology

    This blog is part of a miniseries on UKG Dimensions™ Data Hub. To go to the start of the series, visit our first blog here

    In this continuation of the Data Hub series, we’ll get hands on with the platform. I’ll talk about operational challenges a customer was experiencing, and how Data Hub helped them tackle these challenges. After I talk about the background of these challenges, I’ll explain the process the team used to extract and analyze the data.

    The early adopter customer who we’re going to talk about would like to stay anonymous, so let’s call them by the alias Green Gables instead. Green Gables is a non-acute healthcare customer with housing and programs where they help take care of people. They’re one of the most compassionate organizations that we’re proud to call a customer of UKG™ (Ultimate Kronos Group). And as every reader today can imagine, in March of 2020, they found themselves amidst a global pandemic that was affecting their industry in the most unexpected and difficult of ways.

    A people-first mindset

    Green Gables made many changes to support their people, both for the caregivers and care recipients. One change the organization made was to adjust the punch rounding rules for a set of employees in a way that paid employees to at least a full 8-hour day of work. While working hours become chaotic and less certain, or when employees were asked to come in late or leave early, the rounding rules helped keep employee compensation stable. This ensured employees’ paycheck had some form of stability in an otherwise remarkable, uncertain time. 

    This change was made early in the era of COVID-19, and it was a clever and agile solution to adjusting how employees are paid without upending entire systems of payrules and accruals. The drawback was it added a confounding factor to Green Gables’ existing HR analytics and reporting. In these existing reports, used to understand hours worked, managers found it difficult to distinguish worked hours from the rounded-to-schedule hours. As any reader of this blog can imagine, it’s still important to understand the actual hours worked by your workforce, even if you are paying them more than that. Managing worker fatigue and total hours for compliance reasons comes to mind as a good reason to want to track this.

    Let’s look next at how the early adopter was able to stratify this data to understand the actual work from the rounded values.

    UKG Dimensions helps your frontline

    The good news for Green Gables is that UKG Dimensions Analytics comes out of the box with a KPI designed to view time-work-not-paid and time-paid-not-worked.  Here’s what this might look like in one of the UKG Dimensions Dataviews:

    Time Paid Not Worked Graph

    These KPIs and their related Dataviews allowed frontline managers at Green Gables to gain daily insight into their people, enabled operational management of the effects of the rule change and the actual work being performed.

    Big data? Try Data Hub

    Leadership was still interested in a long-term look at this data. When it comes to analyzing historical workforce or human capital data, Data Hub is a great tool for this job. Data Hub brings detailed data from UKG Dimensions into Google Big Query. The pre- and post- punch round times are all available for every punch, alongside people information, so we can filter the search down just for the subset of employees that were affected. Lastly, we have the business structures so that we can aggregate and drill down in the data.

    This data, in Data Hub, is available for long historical periods (years in many cases), and in this example stretched back to pre-COVID, so that Green Gables can look at the timecards over the entire period. And with the data now in front of you, in a clean and rectangular format, you can continue your analysis with Big Query Aggregate Functions.

    If you’d like to try this for yourself on your own Data Hub tenant, I’ve uploaded the query source code to Gist that anyone is free to download.

    What’s next?

    Data Hub gave Green Gables the analytics it needed to untangle its employee pay from its employee hours worked that stemmed from a rapid pivot due to COVID-19. This allowed the organization to manage employee burnout at the same time as understanding its total payroll. Long term, there are other ways to manage this configuration change, but global pandemics don’t always wait for you to consider the downstream reporting effects of making a rule change to your workforce.

    To wrap things up, the Dataviews and KPIs you’re already familiar with are the best instrument for managing your day-to-day people pay and data-driven decision making, especially if you are a frontline manager. Data Hub is the tool you pick-up when you need to analyze trends and explore data that might span years or your entire organization. Or if you need to apply more sophisticated analysis.

     

    Learn more about Data Hub and talk your customer success or account manager to learn which part of the UKG Dimensions toolbox is right for the task you have at hand.
     

    • The People Purpose Blog
    • How Can Data Hub Help Steer Your Analytics Back on Track After COVID-19?

    Related Stories

    Grocery store frontline worker
    The People Purpose Blog

    6 Myths About Frontline Workers, Debunked

    Learn six common myths about frontline workers and how to overcome them to empower your people.

    Cheerful young woman celebrating her achievement while reading good news on laptop from home office - Smiling female expressing excitement working at home
    The People Purpose Blog

    How to Revamp Your Talent Acquisition Strategy with Competitive PTO

    Paid time-off policies have evolved to play a significant role in attracting and retaining employees. Learn how a more flexible approach can create a competitive talent acquisition strategy.

    How to reduce turnover in manufacturing
    The People Purpose Blog

    How to Reduce Turnover in Manufacturing

    Learn the true cost of turnover and five critical strategies to reduce turnover in manufacturing. 

    UKG logo

    Footer menu

    • Human Capital Management
      • Human Resources
      • Payroll
      • Talent
      • Reporting and Analytics
    • Workforce Management
      • Time & Attendance
      • Scheduling
      • Compliance
    • Product Suites
      • UKG Pro
      • UKG Dimensions
      • UKG Ready
    • Customer Experience
      • Implementation
      • Support Experience
      • UKG Community
      • Customer Stories
    • About Us
      • Why UKG
      • Culture
      • Our ESG Program
      • Leadership
      • Newsroom
      • Careers
      • Privacy and Security

    Sub Footer

    • Modern Slavery Statement
    • Accessibility
    • Cookie Choices
    • Cookie Notice
    • Terms of Use
    • Trademarks
    • CCPA Notice
    • Licenses
    • Privacy Notice
    © 2023 UKG Inc. All rights reserved.

    Kronos SaaShr, Inc., a UKG Company (NMLS ID#1698726) provides money transmission services on behalf of UKG Inc. customers and in connection with certain UKG products.