https://moderndive.com/data/le_mess.csv
.Write an R Markdown file containing (1) the above outputs, (2) all R code used, and (3) explanations for each part of your code.
This assignment is really more of a mini-project. As such, it is worth 2 homework assignment grades.
Your homework comes from my real life. I do some work as a freelancer, including for a holding company that owns several smaller manufacturing companies (often called “business units”). These business units all have separate computer systems, so they all generate reports of different formats. It’s my job to parse these different reports, aggregate the data, and show a dashboard that helps executives make decisions.
Obviously I can’t share their real data, but I’ve created some synthetic data that is somewhat similar (and greatly simplified). That Excel file contains 5 sheets. The first 4 simulate output from each company, e.g., sheet “A” contains sales for each day of 2022 for a business unit called “A”. The last sheet, “company_info”, contains some info about each business unit.
Your job is to produce a report for executives of the holding company. At a minimum, your report should contain:
Throughout this assignment, you may NOT hard-code any data. For example, you cannot directly type in the number of employees for a business unit. You must read it from the Excel file using R.
Write an R Markdown file containing (1) the items above, plus anything additional you’d like to focus on, (2) all R code used, (3) explanations for each part of your code, and (4) an executive summary providing high-level details and summarization that an executive would be interested in. The executive summary should come first.
After knitting, print out the document and hand it in on Wednesday, October 11, 9:00 AM.
This homework will require you to look up additional packages and functions.
realxl
package and the associated real_xlsx
function.mutate
.rbind
function.lubridate
package.