Registration for all courses will be open on 05-Jun-2024
Power BI for Planning Engineers in Project Control
We've helped numerous planning engineers with project management & project control training. This course will help you prepare progress reports in a few seconds, analyze progress with a click of a button, and much more.
Ideal for Planning Engineers who have project control experience. NOT Suitable for beginners in project control.
We are an AACEI Approved Education Provider
We trained planning engineers of leading companies
In this program, I helped hundreds of engineers...
- DEVELOP interactive, beautiful and eye-catching dashboards.
- PREPARE weekly and monthly reports in few seconds.
- ANALYZE progress and complete reports with a click of a button.
- AUTOMATE project control tasks.
- ENSURE the accuracy of your reporting.
- SHOW beautiful dashboards in your CV and get shortlisted for vacancies.
- MASTER Power BI skills to stand out from competition.
- IMPRESS your colleagues and project parties with professional and accurate reports.
- UNLOCK better career opportunities.
Who is this course for?
- Experienced Planning Engineers
- OR
- Our academy members who completed the "Practical Project Control" with us before.
- The #1 challenge planning engineers face is not the lack of knowledge, it is the lack of time!
- Do you spend a lot of time preparing progress reports manually?
- Do you spend several hours working with data from multiple excel sheets?
- Do you waste a lot of time revising the whole report when there is a change?
- Do you constantly import numerous XER files or browse reports to find the information you need?
- Do you waste time validating calculations loops and dealing with excel formulas errors?
- Do you prepare progress presentations manually?
- Do you spend a lot of time formatting reports?
- Do you struggle with the workload and meeting deadlines?
- Do you spend a lot of money on software and other project control solutions?
- When these issues exist, you will:
- Be unable to gain recognition as a knowledgeable and expert planning engineer in front of your management and clients.
- Have no skills to stand out from the competition.
- Focus less on things that are more important (e.g. correspondences and analyzing Subcontractors' performance).
- Spend a lot of time preparing reports and presentations requested by management.
- I get it. I was like you 14 years ago. I learned a lot over the years, made many mistakes, worked under pressure. While I was working in super-large projects, I was forced to create systems, tools and methods to add value and deliver RESULTS. What I teach inside the Power BI course is the accumulation of several years of hard work, making mistakes and continuous improvement.
- But you don't have to go through the same struggles because I am here to offer you a step-by-step guidance on how to prepare your progress reports in seconds, analyze any area in the project with a click of a button and automate tasks on auto-pilot.
Meet Your Instructor
Osama Saad
MBA, PMP, PSP, CCP, PMI-SP
I am a planning and project control consultant and trainer with a demonstrated history of working in super large construction projects. Skilled in Planning, Scheduling, Power BI, Delay Analysis and Claims. I have been a Planning and Project Control Practitioner since 2010. I am a PMP, PSP, CCP, PMI-SP certified and a member of PMI and AACEI.
I help planners prepare progress reports in seconds and analyze their projects with a click of a button using Power BI. I help planners build a reputation for outstanding project control services in front of their clients. I also teach planning engineers how to prepare winning claims.
Introducing
Power BI in Project Control
- This course will help you achieve the following:
- Complete progress reports in seconds.
- Analyze any area in the project with a click of a button.
- Have all planning work in one location under one layout using one tool.
- Not worry about validating excel formulas errors or calculations every single time you prepare a report.
- Connect your drawings with the progress data and present photos.
- Not waste time importing several XER files or browsing reports to find the information that you need.
- Extract data from the model and prepare a complete presentation in seconds.
- Create systems and complete tasks on auto-pilot.
- Create themes that save a lot of time on report formatting.
- Impress stakeholders and build a powerful brand in front of clients.
- Provide massive value to the team toward project success.
- Have all the answers in a progress meeting immediately on the spot.
- Show beautiful dashboards and a link to the interactive report in your CV to get shortlisted for vacancies.
- Avoid preparing progress reports manually.
- Not worry about workload and meeting deadlines.
- Show supreme competencies and skills.
- Gain recognition by your team and stakeholders as a planning engineer who is knowledgeable and expert.
- Acquire superior planning skills.
- Develop a strong data analytics mindset that will help you solve future problems and set you up for success.
- Do all of the above using a FREE software service.
Watch the below video for what to expect from the "Power BI in Project Control" Course
It takes less than 30 seconds to have everything updated inside Power BI after you complete your schedule update. The course is for planners who use ANY scheduling software (not necessarily P6)
Here is the thing…
- There are thousands of engineers who are competing for the same job. But if you have average skills, you get average career opportunities. It is essential to acquire practical skills and knowledge which will help you add value, be different and stand out from the competition.
- Learning Power BI is easy but knowing how to use it for project control is really tough. I have taken FOUR different Power BI courses and made A LOT OF MISTAKES before things start to click with me.
- The most valuable training I received was delivered by a Microsoft Certified Analyst. Most Engineers are not familiar with the principles of data analytics which Power BI is based upon.
- A specialized step-by-step program walking you through the foundations of data analytics, features of Power BI and the associated applications in project control is THE most cost and time effective way to take full advantage of the software.
You can achieve a high "STATUS" among your colleagues, get recognized as a professional Planning Engineer and stand out from the competition
Course Curriculum
-
Introduction to Power BI and Data Analytics
- How does Power BI process data?
- Explain data tables and data models.
- Best practices for activity codes in project control.
- Snowflakes Schemas using Power BI.
- Primary and Foreign Keys in project control.
- Principles of data normalization.
-
Creating database and Power Query
- Creating a project control database for Power BI.
- Project Control Database checklist.
- Power Query tutorials for Planning Engineers to transform data.
-
Transform data with Power Query and Data Model relationships
- Transforming Project Control data with Power Query.
- Adding Project Control Data Model Relationships.
-
Earned Value, Measures, Cards, Themes and Progress Curve
- Earned Value in Project Control.
- Adding Measures.
- Card Visualization for Planning and Project Control.
- Color wheel in project control.
- Import themes and color customization for Planning Engineer's reports.
- Progress Curve in Project Control.
-
Conditional Formatting, Planned vs Actual and Activity % Trend Visualizations
- Conditional Formatting in Power BI for Planning Engineer's reports.
- Gauge visualization for Planned vs Actual in project control.
- Pie Chart visualization.
- Table Visualization for Planned vs Actual.
- Types of Slicers for project control reporting.
- Cross Filter Direction for project control reporting.
- Bar Chart visualization for Planned vs Actual.
- Activity % and Earned Value Trend Visualization for Planning Engineer's applications.
-
Variance and Trend Analysis, Matrix and Gantt Chart
- Project delay trend chart.
- Cost variance trend chart.
- Breakdown analysis with Treemap visualization.
- Breakdown analysis with Decomposition tree in Project Control.
- Matrix Visualization for Planning Engineers to report progress.
- Gantt Chart in Power BI for Planning Engineers.
-
Bookmarks and Connect Drawings
- Create bookmarks and selections to optimize space.
- Install Inkspace to create SVG.
- Add Synoptic visual inside Power BI.
- Develop interactive project control reports with project drawings as a Planning Engineer.
-
Publish reports, connect P6 with Power BI and other visualizations
- Create free emails to sign in Power BI.
- Publish Power BI reports.
- Connect Power BI with P6 database.
- Planning and Project Control KPI indicators.
- Ribbon, Donut and Area Charts.
- Key Influencers.
- Funnel Chart and Multi-row Cards.
- Waterfall and Stacked Column Chart.
-
Interactive Dashboards with Advanced Excel
- Pivot tables and Power Pivot for project control.
- Build data model with relationships.
- Develop interactive project control dashboards.
-
Append queries and import recovery programs
- Append queries from folder for project control reporting.
- Import recovery programs to Power BI.
How is this program different?
- The course doesn't just explain Power BI features but how to apply them in Project Control as a Planning Engineer.
- You will not only learn Power BI software. you will learn the key principles of data analytics such as cardinality, cross filter direction, primary and foreign keys and data normalization. This will help you build an effective project control models that eliminate errors.
- Power BI software mechanisms and the process of analyzing data are also explained. The course teaches planning engineers how to think like Power BI.
- You will also receive templates that can make your project control work a lot easier.
- JSON themes are also provided to save you hours of formatting work.
Get the support you need
Attend 6 weekly live Zoom sessions with the instructor to ask questions and clarify doubts.
Can’t make it live? Post your question inside our private community. You can also network with like-minded engineers there. You can also use a tool called “Loom” which is a free chrome extension that allows you to share your screen and ask any technical question as if you are inside a Zoom class. You get the response from me via Loom too. This means that you complete the course and ask any questions at your own pace. No time wasted.
You may feel alone. But you no longer have to do it alone. You'll get
Understand Power Query, Relationships and Visualizations.
Private community membership ($700 Value)
BONUS# 2: Templates ($400 Value)
Ready templates to make your work a lot faster.
BONUS# 3: Themes ($400 Value)
BONUS# 4: Lifetime access to the course ($400 Value)
Total Value: $4,500
Program Price: $699
Be the first to know when registration is open
Check out what other engineers who took the course are saying...
It was a really interesting training that fully met my expectation in the advanced levels of project control tools. I am glad to end 2021 with it. Osama Saad, MBA, PMP, PSP, PMI-SP delivered the course with professionalism, wide knowledge, and expertise. He really masters the advanced levels of Primavera P6, Excel, Power BI, and delay analysis. The course was one of the best trainings I have ever attended, as it was clear, precise, and very practical.
Mahmoud Arafat
Project Control Manager, KSA
The programs have a dense content "although it was enjoyable" and new information was presented "in a practical way". Planning, scheduling, controlling, and interactively presenting the outcome using Power BI was great to add to my skills as an Engineer. Thanks Osama Saad, MBA, PMP, PSP, PMI-SP for sharing your brilliant experience with me.
Wael Eldemardash
Senior Project Engineer, Australia
Practical Project Control Course covers all practical knowledge with detailed explanation of P6 and also the usage of Advanced Excel Functions in the Planning and Project Control.Power BI in Project Control Course: the best in Industry explanation with all Visual for advanced Dashboards that meet the current Industry demand. Delay Analysis and EOT Claim Course which explains Practical TIA -Windows analysis with Effective EOT writing and submission.
Dilip Kumar
Planning Manager, Oman
I would like to thank Engr Osama Saad for his important part in providing invaluable support through the “PSP Exam Preparation Course” offered by Smart PM Training. I wonder how to pass the exam without this course. The content of the course, the mock-up test, valuable tips and the strategies really helped me to focus on the important topics needed to pass the exams. To the planners, I highly recommend you take this “PSP Exam Preparation Course”.
Joel Estella
Project Control Manager, Turner KSA
Great Practical Content, and believe it or not, you can really do Magic with Power BI in Project Control! Thanks Osama Saad, MBA, PMP, PSP, PMI-SP for the great comprehensive training course which is direct to the point and provides a clear concept of how to use Power BI in the Project Control field.
Ahmed Qamary
Senior Planning Engineer, Qatar
Delay Analysis from A to Z ! Excellent course with integrated process of delay analysis, which presents inclusive knowledge in capsule. It is highly recommended course for my colleagues who are interested in learning more about delay analysis and the integration of the comprehensive process on Primavera 6. It is really excellent and valuable course that introduce a complicated process in a very simple way which makes from a beginner in the field a master indeed.
Eman Fouad
Contracts Engineer, UAE
I found this course much more practical and precise in terms of illustration. Being an independent Planning Engineer since the start I am always facing the same issues which you discussed during the course. I admire your work & appreciate your work, please keep it up.
Shaikh Ayazuddin
Planning Engineer, UAE
Power BI course from Smart PM Training is very impressive and useful for the Project Control. I understand that it is inevitable in Project Control now. It helps minimizing time while producing dashboard reports and all comprehensive reports in visual.The course is well structured and well explained. Although it is more comprehensive with 17 hour, the way it is explained makes us much attentive and not got deviated.
Gani Muhammed
Project Control Engineer
The course was well structured and I am happy to learn some insider tricks and tips from a well experienced delay analyst.
Hemanth Kumar
Planning Manager, Qatar
I would like to Thank Eng Osama Saad, MBA, PMP, PSP, PMI-SP and Smart PM Training for Delay Analysis Mastery course. The course content was well structured and easy to understand to everyone. I strongly recommend to all my connections, friends and colleagues those who want to learn about Delay Analysis and EOT claim. Much appreciate to Eng Osama Saad, MBA, PMP, PSP, PMI-SP for the template provided during the course which is really helpful for Delay analysis beginners.
Dhandapani Perumal
Senior Planning Engineer, Bahrain
Thanks a lot Eng. Osama. From the beginning of the course, I had confidence in the content he provided because of my previous experiences as this was my fifth course with him. The PSP course is one of the strongest courses that I ever attended, and it benefited me on a personal level.There is no need for any other sources, only this comprehensive course is enough. I booked the test only one week after the end of the course. I highly recommend it. Thank you, Engineer Osama!
Ashraf Morsy
Project Control Engineer, KSA
I would like to especially thank the professional engineer Osama Saad for his easy and simple method of delivering information. There is no doubt that this course has reorganized some of the information gained in my mind. And also organize the process of how to formulate the Claim to become stronger, specific and technically acceptable. It’s a very important course for Planning , Scheduling and Control engineers. All thanks and appreciation to engineer Osama and his Team.
Ahmed Ramadan
Planning Engineer
I would like to thank Eng. Osama Saad, MBA, PMP, PSP, PMI-SP and Smart PM Training for effective delay analysis course. it's a very important course for planning, contract engineers and project control engineers.The most important part for me is the effective writing, presentation of the claim, narrative structure and determination of fragnet events and impacts.
Abdullah Saleh
Planning Engineer
Thank you very much for your course about delay analysis. I’ve attended similar courses before; yours was by far the most useful and valuable Osama Saad, MBA, PMP, PSP, PMI-SP. I highly recommend this course of study to anyone interested in improving his knowledge about delay analysis and claims in Smart PM Training.
Ayman Ellaithy
Planning Engineer
You may feel alone. But you no longer have to do it alone. You'll get
Power BI Tutorials for project control ($1,000 Value)
Understand Power Query, Relationships and Visualizations.
Data Analytics Training for Planning Engineers ($500 Value)
Data normalization, snowflake schemas, cross filter direction, cardinality and primary and foreign keys.
Weekly Live Classes ($500 Value)
Attend 6 weekly live Zoom sessions to ask questions and clarify doubts.
Private community membership ($800 Value)
Network with like-minded planning engineers, ask questions and clarify doubts.
BONUS# 1: Advanced Excel for planning Engineers ($500 Value)
Pivot Tables, Power Pivot and Interactive Dashboards in Excel.
BONUS# 2: Templates ($400 Value)
Ready templates to make your work a lot faster.
BONUS# 3: Themes ($400 Value)
JSON files that you can upload and have professional designs in seconds.
BONUS# 4: Lifetime access to the course ($400 Value)
Access the course anytime in future to refer any tutorials that might help you at work.
Total Value:$4,500
Program Price: $995
We enroll the course members in batches so we can give them the best support.
Registration will be open in June 2024.
Be the first to know when the registration is open
How much does it ACTUALLY cost you?
- The course price is still a fraction of what a master degree will cost you. Moreover, academic degrees won't teach you data analytics, Power BI, task automation or advanced excel. Employers are looking to hire professional planning engineers who have a practical knowledge and can get the job DONE.
- The course price might be equivalent to a one week salary or two months salary for you. This can be the best investment that you will make in yourself so far. You will significantly compress the time horizon for your career development and also stand out from the competition by showing unique skills. You will gain supreme skills and unlock better career opportunities for many years ahead. Your average skills and lack of knowledge will cost you more in the long run. So the course really pays for itself.
Certify your knowledge with a Certificate of Completion
You can demonstrate your discipline towards continuous learning which Employers are looking for in candidates.
Frequently asked questions(FAQ)
Yes, the course explains data analytics and all Power BI features from scratch.
All lessons are pre-recorded! Post your question inside our private community. You can also use a tool called “Loom” which is a free chrome extension that allows you to share your screen and ask your questions as if you are inside a Zoom class. You get the response from me via Loom too. This means that you complete the course and ask any questions at your own pace. No time wasted!
After you sign up for the course, you will receive an invitation to join our private community.
We enroll members in batches so we can give them full attention and the best support. We can also effectively monitor their progress throughout the course.
Email us at info@smartpmtraining.com and we’ll help you out.
Total Value:$4,500
Program Price: $995
Registration will be open in June 2024.