Search Results

Summary Nearly 50% of businesses fail within the first five years in the United States. However, there are measures you can implement to help avoid this. Using the right software goes a long way when it comes to ensuring that your company remains successful. Microsoft Power BI is one of the most powerful applications you can […]

Microsoft Power BI evolves often so staying on top of the latest tips and tricks is key. Learn seven important tips by clicking here.

Microsoft Power BI has a lot of capabilities for business reporting. Learn about how to use the program for keeping records.

Project Management is critical for any type of project, including those in the financial industry. Microsoft Project Online helps with the project management processes required, as well as the knowledge to effectively execute those processes

Power Platform is an integrated suite of BI, automation, and app development software applications unified by the Power Fx low-code programming language. Above all, this means that it provides a suite of business services with which users can engage without extensive technical or coding knowledge.

Permissions are what allow users to perform a specific function or action with Project Online.  The security configuration uses Allow and Deny or no selection to configure each and every permission in Project Online.

This video is a demonstration of Project for the Web. The environment utilized in this video has Power BI reports and dashboards as well as a number of custom entities. The solution will help potential customers of the product visualize some of the capabilities Project for the Web brings to the table. Team members, Project Managers, and others all have something to gain from using the product.

So you want to create powerful reports and dashboards? Well Power BI is certainly one of the strongest technologies available to create reports and dynamic dashboards for various roles in your organization.

When using Power Query (Get & Transform) in Power BI and Excel, you have the ability to merge queries together and expand the dataset to view all the columns in your merged dataset. While you can do this in Power BI, the intrinsic join capabilities of that software program do not require you to perform […]

I have been helping several customers recently with their reporting performance issues. The reports themselves performed well, but the data refresh took forever. There are two simple steps in Power Query for Power BI and Excel (Get and Transform in Excel 2016) that can drastically reduce your data refresh times. After making your connection to […]

Today I was working with the Project Online Projects and ProjectWorkflowStageDataSet tables in PowerBI.  I wanted to created a chart that showed data points that involved workflow status, projects, tasks.  The many to one relationship between the ProjectWorkflowStageDataSet and Projects table was causing an issue when combining these data-points.  This required I create a filtered […]

Most of the reports I create have a time element… Which client used the most project hours last year? ….. How many hours are my QA people scheduled to work next month?  Without that time framework, the information is less valuable. Time phased reports do, however, have an unfortunate side. The tables we must use […]