You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

The agency typically updates its influenza data on a weekly basis, with reports containing compiled data on one site as opposed to the COVID-19 dashboard that is currently being used.

That will change starting next week when the state’s Department of Public Health will switch to reporting the commonwealth’s COVID-19 data weekly.

Semi-structured data is here to stay, and it offers the potential for business advantage to companies that know what to do with it. Mark Whitehorn has advice on how to do that.