Posted by: Peter Williams on May 28, 2019
The Problem I had a need to create report that consumed the following data sources: Project Online timesheet data SharePoint Online list info On-Premise SharePoint list info Zendesk ticket data I have a reasonable amount of experience using PowerBI to query and consolidate this information. My desire was to have a report that used essentially
Posted by: Cheston Hsu on May 8, 2019
To ensure that a business can make accurate and sound decisions, the “freshness” of information and data available to them is critical. Having “old” or “stale” information and data can lead to poor or wrong decisions that could devastate a business. Ideally, keeping data “fresh” should be an automated process to ensure that whenever a
Posted by: Cheston Hsu on April 18, 2019
What is a relationship and how does it affect Power Bi Relationships in both life and Power Bi can be complicated. Relationships in Power Bi are necessary as they form a bond between different tables to accurately correlate and display data. There are various cardinalities used in these relationships and different types of filters that
Posted by: EPM Partners on February 25, 2019
Microsoft Power BI paved the way to automated reporting & in-house visual dashboards for local government. Resulting in decreased reporting preparation time, and more focus on analysis and collaboration leading to increased staff productivity. Read all about this here: https://news.microsoft.com/en-au/2019/02/11/taking-best-in-class-local-government-reporting-to-the-next-level-using-power-bi/
Posted by: EPM Partners on November 16, 2018
Do you currently have a list of SharePoint sites, OData feeds, excel sheets, websites, CRMs and databases that all have different types of important data? Wouldn’t it be nice if you could combine them all into one central location and fuse the different data sets to provide meaningful information? This is Power Bi! Not only
Posted by: Dan Stopher on April 20, 2018
Since the introduction of Engagements to Microsoft Project Online we have had the below option in MS Project under Project -> Project Information But what exactly does this setting do? Resource Centre In the case of the Resource Centre -> Capacity Planning -> Capacity and Engagements heatmap view, this setting has no effect! This view shows
Posted by: Peter Williams on January 22, 2018
Background Microsoft Project Online is a great platform to manage a programme/portfolio of projects. Project Online is an app that leverages SharePoint Online; it is effectively a very complex “app” for SharePoint Online. Project Online encourages project collaboration via the use of a dedicated SharePoint site for each project. Typically, you can expect to find
Posted by: EPM Partners on December 8, 2017
For those who are looking for presentation tools beyond PowerPoint, look at Microsoft PowerBI. Power BI is a new and well-known tool in the Microsoft ecosystem. Though it has only been around for three years, it is already a leader in the BI & Analytics market. Prior to PowerBI, the market had been dominated by tools like
