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 …
I’ve had several requests on “what is the fastest and easiest way to create graphs in Excel without using Pivot Tables or Pivot Charts?” Well, the answer is quite simple. Have a look at the quick tutorial below. We will be creating a graph that represents the number of employee terminations for a given year. Firstly, create a summary …