-
SOFTWARE
SOFTWARESAP HCM & PayrollQuery Manager Query Manager Add-ons Document Builder Variance Monitor DSM for HCM HCM Productivity Suite FLOW GeoClockSAP Landscape & Test Data ManagementData Sync Manager (DSM) suite - System Builder/Shell Sync - Object Sync - Client Sync - Data Secure Archive CentralSupport & TrainingClient Central E-learning & trainingSAP Data Privacy & SecurityData Privacy suite - Data Secure - Data Disclose - Data Redact - Data Retain Soterion (GRC)
-
SERVICES
SERVICESSAP HCM & PayrollPRISM for HR & Payroll SAP SuccessFactors Integration monitoring Payroll reporting Report writingClient-specific DevelopmentCustom development SAP BTPSAP Landscape & Test Data ManagementPRISM Migrations to S/4HANA System Landscape Optimization (SLO) Managed data refresh servicesSAP Data Privacy & SecuritySAP data privacy assessment serviceMass data removal services Data privacy consultingCloud and Application Managed ServicesFunctional AMS Cloud management services Cloud migrations Basis managed services Private cloud hosting SAP on AWS SAP on Azure Premium Support Services RISE BRIDGE Managed Services
- All Solutions
- Request Estimate
-
Resources
Resources Blogs Read the latest updates on SAP SLO, SAP HCM, Data & Privacy, and Cloud Webinars Access expert insights in live and recorded webinars Video library Watch videos and improve your SAP knowledge
- About
Query Manager powers Sellafield's analytics engine
Personalised data views
Efficiency boost
Insightful dashboards
About Sellafield
Sellafield is a nuclear facility located in Cumbria, United Kingdom. Recognised for its historic contributions to nuclear energy and decommissioning activities, Sellafield plays a crucial role in nuclear research, development, and waste management. The site's diverse functions encompass reactor operations, waste recycling, and environmental management, making it a pivotal player in the global nuclear industry.
Feedback from HR managers and line managers was overwhelmingly positive, praising the dashboard's effectiveness and usability. The success triggered a surge in demand for similar dashboards across the company.
Enhancing HR reporting efficiency: Overcoming manual data extraction
In the world of HR reporting at Sellafield, the adoption of Query Manager™ and Power BI has proved to be a game-changing success.
In 2020, Sellafield's HR systems' team recognised the need for more efficient HR reporting solutions. They had previously relied on SAP Ad Hoc query and Business Warehouse for HR data extraction, requiring expert business analysts to transform data and present reports. They seamlessly integrated Query Manager and Power BI into their SAP environment to revolutionise their approach.
From adopting Query Manager, to game-changing dashboards
The Sellafield team noticed common reporting patterns and increased demand for interactive dashboard-style reporting. They delved further into Query Manager's advanced features, automating reporting processes and scheduling queries. They introduced the Query Manager Analytics Connector Add-on, and explored Document Builder, giving them access to vital SAP data and improved reporting.
With heightened confidence, the team crafted a 'Line Manager Dashboard' aiming to:
- provide all line managers with employee data
- highlight areas requiring immediate attention (like missing timesheets)
- support day-to-day line management
- standardise elements of people data reporting, and
- reduce effort required to access information.
Line Manager Dashboards with personalised data views
The intention of the dashboards was to offer personalised data views, a novel feat in their organisation, and technically difficult. Despite the complexity, they mastered data modelling and Power BI development, creating a well-connected schema driven by Query Manager's scheduled outputs.
The positive reaction to this dashboard is a testament to their accomplishment. It offers tailored data views to relevant colleagues, and has propelled the organization's commitment to efficient, self-serve reporting solutions. In a short period, the integration of Query Manager and Power BI reshaped HR reporting for Sellafield, highlighting the benefits of this innovative technology.
