Advanced Planning Analytics
  • Home
    • About Us >
      • Services
      • Careers
      • ORACLE in Las Vegas P6 Advanced
      • Contact Us
      • Call for Speakers
  • SME TRAINING
    • Engineering, Procurement, & Construction Planning [EPC]
    • Earned Value in P6
    • Power BI in EPC
    • Advance Work Packaging
    • Schedule Analytics
    • EVM in P6 Online Course
    • $100 TIC Estimating
  • ONLINE P6
  • ORACLE P6 TRAINING
    • P6 Fundamentals
    • P6 Advanced
    • Primavera Risk
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • Free Tools
    • Free Tools
    • FREE Online Tests >
      • Assessment PLANNING & SCHEDULING
      • Assessment EARNED VALUE
      • Assessment EPC
      • Assessment Procurement
  • APA Store
  • Engineering Deliverables in P6
  • Project Analytics APP
  • XER Analytics BETA TESTERS
  • XER P6 Templates

Power BI in EPC

Power BI in EPC - 1 Day Course

$1,050.00 $850.00

This course is intended to provide a hands-on approach to understanding the functional responsibilities of the project & team members using Power BI for daily reporting. Engineering, Procurement, & Construction Professionals all carry the need to not only follow project reporting requirement, but also need to be dynamic on handling data. We call that “data wrangling”. 


Power BI exercises are provided to show how the fundamental basis of Power BI reports are built. This course will equip participants with an understanding of the needs for where to source the data, how to capture the data, adjust calendars, as well as complete DAX formulas. Then finally we will finish by creating multiple dashboard reports.



Power Bi General Overview

oPower BI Desktop

oPower BI Service

oPower BI Applications


Power Bi Desktop

oRibbon

oViews

oPanes

oQuery Editor

oGet Data

oQueries

oCalculated Tables

oManual Entry



Visualizations

oTypes

oFilters


Model

oStar Schema: Fact Table, Dimension Tables

oCardinality



Tables

oDAX Formulas

oWorking with Query Editor

oTable Unique values, Sorting

oCalendar


Dashboard Layout

oPublishing

oReferences and Resources


Benefits to You

Enrolling in this course will help you understand P6 Professional’s basic features and functionality so you can apply them to your organization’s project management processes. You'll also learn how to manage projects on time and within budget to ensure optimal outcomes from capital and resource investments.


Terms & Conditions

Payment is expected in advance. Registration is not confirmed until payment is received. Advanced Planning Analytics reserves the right to cancel the class. We advise refundable travel arrangements. Advanced Planning Analytics cannot be held liable for airfare, lodging or other related travel expenses. It is the student's responsibility to attend the class for which they are registered.


General Cancellation Policies

Tuition will be promptly refunded with the following constraints:

  • Notice must be sent, and received by Advance Planning Analytics, in writing ten (10) calendar days prior to the start date of class.
  • Cancellation notice may be faxed to +1 (866) 291-1068, or emailed to cesar.ramos@advancedplanninganalytics.com. If you don’t receive confirmation of cancellation within 1 business day, please contact us by phone at +1 (888) 476-5848.
  • In all cases, failure to comply with this cancellation policy or failure to show up for class results in a charge of 100% of the class fee. The student may apply 75% of this charge to the same course in the future, scheduled within 12 months of the original course missed. If the student is unable to reschedule within 12 months of the original course missed, 50% of the charge for the original course missed may be applied to the balance of the same course in the future between 12 months plus one day to 18 months from the date of the original course missed. After 18 months the students credit for the original course missed is reduced to 0%.
  • 100% of a course fee will be refunded to the student, or employer of the student, if cancellation is requested and received by Advanced Planning Analytics no less than 10 calendar days from the start date of the course.

Student substitutions may be made at any time without penalty.


By purchasing this course you and your employer acknowledge, and agree to, the Terms & Conditions and to the General Cancellation Policies herein

Register Now

COURSE OUTLINE
Power Bi General Overview

- Power BI Desktop
- Power BI Service
- Power BI Applications
Power Bi Desktop
- Ribbon
- Views
- Panes
- Query Editor
Get Data
- Queries
- Calculated Tables
- Manual Entry
Visualizations
- Types
- Filters
Model
- Star Schema: Fact Table, Dimensions 
- Cardinality

Tables
- DAX Formulas
- Working with Query Editor
- Table Unique values, Sorting
- Calendar
Dashboard Layout
Publishing
References and Resources



Picture
This course is intended to provide a hands-on approach to understanding the functional responsibilities of the project & team members using Power BI for daily reporting. Engineering, Procurement, & Construction Professionals all carry the need to not only follow project reporting requirement, but also need to be dynamic on handling data. We call that “data wrangling”. 
​
Power BI exercises are provided to show how the fundamental basis of Power BI reports are built. This course will equip participants with an understanding of the needs for where to source the data, how to capture the data, adjust calendars, as well as complete DAX formulas. Then finally we will finish by creating multiple dashboard reports.

    More Information for Power BI

Submit

Topics covered

  • Earned Value Management

Benefits

  • Become a desirable hire for any company
  • Advance your position in your current company

Features

  • Various methods used in Earned Value Methodology

Learning Outcomes

  • Obtain applied understanding of how to build an Earned Value Tool
  • Gain an understanding of how to interpret the results of data
Picture
Privacy Policy

Terms of Use

Excel Gantt Tool
Copyright © 2019 - Advanced Planning Analytics,  All Rights Reserved.  CRamos Management LLC.
  • Home
    • About Us >
      • Services
      • Careers
      • ORACLE in Las Vegas P6 Advanced
      • Contact Us
      • Call for Speakers
  • SME TRAINING
    • Engineering, Procurement, & Construction Planning [EPC]
    • Earned Value in P6
    • Power BI in EPC
    • Advance Work Packaging
    • Schedule Analytics
    • EVM in P6 Online Course
    • $100 TIC Estimating
  • ONLINE P6
  • ORACLE P6 TRAINING
    • P6 Fundamentals
    • P6 Advanced
    • Primavera Risk
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • Free Tools
    • Free Tools
    • FREE Online Tests >
      • Assessment PLANNING & SCHEDULING
      • Assessment EARNED VALUE
      • Assessment EPC
      • Assessment Procurement
  • APA Store
  • Engineering Deliverables in P6
  • Project Analytics APP
  • XER Analytics BETA TESTERS
  • XER P6 Templates