Category: Real World Tip
Learn how to set up and use Power BI parameters in Power Query and DAX to make your models more maintainable.
Many Power BI reports and dashboards have simple, color-based indicators, commonly referred to as Key Performance Indicators or KPIs. These indicators provide a way to communicate the current condition of a monitored metric. These KPIs require the data consumer to: Trust the data used to calculate it Understand the rule used to derive the indicator […]
Learn how to add needed context to your business intelligence content easily using Microsoft Power BI and Microsoft Sway. The results will amaze you.
This post is an excerpt from our Advanced Power BI class. Importance of Data State Analyzing data states in the data collected is generally the primary focus of our Power BI analyses. We look at aspects related to standards, compare dates to today’s date and execute other such comparisons. The business user who consumes your […]
This post addresses one of several common challenges for new Power BI users face. We’ve compiled a list of challenges, based on Our Real World Power BI training series. Making your Power BI slicers visually distinctive. Many new users can create slicers in Power BI to enable the end user to dynamically explore their data. […]
In part 1, we outlined the problems that many customers encounter managing operational work in Project. We need to capture this information for higher fidelity resource capacity. However, previous methods required more work on the part of Resource Managers than desired. In this article, you’ll see how to set up an operational project plan template […]
Many organizations struggle to manage resource capacity. If they are following the OPRA Resource Capacity model, the need to track recurring operations work immediately becomes necessary. This article is based on real world experiences while managing large Project Implementations. Current tracking methods will be examined and some suggested approaches will be presented. The old way […]
What we typically do today. This post is about what can be gained from making one simple change in your Resource Custom Field configuration. Many companies have an FTE Yes/No type resource custom field to distinquish between employees and contractors. This has been the approach for many years, as I see this many times in […]
Yes, Part 3. This technique was published some time ago and as it gets further “field testing”, new conditions have come to light which require a revision of this technique. Assuming this is the last post on this topic, I need to figure out how to duplicate this logic in PowerBI. I consider this to […]
Here’s a quick article on how to connect Project Pro to Project Online. The question seems to come up on a regular basis so I’m documenting it here. In Project 2013 and Project Online, Microsoft added the ability for Project Pro to autoconfigure the connection to Project Web App. However, to make this happen, you […]