Browse Articles by Topic
Explore over 125 real-world guides, custom formulas, and step-by-step tutorials organized by core subject area:
Microsoft Project
Scheduling, calendars, durations, Kanban boards, sprints, Earned Value & custom formulas.
47 ArticlesProject Server & EPM
Enterprise Global, permissions, EPT site templates, resource plans, and task alerts.
14 ArticlesPower BI & Reporting
Power BI Gantt charts, RAG status KPIs, Row-Level Security (RLS), and dashboard templates.
7 ArticlesExcel & VBA Integration
Importing/exporting between Excel & Project, timephased Visual Reports, and VBA automation.
Most Popular Guides & Tutorials by Topic
Microsoft Project Scheduling & Tracking
Excel Integration & Power BI Reporting
All Articles (Chronological Archive)
-
Quick Hack to create a Lipstick Chart in Power BI
Use this Power BI template to report on Labels from you P4W projects.
-
New Project for the Web labels available in Power BI
Use this Power BI template to report on Labels from you P4W projects.
-
Error when loading a new query – OLE DB or ODBC error 10 keys were specified, but 5 values were provided
I recently had an issue in Power BI when trying to add in an additional query. The screenshot of the error message is displayed below. …
-
Teams Apps for Project and Roadmap
There have recently been a couple of apps introduced into Teams that consolidate the Microsoft Teams experience around collaboration and especially Project Management. These are the Project App…
-
Project Solution Accelerator
One of the major announcements at Ignite was a solution Accelerator for the new Project, aka, Project for the Web (P4W). The accelerator is being developed by Microsoft and…
-
A whole host of Power BI content – Power BI Lunch and Learn and the Manchester Power BI user group
Over the last four years I’ve spent a lot of time working in both Power BI and using the similar tools in Excel (for those of you who…
-
Planner Tasks Power BI Template on GitHub
Microsoft are retiring content on TechNet, and so I’ve taken this opportunity to slightly modify the Planner Power BI template, and move it over to GitHub. At the…
-
Updated Planner Tasks Power BI Template
Planner Priority field #2 It’s great when Microsoft copy one of your ideas 🙂 Back in Sept 2019 I updated my Planner Template to include the Priority field. …
-
Displaying the current plan and multiple baselines
Project has the ability to hold 11 baselines, and I’m often asked to devise a process whereby my client can track the current plan, the original plan, and…
-
Planner Tasks now have a Priority field
This is just a quick blog post to say that Planner now includes a priority field for each task. The priority can be Urgent, Important, Medium (default) or…
-
PowerBI Template for Exported Planner Plans
Download and configure the Power BI template for exported Microsoft Planner plans to track task progress, buckets, assignments, and schedules.
-
Updated PowerBI Template for Project Server
Updated Power BI Content Pack – drill through and buttons! Power BI has definitely become my favourite application (after Project of course) in the Microsoft suite simply because…
-
Auto Calculate
Recently one of my customers was having an issue with Project not “behaving”correctly. As I was demonstrating how Project works, he was doing the same but without anything…
-
Best Practices for Integration of Microsoft Project and Excel
Learn the 3 best methods to import Excel data into Microsoft Project and export schedules back to Excel using Copy/Paste, the Import/Export Wizard, and Visual Reports.
-
Permissions Mode
Introduction This is really the briefest of blogs to let you know of a UI change away from SharePoint to Project Server. Permissions Modes Since Project Server came…
-
Managing Sprints in Project
Learn how to configure and manage Agile Sprints in Microsoft Project Desktop, assign backlog tasks to sprints, and track sprint velocity.
-
Using Row Level Security to Auto Filter your Power BI Reports
How to configure Dynamic Row-Level Security (RLS) in Microsoft Power BI so project managers and executives automatically see only their own projects.
-
Using Kanban Boards in Microsoft Project
How to set up and use Kanban Task Boards in Microsoft Project Desktop to manage agile workflows, board columns, work-in-progress limits, and task status.
-
Project Server Content Pack Multiple Language Support – now with Polish language
Modifying Microsoft’s #ProjectOnline #PowerBI Content Pack to Support Your Language – Polish, Russian and now Polish. <180822 – Update> A quick note of thanks to Bartek from Poland…
-
Modifying the Menus in Project
Modifying the Menus in Project Over the years I have run hundreds of training courses and one of the issues I often hear from people is the complexity…
Leave a Reply