Data Analyst Portfolio
HR analytics is the process of collecting and analyzing Human Resource (HR) data to improve an organization’s workforce performance. The process can also be referred to as talent analytics, people analytics, or even workforce analytics. This method of data analysis takes data that is routinely collected by HR and correlates it to HR and organizational objectives.
The data set that I used is a CSV file supplied by Kaggle, which is created by IBM data scientists. The dataset is trying to determine some of the causes of attrition among employees or what could cause them to leave. The types of data include metrics such as education level, job satisfaction, commute distance, income per month, and other categorical data.
Employees are the backbone of the organization. Organization's performance is heavily based on the quality of the employees. Challenges that an organization has to face due employee attrition are:
1, Loss of experienced employees
2, Expense in terms of both money and time to train new employees
3, Impact on productivity
4, Impact on Profit
1, What factors are contributing more to employee attrition?
2, What type of measures should the company take in order to retain their
3, Will the model save lots of money?
4, Which business unit faces the attrition problem?
Project 2: Factors That Drive House Prices
In this scenario, I am working as an Analyst at an investment bank. The team that I am working with wants to understand how it should allocate dollarsearmarked for investment into mortgage backed securities. They have asked me to look into the factors that drive home prices. The original data am working with comes from kaggle which is known as the Ames housing dataset was compiled by Dean De Cock for use in data science education.
Project 3: Lariat Rental Car Business Analysis
Created Excel model to help make data informed decisions about car fleet, based on the observed costs and revenue data from the fleet in recent years. Built using Excel for analysis and PowerPoint for storytelling and presentation. Applied different techniques and visualization to clearly communicate insights that inform decision making by creating baseline calculation tables, plotting pivot charts and filters to summarize data to create a business strategy model to maximize gross revenue.