Data Quality and Reporting for a Small Fitness Studio Chain
FlexFit Studios is a chain of 5 fitness studios with 3,000 members. They use Salesforce to track members, memberships, and attendance. They have custom objects for Classes and Attendance. The membership object has fields for start date, end date, and status. However, they have data quality issues: 20% of members have missing email addresses, and 15% have inconsistent status (e.g., active but end date in the past). They want to build a dashboard for the owner to see active members, revenue, and attendance trends. They have Sales Cloud Enterprise and two licenses. They are considering hiring a data analyst or using native Salesforce tools.
1. What is the most effective way to clean the data and ensure ongoing data quality with native tools?
Read the worked answer
Reasoning: The data quality issues are missing emails and inconsistent status. Native tools include validation rules, duplicate rules, and data quality dashboards. For missing emails, they can set a validation rule to require email on new records, but for existing records, they need a data cleanup effort. They can use reports to find members with missing emails and then update via data loader or inline editing. For inconsistent status, they can create a formula field to flag mismatches (e.g., if status = 'Active' and end date < TODAY(), then flag). Then run a report and update statuses. To prevent future issues, add validation rules: email required, and status cannot be Active if end date is past. Also, consider using Flow to auto-update status when end date passes. For ongoing quality, schedule a weekly report of data issues. They should also use duplicate rules to prevent duplicate members. Since they have Enterprise, they have validation rules and workflows/flows. They might need to use data loader for bulk updates. Hiring an analyst is not necessary if they use native tools and assign a admin to monitor.
2. How should they design the dashboard to accurately reflect active members and revenue, given the data issues?
Read the worked answer
Reasoning: The dashboard must be based on clean data. Before building, they must resolve the status inconsistencies, otherwise active member counts will be wrong. They should first clean data, then build reports. For active members, use a report on Members with Status = 'Active' and End Date >= TODAY(). For revenue, they need a custom object or field for payments; if they don't have it, they might need to create one. Assuming they have a related Payments object, they can sum revenue. For attendance trends, use the Attendance object. The dashboard should include: Active Members count, Revenue this month vs last, Attendance by week. They should also include a data quality component: count of members with missing email or inconsistent status. Use report filters to exclude incomplete records or flag them. They should schedule the dashboard refresh daily. Since they have two licenses, the owner and an admin can access. They should also consider using Salesforce Reports and Dashboards (native). They might need to create summary reports. The key is to clean data first, then build reports with filters that account for data quality, and include a data quality metric to monitor.