Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Not difficult but ended up being a little more involved than I expected.
Spoiler
Process:
- Separate data to columns
- Clean-up and set data types
- Convert to proper date format
- Clean-up and Sort by Client ID and Date
- Determine Quarter for each client
- Extract Year from date
- Join with Cost data (join on Year)
- Calculate cost and revenue for each client and quarter
- Aggregate Revenue and Cost (group by quarter)
- Calculate profit margin
- Sort (desc)
- Separate data to columns
- Clean-up and set data types
- Convert to proper date format
- Clean-up and Sort by Client ID and Date
- Determine Quarter for each client
- Extract Year from date
- Join with Cost data (join on Year)
- Calculate cost and revenue for each client and quarter
- Aggregate Revenue and Cost (group by quarter)
- Calculate profit margin
- Sort (desc)
