Data Cleaner

GARBAGE IN, GARBAGE OUT

Note: This feature is useful if Microsoft Entra ID is your primary source for user attributes. If your organization manages user attributes (e.g., job titles, departments, locations) through an HR tool or another third-party system, modifications in ServiceChanger may be restricted. However, you can always use it for read-only purposes.

The Data Cleaner feature helps organize and standardize user attributes in Microsoft Entra ID. It fixes inconsistencies in departments, job titles, and locations, ensuring everything is neat, uniform, and easy to manage.

By automatically updating user attributes across ServiceChanger and Microsoft Entra ID, this feature prevents errors, improves data accuracy, and keeps your access control structure clean.

---

How It Works

Data Cleaner gathers all unique values for departments, job titles, and locations from your Microsoft Entra ID users. When you make a correction or rename an attribute, it automatically updates all affected users, ensuring consistency across your system.

Instead of manually fixing mismatched or duplicate entries, Data Cleaner applies bulk corrections instantly, keeping your directory well-structured and easy to manage.

---

Examples of Data Cleaning in Action

Example 1: Department Renaming

A company has users listed under "Sales" and "Sales Netherlands", but they should all be in "Sales".

Before the Change:

• Users A, C, and D: Department - "Sales"

• Users B and E: Department - "Sales Netherlands"

Action:

• Rename "Sales Netherlands" to "Sales"

After the Change:

• Users B and E’s department is automatically updated to "Sales" in both ServiceChanger and Microsoft Entra ID.

---

Example 2: Job Title Correction

Some users have "Salesmanager" (without a space and proper capitalization), while others have "Sales Manager".

Before the Change:

• Users A, B, and D: Job Title - "Salesmanager"

• Users C, E, and F: Job Title - "Sales Manager"

Action:

• Correct "Salesmanager" to "Sales Manager"

After the Change:

• Users A, B, and D’s Job Title is now correctly formatted as "Sales Manager" across ServiceChanger and Microsoft Entra ID.

---

Example 3: Location Standardization

A user’s location is written inconsistently, once as "Barcelona", and once as "barcelona " (with a lowercase letter and extra space).

Before the Change:

• User A: Location - "Barcelona"

• User B: Location - "barcelona "

Action:

• Standardize "barcelona " to "Barcelona"

After the Change:

• User B’s location is updated to "Barcelona" across ServiceChanger and Microsoft Entra ID.

---

Why Use Data Cleaner?

✅ Ensures departments, job titles, and locations follow a standard naming format. ✅ No need to manually edit user attributes one by one. ✅ Clean and consistent data makes it easier to manage access and generate reports. ✅ Standardized data ensures users are grouped correctly and have the right access.

---

Conclusion

Keeping user data clean and structured is key to accurate access control and efficient management. The Data Cleaner feature helps maintain consistency in your Microsoft Entra ID attributes, ensuring they stay error-free.