15 Topics
10 Days
75 Sessions
Programme Overview
Training Description
Who Should Attend
- Programme and Portfolio Managers
- Project Coordinators and Project Officers
- Business Analysts
- Data and Business Intelligence Analysts
- Finance and Cost Control Professionals
- Resource Managers
- Risk Management Professionals
- Engineers and Construction Project Professionals
- IT Project Managers and Technology Professionals
- Reporting and Performance Management Professionals
- Professionals responsible for project dashboards and management reporting
Session Objectives
- Understand the core features of Microsoft Project
- Create and manage a project schedule
- Assign resources and track progress
- Build project reports in MS Project
- Understand the fundamentals of Power BI
- Connect MS Project data to Power BI
- Create interactive dashboards and visualizations
- Develop key performance indicators (KPIs) for projects
- Automate data refreshes for real-time reporting
- Present project insights to stakeholders
About the Course
The Data-Driven Project Mastery: Microsoft Project Management with Power BI Training Course equips project professionals with practical skills to combine Microsoft Project and Power BI for effective project planning, monitoring, analysis, visualization, and decision-making.Participants will learn how to develop project schedules in Microsoft Project, manage resources and milestones, track progress, and extract meaningful project data for analysis. They will then use Power BI to transform project data into interactive dashboards and reports that provide real-time insights into schedule performance, costs, resources, risks, and overall project health.
Curriculum & Topics
15 Topics | 75 Sessions
-
Workshop 1.1:
The role of MS Project in project management
-
Workshop 1.2:
Navigating the user interface
-
Workshop 1.3:
Understanding project views (Gantt, Task Usage)
-
Workshop 1.4:
Creating and saving a new project file
-
Workshop 1.5:
Setting up project calendars
-
Workshop 2.1:
Creating a work breakdown structure (WBS)
-
Workshop 2.2:
Defining tasks and durations
-
Workshop 2.3:
Establishing task dependencies
-
Workshop 2.4:
The importance of the critical path
-
Workshop 2.5:
Using milestones to track key deliverables
-
Workshop 3.1:
Defining and assigning project resources
-
Workshop 3.2:
Handling resource over-allocation
-
Workshop 3.3:
Understanding resource types (work, material, cost)
-
Workshop 3.4:
The role of a resource calendar
-
Workshop 3.5:
Tracking resource usage and costs
-
Workshop 4.1:
Setting a project baseline
-
Workshop 4.2:
Updating tasks with progress
-
Workshop 4.3:
The difference between planned and actual work
-
Workshop 4.4:
Using the tracking Gantt view
-
Workshop 4.5:
Troubleshooting a schedule that is off track
-
Workshop 5.1:
Using the built-in report templates
-
Workshop 5.2:
Customizing reports with specific data
-
Workshop 5.3:
Exporting reports to other formats
-
Workshop 5.4:
Creating a visual report
-
Workshop 5.5:
Highlighting project risks and issues
-
Workshop 6.1:
The role of Power BI in data visualization
-
Workshop 6.2:
Navigating the Power BI desktop interface
-
Workshop 6.3:
Understanding datasets, reports, and dashboards
-
Workshop 6.4:
Importing data from different sources
-
Workshop 6.5:
Using the Query Editor to transform data
-
Workshop 7.1:
Methods for exporting data from MS Project
-
Workshop 7.2:
Using the "Excel" option for data transfer
-
Workshop 7.3:
The benefits of a clean data source
-
Workshop 7.4:
The importance of a consistent data model
-
Workshop 7.5:
Establishing the relationship between tables
-
Workshop 8.1:
The importance of a star schema
-
Workshop 8.2:
Creating relationships between tables
-
Workshop 8.3:
Understanding cardinality and filter direction
-
Workshop 8.4:
The role of a date table
-
Workshop 8.5:
Hiding unnecessary columns
-
Workshop 9.1:
Choosing the right chart type for your data
-
Workshop 9.2:
Building a Gantt chart in Power BI
-
Workshop 9.3:
Visualizing project costs and budgets
-
Workshop 9.4:
Creating a report on resource allocation
-
Workshop 9.5:
Designing a project status dashboard
-
Workshop 10.1:
Using custom visuals from the marketplace
-
Workshop 10.2:
Building a project timeline with a slicer
-
Workshop 10.3:
Creating a project health matrix
-
Workshop 10.4:
Using cards for key metrics
-
Workshop 10.5:
The importance of clear and concise design
-
Workshop 11.1:
Introduction to DAX formulas
-
Workshop 11.2:
Creating calculated columns
-
Workshop 11.3:
Building custom measures
-
Workshop 11.4:
The purpose of time intelligence functions
-
Workshop 11.5:
Using DAX to calculate project variance
-
Workshop 12.1:
Publishing your report to the Power BI Service
-
Workshop 12.2:
Creating a dashboard from your report
-
Workshop 12.3:
Sharing dashboards with team members
-
Workshop 12.4:
The benefits of a shared workspace
-
Workshop 12.5:
The importance of data security
-
Workshop 13.1:
Setting up an automated refresh schedule
-
Workshop 13.2:
Using a personal gateway for on-premises data
-
Workshop 13.3:
Troubleshooting data refresh issues
-
Workshop 13.4:
The importance of real-time data
-
Workshop 13.5:
Best practices for maintaining data integrity
-
Workshop 14.1:
The importance of a clear narrative
-
Workshop 14.2:
Building a project narrative with your dashboard
-
Workshop 14.3:
The role of tooltips and drill-through pages
-
Workshop 14.4:
Using the Q&A feature for quick insights
-
Workshop 14.5:
Presenting data to a non-technical audience
-
Workshop 15.1:
A case study on reporting a large construction project
-
Workshop 15.2:
A scenario on managing a software development project
-
Workshop 15.3:
Best practices for a hybrid project approach
-
Workshop 15.4:
A use case for portfolio-level reporting
-
Workshop 15.5:
Troubleshooting a data connection issue
