DM-Employee
Employee Data Mart (DM-Employee)
About the Employee Data Mart
The DM-Employee data mart consolidates employee information from multiple source systems into a structured, reporting-friendly format optimized for PowerBI and other reporting tools. This data mart provides comprehensive coverage of employee data including demographics, employment details, benefits, payroll, and more.
Key Benefits and Features
When you use this feature, you gain:
- Consolidated employee information from multiple sources in one place
- Optimized data structure for PowerBI reporting and analysis
- Comprehensive coverage of all employee data domains
- Simplified access to complex employee information through views
- Regular data refreshes aligned with business cycles
- Built-in data quality and validation rules
- Standardized data transformations and business rules
- Integrated payroll and benefits information
- Historical tracking of employee changes
- Compliance-ready data structure
Common Use Cases and Scenarios
Use this feature to:
- Create HR dashboards and reports in PowerBI
- Analyze employee demographics and trends
- Process and validate payroll information
- Track position and organizational changes
- Monitor employee skills and certifications
- Generate compliance reports
- Access consolidated employee views
- Validate benefit enrollments and deductions
- Review historical employee information
- Perform workforce analytics
Data Refresh Schedule
- Employee Data: Daily updates
- Position Changes: Daily updates
- Benefits Data: Weekly updates
- Payroll Data: Bi-weekly updates (aligned with pay periods)
- Full Validation: Monthly refresh
Best Practices
- Use provided views when possible
- Consider data refresh timing when running reports
- Implement appropriate security filters
- Test with representative data volumes
- Verify data completeness before analysis
- Follow recommended validation procedures
Table Documentation
Core Tables
Position Tables
Benefits Tables
Key Views
Employee Information
- Core.EmployeePersonalDataView - Consolidated personal information
- Position.PositionOrgDataView - Position and organizational details
- Position.EmployeeHistoryView - Historical employment information
Financial Information
- Payroll.CompensationFinancialView - Payroll and compensation data
- Benefits.BenefitsTimeOffView - Benefits and leave information
- Core.EmployeeSummaryView - Comprehensive employee dashboard
Support and Resources
- For data discrepancies: Submit ticket to HR Data Team
- For access requests: Contact your supervisor
- For technical issues: Contact IT Support
- Documentation: See individual table documentation
Related Resources
- IWUDATA Datamarts
- PowerBI Report Templates
- Data Dictionary
- Security Guidelines