Data Versus Information - Excel Analysis with Power Point
$10-30 USD
进行中
已发布将近 3 年前
$10-30 USD
货到付款
In this exercise, you will build your Excel, analytical and presentation skills. While this is an individual assignment, feel free to work within your analysis teams.
Dataset Background
Context
We are conducting an analysis for the Human Resource Department and leadership to help the organization understand why they are having turnover issues. Right now, there is too much data and not enough information. The CHRO and CEO need useful reports, fail to understand the difference between data and information, and would like multivariate analysis. The data set we are using was derived from Workday and the company's ERP's HR subsystems (Oracle and SAP).
About this Analysis
Why are our best and most experienced employees leaving prematurely? Have fun with this database and try to predict which valuable employees will leave next. Fields in the dataset include:
Satisfaction Level
Last evaluation
Number of projects
Average monthly hours
Time spent at the company
Whether they have had a work accident
Whether they have had a promotion in the last 5 years
Departments
Salary information by banded within roles
Assignment
Let's example the difference between data and information using a published dataset on https://www.kaggle.com. Create an account and locate the dataset for this project: ps://[login to view URL] (Links to an external site.)
Once you have located the dataset, identify whether or not the file is 1) data, 2) information or 3) both. Then import the data into Excel and create a comprehensive analysis to understand how the various forms of employee engagement affect satisfaction and their effect on turnover.
Create summaries by type of worker to provide meaningful information at the aggregate level. You will also need to match the output (s) below using Excel. Your assignment is to replicate the analysis and seek to add further insight, so that better HR policies can be adapted and turnover be reduced.
Deliverables:
Data Analysis Delivered Via Excel (see samples below). Grading for the first 200 points of the assignment is indicated within the parentheses.
Create an Index with macro enabled buttons (5%)
Ensure that each page has navigation buttons
Analysis by Gender (15%)
Analysis by Employee Identity and Role (15%)
Sensor Analysis (15%)
Conditional Analysis Using SumIf, CountIf and Average If (15%)
Geography Analysis (15%)
Freeform correlation and statistical analysis (20%)
This is your opportunity to demonstrate your critical thinking abilities by using advanced statistical analysis in Excel.
Visual analytics
Correlation between data fields
An advanced Power Point presentation to the CHRO and CEO. Be sure to include a thorough departmental analysis, but be careful to consider geographical considerations. You must embed Excel objects within PowerPoint wherever possible to avoid keying errors. Grading for the last 100 points of the assignment is based on how well you make an evidence-based argument and present solid recommendations.
OPTIONAL: If you are truly trying to advance yourself, include a multivariate analysis. Use SmartPLS to support your analysis. This part of the assignment will count as extra credit towards a future assignment.
Esteemed employer,
I hold a Master's degree in statistics making me a suitable person for your project. I have more than 3 years of professional experience in statistical analysis. Besides, I have skills in
Data Processing
Excel
Statistics
R Programming Language
Statistical Analysis
Kindly see my profile reviews to have an insight into what I will do for you.
Thanks.
EXPERT IN NAMED SKILLS,
OVER 18 YEARS OF EXPERIENCE,
DEAR EMPLOYER,
After KEENLY reading your description and being in possession of all CLEARLY STATED REQUIRED SKILLS as this is my area of PROFESSIONAL SPECIALIZATION having the above QUALIFICATIONS, i hereby humbly request you to consider my bid for QUALITY and PROFESSIONAL work.
THANK-YOU.
Hi , I will write a detailed report on your work experience. I am a Masters data science writer with 3 years of experience. I have worked on several similar projects including compiling dissertation projects and technical reports, and can deliver on tight deadlines.
I can generally deliver up to 10 pages of reports per day. I'm interested to hear more about the project and about the subject matter. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks! Handerson
HELLO DEAR CLIENT
I have gone through your project details and the work is DOABLE since its within my area of EXPERTISE.I will tackle are required guideline to deliver desired goal Please consider my bid. THANKS
Salutations,
I would be the best candidate for you.
With a background from data and Analytics I wold do best justice to the job's demand.
Regards,
Abhi
Hello sir
I have gone through your project details and I am just excited to work on this project. I might be good fit for this project. Please give me a chance to work with you.
Best Regards
Nandu
How are you?
I am a software and write. I have also lot of experience in Designing.
I have some rules and regulations before start of project:
1. Provide 100% work within deadline.
2. Provide unlimited revisions until employee satisfy 100%
The area of experties are:
skill is entry excel vba, macro Programmin
Thanks