Based on the business requirements summary you've created in the previous step, you can now design the high-level overview of your BI Solution. This step aims to translate the business strategy into operational terms and associate it with the required data.
For that, we will use the Dashboard Planning Document. The document will assist you to define the business goals and objectives and break it down into specific KPIs and measures. Then, we will be able to link each measure to its relevant data and formula. The following template will assist you in planning your dashboard. You can download the template below:
[Brief statement of the Dashboard goal and the business question/s covered in the dashboard. Provide the reader a background information, concise analysis, and main conclusions. Must be short and to the point.]
Creating a dashboard flow chart is recommended while planning any BI project.
This section describes the dashboard objective, the different types of users that will be using the dashboards and the expected call to action, based on this dashboard.
Business Objectives - Main Business Questions
A Business Objective is a Sub-goals, the steps to achieve the main goals, Medium or small in size, Concrete Shorter term, SMART. For Example:
Increase the number of qualified leads
Reduce marketing cost
A freestyle sketch of the final dashboard, to illustrate the dashboard layout, the selected visualization for each KPI, and additional information such as filters, plugins, etc.
Break each objective into KPIs and measures, and specify the formula and data tables that are required for achieving the KPIs.
Key performance indicators - Business metrics which support decision making. KPIs are used to evaluate factors which are crucial to achieving the business objectives.
Measures - Quantifiable values which can stand alone or when composed with other measures form KPIs.
Maps, in detail, the data elements that are required for analyzing the above KPIs. This map will help you to plan the ElastiCube structure and connections between the data elements in your model
This is the place to mention any general constraints you have on your analysis and limitation in terms of the data model (such as data security, the frequency of use, special business logic, etc.)