How to make the most of your data – Part 2: Make sure you can handle all data types

05 October 2021
Written by Danielle Larocca

With over 25 years in SAP Human Capital Management, Danielle is a recognized leader in HR technology. She holds the distinguished roles of SAP Mentor and SuccessFactors Confidant, and serves as HXM Chairperson for ASUG (America's SAP User Group). Danielle is a sought-after speaker at international conferences, sharing insights on HR tech trends. She has authored four best-selling books on SAP and holds certifications in both SAP and SuccessFactors technologies.

How to make the most of your data - Part 2: Make sure you can handle all data types

A recent SAP news article titled Five Ways to Make the Most of Your Data explains how business leaders are now recognizing that data is at the heart of digital businesses.  It lists the five ways to make the most of your data as:

  1. Leave your data where it is
  2. Make sure you can handle all data types
  3. Harness data to drive automation
  4. Democratize data
  5. Protect your data

I’m looking at each of these areas in more detail. You might want to read my first blog (Part 1) on leaving your data where it is. Today’s blog focuses on the second recommendation around making sure that you can handle all data types.

 

ReorderLevel

Image Source Microsoft Access from fmsinc.com © 1998

 

One of my earliest technology jobs was working as a Microsoft Access programmer, and I spent quite a bit of time merging data from multiple places into a single system. From there, the task was to create relationships between the multiple data sources so that they made sense (see sample above). In today’s world, not only does the data have to make sense from a relational perspective, but there is also a greater spectrum of types of data, including structured, unstructured, relational, or geospatial to name a few.

 

You may have heard the term ‘normalizing the data’ which is essentially about taking different types of data and having them make sense together. As stated in the SAP article, “Too often organizations approach each type of data differently and separately, which replicates the problem of unconnected data that doesn’t come together in one holistic picture.”

 

In the SAP HCM and Payroll world, we see quite a bit of this, especially considering the number of users who attempt to work with their data via multiple downloads in something like Microsoft Excel. It’s no secret that in the SAP ERP HCM and Payroll world, you often have to use multiple solutions to produce a report, a topic I speak about quite frequently. See an example below.

 

Reporting in SAP HCM without Query Manager-2

Users often start by getting the Master data from a delivered report or via table or infotype dumps from transaction code SE16, and then they add to it some payroll data accessed via the Pay Recon report. Add to that some detailed Organizational Management data, and you can easily see how it can go wrong rather quickly. Just the basic one-to-many relationships that exist – coupled with the concept of effective dating – is enough to give a programmer a rough time.

 

The suggestion in the SAP news article is to be sure to pick a “platform that treats data as both multimodal and multidimensional.” 

 

If you are working with data from all things HCM SAP and/or SuccessFactors and that landscape, it's easy to simply point you to a third-party solution that does this for you already, which, of course, is the EPI-USE Labs Query Manager solution (the only SAP S/4HANA-certified solution designed for this). Query Manager solves the reporting challenge for SAP HCM as shown in the image below.

Reporting in SAP HCM with Query Manager-3

If your scope and data sources go way beyond all things SAP ERP, you may require a platform that allows you to perform this type of data normalization. SAP Data Warehouse Cloud is a popular option that allows customers to connect data with business context in a unified data and analytics cloud solution. The good news there is that we can help you to get your critical HR and Payroll data into SAP Datasphere.

 

Employee Data View

 

Employee Salary Breakdown

My next blog will focus on the third item listed in the Five Ways to Make the Most of Your Data’ article, which is harnessing data to drive automation.  

 

 

 

New call-to-action

 

 

Explore Popular Tags

SAP SuccessFactors Query Manager SAP HCM SAP HCM reporting HCM Reporting Intelligent HR and Payroll SAP SuccessFactors Employee Central Payroll Human Capital Management (HCM) SAP Payroll SAP Reporting EPI-USE Labs HCM SAP SuccessFactors Reporting PRISM Payroll Payroll reporting reporting Document Builder Query Manager Analytics Connector SAP Analytics Cloud SAP HCM Data SAP Query SAP S/4HANA Artificial Intelligence (AI) Microsoft PowerBI SAP Payroll data SAP SuccessFactors People Analytics Variance Monitor SAP HXM HR and Payroll data SAP S/4HANA Private Cloud Edition (S/4 PCE) Tableau HXM Move Payroll Data SAP SAP ERP HCM SAP HCM On-Premise Solutions SAP HCM Payroll SAP HR Reporting SuccessConnect people analytics sap query hr Data Sync Manager Employee Central Payroll Journey to SAP SuccessFactors Machine Learning (ML) PRISM for HCM (Private Cloud Edition) PRISM free assessment SAP HCM journey SAP and SuccessFactors HXM Reporting AI COVID-19 Cloud-based SAP HCM solutions Employee Central Payroll Reporting Employee data Employee payroll GeoClock H4S4 HCM Productivity Suite HR PRISM for ECP SAP Business Technology Platform SAP HCM/HXM SuccessFactors reporting solution ABAP DSM for HCM Joule Let's Talk HCM On-Premise Payroll Pay Recon SAP HCM Analysis SAP HCM for SAP S/4HANA On-Premise SAP HR SAP SuccessFactors HCM Journey SAP SuccessFactors Roadmaps SAP data privacy and compliance Transformation without re-implementation Ultimate Guide: SAP HCM & Payroll Options accurate payroll data data validation payroll control center 2024 BTP ChatGPT Data Sync Manager for HCM Digital transformation EPI-USE Labs’ solutions Employee Central Employee communication GDPR Generative AI HCM, HR Large Language Models Move to SuccessFactors Employee Central OData PRISM for H4S4 Query Manager with Document Builder Real-time reporting and document creation SAP Analytics Cloud (SAC) SAP Data Warehouse Cloud SAP HCM On-premise SAP HCM for S/4HANA SAP On-Premise customers SAP Payroll to the Cloud SAP Road maps SAP SAPPHIRE 2024 SAP SuccessFactors Time Management SAP SuccessFactors Time Tracking SAP customers SAP data SAP data privacy & security Success Factors SuccessConnect 2019 Tax Reporting Time management certification custom infotype data source ebook on-premise SAP HCM s/4HANA Analytics solutions Automated reports Automation Cloud migrations Comparing data DSM Object Sync for SuccessFactors Hybrid Data Secure Data Types Data analysis Employee Central time Employee Letters Free HCM Assessment HR Journey HR employee reports Hourly time tracking Human Experience Management (HXM) Human Resources Human Resources data Hybrid Reporting SAP and SuccessFactors Hybrid SAP and SuccessFactors Hybrid reporting Hybrid reporting solution Integrated reporting SuccessFactors SAP Intelligent Enterprise Microsoft Excel Natural Language Processing News OData integration OM Object Sync On-Premise Payroll S/HANA Sidecar On-premise reporting Organization of the data PA Pay reconciliation People Analytics Workforce Planning Personalized documents Prompt Engineering Protect personal employee data Report Stories Reporting and analysis Robotic Process Automation (RPA) Robotic Process Automation framework S/4HANA Private Cloud Edition (PCE) SAP BTP SAP Data Privacy Suite SAP Data Security SAP ERP Payroll customers SAP HCM 2023 SAP HCM Roadmap SAP HCM and Payroll customers SAP HXM 2021 SAP Mentors SAP SuccessFactors Hybrid SAP SuccessFactors Next-Gen Payroll SAP SuccessFactors Release updates SAP Wage Type Reporter SAP certified solution SAP migration SAPPHIRE 2018 SuccessFactors and the Intelligence Enterprise SuccessFactors' Employee Central Payroll TCO Calculator The Report Center The Road to People Analytics Tracking employee time Workforce Planning ad hoc data variances easy reporter high-speed, low-risk on-premise SAP data partner roadmap single reporting solution sq01 stories in SAP SuccessFactors People Analytics technology third party ALE STP report APJ ASUG Accessing COVID-19 data Ad Hoc Query American Payroll Association (APA) Analytics Connector Analytics reports Analytics solution At-risk employees Australian Payroll Australian Tax Office (ATO) Automated analysis and pay run reconciliations Automatic HR reports Best practice in BI Bots Business Analytics Business Intelligence COVID-19 statistics COVID-19 vaccinations Certified solutions Check for data replication errors Client Sync Client-centric Cloud Cloud hosting SAP PCE Cloud innovations Company Branding Compare legacy HR and Payroll data Configuration Center Copy and mask test data Coronavirus Created timestamp Custom Development Custom store Customer-specific infotypes DSAG Data Privacy Data Replication Data Sources Data Sync Manager (DSM) Data access Data privacy regulations Data production support issue solution Deep Learning Democratize data Description Diversity & Inclusion reporting DocuSign
+ See More

Get Instant Updates


Leave a Comment: