Data Analysis

Power Pivot & DAX Language

WebNLearn: From Raw Data to Actionable Insights. Intro to Power Pivot & DAXs (3 of 3)

Intro to DAX (Power Pivot formula language), Lookup with DAX, DAX calculated columns v Query editor, CUBE functions

Pivot Tables and Power Pivot

WebNLearn: From Raw Data to Actionable Insights. Mastering Pivot Tables (2 of 3)

Filtering a pivot table; creating slicers, GETPIVOTDATA; "Group By"; calculated fields, the benefits of power pivot and the data model

Mastering Pivot Tables

WebNLearn: From Raw Data to Actionable Insights. Mastering Pivot Tables (1 of 3)

Have you always wanted to learn how to create a pivot table or manipulate data into a pivot table? Look no further than this step-by-step!

Webinar Highlight: Automate Your Project for the web and Project Online Reporting

Please find highlights from Ben Howard’s course – Automate your Project for the Web (P4W) and Project Online (PJO) Reporting – being provided by MPUG for the convenience of our members. You may wish t...Read More

Introduction to OnePager Pro for Microsoft Project

As users of Microsoft Project, Project Online, or Project Server, you’ve probably been asked by your senior management for a visual overview of your project or portfolio so that they can understand th...Read More

How To Remove (blank) Values in Your Excel Pivot Table

You might call it perfectionism, but I hate when my reports don’t look their best. One of the most irritating elements is the “(blank)” text you may have on your Excel pivot tables. ...Read More

PMBOK

Overview of the PMBOK® Guide Seventh Edition – Lesson 3 Transcription

Please find below a transcription of the audio portion of Jeff Bongiovani’s Overview of the PMBOK® Guide Seventh Edition – Lesson 3 being provided by MPUG for the convenience of our members. You may w...Read More

Webinar Recap: Project Performance Measurement – Part 1: Overview Of Project Performance Measurements

Please find below a transcription of the audio portion of Fletcher Hearn’s session, Project Performance Measurement – Part 1: Overview Of Project Performance Measurements, being provided by MPUG for t...Read More

Webinar Recap: Power BI for Business Users and Project Managers – Part 2: Deep Dive into Shaping Data using Power Query

Please find below a transcription of the audio portion of Ben Howard’s session, Power BI for Business Users and Project Managers – Part 2: Deep Dive into Shaping Data using Power Query, being provided...Read More

Effectively Using Excel for Analyzing MS Project Data

MS Project (MSP) is an excellent tool for preparing and tracking project schedules. Excel is also a great tool for analyzing any type of data. So, which one should you use for schedule analysis? You p...Read More