Category: Power BI

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 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. 

Microsoft Power BI isn’t just for getting data from Microsoft products. The PBIX demo file that you can get once you register below, allows you to query the data from your Google Sheet into Power BI and then share resulting reports and dashboards via PowerBI.com with co-workers or the world if you desire. If you have […]

Power BI’s Donut charts are very attractive. When used improperly, they make it harder for the user to read the data. In this segment, see how a donut chart has been used improperly and learn a better way to show the data.