Contact Us WhatsApp :https://wa.me/+923155537580
Get the Tool : https://www.softedemy.com/product/1-primavera-p6-to-excel-schedule-comparison-dashboard-pro-tool/
Contact us on [email protected]

Welcome to Softedemy, your Project Control and Engineering Software Academy! In this video, we will guide you through the comprehensive features of our Schedule Comparison Dashboard Excel tool, designed to seamlessly integrate with Primavera P6 for efficient project management.

Dynamic Schedule Comparison
Automatically compares baseline and updated schedules.
Generates detailed comparison summaries for accurate project tracking.

Data Extraction
Extracts key metrics: activity percent complete, performance percent complete, duration percent complete, unit percent complete, schedule percent complete, cost percent complete, and physical percent complete.
Retrieves Earned Value Management (EVM) metrics such as budgeted costs, earned value, actual value, and performance indices.

Comparison Summary Metrics
Deleted and newly added relationships
Critical and driving relationships
Lag changes and relationship type changes
Free float changes, actual duration, total float, and remaining duration
Detailed budgeted costs, planned value, earned value, and actual costs

Resource Management
Tracks added and deleted resources
Monitors resource assignments, actual costs, and budget at completion
Detailed labor unit tracking

Interactive Dashboard
Visual representation of previous and current project statuses
Customizable data points: critical path analysis, longest path, float path order, and activity details

Project Dates and Milestones
Comparison of project dates: baseline start and finish, current start and finish, and any delays
Displays progress percent resource assignment, project status, and activity details

Ease of Use
User-friendly interface with options to print and deliver reports
Automatic data refresh and update functionality

Comprehensive Reports
Summarizes all key project metrics for quick insights
Easy-to-understand visuals and summaries

Compatibility
Integrates with Primavera P6 and Excel

Support and Updates
Access to support and regular updates to enhance functionality
Whether you're a project manager or a control engineer, our Schedule Comparison Dashboard Excel tool is perfect for efficiently comparing schedules and tracking project progress accurately.

Timestamps:

0:00 - Introduction to Softedemy
0:50 - Overview of Schedule Comparison Dashboard
1:04 - Power Query and Prim P6 Integration
1:33 - Demonstration of Tool Usage
2:23 - Importing ERP Data into Prim P6
3:25 - Setting Up Schedule Comparison Dashboard
4:28 - Changing Data Sources in Power Query
5:20 - Exporting Data from Prim P6
6:32 - Updating the Dashboard with New Data
7:50 - Exploring the Interactive Dashboard
9:05 - Printing and Delivering Reports
10:00 - Final Summary and Conclusion
11:15 - Detailed Comparison of Baseline and Updated Schedules
12:12 - Adjusting Data Source Settings in Excel
13:21 - Importing and Editing ERP Files
14:19 - Exporting Activity Data from Primavera P6
15:27 - Importing Resource Assignments
16:45 - Linking Excel to Prim P6 Data
17:58 - Creating and Updating Power Query Connections
19:00 - Interactive Features and Summary Analysis
20:12 - Customizing the Dashboard for Different Projects
21:27 - Detailed EVM and Critical Path Analysis
22:40 - Troubleshooting Data Loading Issues
23:45 - Comparing Lag Changes and Relationships
24:10 - Updating and Refreshing Data in Excel
24:35 - Contact and Support Information

FOLLOW US ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
Twitter: https://twitter.com/FaisalM15432091
Facebook: https://facebook.com/Softedemy
Instagram: https://www.instagram.com/softedemy/
LinkedIn: https://www.linkedin.com/company/Softedemy


#softedemy,#Planningengineer,#primaverap6
Disclaimer:- This channel does not promote or encourage any illegal activities and all content provided by this channel is meant for EDUCATIONAL PURPOSE only. Copyright Disclaimer: - Under section 107 of the
Copyright Act 1976, allowance is made for FAIR USE for the purpose such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statutes that might otherwise be infringing. Non- Profit, educational, or personal use tips the balance in favor of FAIR USE.