Category: Business Intelligence
[fusion_text] My Star Trek moment has finally arrived! Growing up, it always seemed like a pipe dream to be able to ask questions of the computer and have her answer. Microsoft has got us the closest to this dream with Cortana and Power BI Integration. You can now summon answers from your Power BI dashboards, […]
[fusion_text]You can use the free PowerBI.com license with Microsoft Project Online to do your basic reporting. There are caveats but I’ll show you ways that you can use the free license effectively. What is Power BI? Microsoft Power BI is a collection of online and client tools that enable organizations to visualize and explore data, […]
Visualizing Project Time Project Online supports collaborative work management across your organization. It provides the ability to manage multiple project schedules and allows project team members to enter the time spent on assigned tasks via their timesheet. The timesheet information can then be used for many purposes. Many Project Management Offices (PMOs) have dynamic information […]
Thank you for the great response! I created a video last week called the most interested time sheet audit report, mainly as a tongue-in-cheek way of introducing the cool functionality of Power BI over what is normally a dry reporting topic. The response was great! So great, that I’m putting together a hybrid class to […]
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 […]
Data can be a wonderful thing. There are so many stories you can tell with the right data. These stories have the power to persuade and motivate positive changes in the organization. And so the marketing stories go on and on about the power of data. The question is, do you have the right data? […]
Scenario You have a report where the need is to show multiple values for a given custom field. For example, you have a multi-value Project custom field for Impacted Business Organizations. You want to see your values as a comma delimited list so that this can be used in an Excel pivot table or SSRS […]
These high level entity relationship diagrams were first published in the deck for my Project Conference Hands On Lab deck. I’ve had a number of requests for this information so here it is. These diagrams are based on the 2010 RDB but the 2013 RDB should not be materially different. For 2007 users, many of […]
At some point, you will be asked for information by Fiscal Year. The Fiscal calendar was set up in Project Server so it should be accessible for reporting, right? A fair number of companies have fiscal calendars which don’t exactly line up with the standard calendar which can cause some challenges. You could hard code […]
If you’ve ever attempted to include content from a Project multi-line text custom field or Issues multi-line fields in an Excel report, you will get a result that looks like this: <div><p>Vendor is having issues with deliveries to the East Coast.</p></div> At the 2012 Project Conference, I presented a SQL based solution that converts the […]