Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
This article forms part of the Power BI implementation planning series of articles. This series focuses primarily on the Power BI experience within Microsoft Fabric. For an introduction to the series, see Power BI implementation planning.
This article helps you to plan solutions that support your business intelligence (BI) strategy. It's primarily targeted at:
A BI strategy is a plan to implement, use, and manage data and analytics. You define your BI strategy by starting with BI strategic planning. Strategic planning helps you to identify your BI focus areas and objectives. To determine the path to progress toward your BI objectives, you describe specific key results by using tactical planning. You then achieve progress toward these key results by planning and deploying BI solutions.
Note
In the objectives and key results (OKRs) framework, objectives are clear, high-level descriptions of what you want to achieve. In contrast, key results are specific, achievable outcomes to measure progress toward one of your objectives.
Further, initiatives or solutions are processes or tools built to help you achieve one or more key results. Solutions address specific data needs for users. A solution can take many forms, such as a data pipeline, a data lakehouse, or a Power BI semantic model or report.
For more about OKRs, see Get to know OKRs (Microsoft Viva Goals).
There are many approaches to plan and implement BI solutions. This article describes one approach that you can take to plan and implement BI solutions that support your BI strategy.
The following high-level diagram depicts how to conduct BI solution planning.
You take the following steps to conduct BI solution planning.
Step | Description |
---|---|
1 | Assemble a project team that gathers requirements and defines the design of the solution. |
2 | Plan for solution deployment by performing initial setup of tools and processes. |
3 | Conduct a solution proof of concept (POC) to validate assumptions about the design. |
4 | Create and validate content by using iterative development and validation cycles. |
5 | Deploy, support, and monitor the solution after it's released to the production environment. |
Note
BI solution planning applies to both self-service BI and enterprise BI projects.
For more information, see the Power BI migration series. While the series is concerned with migration, the key actions and considerations are relevant to solution planning.
You commence solution planning by first gathering requirements and defining the solution design.
Note: Strategic and tactical planning is led by a working team, which leads the initiative. In contrast, solution planning is led by a project team, which consists of content owners and creators.
Gathering the right requirements is critical to achieve successful solution deployment and adoption. An effective way to gather requirements is to identify and involve the right stakeholders, collaboratively define the problem to be solved, and use that shared understanding of the problem to create a solution design.
Here are some benefits from using a collaborative approach to gather requirements.
You can take different approaches to engage users and gather requirements. For example, you can gather requirements with business design and technical design (described in detail in later sections of this article).
Business design is an approach to gather business requirements. It focuses on engaging business users in business design sessions to collaboratively design the solution. The output of a business design consists of solution mock-ups and descriptive design documentation.
Technical design is an approach to translate business requirements to technical requirements, and to address design assumptions. A technical design focuses on validating the business design and defining a technical approach to use. To validate the design, content creators typically engage with technical experts in focused discussions called technical design sessions, where necessary.
Important
Collecting the wrong requirements is a common reason why implementations fail. Often, teams collect the wrong requirements because they engaged with the wrong stakeholders, like decision makers who provide top-down requests for solutions to be built.
Engaging business users by using collaborative approaches like a business design can help you collect better requirements. Better requirements often lead to more efficient development and more robust solutions.
Note
For some teams, adopting a structured requirements gathering process is a big change. Ensure that you manage this change, and that it doesn't disrupt solution planning. We recommend that you find ways to adapt these approaches to fit with the way your team works.
You should first prepare for solution planning by considering the factors described in the following sections.
Tip
Consider identifying and involving the support teams responsible for the solution early in the requirements gathering process. To effectively support the solution, the support teams will need a comprehensive understanding of the solution, its purpose, and the users. That's particularly important when the project team is comprised only of external consultants.
Gathering the right business requirements is critical to designing the right solution. To gather the right requirements and define an effective solution design, the project team can conduct business design sessions together with the business users.
The purpose of the business design sessions is to:
The following diagram depicts how to gather business requirements and define the solution design by using a business design approach.
The diagram depicts the following steps.
Item | Description |
---|---|
The project team begins the business design by confirming the solution scope that was first documented in tactical planning. They should clarify the business areas, systems, and data that the solution will encompass. | |
The project team identifies key stakeholders from the user community who will be involved in the business design sessions. Key stakeholders are users with sufficient knowledge and credibility to represent the subject areas of the solution. | |
The project team plans business design sessions. Planning involves informing stakeholders, organizing meetings, preparing deliverables, and engaging with business users. | |
The project team gathers and researches existing solutions that business users currently use to address existing business data needs. To accelerate this process, the project team can use relevant research from BI strategic planning, which has been documented in the communication hub. | |
The project team runs business design sessions with stakeholders. These sessions are small, interactive meetings, where the project team guides stakeholders to understand business data needs and requirements. | |
The project team concludes the business design by presenting a draft solution design to stakeholders and other users for feedback and approval. The business design is successful when the stakeholders agree that the design will help them achieve their business objectives. |
The business design concludes with the following deliverables.
The business design deliverables are used in, and validated by, the technical design.
Tip
Solution mock-ups, prototypes, or wireframe diagrams can create a clear understanding of the expected result, both for developers and end users. Creating effective mock-ups doesn't require artistic skill or talent. You can use simple tools like Microsoft Whiteboard, PowerPoint, or even just a pen and paper to illustrate the design.
After completing the business design, the project team validates its outcomes by using a technical design. The technical design is an approach similar to the business design. While the business design focuses on business data needs, the technical design focuses on the technical aspects of a solution. A key outcome of the technical design is the solution plan, which describes the final solution design and informed estimates of the effort to implement it.
Note
Unlike the business design, the technical design is largely an independent investigation into source data and systems conducted by content creators and owners.
The purpose of a technical design is to:
The project team engages technical or functional stakeholders in limited, focused technical design sessions. These sessions are interactive meetings with the functional stakeholders to gather technical requirements. Stakeholders are responsible for specific functional areas required for the solution to work effectively.
Examples of stakeholders in a technical design could be:
The project team engages stakeholders in technical design sessions to address technical aspects of the solution. Technical aspects can include:
Tip
The project team who conducted the business design should also conduct the technical design. However, for practical reasons, different individuals might lead the technical design. In this case, begin the technical design by reviewing the outcomes of the business design.
Ideally, the individuals who lead the technical design should have a thorough understanding of the outcomes and the business users.
The following diagram depicts how to translate business requirements into technical requirements by using a technical design.
The diagram depicts the following steps.
Item | Description |
---|---|
The project team begins the technical design by defining the data source scope based on the results of the business design. The data source scope declares which data are required to build the solution. To identify the right data sources, the project team consults with the business and functional SMEs. | |
The project team identifies technical or functional stakeholders to involve later in the technical design sessions. | |
The project team plans limited, focused sessions with functional stakeholders to address technical aspects of the solution. Planning involves informing stakeholders, organizing meetings, and preparing deliverables. | |
The project team researches technical requirements. Research includes defining field calculations and data source mappings, and also addressing the business design assumptions with technical analysis and documentation. | |
If necessary, the project team involves stakeholders in technical design sessions. Sessions focus on a specific, technical aspect of the solution, like security or data source connections. In these sessions, the project team gathers qualitative feedback from stakeholders and SMEs. | |
The project team prepares their findings by using a solution plan, which they present to stakeholders and decision makers. The plan is an iteration and extension of the business design outcomes that includes the final design, estimations, and other deliverables. | |
The technical design should conclude with a final meeting with stakeholders and decision makers to decide whether or not to proceed. This meeting provides a final opportunity to evaluate the solution planning before resources are committed to developing the solution. |
Note
The technical design might reveal unexpected complexity that could make the solution planning infeasible given the current resource availability or organizational readiness. In this case, the solution should be reevaluated in the subsequent tactical planning period. Depending on the urgency of the business data needs, a decision maker, like the executive sponsor, might still want to proceed with a proof of concept, or only one part of the planned solution.
The technical design concludes with a solution plan, which consists of the following deliverables.
Important
Ensure that the project team notifies stakeholders of any changes or unexpected discoveries from the technical design. These technical design sessions should still involve relevant business users. However, ensure that stakeholders aren't unnecessarily exposed to complex technical information.
Tip
Because business objectives invariably evolve, it's expected that requirements will change. Don't assume that requirements for BI projects are fixed. If you struggle with changing requirements, it might be an indication that your requirements gathering process isn't effective, or that your development workflows don't sufficiently incorporate regular feedback.
Checklist - When gathering requirements, key decisions and actions include:
When the project team finishes gathering requirements, creating the solution plan, and receiving approval to proceed, it's ready to plan for solution deployment.
Deployment planning tasks differ depending on the solution, your development workflow, and your deployment process. A deployment plan typically pertains to many activities involving the planning and setup of tools and processes for the solution.
The project team should plan for key areas of solution deployment. Typically, planning should address the following areas.
The project team should perform initial set up to commence development. Initial set up activities can include:
Note
Deployment planning differs depending on the solution and your preferred workflow. This article describes only on high-level planning and actionable items.
For more information about deployment planning, see Plan deployment to migrate to Power BI.
Checklist - When planning solution deployment, key decisions and actions include:
The project team conducts a solution proof of concept (POC) to validate outstanding assumptions and to demonstrate early benefits for business users. A POC is an initial design implementation that's limited in scope and maturity. A well-run POC is particularly important for large or complex solutions because it can identify and address complexities (or exceptions) that weren't detected in the technical design.
We recommend factoring in the following considerations when preparing a POC.
Caution
When the project team conducts the POC, they should remain alert for assumptions and limitations. For example, the project team can't easily test solution performance and data quality by using a small set of data. Additionally, ensure that the scope and purpose of the POC is clear to the business users. Be sure to communicate that the POC is a first iteration, and stress that it's not a production solution.
Note
For more information, see Conduct proof of concept to migrate to Power BI.
Checklist - When creating a POC, key decisions and actions include:
When the POC is successful, the project team shifts from the POC to creating and validating content. The project team can develop the BI solution with iterative development and validation cycles. These cycles consist of iterative releases, where the project team creates content in a development environment and releases it to a test environment. During development, the project team gradually onboards the user community in a pilot process to early (beta) versions of the solution in the test environment.
Tip
Iterative delivery encourages early validation and feedback that can mitigate change requests, promote solution adoption, and realize benefits before the production release.
Iterative development and validation cycles proceed until the project team arrives at a predefined conclusion. Typically, development concludes when there are no more features to implement or user feedback to address. When the development and validation cycles conclude, the project team deploys the content to a production environment with the final production release.
The following diagram depicts how the project team can iteratively deliver BI solutions with development and validation cycles.
The diagram depicts the following steps.
Item | Description |
---|---|
The project team communicates each release to the user community, describing changes and new features. Ideally, communication includes a solution demonstration and Q&A, so users understand what's new in the release, and they can provide verbal feedback. | |
During validation, users provide feedback via a central tool or form. The project team should review feedback regularly to address issues, accept or reject requests, and inform upcoming development phases. | |
The project team monitors usage of the solution to confirm that users are testing it. If there isn't any usage, the project team should engage with the user community to understand the reasons why. Low usage can indicate that the project team needs to take further enablement and change management actions. | |
The project team promptly responds to user feedback. If the project team takes too long to address feedback, users might quickly lose motivation to provide it. | |
The project team incorporates accepted feedback into the solution planning. If necessary, they review the planning priorities to clarify and delegate tasks before the next development phase begins. | |
The project team continues development of the solution for the next release. | |
The project team iterates through all steps until they reach a predefined conclusion, and the solution is ready for production deployment. |
The following sections describe key considerations for using iterative development and validation cycles to deliver BI solutions.
The project team develops the solution by following their normal development workflow. However, they should consider the following points when creating content.
Each iterative development cycle should conclude with content validation. For BI solutions, there are typically two kinds of validation.
Important
Ensure that any data quality issues are addressed during developer validation (before UAT). These issues can quickly erode trust in the solution, and they can harm long-term adoption.
Tip
When conducting user validation, consider occasional, short calls with key users. Observe them when they use the solution. Take notes about what they find difficult to use, or what parts of the solution aren't working as expected. This approach can be an effective way to collect feedback.
Factor in the following considerations when the project team validates content.
When the solution reaches a predefined level of completeness and maturity, the project team is ready to deploy it to production. After deployment, the project team transitions from iterative delivery to supporting and monitoring the production solution.
Note
Development and testing differ depending on the solution and your preferred workflow.
This article describes only high-level planning and actionable items. For more information about iterative development and testing cycles, see Create content to migrate to Power BI.
Checklist - When creating and validating content, key decisions and actions include:
When ready, the project team deploys the validated solution to the production environment. The project team should take key adoption and support actions to ensure that the deployment is successful.
To ensure a successful deployment, you perform the following support and adoption tasks.
Caution
Failing to conduct an effective handover can lead to preventable issues with solution support and adoption during its lifecycle.
After deployment, the project team should plan to proceed to the next solution in the prioritized solution backlog. Ensure that you collect any new feedback and requests and make revisions to tactical planning—including the solution backlog—if necessary.
Checklist – When considering solution deployment, key decisions and actions include:
For more considerations, actions, decision-making criteria, and recommendations to help you with Power BI implementation decisions, see Power BI implementation planning.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Learning path
Solution Architect: Design Microsoft Power Platform solutions - Training
Learn how a solution architect designs solutions.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.