Touro University International
Scott G. Sunday
ITM442 â€“ Knowledge Management, Business Intelligence, and Enterprise Systems
Module 2 â€“ Session Long Project
Dr. Elizabeth Warren
The purpose of this paper is to continue exploring the business intelligence program Crystal Xcelsius. The assignment for this Session Long Project provides more practice with Crystal Xcelsius through two getting started tutorials. The paper begins with a discussion of the two tutorials â€“ what was expected and what was accomplished. The paper then captures lessons learned throughout the tutorials. The paper closes by providing general thoughts regarding the use of tutorials such as ...view middle of the document...
This tutorial linked the Xcelsius presentation directly to sites on the web, allowing users access to additional information. The tutorial closed by cleaning up the presentation with final formatting â€“ adding headers, labels, and backgrounds. The tutorial demonstrated the vast potential for this program as a decision making tool. Allowing organizations to analyze data visually, using multiple comparison charts, lets business managers make sound decisions.
The second tutorial for this Module, the Spreadsheet Design Getting-Started Tutorial, â€œleads you through a few â€˜best practicesâ€™ for formatting and organizing your Excel spreadsheets for optimum use in Crystal Xcelsiusâ€ (Enhance your skills and knowledge in the Xcelsius learning center). This tutorial consisted of two sections, general guidelines and guidelines for specific Xcelsius tasks. The first section, general guidelines, focused on general tips for creating streamlined Excel spreadsheets. The second section introduced several concepts unique to creating Xcelsius presentations.
Unlike previous tutorials, which created new Xcelsius presentations, this tutorial focused on manipulating data contained in existing Excel spreadsheets. Section one listed the following best practice strategies, with descriptions and sample spreadsheets for each:
â€¢ Best Practice 1: Organize your data in a logical fashion.
â€¢ Best Practice 2: Use tabs for larger spreadsheets.
â€¢ Best Practice 3: Keep instructions, parameters, and other frequently used variables at the top of your spreadsheet.
â€¢ Best Practice 4: Document your work with comments.
â€¢ Best Practice 5: Use labels and colors to identify data types.
â€¢ Best Practice 6: Separate input and output data into distinct areas of your spreadsheet.
â€¢ Best Practice 7: Keep all data within a given data set contiguous.
â€¢ Best Practice 8: Place all data for a given set of selection variables in the same row.
â€¢ Best Practice 9: Allow plenty of space between data groupings.
â€¢ Best Practice 10: Insert chart titles, labels, and numbers in the appropriate format and alignment in...