How to Migrate SharePoint List Items to Project Online
Recently we did a Project Online/SharePoint Online Implementation based projects which included AdValue (Project Portfolio Management Package) implementation along with the migration of list items from SharePoint 2010 to Microsoft Project Online instance and creating projects from those list items. There were around 200 list items and more than 50 list columns in the old SharePoint list. So now the question is how this could have been done efficiently. Here, for explaining the steps, I am using limited rows. You can use as many needed. Also, I am referring old SharePoint list as source list and new SharePoint list as destination list. Below are the steps to Migrate SharePoint List Items to Project Online: Step 1: Define the fields mapping strategy (source to destination): We first needed to decide with client how list columns should be mapped to PWA custom fields. An excel template would help here. List Column Name List Column Type PWA Field Name (To be mapped with list column) PWA Field Type Project Title Single line of text Project Name Text Project Start Date Date and Time Project Start Date Date Project Finish Date Date and Time Project Finish Date Date Total Team Members Number Total Team Members Number Total Estimated Cost Currency Total Estimated Cost Cost Project Description Multiple lines of text Project Description Text Project Owner Person or Group Project Owner Text Type Of Project Choice Type Of Project Text Leveraging the same template, we created our mapping strategy. Step 2: Export data (in excel) from source list to be migrated: Go to the source list i.e. Project Requests. Export list items to excel. Step 3: Normalize the Excel Data for migration: Open the excel containing source list items. Here, I am keeping all list columns for mapping and removing default columns Item Type & Path. Step 4: Define the enterprise custom fields mapping in destination list: Go to the destination list. Go to list settings. Go to Project Server settings. Map list columns to PWA fields. Note: We can’t map the list item ID here. It can be mapped using SharePoint Designer list workflow. For mapping a list column to enterprise custom field, make sure that both have same data type. Multiline text type field values will be mapped only up to 255 characters. Step 5: Importing data from excel Create a CSOM solution in visual studio. For this, you can refer my previous blog .NET Managed Client Side Object Model for Project Online. Add a new class ExcelParser.cs to your visual studio solution. Here, I have named my solution as SPListItemCreation. This class file is used to read data from excel file. Step 6: Creating bulk list items List items can be created quickly using CSOM. Modify your Program.cs as my Program.cs file. Run the solution. List items will be created in your destination list. Step 7: Create projects from list items There are two options for creating projects which can be leveraged based on requirement and data volume. 1. From list item: Select the list items, for which you want to create a project in PWA. Here I am selecting all items. Under Items, click on Create Projects. You will see a pop-up form. This form will show you details of mapping done in Step 4. Select Enterprise Project Type under which you want to create the project. Click Create Projects. Projects will be created in PWA. 2. Using workflow: In SharePoint Designer list workflow, you can use the action “Create a project from the current list item with this Enterprise Project Type” to create the project from the list item. Also, you can customize the list workflow for creating projects only after certain approvals or column values. Finally, validate list columns & enterprise custom fields mapping Open project, which you have created from list item. Validate field values. You will see the same values as there in the list item. This is how you can create bulk SharePoint list items. In case of query, add your comments below.
Scrum vs Kanban: What’s the difference?
From Agile to Waterfall to Scrum to Kanban, there are a variety of project management frameworks, and choosing which methodology to follow can be tough. Scrum and Kanban, both related to the Agile family, are trending methodologies. Both have pros and cons of using them, and the key is to figure out why and when should you go for Scrum or Kanban. Let’s understand a bit about agile before we get into Scrum vs. Kanban. Agile project management: Agile means the ability to respond quickly to changes. In traditional project management technologies like Waterfall, the customer may get to see the end product on project completion, while in case of agile, sprints or iterations of shorter duration are delivered to the client. This way customer has more control over the projects. In Agile project management, new requirements are developed during the project execution and accommodated in the coming sprints. And this way, the outcome is different from what was thought at starting of the project. MORE INTERESTING ARTICLES REPORTS & DASHBOARDS FOR AGILE PROJECTS Now we would be comparing two agile methodologies – Scrum and Kanban. Scrum: In this methodology, we list down all features or wish list items to product backlog. Then we do sprint planning and add those wish list items to different sprints. The team then chooses which work they can complete during the sprint and moves the work from the product backlog to the sprint backlog. During this Scrum Master keeps the team focused on its goal. At the end of each sprint, the team presents the work they have completed at a sprint review and retrospective meeting. When the next sprint begins, the team chooses another chunk of the product backlog and begins working again. Kanban: Kanban is a visual system for managing work, related processes and their flow. The goal of Kanban is to identify potential bottlenecks in your process and fix them, so that work can flow through it cost-effectively at an optimal speed or throughput. Kanban board and Scrum board are usually associated with whiteboards and To Do – Doing– Done categories. As shown below, we can put the work on different categories. Things that are to be done, currently in process, and that are done. To Do – Doing – Done columns are not canonic, and usually teams expand ‘Doing’ section according to their needs (ex. Development, Testing, etc.). Kanban Methodology follows a set of principles and improves the flow of work which promotes gradual improvements to processes. These are the advantages of both Scrum and Kanban methodologies: Advantages of Scrum Advantages of Kanban Transparency Flexibility Improved credibility with clients Focus on continuous delivery High product quality Increased productivity Product stability Increased efficiency Team members reach sustainable pace Allows team members to focus Allows client to change priorities and requirements quickly Reduce wasted work/wasted time Now, let’s look at the differences: Scrum AKanban A lot of sprint planning is done in the beginning. It is open to make changes on the go. It means there is less rigidity and things can change as and when required. Work is done within time frame (usually 2-4) weeks. The goal is to produce a tangible deliverable after a sprint. There is no fixed length of sprints. Teams pull a task from backlog list and work on it. The product is released after the complete cycle of sprint. (may be 3 or 6 weeks) Release occurs continuously depending on the backlog items. Daily meetings and retrospective meeting at the end of sprint. Daily meeting not required, and Sprints are not defined in Kanban. Scrum Master will be there to drive the project No specific role required. It helps firms to save time and money. It focuses on the continuous improvement, productivity, and efficiency. The total work is done in batches/sprints. The entire project is performed on the single-threaded work item flow. It measures productivity using velocity of sprints. It measures the cycle time in the work flow process. Every individual has its role and responsibilities. No set roles, so there’s flexibility in terms of individual responsibilities. It is not possible to add new work items to the ongoing Sprint. New work items can easily be added and taken up on the basis of priority. A sprint backlog is owned by only a single team. Multiple teams can share the Kanban board. Best for teams with stable and defined priorities that may not change as much over time. Best for projects with widely-varying priorities and requirement. Conclusion No framework is perfect, and each has its own benefits and flaws. Project managers should focus on the aspects of Scrum and Kanban, which can be used effectively to develop products and services for their organizations. Given the advantages and disadvantages of both framework approaches, development and product teams can choose which framework works the best for them. Recently, some teams have also experimented by combining both frameworks and taking best practices from each of it to achieve better team synergies and improved productivity. If you don’t know already, now Microsoft Project Professional 2016 supports both Scrum and Kanban agile project boards. This opens up a world of easier scheduling for Agile methodology within projects. I hope that you enjoyed this article, and if you want to know more on this topic, you can register here for our webinar recording of – ‘The Future of PPM’ Yashwant shrimali System Analyst-EPM Advaiya Solutions Inc Udaipur, Rajasthan, India TALK TO OUR EXPERT!
Reports & Dashboards for Agile Projects
Implementing Projects in an ‘Agile’ way is common norm and best practice these days. Agile project management allows Project Managers to keep track of the project deliverables and provide up to date project status. This results in greater visibility thus delivering better implementation of software with approval of all the stakeholders. Thanks to Agile methodology through which one can react very quickly to changes and loopholes in the development process. The main idea behind using Agile framework is to break a complex project into smaller chunks called sprint and simultaneously testing it in manageable, two- to four-week cycles rather than building the entire product and then testing to find hundreds of product flaws. Why Dashboards are important for Agile Projects? Many organizations still follow the waterfall methodology of planning a project where they set an annual or biannual planning cycle to achieve the set goals. This results in poor execution of the projects. And for those organizations who have adopted the Agile methodology, even that does not guarantee best results. So, the need is to get a clear view of all the deliverables in a consistent manner. Dashboards and reports can help provide complete visibility across projects. Dashboards provide a snapshot of how sprints, iterations, and projects are doing at a given point in time. Reports help you regularly monitor your team’s progress against targets. Let us have a look at the reports that are useful for tracking key components related to an Agile project. MORE INTERESTING ARTICLES SCRUM VS KANBAN BOARDS: 11 MAJOR DIFFERENCES Iteration Burn Down: A burn down chart is a graphical representation of work left to do versus time. At iteration level, the burndown chart presents the work remaining and completed in the iteration. It tells you whether the committed tasks would be completed by the end date or not. It is the easiest way to determine the chances of iteration getting completed. Team & Iteration Velocity Chart: Put simply, sprint velocity represents the average number of story points a team can take on for a Sprint. Velocity measures the amount of work a team can tackle during a single aprint and is the key metric in Scrum. In other words, it represents the average number of story points a team can handle in a single iteration. When one knows the team velocity, it becomes easy to distribute the work among the team members and it becomes easier for a project manager to assign work to team members at the beginning of a sprint. Defects Trend Keeping a track of defects is very necessary for smooth running of a project. Defects Trends helps in tracking defects count for a release or a product. Not all defects may be resolved within the Sprint as they are identified. Non- blocker defects tend to get carried into future Sprints or iterations. Thus, having a view which shows the urgency of fixing a defect helps the developers tremendously. All these reports and dashboards tell us whether we are on track or not. By incorporating reports for Agile projects, one can ensure the following: You can track how good or bad a project is performing. You can immediately identify the sprints which are not doing well and thus can take measures to reduce the risks and issues involved in the sprints. You have reports to manage the team in a better manner and regularly monitor your team’s progress against goals. You can identify those teams which are not working at the desired pace or whose work has exceeded the bug count. Thus, reports help stakeholders, project managers and team members to observe, manage work allocation and work distribution, and approve funding. Himanshu Nandwana Technology Analyst – DW/BI Advaiya Solutions Inc Udaipur, Rajasthan, India TALK TO OUR EXPERT!
How to ensure effective demand management with Project Online
Within an organization, project requests can originate from anywhere. The absence of demand management process makes it chaotic and difficult to figure out as to what is being worked on and by whom. Establishing a right process to centralize all demand requests, use of standardized templates and governance processes help streamline the process for consolidating data collection and providing the appropriate amount of flexibility and autonomy for individual business units. Demand management as a concept in Microsoft Project Online integrates project proposals, portfolio analysis, and project management through workflows and project detail pages. It captures all work proposals at one place, guides the proposals through a multistage governance process, helps decision-makers make decisions about which proposal to approve, and track progress on project execution until the work is completed. Microsoft Project Online can serve as an effective demand management tool for your organization by capturing demand as potential projects directly into Project Server or via a SharePoint list that is connected to Project Server. The above figure shows the four phases of demand management, and how they are interlinked. Within each phase, there are various stages, and each stage can be associated with a Project details Page (PDP) in Project Web App and linked as a workflow to Enterprise project template (EPT) in Project Online. Let’s understand the demand management concept through a simple example: – Consider yourself as a program or project manager for ABC organization who is using Microsoft Project Online for managing projects and proposals. Now per recent management decision, you are asked to collect proposals and requests, as well as project ideas from different people in your team or even across the organization at a centralized space. A simple way to do that would be to collect these through email requests or one to one conversation, and then you consolidate them and manually enter in Project Web App (PWA) one by one. The problem with this is that it’s pretty time consuming, and not easily scalable for a continuous and seamless agile process. Plus, the proposals could be submitted in different formats, which creates a further overhead of converting them to projects in Project Web App (PWA). READ MORE ARTICLES PROJECT SERVER 2007 END OF LIFE – MIGRATION OPTIONS TO CONSIDER PLAN & MANAGE WITH ADVALUE – THE ULTIMATE ADD-ON FOR PROJECT SERVER/PROJECT ONLINE It would be great to have a mechanism of having everyone enter their requests and ideas into Project Web App (PWA) directly through a SharePoint list tailored per organizational needs (using specific list items to capture the request), and then you could convert a subset of those list items to projects? Just start by creating a custom SharePoint list within your Project Online environment with criteria that matchProject Custom fields Ensure that this list captures the minimal information you require to manage demands. In the example above there are two requests entered as: New Windows Phone App and New Windows 8 App Custom SharePoint list items with columns such as Description, Submitter, Budget Cost, Budget Estimate, Risk, and Rating) can be created to capture the demand requests. All the List items, or ideas listed can be easily “promoted” to Projects by clicking on Create Project button as available inside the list items control, which brings up the “Create Projects in Project Web App” dialog which lists the data captured in the Ideas & Requests list and intelligently maps to equivalent PWA custom fields automatically. For instance: Budget Cost maps to Total Cost, or the Risk choice list maps to Risk Rating. Note that, you can always set the default mappings, by navigating to the SharePoint list settings, and choosing Project Server settings options. Once all mappings are done and you are ready to proceed to choosing the process that would be used to evaluate and execute the request. In Project Sever and Project Online, there’s a concept of Enterprise Project Type (EPT) that allows diverse projects to be driven by different workflows and in this new scenario we will choose the New Product Development EPT. Now post process selection, move to the command “Create Projects” which will then convert the SharePoint list items as selected as projects in PWA. You will be notified that the projects have been successfully created in PWA: Now navigate to PWA’s Project Center and you can now see your new projects listed there. Let’s select the New Windows 8 App project and you will notice there are five phases in the workflow specific to New Product Development EPTs associated. All the information captured in the list item is also transferred to the project’s custom fields as shown below: Microsoft Project simplifies overall project management by providing an evaluation phase through out of the box portfolio analysis capabilities of PWA before the execution phase. It’s an end to end process without any customization or a single line of code required! PROJECT STATUS REPORTING TOOL Keep things up-to-date and focus on your project’s success
AdValue is now available with new and enhanced features
We are very excited to present some of the new features that are now part of AdValue – one of the most powerful project management solutions. We deployed AdValue on various project sites, and based on our experience and feedback from the users, we have now integrated some new features in it. The key highlights of the new features are: Web-based version of project manager and executive dashboards, Monthly and weekly task completion updates for project manager, Role-based access to project workspace, Risk heat map under project workspace, Overall performance and reliability improvements, and much more. 1. Project Manager Dashboard The web-based version of the project manager dashboard is now available with more in-depth insights on task completion velocity. So, you can track the project progress in the past month or week at any time, and take necessary actions to finish the project on time. Fig.1: Project Manager Dashboard with task completion velocity details Fig.2: Web-based Project Manager Dashboard OTHER INTERESTING READS:1. ADVALUE EARNS TWO PROJECT MANAGEMENT SOFTWARE AWARDS FROM FINANCESONLINE2. PLAN & MANAGE WITH ADVALUE – THE ULTIMATE ADD-ON FOR PROJECT SERVER/PROJECT ONLINE 2. Executive Dashboard Fig.3: Web-based Executive DashboardThe web-based version of the executive dashboard is now live and lets you get all project and portfolio insights anywhere from any device, platform or browser. 3. Team Member Dashboard Team members can now get a complete summary of the current/overdue/future tasks at-a-glance, and quickly navigate to the project workspace with just one-click. Fig.4: Web-based Team Member Dashboard 4. Project Workspace The role-based project workspace displays the information based on the user logged in. Also, without much roaming around, the tasks, risks, issues and other lists data can directly be accessed and added right from the workspace. Fig.5: Project Workspace view for Project Managers Fig.6: Project Workspace view for Team Members Now, project managers can view assignments of all the project resources in a single view, and team members can see all their associated tasks and items from the workspace. 5. Risk Heat Map With this update, we are launching a new feature in AdValue called ‘Risk Heat Map’ that will display identified risks in the project, their severity, mitigation measures, owner, and other useful information. Fig.7: Risk Heatmap We’re also working on further improving and developing other exciting features like stakeholder analysis, issue tracker and few others, that we can’t wait to unveil. So stay tuned for more updates and additions in this new year! Interested in AdValue Solutions? Checkout the pricing & features here
Leveraging automated workflow to streamline project processes
Effective project management is the key towards successful project execution within any organization. There are several important aspects of a successful project management within an organization and one of the most important is process automation. An effective and robust process automation may result in a faster and smoother project management. In an organization where the project processes are followed manually, it becomes very cumbersome to handle the project and track information about processes because of scattered data. With advancement in traditional data storage systems, the storage is increasingly moving towards cloud, emails, OneDrive, etc., hence enabling a central process in the organization for project execution. There are several tools available for process automation, and custom applications can also be developed for specific needs. Microsoft Project – a project management tool solution – enables extensive process using SharePoint designer workflow, Nintex workflow, Microsoft flow. Project workflow automation Automated demand management workflow can be built for different project types. By default, Microsoft Project Online provides workflow phases as – create, finish, manage, plan and select. Customized phase and stage for approval can be added according to the organizations’ needs. Below are few actions and examples which can be automated inside the workflow Customized email notification on different stages of the workflow Approval task assignment and notification to task owner for the action taken Project information can be marked as read-only/required based on project stages and phases Using stage gate condition, a checklist for the actions to be performed can be verified before moving to the next phase/stage/ These are only high-level and most generic actions. Specific processes on each stage gate, whether its integration with other system or updating something on the project itself can be performed with the help of the workflow. Configuration based interface provisioning by SharePoint Designer enables quick development of such workflows. Process automation on project artifacts Microsoft Project Server/ Project Online offers workspace for each project created that allows to store all the project related information in a consistent manner. There are several workspace-based processes, which can be automated that includes change request management, issue/risk management, action required, document approval process, document retention, among others. For example, to handle a change request in a project, a customized SharePoint list can be created and using the SharePoint workflow on the change request, approval process of that request from the financial department or stake holder can be implemented. Microsoft Project Server/ Project Online by default provides the register for risks and issues in project workspace. Risk management process can be built, wherein whenever a risk is added for a specific project, notification emails can be sent to the project owner and the sponsor for approval. Process can be built when a new issue has been identified and added in the issues register, and task action can be assigned to the owner of the issue and the notification be sent to the project manager. In this blog post, we discussed generic workflows and processes, which can be easily automated with the help of SharePoint and Project Server workflows. However, process automation with specific requirements like integration with other LOBs, calling any external APIs on project publish, project closure workflow, sending custom email notifications, enabling document approval process up to nth level of approvals and review, can be configured per the need. Using SharePoint Designer for workflow development requires less development and allows focusing more on the process enablement. Microsoft Project Server/ Project Online built on the top of SharePoint leverages all the features of SharePoint and can merge these with its project processes like publish, save, checking, etc., to create more robust processes. You can learn more about this topic in our upcoming webinar on ‘Streamline your process with Project Online’ on January 9th at 11:00 AM. Register now to view the Recording! Sonika Jain EPM Developer Advaiya Solutions Inc Udaipur, Rajasthan, India TALK TO OUR EXPERT! CALL NOW CALL NOW
Microsoft Teams and Project Online integration using Microsoft Flow
Microsoft Teams is a unified communications platform that combines persistent workplace chat, video meetings, file storage, and application integration. The service integrates with the company’s Office 365 subscription office productivity suite and features extensions that can integrate with non-Microsoft products. Microsoft Teams is being used by over 125,000 organizations across the world, since its launch on March 14, this year. It has come out as core product of Microsoft ‘s vision for intelligent communications – bringing together conversations, meetings, files, Office apps, and third-party integrations at a single hub in Office 365. And as Teams become a single hub for team work, it is obvious that all project related updates should be available as posts in Teams as well. Though Teams provide a bunch of connectors to integrate with other application, but not for Microsoft Project Online. This integration is important because it would help to keep the project team updated with the latest project happenings in the form of posts in Microsoft Teams. Isn’t it interesting? In this article, I’m going to share a simple scenario about how we can quickly integrate Teams with Project Online using Microsoft Flow. To give you a bit of context, Microsoft Flow is a cloud based workflow service that enables automation of common tasks and business processes across the most common apps and services. It has Project Online connector and supports the following triggers: Microsoft Teams is core to our vision for intelligent communications—bringing together conversations, meetings, files, Office apps, and third-party integrations—to provide a single hub for teamwork in Office 365. New project created New resource created New task created Project published And following are the actions available for Project Online: Check-in and publish project Checkout project Create a new resource Creates new project Creates new task List projects List tasks Let’s see how we can develop Microsoft Flow workflow to post a message in Microsoft Teams whenever a new project is created in Project Online. To begin, sign-in (or sign-up), into Flow and click on Create from blank. Step 2: At the bottom of the screen, click on Search hundreds of connectors and triggers Step 3: In the search bar, type Project and you will see the list of connectors available for project management. Step 4: Click on Project Online Step 5: Next screen shows all the supported triggers for Project Online. In this scenario, we want to post message in Teams whenever a new project is created so select Project Online – When a new project is created. Step 6: Provide your project root site URL and click on + New step Step 7: Click on Add an action Step 8: Here we need to specify action for Microsoft Teams. Type Teams in search bar and click on Microsoft Teams Step 9: Select Microsoft Teams – Post message. Step 10: Select Team Id to post a message. Step 11: Select Channel Id. Step 12: Draft a message for post using custom text and fields from Project Online. From the right Dynamic panel, select needed field and drop it in the Message box. See the below image: Step 13: Once you have drafted the message, give a name for your Flow and click on Create Flow to save this workflow settings. Testing Flow Go to Project Online and sign-in Create a new project Check Microsoft Teams to receive project creation notification in the configured channel There you go! You have successfully integrated Project Online with Microsoft Teams without any coding. If you are looking for more such integrations with Microsoft Project Online, our PPM experts can help you with the right solution. Here I showed just one example for a trigger and action. Similarly, you can add more triggers as you require. Good Luck! You may find these useful: Related services & solutions Robotic process automation Automate repetitive tasks focus on higher-value work Read more Implementation Deploy and adopt automated, integrated, and customized applications and tools, to stay proactive. Gain a complete picture of your organization with a system of integrated applications and data stores. Read more Collaboration with SharePoint and … Automate workflows and empower teamwork Read more Business productivity Read more Related Technologies: Apps and Business Automation Integration Adoption Services
Establish project and portfolio management in your organization
In recent years, establishing Project Portfolio Management has become a key preference for most of the organizations. There can be seen a huge change in the way organizations are managed and the narrowing of the gap between Project & Program management and top leadership. According to a PM Solution survey, ‘Higher PPM capabilities lead to greater ROI’. The organizations with established PPM processes at the enterprise level are in a better state to make more informed and data-driven decisions on regular basis. No doubt, the glamorous results of PPM practices establishment require time, niche skill set and organization wide adoption and support. Here’s a quick checklist that might come handy when establishing PPM practices in your organization: Get the top leaders involved in identifying the critical needs and issues of the organization, and then design the processes that will best meet those needs. Plan to execute the whole process in phases and decide outcome for each phase, so the effectiveness at each phase can be evaluated. Keep the end users well informed about the PPM establishment and list the changes that can impact the process/way of their work. Select appropriate PPM Methodology that works the best and is easy to adapt to your organization culture. Decide project prioritization with top leaders and PMOs. Ensure that the PPM establishment plan does not include several changes at one time, which may lead to complexity and people tend to ignore them. Decide the channels for process implementation (training/hands-on/ stand up discussion, etc.,) in advance as required at each stage. Document the identified processes. Leverage the best from existing organizational processes and business scenarios, which are relevant to PPM. For example – Elements of processes for planning and cost estimating, project management, risk management, and resource management may need to be refined, expanded, or better coordinated instead of defining them from scratch. These points are an initial homework for the organizations planning for PPM establishment and use. Once this is done, you should select the appropriate PPM software/tool. You may have PMOs in your organization to drive this or you may hire an external consultant to drive the whole process for you. Now, to select the appropriate technology/tool, you must make sure of the following: The solution is scalable to all PPM scenarios regardless of your needs, so you can scale your implementation in future as needed. The solution follows the standards of Project Portfolio Management and at the same time should have the capability to be customized for specific needs as every organization has different standards and processes. You compare the feature and pricing offered by different software/tools. Select an on-cloud solution which is scalable as you use it, and will required less maintenance with minimum infrastructure; unless your organization is a big fan of on-premise solution.
How to create resource availability report on Microsoft Project Online
One of the most important aspects of a resource manager / project manager is to monitor the assignments for each of their resources so that they can effectively balance their team’s workloads. There might be resources that are overallocated or underallocated. The key is to efficiently manage those resources by viewing their workloads and availability in Microsoft Project and making adjustments. MS Project Online combined with MS Power BI is a great online solution for powerful and effective project and resource management. These are some of the views that a resource manager / project manager looks for: Future availability of resources Resource utilization over last week or last month Resource current assignment/ projects Here I will provide you with an overview on how you can connect to Project Online from Power BI and create reports that help in effective project and resource management. To connect to your resource data follow these steps: Open your Power BI Desktop. On the home screen, click on Get Data. Choose OData feed and click on Connect. Then enter the URL for your OData feed in the URL box, and click on OK. Suppose the address for your Project Web App(PWA) site resembles https://.sharepoint.com/sites/pwa, then the address you’ll enter in the URL box for your OData Feed is https://.sharepoint.com/sites/pwa/_api/Projectdata. You will be prompted by Power BI Desktop to authenticate with your Office 365 account. Select your organizational account and then input your credentials. After connecting, choose the tables you would like to connect to and build your query. Choose the appropriate tables from your Project Online for creating Resource Availability Report. For example: take the tables that consist of all the resource data, their roles in your organization, their projects and assignment data, etc. After choosing the required tables, you will need to create the possible relationships between tables. While working on the relationships you need to answer these questions: How much work is allotted to a resource on each day? What are the active tasks a resource needs to work on? What are the future tasks allotted to any particular resource? Which resource is available to work on any project? How much work is assigned to a resource? Which resource is available to work on any project? … and many more. In the Resource Report, you may group the resources by role so when you click on a particular Role, all the resources of that role gets displayed and you may select relevant resources to look into for the details. The below dashboard displays the Resource availability report for next 2 months: You can also drill down into resources. As shown in the below image, if we click on any resource name, we can easily check on what projects is the resource working on. Also, the active, future & overdue tasks for that resource can be identified. This helps in understanding the kind of complexity level task assigned to the resource. Also, the availability of resources for next 2 months can be seen in this report. You can change the duration easily by filtering the date as per the requirement. As shown in the below image, you can see all the available resources for the coming two months and their allocation on various projects. This duration can be changed to look for the information at a certain duration. This report can be a great tool for resource managers to understand the resource allocation and availability at a glance, saving them time invested in navigating to each individual project in Project Online. Similarly, to track the team wise, role wise or department wise resource utilization, all resources can be grouped at a desired level and then their submitted timesheet data can be leveraged to get the utilization. The below report gives the information about resources who are grouped role wise. So, we have seen how these interactive dashboards and reports can be useful to check for the availability and utilization of resources. The above reports are generic and can be created for any Project Online Tenant users and of course can be further customized based on specific needs. To better understand project and resource management, you can watch the recording on Project and Portfolio Management using MS Project Online