Tag: Power BI
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 timephased, such as sales transactions or Project Online schedule and capacity data. If you need to start your […]
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.
When designing your Power BI solution, are you designing your solution for maximum long term effectiveness? One of the biggest mind shifts that my Power BI students have to make when beginning their Power BI journey is to stop thinking in terms of reports when approaching their Business Intelligence (BI) needs. Rather, it’s more effective […]
We’ve been hard at work, pursuing that dream that we should be able to ask our computers questions and get reasonable answers quickly. This post shows some of our recent work, integrating Microsoft Project Online with Power BI and Cortana to create a seamless experience across the products. The video demonstrates this integration, using a […]