If your Excel reports are mainly made of cells and tables, we recommend replacing them with intuitive and interactive reports comprised of charts made of single-screen reports – dashboards. Dashboard is a specific kind of report where the most important information and indicators connected with company/organisation goals are visualised. The information is presented on a single screen or sheet. We create dashboards in Excel, which in a visual and simple way communicate the crucial information to the manager. The dashboards have the form of managerial dashboards which provide information and send signals or analytical dashboards which allow the user to answer the question: “Why?”. The scope of the project most frequently includes:
- Preparation of the data model or combining with a database
- Complete designing of a dashboard – on paper and in Excel
- Placing interactions (e.g. details on demand, view details, filtration or sorting)