Microsoft Power BI for Project Planning and Control

Microsoft Power BI for Project Planning and Control -ENGLISH

4.25 (101 reviews)
Udemy
platform
English
language
Microsoft
category
350
students
12.5 hours
content
Nov 2023
last update
$119.99
regular price

What you will 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

Description

**to get the latest update or offer, contact me on my WhatsApp (+966567692010) or , my email (mohamed.aboadma90@gmail.com)

Are you a project manager or Planning Engineer who wants to learn MICROSOFT POWER BI and gain insights into your project progress? If so, you have come to 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.

What makes this course different? It is based on real-world experience in using this app in the construction field. It also includes best practices that will guide you to success. And I keep it updated regularly.

------------------------------------------

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 visuals 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 issue




Content

Introduction

download free power bi desktop
walk through part 1, get data
walk through 2, queries
walk through part 3 , insert /visualisation /filter
walk through part 4 ,modelling /new columns & measures
walk through part 5 , view menu
1.3-publish to web

how to use the tools to make the dashboard (new)

import from primavera through excel part 1
import from primavera through excel part 2
use (cards) to display specific data
show project duration ,make new columns and enter data
use different type of (slicer )
make donate and pie chart
maintain the project duration progress (elapsed and remain ) using DAX
cash flow & s-curve (line and stacked column )
Create date table using DAX functions
Get the weekly planned using DAX ( DATESBETWEEN +DATESINPERIOD +CALCULATE)
Unpivot table ( distribute horizontal data to virtual rows )-get planned Qty
Index the data +drill through
Manage relationship options
Manage filters

Update the project(new)

Reflect P6 update on power bi (Activities) ,SPI ,CPI ,PROGRESS
WBS levelling
The matrix visual
UPDATE THE S-CURVE , CASH FLOW & project status
KPIs & condition formatting
update the casting Qty vs planned +new DAX formula part 1
update the casting Qty vs planned +new DAX formula part 2
use synoptic panel to show the project key plan

TIPS &TRICK

solving the most common issues
Show the images in smart way

direct connect to primavera

setup the connector
import the tables from primavera

Screenshots

Microsoft Power BI for Project Planning and Control - Screenshot_01Microsoft Power BI for Project Planning and Control - Screenshot_02Microsoft Power BI for Project Planning and Control - Screenshot_03Microsoft Power BI for Project Planning and Control - Screenshot_04

Reviews

Zubair
August 19, 2023
wonderful course, The Instructor was really supportive May be the only course on this platform who have explained the DAX Formula's in this much detail. Thank You for this wonderful Course..
Razme
July 17, 2022
This course give sound knowledge to do our work very quick and professional way to present the data as well as this course full fill what I expected.
Kasim
March 17, 2022
Highly educative and really impressed about the way you teach of high standard.. it really gives me courage to complete the course. Best Regards Kasim Abdulkarim
Omar
August 31, 2021
It's a amazing training that can help planning engineers to visualize data from primavera P6 in two ways :Manual & Automatic method Thank you
Rashidm
May 23, 2021
This course is very helpful for Monitoring & reporting the project progress to the next level. Now I can implement the power BI for my projects. Engr. Mohamed Hisham,Thank you so much for your time which you have spent on this course!

Charts

Price

Microsoft Power BI for Project Planning and Control - Price chart

Rating

Microsoft Power BI for Project Planning and Control - Ratings chart

Enrollment distribution

Microsoft Power BI for Project Planning and Control - Distribution chart

Related Topics

3913312
udemy ID
3/14/2021
course created date
6/26/2021
course indexed date
ANUBHAVJAIN
course submited by