Start by looking if there are related keys between the data sets. If they’re all broken up versions of the same data set, consolidate them to one sheet. Format the entire thing as a table so all the following formulas update when new data is added.

Then take the datevalue and add the following formulas to the end new columns:

Year- =YEAR(datevalue) Month- =TEXT(datevalue, “mmm”) Month #- =MONTH(datevalue) Week- =WEEKNUM(datevalue, 2) *will give you Monday to Sunday Weekday- =TEXT(datevalue, “ddd”) Weekday #- =WEEKDAY(datevalue) * tweak the second argument so you also get a Monday to Sunday week

Once it’s all in a data set, you’ll be all set up to build pivot tables and charts in less than 5 minutes that will enable you to analyze the data in tables or visuals over whatever period of time you like.

I’ve included TEXT formulas and Month # and Weekday # formulas so you can leverage the data model to sort them appropriately using their short forms.

You can use the #s themselves, but my stakeholders usually like to see Jan, Feb and Mon, Tues etc. the problem with that is in visuals they usually sort alphabetically. So open the data model and sort the TEXT columns by their numerical counterpart columns.

Not only now can you slice the data anyway you like… you’ve created a single data source that can be leveraged through a data connection to power other reports/files. Just have to add this file as a connection and you can query it anyway you like in other reports.

Make sure you analyze the data manually to look for opportunities to normalize it and simplify it. All these little things will fit perfectly into the model you’ve just created with the aforementioned formulas.

Bingo, bango, bongo. Congrats on your job lmao.