This is a guide and possible template of the process to begin the development of a set of a data analytics dashboards. This will assist you in your business analysis and gathering requirements.
The principals as documented in 1.1 Foundation Principles will be the starting point of this process.
People
Who are the people involved with dashboard? Outline in the tables below who the people are and what their role is in the development of the dashboard.
Data Analytics Team
| Role | Name(s) | Email(s) | Phone Number(s) |
|---|
| Project Manager |
|
|
|
| Lead Dashboard Developer |
|
|
|
| Other Dashboard Developer(s) |
|
|
|
| Lead Database / ETL Developer |
|
|
|
| Other Database / ETL Developer(s) |
|
|
|
Client(s)
| Role | Name(s) | Email(s) | Phone Number(s) |
|---|
| Primary Stakeholder |
|
|
|
| Other Stakeholder(s) |
|
|
|
| Lead Data Source Business Expert |
|
|
|
| Other Data Source Business Expert(s) |
|
|
|
| Primary Data Source Technical Contact |
|
|
|
| Other Data Source Technical Contact(s) |
|
|
|
Customer(s)
| Team | Number of Users | Security Notes |
|---|
|
|
|
|
|
|
|
|
|
Tools
What sort of databases and tools are there?
Data Analytics Team
Database Servers
| Database | Phase | Server + Domain Name | CPU | RAM | Connection Details |
|---|
| Development |
|
|
|
|
| Test |
|
|
|
|
| Production |
|
|
|
|
Business Intelligence Servers
| Tool | Phase | Server + Domain Name | CPU | RAM | Connection Details |
|---|
| Development |
|
|
|
|
| Test |
|
|
|
|
| Production |
|
|
|
|
Project Management and Version Control
| Tool | HTTP Link | Connection Details |
|---|
| Project Management |
|
|
|
|
|
Documentation
| Tool | HTTP Link | Connection Details |
|---|
| SharePoint Site |
|
|
|
|
|
Client
Data Source
| Data Source Description | Database | Phase | Server + Domain Name | CPU | RAM | Connection Details | Client Requirements (Live / Daily??) |
|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Documentation
| Documentation Description | HTTP Link | Connection Details |
|---|
|
|
|
|
|
|
|
|
|
Processes and Procedures
Data Analytics Team
| Instance | Describe the process | Relevant HTTP Link |
|---|
| Requesting access to the dashboard |
|
|
| Dashboard server issues like server down or cannot connect |
|
|
| Dashboard issues like incorrect data / data quality |
|
|
|
|
|
Client processes and procedures
| Instance | Describe the process | Relevant HTTP Link |
|---|
| Requesting server to server access to client data source |
|
|
| Client data source server issues like server down / cannot connect |
|
|
| Client data source data issues like incorrect data / data quality |
|
|
|
|
|
Dashboard Requirements and Measures
Please list below the reporting and dashboard requirements that the client wants. This will also record the development status of their request
| Record Date | Name of Measure | Measure Description | Relevant Calculations / Formulas | Dashboard Page Name | Development Phase | Development Notes (including date) |
|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|