Make Your Data Speak

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 howto 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

  Understand how to choose the right chart for every business case Learn how to create interactive dashboards Study how you can design dashboard that work within the corporate identity

  Autorentext
  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, he's 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.

  Klappentext

  Chapter 1: Data preparation.- Chapter 2. Dashboard assembling.- Chapter 3. Anatomy of diagrams.- Chapter 4. Final Design.- Chapter 5. Corporate identity.- Chapter 6. Data visualization rules.- Conclusion.

  Inhalt
  Chapter 1: Data preparation.- Chapter 2. Dashboard assembling.- Chapter 3. Anatomy of diagrams.- Chapter 4. Final Design.- Chapter 5. Corporate identity.- Chapter 6. Data visualization rules.- Conclusion.