WIXLIB

ABX MEDIAOpenReportWareData QualityScorecard10 Responses

OpenReportWare Data Quality Scorecard / ABX MediaABX MEDIAHow to Use the ScorecardOpenReportWareThe Data Quality Report is designed to help you understand, assess and improve key organizational dataquality issues. Instructions on each page will help you understand the data and what you can do about it.Data Quality Scorecard ContentsOnce you have consumed the report yourself, Info-Tech recommends the following discretionary steps:OpenReportWare Data Quality Scorecard3OpenReportWare Department Summary4OpenReportWare Training View5OpenReportWare Comments61. Share Results with Your Data TeamWalk through this report with your team. Cover overall results and key areas, encouraging them to review thefull report if interested. Beyond understanding the data, communicating the importance of measuring andimproving business satisfaction with data quality is critical.2. Provide Training as RequestedUse the Training View to book training immediately for interested business leaders and teams. Work withyour team to establish who should lead each training session.3. Communicate Results and Planned Action with Business LeadersShare this report with executives or the management stakeholder (group) ultimately concerned with theeffective use of organization data. Highlight key issue areas, proposed solutions, and get direction on goalsand issues to address.4. Determine Key Applications and Quality Issues to TargetUsing the data, management preferences, and input from your team, determine where to focus improvementefforts.5. Create & Execute a Business Leader Engagement PlanUsing the data in this report, work with your team to determine key stakeholders who require better dataquality. Assign a manager for each relationship and plan out meeting objectives and frequency. Engageindividual business leaders around their data needs. Use individual Department Scorecards, ApplicationScorecards and Comments as a conversation starting point.6. Execute Targeted Data Quality ImprovementsPull together improvement initiatives from your team, executives and stakeholders. Create plans forundertaking them and have your team begin to execute them.7. Repeat this Program as NeededComplete this program annually or as desired to measure and communicate improvement, as well as receiveongoing feedback.2

OpenReportWare Data Quality Scorecard / ABX MediaOPENREPORTWAREData QualityScorecard69%ClarityHow satisfied are you that thedata in this application isclear. Data is easy tounderstand and interpret.DEGREE OF SATISFACTIONSATISFACTIONSatisfied72%HygieneHow satisfied are you thattime-dependent activities (e.g.tasks, cases, jobs) areappropriately managed tomaintain data cleanliness andquality.DEGREE OF SATISFACTIONSATISFACTIONSatisfiedUse this Application Scorecard to understand how satisfied respondents are with Data Quality across 10dimensions.NeutralNeutralFollow up with respondents from the department to better understand their concerns. Ensure you workclosely with this application's owner or assign one if there is no owner.NotSatisfiedNotSatisfiedFor each satisfaction breakdown:“Satisfied”: 8/10 or above.“Neutral”: 7/10.“Not Satisfied”: 6/10 or below.How satisfied are you that thedata in this application isaccurate. Data values arecorrect and accurately reflectreality.Owner Martine LerouxDepartments Using IT, Sales, Marketing .68%ConfidenceHow confident are you withthe quality of the data found inthis application?DEEGREE OF CONFIDENCESATISFACTIONConfidentDEGREE OF SATISFACTION79%DEGREE OF SATISFACTIONImportantSatisfied72%DEGREE OF ed72%DEGREE OF SATISFACTIONEntryQualityHow satisfied are you that thedata in this application is easyto enter. Quality andappropriate validation of dataentering applicationsSatisfiedCompletenessHow satisfied are you that thedata in this application iscomplete. All required data iscaptured, and no data sfiedNotSatisfiedSATISFACTIONDEGREE OF SATISFACTIONNotSatisfiedNotConfidentDEGREE OF IMPORTANCEHow satisfied are you that thedata in this application isavailable. Appropriate dataand report security and lCurrencyHow satisfied are you that thedata in this applicationis current. Data isappropriately up-to-date, How important is the data inthis application to deliveringbusiness results?78%AccuracySATISFACTION79%UniquenessHow satisfied are you that thedata in this application isunique. Each data element iscaptured in one spot, notduplicated across multiplefieldsDEGREE OF tralNotImportantNotSatisfiedNotSatisfied3

OpenReportWare Data Quality Scorecard / ABX MediaOPENREPORTWAREEnterprise applications are used across the organization. Use this page to understand how data quality satisfactionfor this application varies by department. Identify low satisfaction departments to determine if there are patterns orspecific issues that can be addressed. Follow up with respondents as appropriate.Department SummaryITSALESScorevs. Org.AverageConfidence80 %12 %Importance82 %ClarityMARKETINGScorevs. Org.AverageConfidence40 %28 %4%Importance100 %14 %70 %1%Clarity63 %Accuracy82 %4%AccuracyCurrency76 %3%Completeness78 %HygieneRESEARCHScorevs. Org.AverageConfidence90 %22 %Confidence70 %2%Importance90 %4%Importance60 %26 %6%Clarity70 %1%Clarity80 %11 %73 %5%Accuracy80 %2%Accuracy70 %8%Currency73 %6%Currency100 %21 %Currency90 %11 %6%Completeness63 %9%Completeness80 %8%Completeness60 %12 %74 %2%Hygiene67 %5%Hygiene90 %18 %Hygiene60 %12 %Availability86 %11 %Availability57 %18 %Availability70 %5%Availability80 %5%Entry Quality70 %2%Entry Quality67 %5%Entry Quality100 %28 %Entry Quality70 %2%Uniqueness78 %1%Uniqueness77 %2%Uniqueness90 %11 %Uniqueness80 %1%Scorevs. Org.Average4

OpenReportWare Data Quality Scorecard / ABX MediaOPENREPORTWARETraining ViewHow to Use this InformationOften data and reporting issues can be resolved through training aloneand require no technical or process-based solution.Providing training is something you can do right now to improvebusiness satisfaction and help your stakeholders get the most out ofdata and reporting.RESPONDENTS REQUESTING TRAININGRespondentEMAILDEPARTMENTCOMMENTSDiego Fernandesdfernandes@abxmedia.comSalesData entry is difficult. Sales people need better training on how to updaterecords to keep things current.Leah Holmviklholmvik@abxmedia.comSalesOnboarding new employees isn't very efficient. We could use a basicintroduction to the software as people join the department.Alan Smitheealansmithy@test.comSalesCustomizing our existing report set, and creating new ad-hoc reports.Use this information to book training sessions immediately. This is aquick win and there is no reason to wait.Use the attendee lists provided when booking the training. Read eachcomment to determine specific training needs, or if there are specificrequests or concerns from stakeholders.If anything in the comments or attendee list seems out of the ordinary,follow up with respondents directly to understand their needs andresolve the issue.5

OpenReportWare Data Quality Scorecard / ABX MediaOPENREPORTWAREUse this sheet to understand key data quality issues as expressed by individual respondents. Look for recurringthemes in the comments to identify high priority issues. Follow up with individual respondents as needed based ontheir role and/or the content of their response.CommentsDiego FernandesSalesImportance10 ConfidenceLeah HolmvikSales3ImportancePhillip FehrIT10 Confidence3Miroslav ShubinITImportance8 Confidence9Importance9 ConfidenceMost Important Data ElementsMost Important Data ElementsMost Important Data ElementsMost Important Data Elements1 - SALE STATUS 2 - PROSPECT STATUS1 - CONTACT PHONE NUMBER1 - CLOSING DATE The closing date1 - CLIENT EMAIL ADDRESS 2 - AVERAGE SALE PRICE3 - YEAR-OVER-YEAR/QUARTER-OVER-Q 2 - CONTACT TITLE Useful to know if the person is a decision-maker2 - AVERAGE SELLING PRICE The average selling priceMost Error-Prone Data ElementsMost Error-Prone Data Elements1 - CLIENT CONTACT INFO Doesn't stay up to date1 - SALE CLOSE DATE We often use fake values when logging a sale then2 - SALE STATUS Doesn't stay up to date3 - PROSPECT STATUS Doesn't stay up to dateRoot CausesClear6Sometimes need someone to tidy a reportAccurate6Find at least one problem a dayCurrent5Don't keep close track of client contact infoComplete3Often difficult to find what I needHygiene4Hard to update so sometimes doesn't happenAvailable6Getting access for new people is a problemEntry Quality 3Hard to update so sometimes doesn't happenUniqueHard to update so sometimes doesn't happen9Unmet NeedsWant to more easily identify sales opportunities through prospect funneland client late in contractdon't go fix them3 - CLOSE RATE The closing rateMost Error-Prone Data Elements1 - CLOSED DATE The closing dateRoot Causes2 - AVERAGE SELLING PRICE The average selling price3 - CLOSE RATE The closing rateIt is very difficult to get the specific values andreports we're looking forMost Error-Prone Data Elements1 - CLIENT TITLE We almost never keep these up to dateRoot y Quality 5Entry Quality 8Available9UniqueUniqueEntry Quality 8Getting permissions for new employees is veryslow8Unmet NeedsBreakdowns of sales by client industryRoot CausesUnique98We often have to go back and fix values thatshow up in reports10Unmet NeedsNothing major is missingUnmet NeedsSometimes there is duplicate data6

OpenReportWare Data Quality Scorecard / ABX MediaOPENREPORTWAREUse this sheet to understand key data quality issues as expressed by individual respondents. Look for recurringthemes in the comments to identify high priority issues. Follow up with individual respondents as needed based ontheir role and/or the content of their response.CommentsAlan SmitheeSalesImportanceIolanda RizzoMarketing10 Confidence6ImportanceJane DoeIT9 Confidence9Alberta WarrenITImportance8 ConfidenceMost Important Data ElementsMost Important Data ElementsMost Important Data Elements1 - ASSIGNEE The person doing the work1 - CONTACT TITLE 2 - CLIENT INDUSTRY 3 - SALES HISTORY1 - ASSIGNEE The person doing the work2 - DATE TASK COMPLETED As long as it's within the same week, slightdifferences are OKMost Error-Prone Data Elements1 - ASSIGNEE The person doing the work. This is sometimes bulk updated,so not always accurateRoot CausesClear9Accurate8CurrentComplete8We're always up to date by the end of a week.7My department is up to date, but I'm nevercertain other divisions follow the Hygiene9Available5Some sales reports, especially forecasting,should be locked-down to director Entry Quality 9Unique6Unmet NeedsWe need better sales forcecasting. I don't know if this is a product limit orjust something we haven't built.Most Error-Prone Data Elements1 - CUSTOMER INDUSTRY 2 - AVERAGE SALE PRICE2 - LOCATION The location the work was captured at3 - SEGMENT The business segment the data was captured forMost Error-Prone Data ElementsRoot Causes1 - TIME OF ENTRY Bulk data operations later sometimes have the wrongvalue for this automatically gen Clear7still needs more work when I get reportsAccurate8good but sometimes roundedCurrent10Complete8Hygiene9Available7Root CausesClear5Accurate10Current9Complete7Relations between datasets are understandablycomplexonly a few minor missinghave had problems getting reports for the rightpeopleEntry Quality 10Unique99Unmet Needsseeing sales from partner connections versus direct salesHygiene5Available108 Confidence7Most Important Data ElementsMost Error-Prone Data ElementsRoot lable8Entry Quality 7We could do better at timely data entry. Bulkupdates sometimes occur and thi Unique6Unmet NeedsEntry Quality 8We could do better at timely data entry. Bulkupdates sometimes occur and thi UniqueWe could do better at timely data entry. Bulkupdates sometimes occur and thi 8ImportanceNoneUnmet NeedsStandardized automatic daily reporting, eliminating some of the ad-hocreports we create. It's a problem when different versions with differen 7