background

Power Query Tips + Project Rescue: How PM Excellence Saved $75M


New Article: Beginner’s Guide - Extracting Project Online Data into Power BI & Excel with Power Query

Unlock the full potential of your Project Online data with Power Query! In this step-by-step tutorial, you'll:

  • Learn to access the Project Online Reporting API directly
  • Transform complex JSON data into structured, usable tables
  • Master date conversion for accurate timeline reporting
  • Get ready-to-use code samples to adapt for your own reporting needs

This beginner's guide is helpful for project managers and PMO professionals who want better reporting without specialized coding skills.

P.S. Author Eric Christoph is teaching our live lesson this week! Register here for Excel & Power BI Supercharged - Unlock Project Online Data with Power Query + learn more below.

Video Quick Video Tip: Enhance Your Schedule with Deadline Dates in Microsoft Project

Need a flexible way to track due dates in Microsoft Project? This quick tutorial shows you how deadline dates can transform your scheduling approach:

  • Apply deadline dates to any task type - summary, regular, or milestone
  • Display contractual finish dates or team targets visually on your Gantt chart
  • Maintain scheduling flexibility unlike rigid constraints like "Must Finish On"
  • See deadlines appear as green arrows directly on your Gantt chart

Watch this 2-minute video to learn how to set and use deadline dates to communicate important target dates while keeping your schedule dynamic.

Case Study: How Strategic Project Management Transformed an EV Manufacturing Launch

Discover how advanced project management techniques rescued a troubled electric vehicle production program. This real-world case study reveals:

  • How establishing clear milestones and KPIs turned a failing launch around
  • Why structured quality planning became the backbone of manufacturing success
  • The project management approach that recovered a six-month parts delay
  • Strategic changes that ultimately reduced program costs by over $75M

This is a great example of how disciplined project management methodologies can create measurable business impact in complex manufacturing environments.

Live Event (3/5): Excel & Power BI Supercharged - Unlock Project Online Data with Power Query

Ready to transform your Project Online data into powerful insights? Join us for a hands-on session that will revolutionize your reporting workflow.

You'll learn how to:

  • Connect directly to Project Online data using Power Query
  • Automate tedious data cleaning and transformation tasks
  • Create dynamic dashboards in Excel and Power BI
  • Implement best practices for efficient project reporting

🗓️ Wednesday, March 5

🕛 12:00pm - 1:00pm EST

📍 Live on Zoom

🏅 1 PMI PDU: Business Acumen

Ideal for data analysts and anyone working with Project Online data. Bring your questions for live Q&A!

P.S. Live events + on-demand replays are exclusive for MPUG members! Join today for just $14.75/month.

Upcoming Live Events

MPUG host live events with leading experts on Wednesdays from 12:00pm - 1:00pm ET! MPUG members get access to live events where you get direct access to industry leaders, actionable insights, hands-on training, and opportunities to earn PDU's.

Learn more and register for upcoming events:

3/5: Excel & Power BI Supercharged - Unlock Project Online Data with Power Query | Learn More / Register Here

3/12: Scaling Scrum with Hands-on Applicability: Understanding Scaling with Scrum (Part 1) | Learn More / Register Here

3/19: Scaling Scrum with Hands-on Applicability: Scaled Scrum with CIPSA Framework (Part 2) | Learn More / Register Here

3/26: Scaling Scrum with Hands-on Applicability: Hands-on, Scaled Scrum with MS Project (Part 3) | Learn More / Register Here

PM Best Practice: Let Deadlines Drive Milestones, Not Constraints

Instead of using rigid constraints like "Must Finish On" in your schedule, try using deadline dates. They provide necessary visibility for stakeholders while maintaining scheduling flexibility. Deadlines appear as green arrows in Microsoft Project's Gantt chart but don't force fixed dates that can create artificial scheduling conflicts. This approach lets your schedule respond dynamically to real-world changes while still clearly communicating important target dates to your team.

Have a great week!

Follow MPUG for PM Tips + Training

View our Privacy Policy

1001 Woodward Ave Suite 500, Detroit, MI 48226
Unsubscribe · Preferences

background

Subscribe to MPUG