Canadian Payroll Reporter - sample

6 Canadian HR Reporter, a Thomson Reuters business 2018 News October 2018 | CPR Do you know your organiza- tion's current headcount? Do you know the turnover rates by department? By using analytics, these types of questions can be answered in less than 30 seconds. Having the right analytics so- lution will help you answer these questions quickly, allowing your teams to make the most out of the data that is already in your systems. By using analytics to find the data to support many decisions your business needs to make, you will consequently work much smarter and save a lot of time. There are two types of analyt- ics tools being used by organi- zations today: descriptive and predictive. Descriptive analytics, often referred to as Business Intelli- gence or BI, is used by many large organizations and has become an essential tool for payroll and HR departments in both small and medium-sized businesses. It presents information about what is or was happening within an organization over a specific period of time. The data is pre- sented through a series of in- teractive graphs or tables often grouped within dashboards. These visuals can be filtered, providing timely answers to "was" or "did" questions such as, "Was the cost of overtime this year the same as last year?" Predictive analytics uses past data to predict future trends or outcomes, given a set of rules. Predictive analytics for busi- nesses is becoming more com- mon over the last five years in medium to large organizations and requires large data sets and the right probability rules to develop statistical relationships that can be turned into accurate predictions. Predictive analytics will help you find answers to "when" or "will" questions such as, "When will overtime costs be high enough during the year to justify a new hire?" Analytics can be used in a number of ways to help answer a wide range of questions about your workforce, from simple to complex. Let us explore some of the benefits, tricks, examples, and approaches you can employ within an analytics tool to effi- ciently get answers: 1. If you are accustomed to traditional reporting, start to use analytics by choos- ing your favourite report(s). Next, apply the appropriate filters, set a bookmark to re- member your filters, and ex- port your report(s). The next time you need the report, just recall your bookmark, and review or adjust the filters to ensure they are accurate. You can then export your updated report. 2. If you spend time today creat- ing reports for management on a weekly or monthly ba- sis, you could use analytics to schedule the reports to be au- tomatically run and emailed to your management team on a regular basis so you do not have to perform this task every week or month. Just imagine how much time you will save with this functional- ity alone. 3. Instead of waiting for a report to run when you only need two numbers from it, use an- alytics to find the two num- bers directly, without export- ing your data to a spreadsheet or printing the report. 4. Easily answer management's "why" questions. For exam- ple, let us say your vice-pres- ident asks you, "Why is over- time over budget?" with no other information to provide context. You can use analytics to first find out which depart- ment has higher overtime than normal, then, which employees are working over- time. You can then check on the turnover rate for that de- partment to see if the reason is due to those employees covering for two employee positions that have not been filled yet. After a quick dis- cussion with the manager of the department to confirm the reason for the overtime, you can report your findings to your vice-president. 5. When you are asked to create a new report for your man- agement team, take an itera- tive approach. Invite mem- bers of the team to join you for a few minutes and draw them a sample of the report they want. Ask questions about the data and how they want it represented, such as what columns to include in a table; how to group and sort the data; do they want to see bars or line graphs; what time periods and filters need to be applied? Having them see your drawing of the report and reacting to it will get you to the final version much fast- er than relying on their writ- ten description of what they have in mind. 6. For members of your manage- ment team who are interest- ed in using analytics instead of receiving just monthly reports, set up a dashboard just for them with the reports they regularly need. They can use analytics to find their own answers to their questions at any time, rather than waiting for a report to be emailed, or asking you "why" questions. Analytics allows for staff to be empowered with informa- tion at their disposal, while managing the data they have permission to see. 7. While analytics can be used to recreate your previous reports, that is not its true power. Instead of recreat- ing the same report, ask the recipient if they still need it, and if so, what portion of the report do they consistently use? Do they just flip to the bottom and use the totals? Do they just want to see data for one department? Do they just look at the last month or quarter? Analytics should have the flexibility to create a report that shows them the data they actually need, when they want it, and in the for- mat they can use, along with allowing you to be more stra- tegic with your time. 8. Reduce the number of spread- sheets in your organization by using analytics to combine data together. For example, use or create a report that combines your payroll costs with HR performance rat- ings and absence manage- ment data. This will help to determine the cost to your organization for employees who are possibly disengag- ing based on their number of sick days and trending lower performance ratings. Analyt- ics should be able to combine this data into one report rath- er than exporting and com- bining it in a spreadsheet. 9. Analytics can be used to de- termine if your data is accu- rate. Look for anomalies that might indicate data input or configuration errors, or even possibly fraudulent data. Quickly spot the issues and fix the underlying data to im- prove trust in your systems. 10. Reports that are not produc- ing accurate results may be due to missing or inconsis- tent data within your sys- tem. Use analytics to find out where there is missing data and then add or correct the information in your systems. If you find that too much data is being produced in your current systems today and you struggle to find answers using traditional reporting tools, it would be a great idea to investi- gate an analytics solution. Ana- lytics' essential value is in ma- nipulating large amounts of data to find answers quickly. Just as search engines allow you to find answers to your questions on the internet, analytics can give you the confidence to quickly find answers in your data. It is important to take the time to understand how these analytics tools drive value for your business. Much more than a series of intuitive charts and graphs, an analytics solution will provide insight into your organi- zation's performance and enable you to make informed, timely and data-driven decisions, and save you time. Myles Halliday is the vice- president of Product Management at Payworks, based in Winnipeg. He is responsible for understanding the product needs for payroll and human resources practitioners, and helps to create innovative workforce management products for Payworks clients, including solutions for payroll, human resources, analytics, and employee time and absence management. Analytics enable timely, data-driven decisions from DATA on page 1 News

• Cover