Название: Make Your Data Speak: Creating Actionable Data through Excel For Non-Technical Professionals
Автор: Alex Kolokolov
Издательство: Apress
Год: 2023
Страниц: 260
Язык: английский
Формат: pdf
Размер: 24.0 MB

Gather and analyze data successfully, identify trends, and then create overarching strategies and actionable next steps - all through Excel. This book will show even those who lack a technical background how to make advanced interactive reports with only Excel at hand. Advanced visualization is available to everyone, and this step-by-step guide will show you how.

The information in this book is presented in an accessible and understandable way for everyone, regardless of the level of technical skills and proficiency in MS Excel. The dashboard development process is given in the format of step-by-step instructions, taking you through each step in detail. Universal checklists and recommendations of a practicing business analyst and trainer will help in solving various tasks when working with data visualization. Illustrations will help you perceive information easily and quickly. Make Your Data Speak will show you how to master the main rules, techniques and tricks of professional data visualization in just a few days.

This Book Is Not About Excel
No matter how much artificial intelligence, robotics, and other latest technologies are discussed, business decisions are still made by people. Often this has to be done in conditions of lack of information, when there is a lot of data, but there are few useful conclusions from them. And Excel, as a basic tool for most, should be mastered at least to solve this problem. I’m not a fan of Excel, but it’s still used even in large corporations, and you can’t ignore this. It just so happened: we all love him, hate him, and cannot do without him. For me personally, Excel is valuable in that you can test a hypothesis right in the source data file and sketch out a draft of a future dashboard or presentation in half an hour. A handy tool for managers and a foundation of digital skills for top managers. I would say this: no, this book is not about Excel. All principles, rules, and techniques are relevant for working in any BI system. If you know them, then even your first dashboard in BI will do better than beginners usually do.

What You'll Learn:
See how interactive dashboards can be useful for a business
Review basic rules for building dashboards
Understand why it's important to pay attention to colors and fonts when developing a dashboard
Create interactive management reports in Excel

Who Is This Book For?
Every report has two audiences. The first is the analysts who collect data and make calculations. The second is the consumers of this information, the managers who make decisions based on the collected data. This book is suitable for both, but it is written in such a way that everythingis clear to business users, even without technical knowledge. I presented the material in simple “human” language – just as I explain in my trainings and MBA programs in business schools. My goal is to show managers with different professional backgrounds how to “tame” data visualization, set a task to develop a dashboard, and control the quality so that the business gets a decision-making tool.