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.
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 This Book is For
Company executives and divisional managers, Middle managers, business analysts
| About the Author |
|
v | |
| About the Technical Reviewer |
|
vii | |
| From the Author |
|
ix | |
| Three Stories That Made Me Write This Book |
|
xiii | |
|
Chapter 1 Data Preparation |
|
|
1 | (40) |
|
Chapter 2 Dashboard Assembling |
|
|
41 | (18) |
|
Chapter 3 Anatomy of Diagrams |
|
|
59 | (40) |
|
|
|
99 | (48) |
|
Chapter 5 Corporate Identity |
|
|
147 | (32) |
|
Chapter 6 Data Visualization Rules |
|
|
179 | (68) |
| How to Improve the Data-Driven Culture in Your Organization |
|
247 | (6) |
| Index |
|
253 | |
Alex Kolokolov is an expert in the Business Intelligence systems implementation and the development of information panels for managers dashboards. He is the CEO and founder of the Institute of Business Intelligence, a consulting company specializing in building corporate reporting systems. Author of the training "Make your Data Speak". Over 12 years of practice, Alex Kolokolov has set up hundreds of management reports in production, banks and trading companies, hes worked with software from Microsoft, Qlik, Tableau, IBM. Based on this experience he described universal rules for visualization and working with the requirements of business customers.
