| <!doctype html><html lang="en"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><title>Project Dashboard Template for Tableau — PMO Schedule, Budget & Risk (.twb, connect your own task export)</title><meta name="description" content="Map your own project task export onto 12 named columns and get 8 calculated fields — schedule variance in days, budget burn %, effort overrun %, completion rate % and a per-task risk classification — laid out over 5 sheets and 1 dashboard. Opens in the free Tableau Public (US$0 licence); the .twb ho"><style> |
| :root{color-scheme:light dark} |
| body{font:16px/1.55 system-ui,-apple-system,"Segoe UI",sans-serif;margin:0;padding:22px; |
| max-width:960px;margin-inline:auto} |
| h1{font-size:1.4rem;margin:0 0 .3rem} |
| .sub{opacity:.78;margin:0 0 1.3rem} |
| h2{font-size:1.06rem;margin:1.8rem 0 .5rem} |
| table{border-collapse:collapse;width:100%;font-size:.93rem} |
| th,td{border:1px solid #8884;padding:.42rem .55rem;text-align:left;vertical-align:top} |
| th{font-weight:600;opacity:.85} |
| code{font:.9em ui-monospace,SFMono-Regular,Menlo,monospace;background:#8881; |
| padding:.12rem .34rem;border-radius:5px;word-break:break-word} |
| .f{border:1px solid #8884;border-radius:10px;padding:12px 14px;margin:.55rem 0} |
| .f p{margin:.35rem 0 0} |
| .hdr{display:block;padding:.6rem .7rem;overflow-x:auto;white-space:pre} |
| ul{margin:.4rem 0 0;padding-left:1.15rem} |
| .buy{margin-top:26px;border:1px solid #8884;border-radius:11px;padding:16px} |
| .buy a{display:inline-block;margin-top:.6rem;padding:.55rem 1rem;border:1px solid currentColor; |
| border-radius:8px;text-decoration:none;color:inherit;font-weight:600} |
| </style><script data-grow-initializer="">!(function(){window.growMe||((window.growMe=function(e){window.growMe._.push(e);}),(window.growMe._=[]));var e=document.createElement("script");(e.type="text/javascript"),(e.src="https://faves.grow.me/main.js"),(e.defer=!0),e.setAttribute("data-grow-faves-site-id","U2l0ZTphZjljMzgyMC0yMmU5LTRhYjgtYTIxNS03OTRhMGY1N2ExYzM=");var t=document.getElementsByTagName("script")[0];t.parentNode.insertBefore(e,t);})();</script> |
| <link rel="canonical" href="https://getreadystack.com/tools/project-dashboard-template-tableau"></head><body> |
| <h1>Project Dashboard Template for Tableau — PMO Schedule, Budget & Risk (.twb, connect your own task export)</h1><p class="sub">Map your own project task export onto 12 named columns and get 8 calculated fields — schedule variance in days, budget burn %, effort overrun %, completion rate % and a per-task risk classification — laid out over 5 sheets and 1 dashboard. Opens in the free Tableau Public (US$0 licence); the .twb holds no data, only the formulas and the layout.</p> |
| <h2>Calculated fields included (8)</h2> |
| <div class="f"><b>Schedule Variance (Days)</b><p>Formula: <code>IF [Status] = "Done" THEN DATEDIFF('day', [Baseline Finish], [Actual Finish]) ELSE DATEDIFF('day', [Baseline Finish], TODAY()) END</code></p><p>Uses: <code>Status</code>, <code>Baseline Finish</code>, <code>Actual Finish</code></p></div> |
| <div class="f"><b>Schedule Status</b><p>Formula: <code>IF [Schedule Variance (Days)] > 5 THEN "Late (over 5 days)" ELSEIF [Schedule Variance (Days)] > 0 THEN "Slipping (1-5 days)" ELSE "On track" END</code></p></div> |
| <div class="f"><b>Cost Variance (USD)</b><p>Formula: <code>SUM([Actual Cost]) - SUM([Budgeted Cost])</code></p><p>Uses: <code>Actual Cost</code>, <code>Budgeted Cost</code></p></div> |
| <div class="f"><b>Budget Burn %</b><p>Formula: <code>IIF(SUM([Budgeted Cost]) = 0, 0, ROUND(SUM([Actual Cost]) / SUM([Budgeted Cost]) * 100, 1))</code></p><p>Uses: <code>Budgeted Cost</code>, <code>Actual Cost</code></p></div> |
| <div class="f"><b>Effort Overrun %</b><p>Formula: <code>IIF(SUM([Estimated Hours]) = 0, 0, ROUND((SUM([Logged Hours]) - SUM([Estimated Hours])) / SUM([Estimated Hours]) * 100, 1))</code></p><p>Uses: <code>Estimated Hours</code>, <code>Logged Hours</code></p></div> |
| <div class="f"><b>Completed Flag</b><p>Formula: <code>IIF([Status] = "Done", 1, 0)</code></p><p>Uses: <code>Status</code></p></div> |
| <div class="f"><b>Completion Rate %</b><p>Formula: <code>IIF(COUNT([Task ID]) = 0, 0, ROUND(SUM([Completed Flag]) / COUNT([Task ID]) * 100, 1))</code></p><p>Uses: <code>Task ID</code></p></div> |
| <div class="f"><b>Risk Flag</b><p>Formula: <code>IF [Schedule Variance (Days)] > 5 THEN "Escalate now" ELSEIF [Actual Cost] > [Budgeted Cost] THEN "Over budget - review" ELSEIF [Status] = "Blocked" THEN "Blocked - needs owner" ELSE "Healthy" END</code></p><p>Uses: <code>Actual Cost</code>, <code>Budgeted Cost</code>, <code>Status</code></p></div> |
| <h2>Columns your CSV must have (12)</h2><table><tr><th>Column</th><th>Type</th><th>Role</th></tr><tr><td><code>Task ID</code></td><td>string</td><td>dimension</td></tr><tr><td><code>Project</code></td><td>string</td><td>dimension</td></tr><tr><td><code>Assignee</code></td><td>string</td><td>dimension</td></tr><tr><td><code>Status</code></td><td>string</td><td>dimension</td></tr><tr><td><code>Priority</code></td><td>string</td><td>dimension</td></tr><tr><td><code>Start Date</code></td><td>date</td><td>dimension</td></tr><tr><td><code>Baseline Finish</code></td><td>date</td><td>dimension</td></tr><tr><td><code>Actual Finish</code></td><td>date</td><td>dimension</td></tr><tr><td><code>Estimated Hours</code></td><td>real</td><td>measure</td></tr><tr><td><code>Logged Hours</code></td><td>real</td><td>measure</td></tr><tr><td><code>Budgeted Cost</code></td><td>real</td><td>measure</td></tr><tr><td><code>Actual Cost</code></td><td>real</td><td>measure</td></tr></table> |
| <h2>CSV header row</h2><code class="hdr">Task ID,Project,Assignee,Status,Priority,Start Date,Baseline Finish,Actual Finish,Estimated Hours,Logged Hours,Budgeted Cost,Actual Cost</code> |
| <p>File you connect: <code>project_tasks_export.csv</code></p> |
| <h2>Worksheets (5)</h2><ul><li>Project Health Scorecard</li><li>Schedule Variance by Project</li><li>Budget Burn by Project</li><li>Completion Trend by Month</li><li>At-Risk Task List</li></ul> |
| <h2>Dashboards (1)</h2><ul><li>Project Status Dashboard</li></ul> |
|
|
| <section data-yj-cta="paid" style="margin:3rem auto;max-width:46rem;padding:1.5rem 1.25rem;border:1px solid #d8dee9;border-radius:12px;background:#fbfcfe;font:16px/1.6 system-ui,-apple-system,Segoe UI,sans-serif"><h2 style="margin:0 0 .5rem;font-size:1.25rem">Get the complete version <span class="yj-price">$120</span></h2><p style="margin:.25rem 0 1rem;color:#41505f">This page is the working piece. The full pack has everything below.</p><p style="margin:0 0 1rem;color:#41505f">Map your own project task export onto 12 named columns and get 8 calculated fields — schedule variance in days, budget burn %, effort overrun %, completion rate % and a per-task risk classif</p><p style="margin:0 0 1rem;color:#5b6b7c;font-size:.94rem">Measured on this shelf right now: a comparable ready-made Tableau project dashboard workbook is listed at US$120. A bespoke build is billed by the hour by a Tableau contractor — we do not quote an hourly rate we have not measured </p><a href="https://buy.polar.sh/polar_cl_RQOvhyGHOof2pS5u9G0u1LIPIN8Zfh5AZxC4r4TY6T5" rel="nofollow" style="display:inline-block;padding:.7rem 1.3rem;border-radius:8px;background:#1b64f2;color:#fff;text-decoration:none;font-weight:600">Send it to me</a></section> |
| <section class="yj-related" style="max-width:920px;margin:56px auto 40px;padding:0 20px"><h2 style="font:600 21px/1.3 system-ui,sans-serif;margin:0 0 6px;color:#1b1f24">More from ReadyStack</h2><p style="font:400 14.5px/1.5 system-ui,sans-serif;margin:0 0 20px;color:#5b6570">Ready-to-use files. One-time download, no subscription.</p><div style="display:grid;grid-template-columns:repeat(auto-fill,minmax(250px,1fr));gap:14px"><a class="yj-rel-c" href="https://getreadystack.com/tools/engineer-resume-template"><span class="yj-rel-t">Engineer Resume Template — 6 Fill-In Word Résumés: Software, Mechanical New-Gr</span><span class="yj-rel-p">$29</span></a><a class="yj-rel-c" href="https://getreadystack.com/tools/shopify-theme-digital-products"><span class="yj-rel-t">Shopify Theme for Digital Products — Instant-Download Store for Ebook, Preset </span><span class="yj-rel-p">$200</span></a><a class="yj-rel-c" href="https://getreadystack.com/tools/agency-website-template"><span class="yj-rel-t">Agency Website Template — 7-Page Studio Site in Plain HTML (No Subscription, S</span><span class="yj-rel-p">$49</span></a><a class="yj-rel-c" href="https://getreadystack.com/tools/charter-boat-booking-wordpress-plugin"><span class="yj-rel-t">Charter Boat Booking Requests — 6-Passenger Limit</span><span class="yj-rel-p">$60</span></a><a class="yj-rel-c" href="https://getreadystack.com/tools/law-firm-website-template"><span class="yj-rel-t">Law Firm Website Template — Six-Page HTML Site for a Solo or Small Practice, W</span><span class="yj-rel-p">$49</span></a><a class="yj-rel-c" href="https://getreadystack.com/en/p/refinance-your-car-or-keep-the-loan-17-formula-verdict-calcu"><span class="yj-rel-t">Refinance Your Car or Keep the Loan: 17-Formula Verdict Calculator</span><span class="yj-rel-p">$19</span></a></div><style>.yj-rel-c{display:flex;flex-direction:column;gap:8px;padding:15px 16px;border:1px solid #e2e6ea;border-radius:6px;text-decoration:none;background:#fff}.yj-rel-c:hover{border-color:#b9c2cb;background:#fafbfc}.yj-rel-t{font:500 14.5px/1.42 system-ui,sans-serif;color:#1b1f24}.yj-rel-p{font:600 13px system-ui,sans-serif;color:#0a6238}</style></section><div style="margin:28px 0 8px;text-align:center"><button id="yjcp" type="button" style="font:inherit;padding:10px 18px;border:1px solid #8884;border-radius:10px;background:transparent;cursor:pointer">Copy link</button></div><script>(function(){var b=document.getElementById("yjcp");if(!b)return;var t=b.textContent;b.addEventListener("click",function(){var u=location.href.split("#")[0];function d(){b.textContent="Link copied";setTimeout(function(){b.textContent=t;},1800);}if(navigator.clipboard&&navigator.clipboard.writeText){navigator.clipboard.writeText(u).then(d,function(){prompt("",u);});}else{prompt("",u);}});})();</script> |
| <script data-yj="yj-view-beacon">(function(){try{var p=location.pathname;var k='yjv:'+p;if(sessionStorage.getItem(k))return;sessionStorage.setItem(k,'1');fetch('/api/ev',{method:'POST',keepalive:true,headers:{'Content-Type':'application/json'},body:JSON.stringify({path:p,lang:"en"})}).catch(function(){});}catch(e){}})();</script> |
| <div class="yj-home-find"><div class="yj-lgbar"><a href="/" class="yj-lg on">EN</a><a href="/de/" class="yj-lg">DE</a><a href="/ja/" class="yj-lg">JA</a><a href="/es/" class="yj-lg">ES</a><a href="/pt/" class="yj-lg">PT</a></div><section class="yj-find"><h2>Find a tool</h2><input id="yjq" type="search" autocomplete="off" placeholder="Type a product name, format or task"><div id="yjr"></div></section><style>.yj-lgbar{position:absolute;top:14px;right:18px;display:flex;gap:6px;z-index:60}.yj-lg{font:600 12px/1 system-ui,sans-serif;padding:6px 9px;border-radius:4px;text-decoration:none;color:#8b96a3;border:1px solid rgba(140,150,165,.28)}.yj-lg:hover{color:#e8eaed;border-color:rgba(160,175,195,.6)}.yj-lg.on{color:#0e1116;background:#cfd6de;border-color:#cfd6de}.yj-find{max-width:760px;margin:34px auto 8px;padding:0 20px}.yj-find h2{font:600 20px/1.3 system-ui,sans-serif;margin:0 0 10px}#yjq{width:100%;box-sizing:border-box;padding:13px 15px;font:400 15.5px system-ui,sans-serif;border:1px solid rgba(140,150,165,.34);border-radius:8px;background:rgba(255,255,255,.04);color:inherit}#yjq:focus{outline:none;border-color:#7FD1C4}#yjr{margin-top:10px;display:flex;flex-direction:column;gap:6px}#yjr a{display:flex;justify-content:space-between;gap:12px;padding:11px 14px;border:1px solid rgba(140,150,165,.22);border-radius:6px;text-decoration:none;font:400 14.5px/1.4 system-ui,sans-serif;color:inherit}#yjr a:hover{border-color:#7FD1C4}#yjr .pr{font:600 13px system-ui,sans-serif;color:#5fbf9a;white-space:nowrap}</style><script>(function(){var q=document.getElementById("yjq"),r=document.getElementById("yjr"),D=null;function load(){if(D)return Promise.resolve(D);return fetch("/search-index.json").then(function(x){return x.json();}).then(function(j){D=j;return j;}).catch(function(){D=[];return D;});}function esc(t){return String(t).replace(/[&<>"]/g,function(c){return {"&":"&","<":"<",">":">",'"':"""}[c];});}function run(){var v=q.value.trim().toLowerCase();if(v.length<2){r.innerHTML="";return;}load().then(function(j){var w=v.split(/\s+/),o=[];for(var i=0;i<j.length&&o.length<12;i++){var t=j[i].t.toLowerCase();var ok=true;for(var k=0;k<w.length;k++){if(t.indexOf(w[k])<0){ok=false;break;}}if(ok)o.push(j[i]);}r.innerHTML=o.length?o.map(function(x){return "<a href=\""+esc(x.u)+"\">"+"<span>"+esc(x.t)+"</span>"+(x.p?"<span class=\"pr\">$"+x.p+"</span>":"")+"</a>";}).join(""):"";});}q.addEventListener("input",run);q.addEventListener("focus",load);})();</script></div><section class="yj-email-gate" style="max-width:46rem;margin:2.5rem auto;padding:1.25rem;border:1px solid rgba(140,150,165,.28);border-radius:10px;font:400 15px/1.5 system-ui,sans-serif"><b style="font-size:1.05rem">Want the full version?</b><div style="opacity:.75;margin:.35rem 0 .8rem">Enter your email and we send the download link.</div><div style="display:flex;gap:8px;flex-wrap:wrap"><input id="yjge" type="email" placeholder="you@example.com" style="flex:1;min-width:210px;padding:11px 13px;border:1px solid rgba(140,150,165,.34);border-radius:8px;background:rgba(255,255,255,.04);color:inherit"><button id="yjgb" style="padding:11px 18px;border-radius:8px;border:0;cursor:pointer;font:600 15px system-ui,sans-serif">Send it to me</button></div><div id="yjgo" hidden style="margin-top:.6rem;color:#5fbf9a">Sent. Check your inbox.</div><script>(function(){var b=document.getElementById("yjgb"),e=document.getElementById("yjge");if(!b||!e)return;b.addEventListener("click",function(){var v=e.value.trim();if(!/.+@.+\..+/.test(v))return;try{localStorage.setItem("yj_em","1");}catch(_){}fetch(location.origin+"/api/subscribe",{method:"POST",headers:{"Content-Type":"application/json"},body:JSON.stringify({email:v,slug:"project-dashboard-template-tableau",lang:"en",source:"hub_gate"})}).catch(function(){}).then(function(){document.getElementById("yjgo").hidden=false;});});})();</script></section> |
| </body></html> |
