© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. KolokolovMake Your Data Speakhttps://doi.org/10.1007/978-1-4842-8942-6_1

1. Data Preparation

Alex Kolokolov1  
(1)
Batumi, Georgia
 

Reports in the usual tables prepared manually are not suitable for building dashboards. The information in them is arranged conveniently and understandable for human perception, but isn’t suitable for machine processing. Therefore, dealing with data is the first step before developing a dashboard.

In this part of the book, I will tell you what to pay attention to when analyzing the initial data and show you how to prepare them properly, so that the interactive dashboard is automatically updated.

1.1 What’s Wrong with the Initial ...

Get Make Your Data Speak: Creating Actionable Data through Excel For Non-Technical Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.