The most common way to view construction schedules is through the use of the Gantt chart, where P6 schedules are generated and emailed to various stakeholders. Visualizations shown on the right side of the Power BI canvas Some of the visuals in this example dashboard include: The ability to display data and quickly generate insights is very valuable, especially for many in project management. Use the Gantt chart visual and create measures for simple schedule metricsĪfter getting the data and creating relationships in a data model, the final (and very fun) piece is to create visuals. What took hours or days to produce (what-if analysis for management) can now be reduced to sometimes under an hour. By linking lookup tables to data tables, you can create formulas that compare things like budget vs.
#WBS CHART PRO PORTABLE CODE#
#WBS CHART PRO PORTABLE HOW TO#
This was an important concept I learned with how to visually organize lookup tables and data tables, which made data modelling easier to learn with a clean and organized structure. One of the great things I learned was from Rob Collie in his book was that filters flow downhill.
![wbs chart pro portable wbs chart pro portable](https://i.ytimg.com/vi/vuLjFcY2uiI/maxresdefault.jpg)
![wbs chart pro portable wbs chart pro portable](https://d32fimaeovbd5u.cloudfront.net/wbs-chart-software-1.png)
Model view in Power BI desktop where relationships between lookup tables and data tables are created/managed It supercharges your analysis and allows you to create endless smart formulas.įor this example, we will create relationships between the activities tables and the following “lookup” tables: Power Pivot takes you from making Pivot Tables in Excel to making dynamic dashboards in Power BI. The real magic in Power BI is the ability to relate tables to each other – activity codes such as area or subcontractor can be linked to a list of activities.īill Jelen, founder of, says Power Pivot (the engine for Power BI) is the best new feature to happen to Excel in the last 20 years. Creating relationships between activities and activity codes The main benefit is this allows you to slice and dice your schedule data the same way as in P6, but using powerful visuals. This same process can be repeated for adding more activity codes from P6 and into Power BI. Power Query (Query Editor in Power BI) connected to an Excel file where the WBS activity code table is saved Filled down on each WBS level to re-create the WBS activity code outside of P6