How to make the most of your data – Part 1: Leave it where it is

September 22, 2021
Written by Danielle Larocca

Senior Vice-President of HCM Solutions Danielle Larocca has worked in the SAP HCM space for over 20 years. An SAP Mentor and featured speaker at numerous conferences, Danielle has authored four best-selling books on SAP, is the Technical Editor for the SAP Professional Journal, and often the Voice of the Expert on SAPInsider’s Ask the Expert series for HR.

How to make the most of your data - Part 1

SAP recently posted a news article called Five Ways to Make the Most of Your Data’ that talks about how as economies have digitized, business leaders now recognize that data is at the heart of digital businesses. It then went on to detail the five ways to make the most of your data, which were:

  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 really enjoyed the article, and I love all things data reporting and analytics, so I decided to chime in with my thoughts on each of the five items. Here goes...


I am passionate about data, especially accurate and real-time data. The only way to make informed decisions, whether it is about opening a new location, implementing a mass increase for a job or position eliminations, is to have the right information. Far too often, companies are making ‘guesstimates’ based on impressions or assumptions or rumors, when critical decisions for the business should only be based on facts and information. 

Access to real-time data for decision-making

To make a good decision, you need data that is real time, unlike the old days when you had to take months to comb through files and data. Now executives, managers and employees expect to have all the information at their fingertips.  We have been spoiled in a world of instant access and instant gratification, and we expect the same type of experience with all things HR and Payroll. Executives and managers need critical information at their fingertips about the enterprise to make informed decisions, and that data may come from several different sources; some from the sales system, some from finance, some from HR etc.  


As described in the article, “too often companies try to centralize data via a large, top-down project where data from across the organization must be brought into a central repository. The problem with this approach: by the time you bring together data from across different parts of an organization into one place, it’s outdated.” I have seen this design used at many organizations over the years, and I recall that when ‘repositories and data warehouses’ were first introduced this was a popular method. It's easy to say you want all your data in a single place; however the truth is you actually want all of your data accessible via a single place in real time.  


Let’s use the HR and Payroll example where your critical HR and Payroll data may exist in several places, which can include your SAP HCM ERP system, your SuccessFactors cloud solution, and third-party tools including the Time solution Workforce.  

A popular old-school centralized repository design

In the example shown above, key data exists in the three systems listed on the left hand side.  In the old-school method, data was copied/extracted/transmitted from those core systems (also known as the ‘system of origin’) and then a copy of that data is placed into an external data warehouse or repository from which reports were created. In the early days of SAP Business Warehouse (BW), this data was transmitted from the core systems to the BW data warehouse on a weekly or monthly basis. 


As you can imagine, there are several concerns with this design, including:

  1. Once the data leaves the core system, it is no longer protected by the security protocols in place in that system

  2. Once the data leaves that core system, it is no longer real-time data; it is rather a frozen look at the data as of the last time it was extracted

  3. There is always risk when an additional step or system is added as formatting issues may incorrectly impact the data (leading zeros, dates, currencies, negative numbers etc.)

So, you need to leave your data where it is!

The first recommendation in the news article addresses the key point of leaving your data where it is, in the core system, and rather extracting it in real time directly for reporting and analysis as shown in the diagram below.

No data warehouse design

In the example above, the data from the core systems is dynamically transmitted directly to your report output. There is no copy of the data made and/or stored (replicated), rather it is received/transmitted dynamically directly to the output, ensuring real-time data is available for reporting and analysis to be used to make business decisions.


My favorite quote from the article is “People need to shift their mindset to connecting – rather than collecting – data”. At EPI-USE Labs, we make the connector that allows our clients to transmit their critical and hard-to-reach data to their external Analysis solutions, including

Microsoft PowerBI, Tableau, SAP Data Warehouse Cloud (DWC) and SAP Analytics Cloud (SAC)


Please feel free to reach out if you would like to see it in action.  

My next blog will focus on the second item listed in the article, which is around making sure you can handle all data types.  

New call-to-action






Explore Popular Tags

Query Manager SAP SuccessFactors SAP HCM reporting HCM Reporting SAP HCM SAP Reporting SAP Payroll HCM SAP SuccessFactors Employee Central Payroll SAP SuccessFactors Reporting EPI-USE Labs reporting PRISM Payroll Document Builder Payroll reporting Query Manager Analytics Connector SAP Analytics Cloud SAP HCM Data SAP Query Microsoft PowerBI SAP SuccessFactors People Analytics Human Capital Management (HCM) Intelligent HR and Payroll SAP Payroll data Variance Monitor HR and Payroll data Tableau HXM Move Payroll Data SAP HCM Payroll SAP S/4HANA SAP S/4HANA Private Cloud Edition (S/4 PCE) people analytics sap query hr Data Sync Manager Employee Central Payroll Journey to SAP SuccessFactors SAP SAP ERP HCM SAP HCM On-Premise Solutions SAP HCM journey SAP HR Reporting SAP HXM SAP and SuccessFactors HXM Reporting COVID-19 Cloud-based SAP HCM solutions Employee payroll HCM Productivity Suite HR SAP HCM/HXM SuccessConnect reporting solution ABAP DSM for HCM Employee Central Payroll Reporting Employee data GeoClock H4S4 Let's Talk HCM PRISM for HCM (Private Cloud Edition) PRISM free assessment Pay Recon SAP Data Warehouse Cloud SAP HCM Analysis SAP SuccessFactors HCM Journey SAP SuccessFactors Roadmaps SAP data privacy and compliance SuccessFactors Ultimate Guide: SAP HCM & Payroll Options data validation payroll control center Data Sync Manager for HCM Employee Central GDPR HCM, HR OData Query Manager with Document Builder Real-time reporting and document creation SAP Analytics Cloud (SAC) SAP HCM On-premise SAP HCM for SAP S/4HANA On-Premise SAP HR SAP On-Premise customers SAP Payroll to the Cloud SAP Road maps SAP customers SAP data SAP data privacy & security Success Factors SuccessConnect 2019 Tax Reporting Transformation without re-implementation accurate payroll data certification custom infotype data source ebook on-premise SAP HCM s/4HANA Analytics solutions Automated reports Automation Cloud migrations DSM Object Sync for SuccessFactors Hybrid Data Secure Data Types Data analysis Digital tranformation EPI-USE Labs’ solutions Employee Letters Employee communication Free HCM Assessment HR Journey HR employee reports 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 News OData integration OM Object Sync On-Premise Payroll On-Premise Payroll S/HANA Sidecar On-premise reporting Organization of the data PA People Analytics Workforce Planning Personalized documents Protect personal employee data Report Stories Reporting and analysis Robotic Process Automation (RPA) Robotic Process Automation framework S/4HANA Private Cloud Edition (PCE) SAP Data Privacy Suite SAP Data Security SAP ERP Payroll customers SAP HCM 2023 SAP HCM Roadmap SAP HCM and Payroll customers SAP HCM for S/4HANA SAP HXM 2021 SAP Mentors SAP SuccessFactors Hybrid SAP SuccessFactors Next-Gen Payroll SAP SuccessFactors Release updates SAP SuccessFactors Time Management SAP SuccessFactors Time Tracking 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 Time management 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 ASUG Accessing COVID-19 data Ad Hoc Query American Payroll Association (APA) Analytics Connector Analytics reports Analytics solution Artificial Intelligence (AI) 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 ChatGPT Check for data replication errors Client Sync Cloud hosting SAP PCE Company Branding Compare legacy HR and Payroll data Comparing data Configuration Center Copy and mask test data Coronavirus Created timestamp 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 Democratize data Description Diversity & Inclusion reporting DocuSign Document Building Dynamic data ECC EPI-USE ERP Education sector Electronic Signatures Embedded Analytics Edition Employee Central time Employee Central timesheets Employee NICs Employee Retention Analytics (ERA) Employee payment summaries Employee right to privacy Employer NICs Encrypt data FAQ Index Font Guidelines Gender Pay Gap General Data Protection Regulation Governance, Risk Management and Compliance (GRC) Government forms Grid control Grid layout HANA HCM Client Sync™
+ See More

Get Instant Updates

Leave a Comment: