{"id":21163,"date":"2022-09-08T09:00:08","date_gmt":"2022-09-08T16:00:08","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-platform-administration-planning\/"},"modified":"2022-09-08T09:00:08","modified_gmt":"2022-09-08T16:00:08","slug":"power-platform-administration-planning","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-platform-administration-planning\/","title":{"rendered":"Power Platform Administration Planning"},"content":{"rendered":"
Behind the scenes, your IT and Center of Excellence team spends time configuring, managing and nurturing the adoption of Microsoft Power Platform. Understanding how that time is spent can help you plan who you need on your team and find the highest-impact opportunities to streamline the administrative effort.<\/p>\n
We\u2019ve put together a simple solution (Power Platform Administration Planning) that is designed to help you better:<\/p>\n
The solution is built on Microsoft Dataverse and is a new stand-alone component in the CoE Starter Kit. Admin tasks are defined in a model-driven app and insights are provided in a Power BI dashboard.<\/p>\n
You can start either by adding your own tasks or by importing a set of example tasks from an Excel spreadsheet, populated with some of the most common administration tasks covering:<\/p>\n
You\u2019ll need to review the tasks and populate task metadata to get the best out of the Power BI dashboard.<\/p>\n
If you\u2019re getting started, you might find importing the sample tasks spreadsheet a great starting point for inspiration. Where possible, we added in the most common administrative tasks that administrators perform and supplied links to supporting\/ instructional documentation.<\/p>\n
Task metadata is used by the dashboard to provide useful information about your team structure and the level of expertise required to complete your administrative work.<\/p>\n
Column<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n | Name<\/td>\n | A brief description of the task. E.g., \u2018Create an environment.\u2019<\/td>\n<\/tr>\n | Task description<\/td>\n | Longer description of the task.<\/td>\n<\/tr>\n | Task documentation link<\/td>\n | URL (Uniform Resource Locator) to documentation<\/td>\n<\/tr>\n | Active task<\/td>\n | Yes\/ no \u2013 is this a task that you currently perform?<\/td>\n<\/tr>\n | Outsourced task<\/td>\n | Yes\/ no \u2013 is this task outsourced?<\/td>\n<\/tr>\n | Automation<\/td>\n | Yes\/ no \u2013 is this task automated?<\/td>\n<\/tr>\n | Frequency<\/td>\n | Choice \u2013 how often is this task performed?<\/td>\n<\/tr>\n | Anticipated task iterations<\/td>\n | Number \u2013 how many times do you expect to perform this in one year?<\/td>\n<\/tr>\n | Duration<\/td>\n | Number \u2013 how long, in minutes does this task take?<\/td>\n<\/tr>\n | Experience required<\/td>\n | Choice \u2013 what level of ability is needed?<\/td>\n<\/tr>\n | Core admin persona<\/td>\n | Choice \u2013 which core admin persona usually performs this task?<\/td>\n<\/tr>\n | Peripheral admin persona<\/td>\n | Choice \u2013 which peripheral admin persona is involved in this task?<\/td>\n<\/tr>\n | Primary task category<\/td>\n | Choice of task categories<\/td>\n<\/tr>\n | Secondary task category<\/td>\n | Choice of task categories<\/td>\n<\/tr>\n | Product or service<\/td>\n | Choice of Power Platform applications<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n | Power BI dashboard<\/h2>\nThe structure of the dashboard is designed to help you focus on what you do, how reactive your team is, and the impact that automation and outsourcing (if your organization does) has on your overall efficiency.<\/p>\n Team, outsourcing and automation<\/h3>\nTeam, outsourcing and automation aggregates administrative task data, indicating:<\/p>\n Team workload<\/strong> \u2013 enter the number of staff in your team. Based on aggregated effort, the required hours (per team member) to complete the tasks are estimated.<\/p>\n Outsourcing<\/strong> \u2013 what, if any, impact outsourcing is having on your workload. How many resources, and what level of expertise is required.<\/p>\n Automation<\/strong> \u2013 This section provides insights into how much time you’re saving by automating tasks and the expertise that would be required.<\/p>\n <\/p>\n Task breakdown – proactive & reactive balance helps focus on the balance between tasks that are ad-hoc, or reactive. By displaying the percentage of tasks that have been categorised as ad-hoc, and providing a filtered list, it encourages you to look for automation, outsourcing or innovation opportunities.<\/p>\n <\/p>\n Task breakdown – experience & personas aggregates the duration for all tasks by frequency and provides insight on:<\/p>\n Experience levels required<\/strong> – illustrates the experience required across all tasks. This can be useful in estimating training requirements for your existing team<\/p>\n Insight for each \u2018core admin persona\u2019 & ‘peripheral persona’<\/strong> – is useful to understand how many of your tasks rely on additional teams to complete. For example: creating an environment may also require Azure AD Security groups to be created for managing access.<\/p>\n <\/p>\n Administrative tasks are categorized, which is useful in understanding where your team spends the most time. Tasks have two categories to provide deeper insight. For example: selecting \u2018Reporting\u2019 will not only filter the list of administrative tasks to display tasks categorized with reporting, it will also display tasks by their secondary category. Especially useful to understand what type of reporting your team is focusing on, and how much time they are spending completing this.<\/p>\n <\/p>\n Microsoft Power Platform Administration Planning is a standalone module in the CoE (Center of Excellence) Starter kit, which means it\u2019s open sourced and available for download<\/a> from the same GitHub repository as the toolkit is. Setup guidance and further information is available.<\/p>\n Watch the Power CAT Live! video<\/a> where we go into more detail about this solution:<\/p>\n |