Data Analysis
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
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
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
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