Intro to DAX (Power Pivot formula language), Lookup with DAX, DAX calculated columns v Query editor, CUBE functions
Filtering a pivot table; creating slicers, GETPIVOTDATA; "Group By"; calculated fields, the benefits of power pivot and the data model
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!
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
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
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
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
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
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
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