Home / Solutions

Analytics across Workday and the business

We help finance and HR understand changes in staffing and cost using Workday alongside other business data. Databasin preserves the history, connects related records and applies shared measures. Our team builds the analysis so people can explore periods, investigate a change and ask follow-up questions in plain language.

  • WashU Medicine
  • University of Kansas Medical Center
  • Saint Francis Healthcare System
  • Saint Louis University
  • Compana Pet Brands

Workforce questions with financial context

We connect workforce and financial records so teams can investigate the same business change. Workday Financials and HCM have separate hierarchies. Shared reference records and explicit relationships bring their data together for the organizations and periods under review.

The relationship also needs the correct historical values. For a staffing question about June, the manager and cost center assigned then explain the records. Databasin retains that effective-dated history. We implement the measures with business owners so finance and HR can examine the period using the same definitions.

What we prepare for analysis

Historical values

We retain effective-dated assignments and compensation so questions about past periods can use the values from that time.

Related records

We join Financials, HCM and other sources through the organizations and periods required for the analysis.

Shared measures

We implement the measures agreed with business owners so finance and HR can investigate a shared calculation.

How can people investigate a change?

A question to Databasin One returns an answer with the SQL used to calculate it. For example, a four-quarter headcount question can produce a chart from the prepared history.

The user can inspect the query and ask about one department. That question uses the same governed records and definitions, keeping the follow-up connected to the period and measure being examined.

What happens next

We would like to hear where your team wants to make progress with data and AI. We can discuss a project you have in mind or explore where Databasin could help with the work.

What happens next

  1. Book a demo

    Book a conversation about your organization and the work you want to improve. Questions about where to start are welcome.

  2. Explore the opportunity

    We show a working example that answers your business questions, then discuss what it would take to deliver it for your team.

  3. Get the first result

    After agreeing the first use case, we implement it with your team. We train the people using it and measure how it performs.

FAQ

How far back can Workday history extend in the analysis?

The connector supports the full effective-dated history from your Workday go-live. That allows the model to retain earlier organization and compensation values and select them for questions about those periods.

What if a compensation correction is entered after the period ends?

The extraction uses effective dates as well as modifications. If a correction entered today belongs to an earlier period, it updates that history so later queries can use the corrected value.

Can a related object change affect an unchanged worker record?

Yes. Changes in a related object can make another extraction necessary even when the worker record itself is unchanged. Databasin's incremental logic handles those relationships alongside modification dates.

Which reference records connect Financials and HCM?

Organizations, locations and currencies are shared across the Financials and HCM pipelines. We use those reference records to prepare the relationships and reporting periods required by the business question.

How are calculated fields represented in the analysis?

We extract the calculated fields the connector identifies as safe to read. Other required logic is built into the prepared model, with finance and HR specialists reviewing the measures against their definitions.

Can an ERP or CRM add information to workforce analysis?

Yes. A question can use connected ERP or CRM records with Workday. We align the organizations, periods and calculations so that the additional records provide useful context for the investigation.

Does the analysis change transactions inside Workday?

Workday continues to handle its transactions. Databasin reads records for analysis and recurring data work. We establish how people act on findings in Workday or another existing business process.

Can compensation analysis have a restricted audience?

Yes. The data owners approve the audience for compensation records. We apply that access in the deployment and define which measures can be shared with other groups.

Can an analyst examine the model behind a plain-language answer?

Yes. The tables, definitions and answer SQL are available for inspection by authorized analysts. They can compare the calculation with its source records and dates to examine the measure shown to business users.

How do you help finance and HR use the analysis together?

We train users on the measures and periods in their shared review and how to investigate a result. Communication, rollout and success measurement accompany the implementation as it enters use.

Discuss your Workday analysis

Talk with us about the changes your finance and HR teams want to understand. We can explore the questions, the history they need and how Databasin could help people investigate the result together.