Power BI for Project Control

Ideal for Planning Engineers. NOT Suitable for Beginners

The course is delivered in English

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 13 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.

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.

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

As the course is recorded, sometimes you want to ask the instructor a question. For each batch, we host a weekly live Q&A session over 12 weeks period to help course members clarify doubts and ask questions. This means that you complete the course and ask questions at your own pace. In the session, you can share your screen and ask your question.

That's why we enroll members in batches so we can monitor their progress and give them the best support.

Join Our Private Community

Can't wait for the live Q&A session to ask your question or can't attend live? You can post your question inside our private community. You can also network with like-minded engineers there

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.

12 Live Q&A Zoom Sessions ($600 Value)
Ask questions, clarify doubts and learn from others' questions.

Private community membership ($700 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: $699

We enroll members in batches so we can give them the best support. Registration is now closed.

Be the first to know when registration is open

5 days money-back guarantee

If you are not satisfied with the course, request a refund within 5 calendar days of your purchase and I will honor the request. That's how confident I am about my courses. You will be blown away by the training. You can try the course risk-free to understand if it is the type of training you're looking for, and if not, get 100% of your money back.

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 day 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 - 17 Hours (PDUs)

Boost your CV and LinkedIn Profile with a Certificate of Completion.

You can demonstrate your discipline towards continuous learning which Employers are looking for in candidates.

Frequently Asked Questions (FAQ)

No. You must have some experience as a Planning Engineer or you completed "Practical Project Control" Course with us before.

All lessons are pre-recorded! Which means you can watch the lessons at your own pace and practice each module before we meet for our weekly Q&A Calls. If it's taking you longer to work through the content, that's cool too—you have lifetime access to the course.

We understand that it is a journey of practice and it is impossible to master everything in your first attempt. For this reason, we offer life-time access to the program so that you can refer any particular tutorials whenever you need to in future.

The program is recorded and has 17 hours of "direct" content delivery through professionally-edited videos. There are no long pauses or unnecessary areas that will waste your time. The program is designed for busy professionals to help them get the best value out of their time.

After you sign up for the course, you will receive an email that has all the information related to the weekly sessions. You will also receive an invitation to join our private community.

Our course members are across the globe. You can submit your questions before the Q&A session, so even if you can't make it live, I will still answer them for you. All live sessions will be recorded and added to your course portal so you can watch them in your own time. Alternatively, you can post the questions inside the community.

The number of PDUs will be mentioned on the certificate. You can submit your PDUs claim to PMI as follows (Category: Education, Sub-category: Course or Training). Smart PM Training is a licensed and registered training institute in the UAE. All of our certificates can be claimed for PDUs or CEUs.

Email us at osama@smartpmtraining.com and we'll help you out.

Words speak for themselves...

Total Value: $4,500

Program Price: $699

Be the first to know when registration is open