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 supporting data.
For that, we will define the business goals and objectives and break it down 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.
A Business Goal is a Strategy statement - should be General, abstract, Large in size, Describe desired end result Longer term. For Example:
- Enable the business to create a focused series of events that all point towards the primary objective of sales conversion.
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
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.
Map in details 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, frequency of use, special business logic, etc.)
High-Level Design Webinar