Based on Microsoft Office Excel, SAP Crystal Dashboard (Xcelsius) allows you to convert your old spreadsheets into exciting visually interactive dashboards. Numbers in Excel are brought to life with dynamic graphs, which allow the user to customize and visualize data in real time. While spreadsheet data is static and needs to be updated from reports using cut-and-paste, dashboards automatically query databases or reports for the most current data.
This book by Information Analytics Institute, designed as a 3 day course, is written in a way perfect for self study or it can be used in an instructor led classroom setting. The student learns by actually building dashboards; not by reading theory. The book consists of nine chapters written in an easy to follow step-by-step format. All the instructions are accompanied by detailed color illustrations. A new and increasingly challenging dashboard, which introduces and teaches new concepts, is built in each chapter. Student files provided by Information Analytics Institute include pre-constructed and mid construction dashboards and can be examined prior to purchase.
During the course you will:
- get acquainted with the program window, menus and toolbars
- discover the variety of components you can choose from to create dashboards
- learn how to deal with properties and settings of different objects
- study how to link objects to spreadsheet data
- find out how to set up connections between objects and make them influence each other
- learn to organize objects on the canvas by aligning and grouping them
- see how to organize data in the spreadsheet by distributing it among different sheets and tables
- write different Excel formulas to get the data you need
- learn many facets of effective dashboard design
- apply standards and best practices and study them with the online Standards & Best Practices reference guide and tools
This book by Information Analytics Institute, designed as a 3 day course, is written in a way perfect for self study or it can be used in an instructor led classroom setting. The student learns by actually building dashboards; not by reading theory. The book consists of nine chapters written in an easy to follow step-by-step format. All the instructions are accompanied by detailed color illustrations. A new and increasingly challenging dashboard, which introduces and teaches new concepts, is built in each chapter. Student files provided by Information Analytics Institute include pre-constructed and mid construction dashboards and can be examined prior to purchase.
During the course you will:
- get acquainted with the program window, menus and toolbars
- discover the variety of components you can choose from to create dashboards
- learn how to deal with properties and settings of different objects
- study how to link objects to spreadsheet data
- find out how to set up connections between objects and make them influence each other
- learn to organize objects on the canvas by aligning and grouping them
- see how to organize data in the spreadsheet by distributing it among different sheets and tables
- write different Excel formulas to get the data you need
- learn many facets of effective dashboard design
- apply standards and best practices and study them with the online Standards & Best Practices reference guide and tools
