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

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.

---

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