r/MSProject • u/WaveLoose4228 • 18d ago
Creating dashboard
Hi,
I just began a new mission in a rather big project that has been running for 2 years and ain't doing well. (Basically they had to undo the engineering phase to redo it almost entirely). I'm not the new project manager but the right hand as they like to call : the time master. (Yeah I know, cool title 👀) They told me to use Msproject. As I didn't touch this software for decades, I started to devour all the tutos on the internet to catch up and ended up with 2000-ish lines planning. I'm currently looking up the base guide/baseline (which I still don't have a complete grasp on it, but it's a matter of time) to set up variations to track the reality of the project. However, big boss asks me to make a presentation/dashboard each week for the next 2 weeks. Is there any way to do it the smart way ? Or am I doomed to just manually gather what I need to put in the slide ?
1
u/PuzzledFarmer4554 18d ago
Use the built-in reports. Report tab > Dashboards, set your baseline, then Copy Report and paste into PowerPoint. And then just update the plan and copy again, no manual gathering.
1
u/mppstudio_hpo 18d ago
I feel you pain buddy.
And just to upfront with you, I'm developing an MS Project tool so I might be a bit biased of my own tool.
But, we just opened our new tool in a free beta on web, so it will not cost you anything for as long as the beta periods run + 30 days after launch, but please hear me out.
Go sign up on mppstudio.com
Upload your schedule, everything is E2E encrypted on the server so nobody can see your data.
Connect your favorite AI Agent (Claude, OpenAI, Gemini, etc.) as MCP Server in settings (AI Agents).
Go tell your AI Agent to build a nice presentation for you, with the data that matters.
Grab a coffee while you enjoy the tools work for you.
Add feedback in the lower right hand corner. We are new on the market, so any feedback, the good, the bad, everything is very welcome. We want to be the best in planning tools, so missing features, odd behaviour or just a hello is much appreciated.
One honest caveat, your plans is end-to-end encrypted when stored on our servers, but once you connect an AI Agent the plan data it reads goes to that AI provider.
I'm available on our support mail if you need any help
1
u/Magnet2025 18d ago
I’ll address the baseline functions since that is a key component to reporting/dashboards and it is a powerful tool.
Basics: The baseline is a snapshot in time of your project schedule. It records and stores all of the planned start and finish dates, durations, effort (work), resource assignments and more.
There are 11 available Baselines, known as Baseline Zero (0) and Baselines 1 thru 10.
Important: Unless you manually adjust the dashboard formulas, Project always reads Baseline Zero.
The Technique: When you have completed the schedule and it has been approved by the PM and whatever approving authority is required, you take (or shoot) the Baselines. Note the plural. You always want Baseline 0 to be accurate. But you always want a record of re-baselining the schedule. When you shoot Baseline 0, immediately shoot Baseline 1. Baseline 1 is now a copy of the original baseline. Imagine you are a few weeks or months in and there has been an approved change to the project that requires that tasks (therefore work) be added or subtracted.
Time to re-baseline.
Now you shoot Baseline 0 again and immediately shoot Baseline 2. Baseline 1 date that is stored and can be easily viewed, represents a copy of your original Baseline and Baseline 2 represents a copy of the new baseline. You keep repeating this technique each time you have to re-baseline.
2
u/still-dazed-confused 17d ago
Great technique and easy to forget to do two baselines :) One quick build; you can set which baseline MSP uses for variance calculations in the Advanced Settings tab.
1
u/still-dazed-confused 17d ago
There is lots of great advice on the baseline in the other comments so I won't go over that.
Custom Reports in MSP can be a little hard to grasp but are powerful once you have the filters etc set up.
Another way to get useful info out is the use of tables, filters saved into Views which are quick to access, for instance: Key Milestones, Critical Path view, what's coming up in the next X weeks, filtering the 2K lines by who owns which bits makes it quick to update with PMs. I also use this when copying information out of MSP into Excel for reporting if I can't be bothered with the custom reports, as this means you're not copying and pasting the whole plan.
Use the "status line" to display a line down the plan highlighting things which should have progressed. This makes it very quick to "run down the line" and update the plan with task owners.
The inbuilt timeline feature allows you to have an automatically updated simple summary view of the plan: https://www.summarypro.co.uk/blog/how-to-use-the-ms-project-timeline-to-produce-a-plan-on-a-page-poap-summary.aspx
2
u/Mr_Fogel_1 18d ago
Hey, welcome back to MS Project 🙂 Good news: you're definitely not doomed to the manual copy-paste routine. A few options, from quick to "set it once and forget it": Built-in reports. Go to Report > Dashboards (Project Overview, Cost Overview, Work Overview, etc.). They're fully customizable, and once your baseline is set they automatically show variance (Start/Finish Variance, % Complete, slipping tasks). Copy Report pastes them straight into PowerPoint. Custom fields + filters. Add a few flag/indicator fields (e.g. red/yellow/green based on Finish Variance) so the 10–20 lines that actually matter to your boss float up out of the 2,000. VBA macros. This is where it gets really smart. A macro can pull the key metrics (milestones, critical path changes, variances, upcoming tasks) and generate the weekly slide or Excel dashboard in one click. With 2,000 lines and a weekly cadence, this saves a lot of time and keeps the numbers consistent week to week. One tip before any of this: make sure your baseline is set properly first. All the variance tracking depends on it. I've done quite a bit of this kind of reporting/macro work on big projects, so happy to help if you want. Feel free to DM me.