Notikumi
Power BI DataViz pasaules čempionāts
14. febr. 16 - 31. marts 16
Ar 4 iespējām piedalīties, jūs varētu laimēt konferences paketi un iekļūt LIVE Grand Finale Lasvegasā
Uzzināt vairākŠī pārlūkprogramma vairs netiek atbalstīta.
Jauniniet uz Microsoft Edge, lai izmantotu jaunāko līdzekļu, drošības atjauninājumu un tehniskā atbalsta sniegtās priekšrocības.
Piezīme
This article forms part of the Microsoft Fabric adoption roadmap series of articles. For an overview of the series, see Microsoft Fabric adoption roadmap.
A critical objective for adoption efforts is to enable users to accomplish as much as they can within the requisite guardrails established by governance guidelines and policies. For this reason, the act of mentoring users is one of the most important responsibilities of the Center of Excellence (COE), and it has a direct influence on how user adoption occurs. For more information about user adoption, see Microsoft Fabric adoption maturity levels.
Mentoring and helping users in the Fabric community become more effective can take on various forms, such as:
Office hours are a form of ongoing community engagements managed by the COE. As the name implies, office hours are times of regularly scheduled availability where members of the community can engage with experts from the COE to receive assistance with minimal process overhead. Office hours are usually group-based, so Fabric champions and other members of the community can also help solve an issue if a topic is in their area of expertise.
Office hours are a very popular and productive activity in many organizations. Some organizations call them drop-in hours or even a fun name such as Power Hour or Fabric Fridays. The primary goal is usually to get questions answered, solve problems, and remove blockers. Office hours can also be used as a platform for the user community to share ideas, suggestions, and even complaints.
The COE publishes the times for regular office hours when one or more COE members are available. Ideally, office hours are held on a regular and frequent basis. For instance, it could be every Tuesday and Thursday. Consider offering different time slots or rotating times if you have a global workforce.
Padoms
One option is to set specific office hours each week. However, users might not show up, so that can end up being inefficient. Alternatively, consider leveraging Microsoft Bookings to schedule office hours. It shows the blocks of time when each COE expert is available, with Outlook integration ensuring availability is up to date.
Office hours are an excellent user enablement approach because:
Office hours benefit the COE as well because:
Padoms
It's common for some tough issues to come up during office hours that cannot be solved quickly, such as getting a complex DAX calculation to work, or addressing performance challenges in a complex solution. Set clear expectations for what's in scope for office hours, and if there's any commitment for follow up.
One way the COE can provide mentoring services is during a co-development project. A co-development project is a form of assistance offered by the COE where a user or business unit takes advantage of the technical expertise of the COE to solve business problems with data. Co-development involves stakeholders from the business unit and the COE working in partnership to build a high-quality self-service analytics or business intelligence (BI) solution that the business stakeholders couldn't deliver independently.
The goal of co-development is to help the business unit develop expertise over time while also delivering value. For example, the sales team has a pressing need to develop a new set of commission reports, but the sales team doesn't yet have the knowledge to complete it on their own.
A co-development project forms a partnership between the business unit and the COE. In this arrangement, the business unit is fully invested, deeply involved, and assumes ownership of the project.
Time involvement from the COE reduces over time until the business unit gains expertise and becomes self-reliant.
The active involvement shown in the above diagram changes over time, as follows:
Ideally, the period for the gradual reduction in involvement is identified up-front in the project. This way, both the business unit and the COE can sufficiently plan the timeline and staffing.
Co-development projects can deliver significant short- and long-term benefits. In the short term, the involvement from the COE can often result in a better-designed and better-performing solution that follows best practices and aligns with organizational standards. In the long term, co-development helps increase the knowledge and capabilities of the business stakeholder, making them more self-sufficient, and more confident to deliver quality self-service data and BI solutions in the future.
Svarīgi
Essentially, a co-development project helps less experienced users learn the right way to do things. It reduces the risk that refactoring might be needed later, and it increases the ability for a solution to scale and grow over time.
The COE could also offer best practices reviews. A best practices review can be extremely helpful for content creators who would like to validate their work. They might also be known as advisory services, internal consulting time, or technical reviews. Unlike a co-development project (described previously), a best practices review occurs after the solution has been developed.
During a review, an expert from the COE evaluates self-service Fabric content developed by a member of the community and identifies areas of risk or opportunities for improvement.
Here are some examples of when a best practices review could be beneficial.
A best practices review is most often focused on the semantic model design, though the review can encompass all types of data items (such as a lakehouse, data warehouse, data pipeline, dataflow, or semantic model). The review can also encompass reporting items (such as reports, dashboards, or metrics).
Before content is deployed, a best practices review can be used to verify other design decisions, like:
Once the content has been deployed, the best practices review isn't necessarily complete yet. Completing the remainder of the review could also include items such as:
From time to time, the COE might get involved with complex issues escalated from the help desk. For more information, see the User support article.
Piezīme
Offering mentoring services might be a culture shift for your organization. Your reaction might be that users don't usually ask for help with a tool like Excel, so why would they with Power BI? The answer lies in the fact that Power BI and Fabric are extraordinarily powerful tools. They provide data preparation and data modeling capabilities in addition to data visualization. Having the ability to aid and enable users can significantly improve their skills and increase the quality of their solutions—it reduces risks too.
A single centralized portal, or hub, is where the user community can find:
Padoms
In general, only 10%-20% of your community will go out of their way to actively seek out training and educational information. These types of users might naturally evolve to become your champions. Everyone else is usually just trying to get the job done as quickly as possible, because their time, focus, and energy are needed elsewhere. Therefore, it's crucial to make information easy for your community users to find.
The goal is to consistently direct users in the community to the centralized portal to find information. The corresponding obligation for the COE is to ensure that the information users need is available in the centralized portal. Keeping the portal updated requires discipline when everyone is busy.
In larger organizations, it can be difficult to implement one single centralized portal. When it's not practical to consolidate into a single portal, a centralized hub can serve as an aggregator, which contains links to the other locations.
Svarīgi
Although saving time finding information is important, the goal of a centralized portal is more than that. It's about making information readily available to help your user community do the right thing. They should be able to find information during their normal course of work, with as little friction as possible. Until it's easier to complete a task within the guardrails established by the COE and data governance team, some users will continue to complete their tasks by circumventing policies that are put in place. The recommended path must become the path of least resistance. Having a centralized portal can help achieve this goal.
It takes time for community users to think of the centralized portal as their natural first stop for finding information. It takes consistent redirection to the portal to change habits. Sending someone a link to an original document location in the portal builds better habits than, for instance, including the answer in an email response. It's the same challenge described in the User support article.
A key factor for successfully enabling self-service users in a Fabric community is training. It's important that the right training resources are readily available and easily discoverable. While some users are so enthusiastic about analytics that they'll find information and figure things out on their own, it isn't true for most of the user community.
Making sure your self-service users (particularly content creators and owners) have access to the training resources they need to be successful doesn't mean that you need to develop your own training content. Developing training content is often counterproductive due to the rapidly evolving nature of the product. Fortunately, an abundance of training resources is available in the worldwide community. A curated set of links goes a long way to help users organize and focus their training efforts, especially for tool training, which focuses on the technology. All external links should be validated by the COE for accuracy and credibility. It's a key opportunity for the COE to add value because COE stakeholders are in an ideal position to understand the learning needs of the community, and to identify and locate trusted sources of quality learning materials.
You'll find the greatest return on investment with creating custom training materials for organizational-specific processes, while relying on content produced by others for everything else. It's also useful to have a short training class that focuses primarily on topics like how to find documentation, getting help, and interacting with the community.
Padoms
One of the goals of training is to help users learn new skills while helping them avoid bad habits. It can be a balancing act. For instance, you don't want to overwhelm new users by adding in a lot of complexity and friction to a beginner-level class for report creators. However, it's a great investment to make newer content creators aware of things that could otherwise take them a while to figure out. An ideal example is teaching the ability to use a live connection to report from an existing semantic model. By teaching this concept at the earliest logical time, you can save a less experienced creator thinking they always need one semantic model for every report (and encourage the good habit of reusing existing semantic models across reports).
Some larger organizations experience continual employee transfers and turnover. Such frequent change results in an increased need for a repeatable set of training resources.
There are many training approaches because people learn in different ways. If you can monitor and measure usage of your training materials, you'll learn over time what works best.
Some training might be delivered more formally, such as classroom training with hands-on labs. Other types of training are less formal, such as:
The advantages of encouraging knowledge sharing among colleagues are described in the Community of practice article.
Padoms
Whenever practical, learning should be correlated with building something meaningful and realistic. However, simple demo data does have value during a training course. It allows a learner to focus on how to use the technology rather than the data itself. After completion of introductory session(s), consider offering a bring your own data type of session. These types of sessions encourage the learner to apply their new technical skills to an actual business problem. Try to include multiple facilitators from the COE during this type of follow-up session so questions can be answered quickly.
The types of users you might target for training include:
Svarīgi
Each type of user represents a different audience that has different training needs. The COE will need to identify how best to meet the needs of each audience. For instance, one audience might find a standard introductory Power BI Desktop class overwhelming, whereas another will want more challenging information with depth and detail for end-to-end solutions that include multiple Fabric workloads. If you have a diverse population of Fabric content creators, consider creating personas and tailoring the experience to an extent that's practical.
The completion of training can be a leading indicator for success with user adoption. Some organizations add an element of fun by granting badges, like blue belt or black belt, as users progress through the training programs.
Give some consideration to how you want to handle users at various stages of user adoption. Training needs are very different for:
How the COE invests its time in creating and curating training materials will change over time as adoption and maturity grows. You might also find over time that some community champions want to run their own tailored set of training classes within their functional business unit.
A curated set of online resources is valuable to help community members focus and direct their efforts on what's important. Some publicly available training resources you might find helpful include:
Consider using Microsoft Viva Learning, which is integrated into Microsoft Teams. It includes content from sources such as Microsoft Learn and LinkedIn Learning. Custom content produced by your organization can be included as well.
In addition to Microsoft content and custom content produced by your organization, you might choose to provide your user community with a curated set of recommended links to trusted online sources. There's a wide array of videos, blogs, and articles produced by the worldwide community. The community comprises Fabric and Power BI experts, Microsoft Most Valued Professions (MVPs), and enthusiasts. Providing a curated learning path that contains specific, reputable, current, and high-quality resources will provide the most value to your user community.
If you do make the investment to create custom in-house training, consider creating short, targeted content that focuses on solving one specific problem. It makes the training easier to find and consume. It's also easier to maintain and update over time.
Padoms
The Help and Support menu in the Fabric portal is customizable. When your centralized location for training documentation is operational, update the tenant setting in the Admin portal with the link. The link can then be accessed from menu when users select the Get Help option. Also, be sure to teach users about the Help ribbon tab in Power BI Desktop. It includes links to guided learning, training videos, documentation, and more.
Concise, well-written documentation can be a significant help for users trying to get things done. Your needs for documentation, and how it's delivered, will depend on how Fabric is managed in your organization. For more information, see the Content ownership and management article.
Certain aspects of Fabric tend to be managed by a centralized team, such as the COE. The following types of documentation are helpful in these situations:
Padoms
For certain activities that are repeated over and over, consider automating them using Power Apps and Power Automate. In this case, your documentation will also include how to access and use the Power Platform functionality.
Different aspects of your documentation can be managed by self-service users, decentralized teams, or by a centralized team. The following types of documentation might differ based on who owns and manages the content:
Padoms
When planning for a centralized portal, as described earlier in this article, plan how to handle situations when guidance or governance policies need to be customized for one or more business units.
There are also going to be some governance decisions that have been made and should be documented, such as:
Documentation should be located in your centralized portal, which is a searchable location where, preferably, users already work. Either Teams or SharePoint work very well. Creating documentation in either wiki pages or in documents can work equally well, provided that the content is organized well and is easy to find. Shorter documents that focus on one topic are usually easier to consume than long, comprehensive documents.
Svarīgi
One of the most helpful pieces of documentation you can publish for the community is a description of the tenant settings, and the group memberships required for each tenant setting. Users read about features and functionality online, and sometimes find that it doesn't work for them. When they are able to quickly look up your organization's tenant settings, it can save them from becoming frustrated and attempting workarounds. Effective documentation can reduce the number of help desk tickets that are submitted. It can also reduce the number of people who need to be assigned the Fabric administrator role (who might have this role solely for the purpose of viewing settings).
Over time, you might choose to allow certain types of documentation to be maintained by the community if you have willing volunteers. In this case, you might want to introduce an approval process for changes.
When you see questions repeatedly arise in the Q&A forum (as described in the User support article), during office hours, or during lunch and learns, it's a great indicator that creating new documentation might be appropriate. When the documentation exists, it allows colleagues to reference it when needed. Documentation contributes to user enablement and a self-sustaining community.
Padoms
When creating custom documentation or training materials, reference existing Microsoft sites using links whenever possible. Most community bloggers don't keep blog posts or videos up to date.
A Power BI template is a .pbit file. It can be provided as a starting point for content creators. It's the same as a .pbix file, which can contain queries, a data model, and a report, but with one exception: the template file doesn't contain any data. Therefore, it's a smaller file that can be shared with content creators and owners, and it doesn't present a risk of inappropriately sharing data.
Providing Power BI template files for your community is a great way to:
Power BI template files can improve efficiency and help people learn during the normal course of their work. A few ways that template files are helpful include:
Piezīme
Providing templates not only saves your content creators time, it also helps them move quickly beyond a blank page in an empty solution.
A Power BI project is a .pbip file. Like a template file (previously described), a project file doesn't contain any data. It's a file format that advanced content creators can use for advanced data model and report management scenarios. For example, you can use project files to save time in development by sharing common model patterns, like date tables, DAX measure expressions, or calculation groups.
You can use Power BI project files with Power BI Desktop developer mode for:
Piezīme
Power BI includes capabilities such as .pbit template files and .pbip project files that make it simple to share starter resources with authors. Other Fabric workloads provide different approaches to content development and sharing. Having a set of starter resources is important regardless of the items being shared. For example, your portal might include a set of SQL scripts or notebooks that present tested approaches to solve common problems.
Checklist - Considerations and key actions you can take to establish, or improve, mentoring and user enablement.
Use questions like those found below to assess mentoring and user enablement.
The following maturity levels will help you assess the current state of your mentoring and user enablement.
Level | State of mentoring and user enablement |
---|---|
100: Initial | • Some documentation and resources exist. However, they're siloed and inconsistent. • Few users are aware of, or take advantage of, available resources. |
200: Repeatable | • A centralized portal exists with a library of helpful documentation and resources. • A curated list of training links and resources are available in the centralized portal. • Office hours are available so the user community can get assistance from the COE. |
300: Defined | • The centralized portal is the primary hub for community members to locate training, documentation, and resources. The resources are commonly referenced by champions and community members when supporting and learning from each other. • The COE's skills mentoring program is in place to assist users in the community in various ways. |
400: Capable | • Office hours have regular and active participation from all business units in the organization. • Best practices reviews from the COE are regularly requested by business units. • Co-development projects are repeatedly executed with success by the COE and members of business units. |
500: Efficient | • Training, documentation, and resources are continually updated and improved by the COE to ensure the community has current and reliable information. • Measurable and tangible business value is gained from the mentoring program by using KPIs or OKRs. |
In the next article in the Microsoft Fabric adoption roadmap series, learn about the community of practice.
Notikumi
Power BI DataViz pasaules čempionāts
14. febr. 16 - 31. marts 16
Ar 4 iespējām piedalīties, jūs varētu laimēt konferences paketi un iekļūt LIVE Grand Finale Lasvegasā
Uzzināt vairākApmācība
Mācību ceļš
Use advance techniques in canvas apps to perform custom updates and optimization - Training
Use advance techniques in canvas apps to perform custom updates and optimization
Sertifikācija
Microsoft Certified: Power Platform Fundamentals - Certifications
Demonstrate the business value and product capabilities of Microsoft Power Platform, such as Power Apps, data connections with Dataverse, and Power Automate.
Dokumentācija
Microsoft Fabric adoption roadmap: Community of practice - Power BI
Establish a community of practice to help users drive strong and successful adoption of Microsoft Fabric.
Microsoft Fabric adoption roadmap: Center of Excellence - Power BI
Establish a Center of Excellence (COE) to drive strong and successful adoption of Microsoft Fabric.
Microsoft Fabric adoption roadmap: Change management - Power BI
Learn about effective change management for Microsoft Fabric.