Microsoft Power BI for Project Planning and Control

Microsoft Power BI for Project Planning and Control -ENGLISH

If you are working in the project management field and interested in MICROSOFT POWER BI and always need to have insight into the project progress, you are in the right place.

What you’ll learn

  • explain the main tools.
  • how to link you project data direct from primavera or excel.
  • draw cash flow & s-curve.
  • learn advanced options in power queries and DAX formula.
  • create interactive reports to show the project’s status.
  • create public link and share it with your colleague.
  • how to solve the expected issues during using the app.
  • explain how to add a the project layout in smart way.
  • update the report during the project duration.

Course Content

  • Introduction –> 7 lectures • 56min.
  • how to use the tools to make the dashboard (new) –> 14 lectures • 2hr 13min.
  • Update the project(new) –> 9 lectures • 1hr 34min.
  • TIPS &TRICK –> 2 lectures • 17min.
  • direct connect to primavera –> 2 lectures • 24min.

Microsoft Power BI for Project Planning and Control

Requirements

  • the basic skills in using excel and primavera.

If you are working in the project management field and interested in MICROSOFT POWER BI and always need to have insight into the project progress, you are in the right place.

The POWER BI has become one of the most important tools to analyze and visualize the data, many companies use it with the project, program,  portfolio, and entire organization because it facilitates the connection between thousands and millions of data and represents it in an interactive dashboard.

One of the best advantage of this program that there is a free version available without limited time, also Microsoft make an update every month and adding more new feature which will support your work.

Why you purchase this course? the answer is, this course builds on actual work experience in using this app in the construction field and it includes the best practice to put you on the right track, also I provide frequent updates.

——————————————

Through this course, we will go gradually in using the app starting with the main tools and tabs by using the demo file with the app.

And of course, we will learn how to download the free version and create an account and a free domain to signup if you don’t have a company account.

Then we will start directly using one of the project samples in Primavera and see how to export the data to EXCEL and connect it with the POWER BI.

and we know your time is very important, so we will learn the tools and visual in the practical example directly without wasting your time, and these skills include for e.g:

  1. linked Primavera and excel with the POWER BI. 
  2. how to edit the tables and data in POWER QUERY
  3. create DATE TABLE  and the related functions and DAX formula to facilities the link with other tables. 
  4. export the cash flow & s-curve from the primavera and the visual related to it. 
  5. export the resources from primavera and apply the UNIPIVOIT on the data to integrate it in the dashboard. 
  6. the different types of filters and how to deal with them. 
  7. the different types of relationships and how to use them. 
  8. how to make an index in the POWER BI for the different types of data. 
  9. how to reflect the updated time schedule
  10. how to show the progress image in interactive ways. 
  11. solving the comment issues while using the app. 
  12. use the SYNOPTIC PANAL to add key plans and layout from AutoCAD after some adjustment to represent the project status. 
  13. using the different KPIs
  14. Share the dashboard with an online link with your manager

in addition to many tools to be professional users in this app.

———————————–

Welcome to my course in advance and don’t hesitate to contact me for more information, you can find my linkedin with my profile

 

I create a Facebook group to keep up with the updates and the issu

 

 

Get Tutorial