In this tutorial we’ll have a look at the process required for the creation of a scatter plot, in order to visualize employee utilization data. Scatter plots can be daunting at times, but the steps outlined in this tutorial are easy to follow and should have you plotting in no time. For this example. we’ll …
Need to shorten time spent on endless reporting? Using multiple systems to manage discipline within your organization? Stop!! Grab a copy of our free Disciplinary Management Template here: Free_Template and manage all your Disciplinary Matters in one place. ———————————————————————————————————- A few notes on using the Template: Step 1: Ensure that your Employee Data is up to date …
What exactly is “Relation Data”? The easiest way to understand relational data is to refer to your very own South African ID number. Your ID number plays a central role in your everyday life. Your name, surname, race, gender, bank accounts, home address, clothing accounts and many other aspects of your life, somehow “relate” to …
You’ve been struggling for weeks to create the perfect Employment Equity Dashboard. After countless hours, infinite cups of coffee, blood, sweat and tears, you’re finally ready to present your Dashboard to your management team. You muster up the courage. You click the send button and of it goes. Within minutes you receive your first response…”Please …
Before we get started: You can download the Excel source data for this tutorial here: EE_Source_Data If you are not familiar with Employment Equity documents, legislation or processes you can find more information from the links below: Employment Equity Act EEA 2 – Employment Equity Report EEA4 – Income Differential Statement EEA9 – Occupational Levels Disclaimer: All information contained …
Whether you’re a novice in the field of people analytics, or a seasoned expert with countless years of experience, the one thing you’ll need to show off your exceptional skillset in data analytics is Data. I’ve compiled a free Excel Workbook that contains prepopulated, randomized Human Resource (HR) data for the following categories: Organizational Structures (Finance, HR, Production, etc.); Generic Employee Data – for …
Measuring employee turnover doesn’t have to be a nuisance. This post provides you with two free templates and a short tutorial on how to measure a few aspects associated with employee turnover. ———————————————————————————————————- In Part 1 of this 2-part series we had a brief discussion about the definition and application of Data Analytics, especially in …
Data is everywhere. In your pocket, on your phone, your laptop, your watch, heck, even your car. But what to do with all this information? The simplest answer, Analyze it. The more complex answer, Analyze it. ———————————————————————————————————- Disclaimer: This is not an in-depth post on every aspect of Data Analytics, purely due to the large scope of Data Analytics. My aim with this post …
I’m clearly a one hit wonder fan… (A little side note: You might have to zoom in and out a bit every now and again. Some of the images in this tutorial contain quite a bit of data) Whenever I mention the words Pivot Table a deafening silence tends to fills the room with eerie echos bouncing of …
“Susan” works for the Learning and Development Department at her Company as a Learning Database Administrator. As part of her daily duties she is required to not only track daily progress of learning interventions, but also supply various Senior Managers with a range of different reports. “Susan’s” predicament is that she uses only a single …