There's no video on how the Data tab table was constructed. However, if you'd like to understand the WORKDAY.INTL function used in that tab, see this tutorial: https://www.myonlinetraininghub.com/excel-functions/excel-workday-intl-function

Hello. Thank you for your reply. I am mainly interested in learning more about the logic behind the Days Completed column in your table.  Why do we need that info to build the progress chart in the dashboard? Thank you!

Days Completed, is just one way to calculate the percentage of the project that is completed. How you go about calculating the Days Completed will be different for different companies, so I don't teach that.

Another way to calculate the percentage of the project that is completed could be to use number of tasks completed as a percentage of the total number of tasks, but you must keep in mind that some tasks will take longer than others.