Project Progress Status Report

Power BI
1

Hello everyone,

I have this Project status data which shows the status of the different projects, the resources available, the different status changes, and stages the process pass through.

What I am looking for:

1.What set metrics I may show for some who wants to understand the status/progress of the project? May be show me some ideas or a couple of sample charts that can provide an insight.

2.Calculate the status changes, probably to show the latest status? or to show the Status change in timeline or to show the highest and lowest change periods?

3.Show the Project risks as per the date changes against the actual project release and estimated completion dates?
please find sample Pbix and sample data.

Project Progress Status Sample Data.xlsx (14.0 KB)
Project Progress Status Sample.pbix (96.9 KB)

Thanks
Jojo

2

Bumping this post for more visibility.

3

Thank you for letting this post to be visible. Here is the output I’m looking for.

Output
Output2358×753 45.3 KB

4

All 3 Result Tables can be generated in Power Query by leveraging GroupBy feature.

To arrive at the Progress change Days, you can use Imke’s solution to retrieve the previous row value.
You can use Table.Max and Table.Min functions to create separate Farthest Progress Change and Quickest Progress Change tables respectively which can be merged to provide you Result 1.

Please find below my solution for your quick reference.

image
image1043×795 48.1 KB

Additionally, you might also want to consider separating the Project Metadata (Project ID, Project Title etc) to a Project Dimension table and Project Details (Project Stage, Project Status, Project Issues, etc) to a Project Fact Table to help optimize the model.
References:
Get Value from Previous Row using Power Query - Gorilla BI
How to Group By Maximum Value using Table.Max - Power Query (gorilla.bi)

Solution File
Project Progress Status Sample_Updated.pbix (105.2 KB)

2 Likes
5

Thank you so much for that detailed answer @pranamg and welcome to EDNA :slight_smile:

We hope this helped you @jojo.

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

6

Thank you so much @pranamg . This solves all my questions and It is explained in detail as well. Great references.