Skip to main content
Indiana Wesleyan University Support Knowledge Base

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

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
  • Was this article helpful?