Category: Business Intelligence

It’s that time again and if you are headed to Microsoft Ignite 2017 and are overwhelmed with the session choices, here’s some recommended sessions to check out. Power BI – Microsoft Ignite 2017 If Power BI is your interest area, here’s some great sessions to check out. Dive into effective report authoring using Microsoft Power […]

I was introduced to the new Visio custom visual for Power BI during the Microsoft Inspire convention. After a few minutes, I was impressed with the power and simplicity of it. It helped solve a problem that we’ve had when building out Power BI reports. Telling a Complete Digital Story In my Power BI classes, […]

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. […]

This article was originally published on our CIO Magazine blog, the Effective Enterprise.  After seeing recent industry presentations on bots, machine learning and artificial intelligence (AI), I see the application of these technologies changing the practice of project management. The question is, is this future desirable or will we have a choice? The project manager role […]

This post shows you how to use the date hierarchy and the grouping function to easily group your data by year, month, week in Power BI. This can be very handy when reporting against data that is time phased, such as sales transactions or Project Online schedule and capacity data. If you need to start […]

Power BI

This post addresses a need to arises when querying Project Online data via OData. It can also serve as a solution template for other data sources. Synopsis A number of projects in our portfolio have impacts in different countries. These countries are designated via a Country Project level multi-value (MV) custom field. When multiple values […]

One challenge facing Business intelligence implementations today is related to how data is shared within the organization. We’ve been working to make work more open and social over the last few years, but there’s one place we’ve neglected to address along the way. How do we share ad hoc business intelligence data within the organization? […]

This is so cool! I just received an alert about a data condition in Project Online from Microsoft Flow. The best thing is that this condition isn’t anything Microsoft provides out of the box. With the functionality now in Flow and Power BI, we can now construct our own using Power BI and Flow. With recent […]

In this episode, I look at a specific data visualization in Power BI called Bubble Charts. I’ll explain what is a bubble chart, when to use it and how to build in Power BI.