Category Archives: BUSINESS & IT OPERATIONS

Automate the export of SharePoint List data to Excel to accommodate historic ‘point-in-time’ reporting

Using Microsoft SharePoint as an IT Project Portfolio Management (PPM) and Governance tool has its pros and cons in medium- to large-sized organizations. But the focus of this article isn’t to debate using SharePoint, nor is it even focused on PPM and Governance. Instead, this article explains how I solved the problem of quickly producing historic ‘point-in-time’ reports from a SharePoint project portfolio management (PPM) solution for when the CIO asks questions like, “How many projects were ready for a gate review at the end of Q3 last year?” 

Continue reading Automate the export of SharePoint List data to Excel to accommodate historic ‘point-in-time’ reporting

Strengthening goals and objectives with cross-functional peer reviews

The yearly goals and objectives (G&O) process in most organizations is often perceived by staff as a mundane HR activity required solely to support year-end performance appraisals. Here’s my thoughts as to how directors and managers can strengthen the process with cross-functional peer reviews.

Continue reading Strengthening goals and objectives with cross-functional peer reviews