Challenge #417: Evaluation of Employee Working Hours
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Maveryx,
A solution to last week’s challenge can be found here. The inspiration for this challenge was submitted by Nathan Purvis (@DataNath) and was based on a Community discussion. Nathan, we appreciate your active participation in the Community!
March 31 marks the end of the first quarter of the year. During the following 2 weeks of April, your company is dedicating its time to evaluating their operational processes from the first quarter and suggesting improvements aimed at enhancing efficiency in the upcoming months.
The provided dataset contains information about the working shifts of all five employees, starting from their first day of work in January 2023 (not necessarily January 1), and spanning through March 31, 2023.
Your tasks for this challenge are as follows:
- Build a table that displays each employee's total shifts during this period, the number of shifts that exceed 4 hours, shifts below 4 hours, and total non-work days.
- For each employee, calculate the percentage of shifts that had fewer than 4 hours.
Bonus Question: In the event the company decides to expand its operations without bringing on new hires, which employee(s) (Employee_ID) should be considered for additional working hours?
If you need a little help, you can review these lessons in Academy:
Enjoy the challenge!
- Labels:
- Basic
- Core
- Data Analysis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
here's my take
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I didn't know about the Round() function handling portions of a percentage. Glad I didn't try to recreate that wheel!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator