Civil · PG program

Post Graduate Program inConstruction Project Management

Superior construction project management is often the difference between achieving project deadlines and cost overruns. Our construction project management course provides training in developing essential skills to manage a construction project.

Talk to a counsellor →View curriculum

Duration: 24 weeks
Content: 144 hours
Courses: 8
Projects: 16
Mode: Online

Overview

What you'll
be able to do.

The PG Program in Construction Project Management Fundamentals covers the major concepts of a construction project, such as construction scope, time, and cost.
It encompasses the whole lifecycle of the construction project and introduces each area of construction to the learners.
The learners will understand the flow of the project, key parameters to monitor, and the management techniques through schedule, contract, and cost management.
During the coursework, they will learn in depth about
- Project design, planning, execution, control, and handover.
- Project process chart, work breakdown structure, project planning using PDM, CPM, and PERT, resource scheduling, resource levelling, and types of contracts.
- Applications of Primavera P6 for project planning and management for construction projects, including infrastructure, roads and railways, buildings, etc.
- Project communication matrix, progress monitoring and reporting systems, CPM and PERT analysis, productivity analysis, and project performance benchmarking.
- Dual roles of client and contractor-side participation, quantity calculation, unit price analysis, tendering process, and billing process.
- Contract and sub-contract management.
They are also exposed to the modern trends and standard practises being followed in the industry right now.
After completing this program, the students will be able to pursue a career as a planning engineer, cost engineer, project manager, construction engineer, procurement/contracts engineer, etc.

Why this program

Project Management Fundamentals and Project Lifecycle
Project Planning and Scheduling Techniques using Oracle Primavera
Project Progress Monitoring and Reporting
Project Cost Budgeting and Control
Contract and Sub-contract Management

Higher Education
- MS in Project Management
- MS in Construction Engineering
Job Opportunities
- Planning Engineer
- Cost Engineer/Controller
- Project Manager/Project coordinator
- Construction Engineer/Project Engineer
- Procurement and Contracts Engineer

Tools you'll use

Primavera P6MS ExcelPower BI

Curriculum

8 courses,
93 modules.

Get the full syllabus ↓

01Construction Project Management Fundamentals12 modules
1. Introduction to Construction ProjectW01
  - What is a Project?
  - Project Vs Operations or Manufacturing
  - Project Stakeholders
  - Project Process Group
  - Project Lifecycle processes
  - Typical Construction Organization Structure
2. Tendering and ContractsW02
  - Tendering Process
  - Bid and Budget Preparation
  - What is a Contract?
  - Different Construction Contracts
  - Different Forms of Contract
  - Important Clauses of the Contract
3. EngineeringW03
  - Stages of Engineering
  - Types of Structures and Design Methods
  - Deliverables of Engineering
  - Different Disciplines of Design
  - Types of Drawings
  - Drawings Content and Management
  - Prominent Software for Design
4. Procurement ProcessW04
  - Material Take-off from Drawings or Model
  - Types of Procurement
  - Pre-requisites of the Procurement Process
  - Procurement Process
  - Subcontract Procurement
  - Logistics of Procurement
  - Long Lead and Special Items Procurement Process
  - Procurement of Imported Items
5. Material Management in StoreW05
  - Material Management at the Project Store
  - Material Stored at the Site
  - Site Store Activities
  - Storage Requirement for Materials
  - Inventory Management
  - Material Reconciliation
  - Physical Verification
  - Waste Management and Scrap
6. P&M Management on ProjectW06
  - Introduction to P&M
  - Types of Construction Equipment (P&M)
  - Equipment Management at Site
  - Selection Criterion for Equipment
  - Hire or Procure Decision
  - Depreciation of Asset
  - Efficiency of Machinery
7. Project Planning and SchedulingW07
  - Importance of Project Schedule
  - Levels of Schedule
  - Baseline Schedule
  - Schedule Preparation Requirements
  - Schedule Basis Document
  - Actual Progress Update
  - Labor Productivity Measurement
  - Schedule Change Management (MOC and Change Document)
8. Project Cost Management and ControlW08
  - Importance of Cost Management
  - Budget for the Project
  - Cost Booking Methodology
  - Cost Change Management
  - Earned Value Management
  - Forecasting
  - Delay Analysis and Extension of Time Claims
9. Vendor and Client InvoicingW09
  - Client Billing
    
    Request for Inspection
    
    Invoice Process
    
    Deductions, Recoveries, and Retentions
    
    Advances
    
    Memorandum of Payment
  - Vendor Bill Certification
10. Health, Safety, and Environment in Infrastructure ProjectsW10
  - Introduction to HSE on Construction Projects
  - HSE Plan
  - HSE Management System
  - HSE Practices
  - HSE Monitoring Process
  - HSE Response Management
11. Quality Management on Construction ProjectW11
  - Quality Management System
  - Developing a Project Quality Plan (PQP)
  - Inspection Test Plans (ITPs)
  - Quality Assurance Vs Quality Controls
  - Quality Controls at Site
12. Digital Technologies in ConstructionW12
  - Introduction to Technology in Construction
  - Current Status of Technology Usage in Industry
  - Different Tools and Technologies
    
    Common Data Environment (CDE)
    
    5D BIM
    
    Scan to BIM
    
    IoT - Equipment Monitoring and RFID for Workforce
    
    Data Analytics - Real-time Progress Reporting and Dashboard
    
    ML For Subcontract
02Project Planning and Scheduling12 modules
1. Project Planning ConceptsW01
  - Transition Phase and its Challenges
  - Success and Failure of Projects
  - Basic Steps involved in Project Planning
2. Project Planning and Control SystemW02
  - Planning, Monitoring, and Control Systems
  - Planning at Site through MPCS - Schedules
  - Planning Organization
3. Project Scheduling W03
  - Understanding Project Plan
  - Ingredients of a Schedule
  - Plan and Schedule Framework
4. Milestone IdentificationW04
  - Setting up Milestone
  - Resource Scheduling
  - Resource Allocation
5. WBS Framework Formulation Part - 1W05
  - Introduction to Work Breakdown Structure
  - Steps to Develop Work Breakdown Structure
  - Procedure to Use Work Breakdown Structure
6. WBS Framework Formulation Part - 2W06
  - Macro-level Understanding of Sequencing
  - Macro-level Understanding of Interfaces and Interdependencies
7. Scheduling Concepts Part - 1W07
  - Micro-level Understanding of Sequencing
  - Micro-level Understanding of Interfaces and Interdependencies.
  - Identification of Activities
  - Estimation and Effort Calculation
8. Scheduling Concepts Part - 2W08
  - Understanding Relationship Dependencies
  - Developing Knowledge of Lead and Lag
  - Scheduling Techniques
9. Network and SequencingW09
  - Elements of Network
  - PERT/CPM Mathematical Analysis
  - Network Analysis Diagram
10. Resource Scheduling TechniquesW10
  - Resources
    
    Utilization Planning
    
    Leveling
    
    Allocation
    
    Limitations
11. Recommendation and Checks for Schedule PreparationW11
  - Recommendation for Schedule Preparation
  - Reducing Project Duration
  - Scheduling using Primavera
12. Types of Contracts W12
  - Brief Outline of Types of Contracts
  - Types of Schedules
  - Brief Outline of EPC-related Schedules
03Project Management Using Primavera12 modules
1. Introduction to Primavera and Project ManagementW01
  - Introduction to the Project and its Management
  - About Primavera
  - Client GUI for P6 Release 8.2
  - OBS Overview
  - Creating OBS
  - Modifying OBS
  - EPS Overview
  - Creating EPS
  - Modifying EPS
2. Projects, Calendar, and Work Breakdown StructureW02
  - Introduction to Calendar
  - Types of Calendar
  - About Projects
  - Client Project Development
  - Project Details Window
  - Introduction to WBS
  - WBS Structure
  - Working with WBS (Add, edit, and delete)
3. Working with ActivitiesW03
  - Introduction to Activity
  - Assigning a Calendar to an Activity
  - Activities (Add, edit, and delete)
  - Activity Types
  - Defining Activity Types
  - Activity Duration Types
4. Relationship and SchedulingW04
  - Introduction to Relationships
  - Types of Relationship
  - Adding Relationships to the Activities
  - Introduction to Scheduling
  - Critical Path Method
  - Advantages of Critical Path Method
  - Constraints
  - Types of Constraints
5. Defining and Assigning resources and roles W05
  - Introduction to Resources
  - Introduction to Roles
  - Resources Vs Roles
  - Adding a Resource
  - Displaying the Resource Details
  - Editing the Resource Information
  - Copying and Pasting a Resource
  - Deleting a Resource
  - Adding a Role
  - Assigning Roles to Resources from the Roles Dialog Box
  - Changing the Proficiency of a Role
  - Assigning Roles to Activities
  - Recalculating the Resource and Role Assignment
6. ResourceW06
  - Resource Analysis
  - Resource Leveling
  - Resource Curves
  - Budget Management
7. Constraint, Reflection, Codes, Grouping and Sorting W07
  - Constraints
  - Purpose of Constraints
  - Types of Constraints
  - Benefits of using Constraints
  - Reflection in P6
  - Creation and using Reflection
  - Codes
  - Grouping and Sorting
8. Documents and BaselinesW08
  - Work Products and Documents
  - Notebook Tab
  - Baselines
  - Setting Baselines
  - Assign Baselines
  - Display Baselines
  - Restoring Baselines
  - Project Updates
9. Project Progress UpdateW09
  - Project Updates
  - Updating Progress for Individual Activities
  - Suspending or Resuming an Activity's Progress
  - Progress Spotlight
  - Project Progress on Gantt Chart
  - Project Progress on Table
10. Earned Value ManagementW10
  - Earned Value Management
  - Earned Value Parameters in Primavera
  - S-Curve
  - EVM Graph
  - Activity Usage Profile – Monthly Cash flow
11. Issues and Thresholds, Risk Register, User-Defined Fields, Global Change, and Formatting Project DataW11
  - Issues and Thresholds
  - Risk Register
  - User-defined Fields
  - Global Change
  - Formatting Project Data
12. ReportW12
  - User Preference
  - Admin Option
  - Primavera Visualizer
  - Project Website Publisher
  - Print and Page Setup
  - Reports
  - Import and Export
04Project Progress Measurement and Reporting12 modules
1. Introduction to Project and Project Management (Part 1)W01
  - Project Management
  - Project Lifecycle
  - Project Management Process
  - Manager and Stakeholders
  - Project Plan
  - Project Notebook
  - Plan Phase
  - Statement of Work
  - Work Breakdown Structure
  - Responsibility Assignment Matrix
  - Project Schedule
  - Network Diagram and Gantt Chart
  - Resource Plan
  - Budget
  - Project Execution/Implementation
  - Project Close-out
  - Examples of Project Management
2. Introduction to Project and Project Management (Part 2)W02
  - What is a Project?
  - Planning
  - Scheduling
  - Important Terms
  - Schedule Compression
  - Sample Schedule
  - Project Organization
  - Types of Organizational Structures
3. Project Communication Management and its Importance (Part 1)W03
  - Project Communication Management
  - Mechanisms of Communication/Information Exchange
  - Various Forms of Communication
  - Importance of Good and Effective Communication
  - Project Communication Management Process
  - Project Communication Matrix
4. Project Communication Management and its Importance (Part 2)W04
  - RACI Matrix
  - Mechanism of RACI Matrix
  - Project Documentation Management
  - Objectives of Documentation
  - Correspondence
  - Contractual Requirement Documentation
  - Conducting Meetings and Capturing Minutes
  - Construction Documents
5. Planning Progress Monitoring and TrackingW05
  - Project Planning
  - Objective and Concepts of Project Planning
  - Basic Concept of Monitoring, Evaluating, and Reporting
  - Project Monitoring and Tracking
  - Project Monitoring Information System
  - Objectives of Project Monitoring
  - Practices of Monitoring
  - Techniques of Monitoring
  - Project Controls
6. Planning Progress Reporting and its SystemsW06
  - What is Progress Reporting?
  - Purpose of Reporting
  - Project Progress Report Format
  - Project Progress Internal Reporting
  - Project Progress External Reporting
  - Types and Contents of the Report
  - Project Progress Report/Executive Report
  - Types of Project Reports
7. Project Performance Evaluation and Reporting W07
  - Project Evaluation
  - Performance Evaluation of a Project
  - Project Performance Evaluation Analysis and Reporting
8. Development of Schedule and its Tracking and Monitoring (Part 1)W08
  - Project Scheduling
  - Importance of Networking in Schedule
  - Fundamentals and Concepts to Remember for Scheduling
  - Schedule Preparation
  - Steps of Schedule Preparation
  - Updating and Tracking Schedule
  - Types of Schedules
  - Calculating the Duration and Resources
  - Use of Project Management Software for Construction Scheduling
  - Benefits of using Project Management Software
  - Project Scheduling Checklist
  - Sample Project Schedules
9. Development of Schedule and its Tracking and Monitoring (Part 2)W09
  - Project Scheduling
  - Preparing a Master Construction Program - Standard Operating Procedure (SOP)
10. CPM and PERT AnalysisW10
  - Basic Terminologies used in Network diagram
  - Types of Activities
  - Network Fundamentals
  - Types of Network Diagram
  - Examples of Network Diagram
  - CPM (Critical Path Method) Analysis
  - Objectives of CPM
  - Steps to Develop CPM for a Project
  - Examples of CPM
  - What is PERT Analysis?
  - Example of PERT Analysis
11. Earned Value ManagementW11
  - Planned Value (PV)
  - Earned Value (EV)
  - Actual Cost (AC)
  - Schedule Variance (SV)
  - Cost Variance (CV)
  - Schedule Performance Index (SPI)
  - Cost Performance Index (CPI)
  - Critical Ratio (CR)
  - Estimate at Completion (EAC)
  - Variance at Completion (VAC)
  - Estimate to Completion (ETC)
  - To-Cost Performance Index (TCPI)
12. S-Curve Representations and Bar chart RepresentationsW12
  - S-Curve or Project Life cycle
  - Bar Charts Introduction
  - Dashboards Representation
05Project Cost Control12 modules
1. Introduction W01
  - Definition of Project Cost control
  - Relevance (Why is it Required)
  - Who can do Cost Control?
  - Nature of Cost
    
    Direct Cost
    
    Indirect Cost
    
    General Expense
    
    Temporary Expense
2. Cost Estimation - Part 1 W02
  - Cost Estimation
  - Importance and Steps in Cost Estimation
  - Project Award
  - Bill of Quantities (BOQ)
  - Quantity Take-offs
3. Cost Estimation - Part 2 W03
  - Components of Cost Estimation
    
    Cost Submission Policy
    
    Cost Submission Format
  - Unit Price/Rate Analysis
  - Project as Cost Centre
  - Introduction to Budget
4. Basics of Control - Part 1W04
  - Cost Control from Client and Contractor Perspective
  - Terminology in Cost Control
    
    Client Claim (C)
    
    Cost to the Company (T)
    
    Budget (B)
    
    Landed Cost (L)
    
    Profit (R)
  - Profit Direction of a Project
  - Work Breakdown Structure
  - Determination of Budget
5. Basics of Control - Part 2W05
  - Determination of Budget
  - Budget Explanation with Example
  - Paid and Payable
  - Variation Order (VO)
  - Value Engineering (VE)
6. Basics of Control - Part 3W06
  - Discrepancy/Variance
  - Review Frequency
  - Income and Expenditure Statement
  - Contingency
  - Forecasting of Profit or Loss
7. Change Order ManagementW07
  - Budget Determination with Example
  - Change Order Management
    
    Definition
    
    Elements of Change Order
  - Change Order Process
  - Change Order with Example
  - Causes of Change Order
8. Risk and MitigationW08
  - Risk and Mitigation
  - 4T of Risk Mitigation
  - Method of Risk Mitigation
  - Cost Reduction Effort
  - Anticipated Cost Increase
9. Basics of Cost Control - Part 4W09
  - TBL Abstract
  - Making of TBL Abstract
  - Cost Saving and Profit
  - Benefits of Early Procurement
  - Procurement Forecast
10. Basics of Cost Control - Part 5W10
  - Budget Transfer
  - Example of Budget Transfer
  - Release of Contingency
  - Profit Forecasting (Minimum and Maximum)
    
    Quantity Control
    
    Amount Control
11. Basics of Cost Control - Part 6W11
  - Project Cost - Management Information System
  - Example of MIS
  - Project Cost Evaluation
    
    Tender
    
    Variation Order (VO)/ Value Engineering (VE) - Claims
    
    Claim Evaluation
    
    Billing
    
    Contactor Submission
    
    Client Evaluation
12. Basics of Cost Control -Part 7W12
  - Cost Management Case Studies
  - Best Practices of Cost Control
  - Project Cost Control Review
  - Software for Cost Control
  - Cost Saving Ideas
06Contract and Subcontract Management12 modules
1. Introduction to Contracting Management W01
  - Contract Management
  - Scope
  - Organization
  - Contract
  - Award
  - Contract Closure
2. Essential Elements of Contract and Industry Good PracticesW02
  - Offer
  - Acceptance
  - Mutual Assent
  - Capacity
  - Legality
  - Industry Good Practices
3. Types of ContractsW03
  - Context 1 : 3 types
    
    Fixed Price Contract
    
    Cost Plus Contract
    
    Time and Material Contract
  - Context 2 : 6 types
    
    LSTk
    
    EPC
    
    EPCM
    
    Item Rate GEC
    
    Item Rate Package
    
    Supply Contract
    
    Labor Contract
    
    Service Contract
4. GCC and SCC - Part 1W04
  - Introduction to GCC and SCC
  - Illustration with an Example
5. GCC and SCC - Part 2W05
  - GCC Implementation
  - SCC Implementation
  - Important Clauses
6. Legal Aspects of Contract - Part 1W06
  - How Legal Contract Works
  - Legal Purpose
  - Mutual Agreement
  - Consideration
  - Competent Parties
  - Genuine Assent
  - Arbitration - Steps of Arbitration in India
7. Legal Aspects of Contract - Part 2W07
  - Contract Breach
  - Force Majeure
  - Sue for Damages
  - Specific Performance
  - Other Remedies
  - Types of Contracts based on Legal Validity
    
    Void Contract
    
    Voidable Contract
    
    Legal Contract
    
    Illegal Contract
    
    Unenforceable Contract
8. Claims and Arbitration W08
  - Claims
    
    Injuries
    
    Change of Work
    
    Damage
    
    Schedule Acceleration
    
    Change in Site Conditions
    
    Construction Defects
    
    Delay
  - Introduction to Project Contract Arbitration
9. Tender Process and Contract ClosureW09
  - Key Terminologies of Project Contract
  - Flow of Events for Tendering Process
    
    Notice Inviting Tender
    
    Bid phase
    
    2-Bid system
    
    GCC and SCC
    
    Notice to Proceed
    
    Project Phase
    
    Contract Closure
10. Subcontracting Management W10
  - What is Sub Contracting?
  - How Subcontracting Works in Engineering and Construction Industry?
  - Industry Example Elaboration
  - Checks Before Engaging Sub Contractor
  - BOQ or Bill of Quantities and SOR or Schedule of Rates
  - Case Study of a Typical Package Based Sub Contract
  - Back-to-back Sub Contracting
11. FIDIC ( International Federation of Consulting Engineers) Contract W11
  - Elementary Understanding of FIDIC
  - FIDIC Contract
    
    Red Book
    
    Pink Book
    
    Yellow Book
    
    Silver Book
    
    Orange Book
    
    Green Book
    
    Gold Book
12. FIDIC Application Scenarios, Use of SAP or Other SoftwareW12
  - FIDIC Clauses
  - SAP and Other Similar Softwares
  - Important and Industry Relevant Points
07Excel Skills and Data Analysis for Construction Project Management10 modules
1. Course Introduction and FundamentalsW01
  - Introduction to the Course
  - Launching Excel and Version Check
  - Level 1
    
    Introduction to the Interface
    
    Saving an Excel Document
    
    Common Shortcuts
    
    Entering and Editing Data
    
    Relative and Absolute Cell References
    
    Formatting
    
    Customizing the Quick Access Toolbar
    
    Excel Self-help
2. Basic Excel Functions and Modification of WorksheetW02
  - Basic Functions
    
    Design of Excel Functions
    
    Understanding SUM(), MIN() and MAX()
    
    Understanding AVERAGE()
    
    Understanding COUNT()
    
    AutoSum and Autofill/Flash fill
  - Modification
    
    Inserting New Sheets, Rows, and Columns
    
    Deleting Sheets, Rows, and Columns
    
    Moving or Copying Sheets
    
    Sheet Formatting
    
    Excel Options
    
    Customize Ribbon
3. Data Formatting, Creating Your First Chart, and Working with Shapes and ImagesW03
  - Data Formatting
    
    Cell Formatting – Merge, Alignment, etc.
    
    Borders
    
    Currencies and Percentages
    
    Format Painter
    
    Conditional Formatting
    
    Find and Search
  - Shapes and Images
    
    Inserting Shapes and Images
    
    Formatting Excel Shapes
    
    SmartArt
  - Creating your First Chart
    
    Creating Chart
    
    Chart Options
    
    Types of Charts
    
    Chart Formatting
  - Date functions
    
    DATE() and DATEVALUE()
    
    NETWORKDAYS()
    
    EOMONTH() and EDATE()
4. Introduction to Tables and Excel Templates, Excel Options and Printing Your Excel WorksheetsW04
  - Excel Templates
    
    Introduction and Import Excel Template
    
    Custom Template
  - Printing Worksheets
    
    Print Preview
    
    Margins and Scaling
    
    Page Layout
    
    Headers and Footers
    
    Specific Range
  - Tables
    
    Introduction
    
    Table Options
    
    Table Formatting
    
    Table References
    
    Working with Formulae
    
    Benefits of Tables
5. Conditional Functions and other FunctionsW05
  - Conditional Functions
  - Understanding IF()
  - Understanding SUMIF() and SUMIFS()
  - Understanding COUNTIF()
  - Use of AND and OR with IF()
  - Understanding IFERROR()
6. Pivot Tables, and Lookup FunctionsW06
  - Pivot Tables
    
    Data Source
    
    Pivot Table Structuring
    
    Pivot Table Options
    
    Pivot Table Formatting
  - Lookup Functions
    
    Understanding VLOOKUP()
    
    Understanding HLOOKUP()
    
    Understanding INDEX and MATCH
    
    Understanding XLOOKUP()
    
    Understanding OFFSET()
7. New Functions, Data Tab and Introduction to Power QueryW07
  - New Functions
    
    Understanding UNIQUE()
    
    Understanding FILTER()
    
    Understanding IFS()
    
    Understanding SORT(), SORTBY()
    
    Understanding SWITCH()
  - Data Tab
    
    Data Import
    
    Data Cleaning and Transform
    
    Intro to Power Query
    
    Use of Power Query
8. Advanced Pivot Table Functions, PowerPivot ToolsW08
  - Advanced Pivot Table Functions
    
    Fields, Items, and Sets
    
    Pivot Charts
    
    Slicers and Timeline
    
    Group and Ungroup
    
    GETPIVOTDATA()
  - PowerPivot Tools
    
    Introduction to Excel Power Pivot
    
    More Tables and Relationships
    
    Creating Data Models
    
    KPIs
9. Large Data Sets, File Protection, Named Ranges, and Data TabW09
  - Working with Large Data sets
    
    Freeze Panes
    
    Grouping Data
    
    Consolidating Data from Multiple Worksheets
  - File Protection
    
    Protecting Specific Cells in a Worksheet
    
    Protecting the Structure of a Workbook
    
    Adding a Workbook Password
  - Data Tab
    
    Custom Sorting
    
    What-If Analysis
    
    Text to Columns
  - Data Validation
    
    Understanding Data Validation
    
    Custom Data Validation Error
    
    Dynamic Formulas in Validation
10. List Functions, Excel Automation Using Macros and Email Automation and FinaleW10
  - List Functions
    
    Understanding DSUM()
    
    Understanding DSUM() with AND/OR()
    
    Understanding DAVERAGE()
    
    Understanding DCOUNT()
    
    Understanding SUBTOTAL()
  - Excel Automation using Macros
    
    Understanding Macros
    
    Creating Macro with Macro Recorder
  - Email Automation
    
    Introduction to the Emailing Section
    
    Understanding Email Routine
    
    Email Loop
08Effective Dashboards using Power BI for Construction Management11 modules
1. Introduction to Power BIW01
  - Introduction to the Power BI
  - Why Power BI?
  - Installing Power BI Desktop
  - Introduction to Power BI Query Editor
  - Types of Power BI Data Connectors
  - Basic Table Transformations
2. Transform Data (Query Editor)W02
  - Transform Data in Power BI
  - Basic Table Transformation
  - Text, Number, and Date Tools
  - Index and Conditional Columns
  - Grouping and Aggregating Data
  - Pivoting and Unpivoting
3. Transform Data (Query Editor)W03
  - Merging, Modifying, and Appending Queries
  - Connecting to Folders
  - Defining Hierarchies and Categories
  - Best Practices of Query Editing and Power BI
4. Relational Data ModelW04
  - Data Model
  - Database Normalization
  - Data Table Types
  - Creating Power BI Table Relationships
  - Table Schemas
  - Relationships
5. Relational Data Model Part -2W05
  - Relationship Cardinality
  - Connecting Multiple Data Tables
  - Filter Flow
  - Two-way Filter
  - Filtering and Cross-filtering
  - Hiding Fields from the Power BI Report View
  - Data Modeling and Power BI Best Practices
6. Part 1 - Basics of DAXW06
  - Introduction to Data Analysis Expressions (DAX)
  - Calculated Columns vs Measures
  - DAX Syntax and Operators
  - Common DAX Functions
  - Basic Date and Time Formulae
7. Part 2 - Basics of DAXW07
  - DAX Syntax
  - Common DAX Functions
  - Text Functions
  - Related
  - Basic Mathematical and Statistics Functions
  - Calculate all Filter
  - Time Intelligence Functions
8. Advanced DAX FunctionsW08
  - Calculated Joins between Tables
  - Relationship Functions
  - Advanced Time Intelligence
9. Creating Interactive ReportsW09
  - Introduction to the Power BI Report View
  - Adding Basic Charts to Power BI Reports
  - Create a Visualization
  - Filtering Options
  - Matrix Visualization
  - Slicers and Timelines
  - Key Performance Indicator (KPIs) Chart
  - Power BI Map Visuals (Basic, Fill, ArcGIS)
10. Creating Interactive ReportsW10
  - TreeMaps, Lines, Areas, and Gauges
  - Editing Report Interactions
  - Adding Drill-through Filters
  - Linking to Report Bookmarks
  - Using "What-If" Parameters
  - Managing and Viewing Roles
11. Creating Interactive ReportsW11
  - Introduction to Power BI Service
  - Power BI Service Administration
  - Connecting to Multiple Types of Data

Industry projects

16 projects
you'll ship.

Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 16 Projects that are available in this program.

Construction Project Management Fundamentals

Understanding Contracting and Tendering Process for the Commencement of a Metro Project

In this project, learners will understand the decision criteria for the type of contracts, different disciplines involved, tendering process, contractor selection process, and vari…

Construction Project Management Fundamentals

Analysis and Report Generation for Delays in Multistorey Building Project

This project will help learners understand the analysis of delays and cost overruns. It also helps them understand the generation of reports that are submitted to the internal mana…

Project Planning and Scheduling

Developing the Schedule for the Construction of Police Station Building

During this projectwork, the learners will develop a schedule for the "Construction of Police Station Building" based on the activity list. This is done by planning and scheduling …

Project Planning and Scheduling

Planning and Scheduling of the Township Development

In this project, the learners will work on the strategy, planning, and scheduling of the township development in a major area. This is done by identifying and meeting the stakehold…

Project Management Using Primavera

Developing a Project Plan for Bridge Construction

During this projectwork, the learners will prepare a plan for bridge construction with a 6-day working calendar and with WBS for identifying the problem, determining constraints, a…

Project Management Using Primavera

Developing a Project Plan for a Cable-Laying Project

In this project, the learners will prepare a plan for XYZ company for a cable-laying project. This project involves several work packages and activities. So, it requires resource o…

Project Progress Measurement and Reporting

Detailed Study: Communication Systems in Project Management

During this projectwork, the learners will develop a detailed study that includes the project lifecycle in terms of all its phases, the work breakdown structure with its types, the…

Project Progress Measurement and Reporting

Detailed Study: Scheduling Techniques in Project Management

In this project, students will have to develop a detailed study that elaborates on the relationships in a schedule, steps involved in creating a network diagram, critical path meth…

Project Cost Control

Developing a Project Cost Control Plan for a Residential Project

In this project, the learners will develop a project cost control plan for a residential project worth INR 50 Cr. The learners will prepare the project estimation cost considering …

Project Cost Control

Analyzing the Tender Documents for a Warehouse Construction Project

In this project, the learners will analyze the tender documents received from the construction company for a warehouse construction project. The learners will understand to set the…

Contract and Subcontract Management

Develop a Scope document or Scope of Work (SOW) for a tender

This project deals with the preparation of Scope of Work document for a tender by listing out the project details, design, timelines, and responsibilities.

Contract and Subcontract Management

Develop an Extension of Time (EOT) application for a water infrastructure project

This project deals with the preparation of an Extension of Time (EOT) application for a water infrastructure project by listing out the delayed events, responsible parties, and for…

+ 4 more projects in the full syllabus

Fee

One fee.
Everything included.

Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals

Premium

₹2,75,000

Inclusive of all chargesEMI from ₹14,375/month

Career Service Assurance
Personalized Career Services Mentorship
1 Year Access
Personalized Page
Live Individual & Group Sessions
Personalized & Hands-On
Job-Oriented Industry Relevant Curriculum

Check eligibility →

You might also like.

PG program · 48 weeksHigh-Rise Building Design & Analysis→PG program · 48 weeksSteel Structures→PG program · 48 weeksBridge Design and Analysis→PG program · 32 weeksInfrastructure - Engineering Design and Project Management→PG program · 48 weeksBuildings - Engineering Design and Project management→PG program · 16 weeksPre-Graduate Program in High-rise Building Design→

Next step

Not sure it's
the right fit?

A counsellor will walk you through the syllabus, projects and fee options — and tell you honestly if another course suits you better.

Call us Enquire