We recently received a number of false/bogus reports on our hotline. Does anyone have experience or thoughts about how to process and ultimately determine a resolution for these kinds of reports that don't skew your year-end numbers and reporting?
Hi Debra - This is a great question. Here's my short answer: outliers need to be addressed during the Exploratory Data Analysis stage (when they are found) and wrangled/transformed once it is known more about them.
There will be instances that outliers need to be part of a report, and also when they need to be removed, standardized or replaced.
Filtering them out or replacing them with the average value of the data set are some of the ways to address outliers.
Data needs to be wrangled, cleansed, and formatted before doing a report. There are guidelines online about how and when to remove/filter outliers.
Meanwhile, an outlier might be an indicator of a new trend in a data, or a potential insight as well. It depends on the context. It all starts at the data source/input. User error, unusual circumstances, and data integrity, to name a few.
Hope this helps.
Ernesto Gonzales
commented
Oct. 19, 2023, 3:54 p.m.
Hi Debra - This is a great question. Here's my short answer: outliers need to be addressed during the Exploratory Data Analysis stage (when they are found) and wrangled/transformed once it is known more about them.
There will be instances that outliers need to be part of a report, and also when they need to be removed, standardized or replaced.
Filtering them out or replacing them with the average value of the data set are some of the ways to address outliers.
Data needs to be wrangled, cleansed, and formatted before doing a report. There are guidelines online about how and when to remove/filter outliers.
Meanwhile, an outlier might be an indicator of a new trend in a data, or a potential insight as well. It depends on the context. It all starts at the data source/input. User error, unusual circumstances, and data integrity, to name a few.
Hope this helps.
We recently received a number of false/bogus reports on our hotline. Does anyone have experience or thoughts about how to process and ultimately determine a resolution for these kinds of reports that don't skew your year-end numbers and reporting?
Hi Debra - This is a great question. Here's my short answer: outliers need to be addressed during the Exploratory Data Analysis stage (when they are found) and wrangled/transformed once it is known more about them.
There will be instances that outliers need to be part of a report, and also when they need to be removed, standardized or replaced.
Filtering them out or replacing them with the average value of the data set are some of the ways to address outliers.
Data needs to be wrangled, cleansed, and formatted before doing a report. There are guidelines online about how and when to remove/filter outliers.
Meanwhile, an outlier might be an indicator of a new trend in a data, or a potential insight as well. It depends on the context. It all starts at the data source/input. User error, unusual circumstances, and data integrity, to name a few.
Hope this helps.
Ernesto Gonzales
commented
Oct. 19, 2023, 3:54 p.m.
Hi Debra - This is a great question. Here's my short answer: outliers need to be addressed during the Exploratory Data Analysis stage (when they are found) and wrangled/transformed once it is known more about them.
There will be instances that outliers need to be part of a report, and also when they need to be removed, standardized or replaced.
Filtering them out or replacing them with the average value of the data set are some of the ways to address outliers.
Data needs to be wrangled, cleansed, and formatted before doing a report. There are guidelines online about how and when to remove/filter outliers.
Meanwhile, an outlier might be an indicator of a new trend in a data, or a potential insight as well. It depends on the context. It all starts at the data source/input. User error, unusual circumstances, and data integrity, to name a few.
Hope this helps.
I’m keen to connect with companies that have well established Speak Up / Whistleblowing processes.
We are good at reporting numbers and trends but I’m looking to develop this further to provide the So-What view. How do you bring all your data to life? Are you able to identify risks within the business? Do you report in a different way?
Would be great to hear from people.
I’m keen to connect with companies that have well established Speak Up / Whistleblowing processes.
We are good at reporting numbers and trends but I’m looking to develop this further to provide the So-What view. How do you bring all your data to life? Are you able to identify risks within the business? Do you report in a different way?
Would be great to hear from people.
A: Talk one-on-one with the employee and voice your concern for her. Tell her you’ve observed that some of her behaviors seem to indicate something is bothering her. Ask her if she is comfortable telling you what the issue is. Genuine human concern is key here. If she says there is no issue or she is not comfortable telling you, suggest setting up a meeting for her with someone in human resources or compliance so that she can unburden herself. Assure her that you are fine with whatever she has to say and that you will not retaliate or let other team members do so. And commit to addressing her issue if it is something within your responsibility.
A: Talk one-on-one with the employee and voice your concern for her. Tell her you’ve observed that some of her behaviors seem to indicate something is bothering her. Ask her if she is comfortable telling you what the issue is. Genuine human concern is key here. If she says there is no issue or she is not comfortable telling you, suggest setting up a meeting for her with someone in human resources or compliance so that she can unburden herself. Assure her that you are fine with whatever she has to say and that you will not retaliate or let other team members do so. And commit to addressing her issue if it is something within your responsibility.