Construction Project dashboard

[mim]

Hi Guys

just a sample Construction Project Dashboard for your cooments and suggestions 

https://app.powerbi.com/view?r=eyJrIjoiOThhMGRjNDYtZGIzZS00NGU2LWE5MTQtMmViMThlNjcxYTdiIiwidCI6ImI2Z...

cheers 

edit:

native PBIX here 

[SwaroopShankar]

Hi,

Could you please let me know what kind of table are you using in sheet 2? I need to get merged cells for one of my projects and this seems to be the only solution out there. 

Thanks in advance.

[SwaroopShankar]

Hi Guys,

I am still looking for a table that can handle merged cells. Please advise.

[mim]

@SwaroopShankar 

it is an ordinary matrix, just change the formating like this

[Rupendankhara]

Hello Mim,

I found your visual really facinating. I am construction tech enthusiast researching on opportunities in construction analyatics. You clearly are an expert in the filed and would ask for your advice. If one is to pursue a carrer in this field, what are the Job Titles normally require Power BI and Analyatics skills and also how are the opportunities for analyatics in construction industry. What other skills are required.

Thank you,

Rupen Dankhara

Rupendankhara@gmail.com

[LisaHoffer]

Will you please let me know what visualization you used on the "Tasks List" report (bottom of page 4)? It looks like this will work for a project I am working on tracking start/end dates and progress of the project. Thank you, LisaH

[mim]

Lisa

i am suing the gantt chart 

cheers 

[v-qiuyu-msft · Accepted solution]

@mim Tanks for your sharing. It would be better if we can check multiple values in the slicer visual.

Best Regards,
Qiuyun Yu

[mim]

thanks for that, i added a little arrow too as an indicator to show if the performance is as per target

[Habib]

@mim Why not you use KPI visual for Schedule and Productivity Factor. This way performance arrow will be taken care by Power BI it self.

[mim]

@Habib  i tried KPI visual, but i could not make it work to show the arrow, probably i am missing an obvious option 

[Habib]

It will not show Arrow but if you provide all parameters correctly espacillay target, it will give you auto formatting like showing the variance and using Green/Red colors. Also if you put time on axis, it will show trend as well..