How to Calculate Project Profitability Using Time Tracking Data

Calculating project profitability doesn't need to be complicated, but it does need to be done. Understanding how time spent, costs, and revenue all come together is the key to understanding whether or not your projects are profitable. And once you understand your projects' profitability, that paves the way to better understanding your team and company, and to making better business decisions.
- -
TUTORIAL CHAPTERS:
0:00 Introduction
00:43 Setting up spreadsheet
02:27 Adding a data model with Power Query
00:03:45 How to transform data
00:07:35 Use Power Pivot to analyze
00:08:05 Build profitability dashboard
00:09:28 Further analysis with slicers
- -
This tutorial shows you exactly how to calculate your project profitability using time tracking data and Microsoft Excel. You can read through this tutorial (complete with screenshots of every step!) right here: bsha.re/project-profitability

If you liked this video, don't forget to:
💡 Comment, like, & subscribe!
💡 Check out our playlist filled with more how to's and spreadsheet tips:    • How to Create an Employee Time Report...  
💡 Have a look at the other tutorials on our blog: bsha.re/tutorials