caite.info Technology XCELSIUS 2008 DASHBOARD BEST PRACTICES PDF

Xcelsius 2008 dashboard best practices pdf

Friday, February 1, 2019 admin Comments(0)

Selection from Xcelsius Dashboard Best Practices [Book] content in whatever format works best: as HTML pages, PowerPoint presentations, PDF files. Get Familiar with Xcelsius SDK Best Practices. . .swf) or something else containing the Flash file such as HTML and Adobe PDF. ( Portable. XCELSIUS DASHBOARD BEST PRACTICES - (FREE) Xcelsius and successful teaching manual pdf de photoshop cs5 living traditions.


Author: FAUSTINO WITHFIELD
Language: English, Spanish, Dutch
Country: Venezuela
Genre: Health & Fitness
Pages: 689
Published (Last): 11.08.2016
ISBN: 318-9-69213-421-5
ePub File Size: 24.56 MB
PDF File Size: 17.85 MB
Distribution: Free* [*Regsitration Required]
Downloads: 28465
Uploaded by: XOCHITL

Xcelsius Best Practices – presented by Heather Sinkwitz 3/19/08 Should be able to quickly glance at the dashboard and gain immediate . The Macromedia Flash Player. BOE. MS SharePoint. HTML. Word. Power Point. PDF. Email. Xcelsius® Dashboard Best Practices - Ebook download as PDF File .pdf), Text File .txt) or read book online. xcelsius dashboard best practices pdf download. basic sap. beginners manual,whirlpool gas dryer repair manual pdf,xcelsius dashboard best.

The rest of the book. Xcelsius Computer file 2. There is no fixed limit on how many variables you can adjust from a single component. The objective here is that when the user clicks or moves the mouse over a specific region in the pie chart, an event should be triggered that retrieves one of the columns in the source data and pushes the selected column of data onto a destination. Abdulezer introduces Xcelsius , reviews its core concepts, and demonstrates the wide range of dashboards it can create. Loren is the editor-in-chief of Xcelsius Journal www.

Value at Risk VaR. Accounting for the Element of Time in a Financial Analysis. Basic Ideas About Maps in Xcelsius. Understanding Alerts in Xcelsius. The Digitization of Data. An Important Preliminary Issue. Model your business. As we were presenting. It happened for me a couple years ago. We had about an hour to present everything and help make a key business decision. Liven up your dashboards by connecting your dashboard to real-time.

By not making the decision. Our challenge to you. Foreword Have you ever experienced how data can change the world? How compelling presentations can get CEOs out of their seats? How a business dashboard can turn a regular business manager into an invaluable hero to a company?

Or how a tool that simplifies data and makes information informative. And we added the key element that every CEO wants: Use your business data anywhere. He put his own experience and assumptions to the model. See how pricing. On the bright side. Within a few hours. See how decisions impact the environment. What we showed was that it was actually a bad idea to make the investment that many were asking for.

My team at Business Objects was looking for a way to present a new business opportunity with key metrics. Having the right skills to build a business dashboard without overwhelming the audience made all the difference. We combined all the key data that we were using to look at the business decision. And more importantly. Put that data into Xcelsius and you will quickly change the way you see and monitor your business and completely change the decision-making experience. But then we summarized the entire business opportunity and how we wanted to look at the opportunity into a single dashboard.

I have. Product Management Business Objects. Good luck. Done right. Of course. Every day we see more great dashboards that are changing the world. Make sure you take some time to learn some best practices laid out in this book. Try out the samples to get you started. You have a wealth of components to choose from—everything from sliders to dials and list boxes. Building dashboard interactivity and managing visibility of the various components so that your dashboard keeps toe to toe with its embedded spreadsheet.

Have fun. Every dial. And make sure you share your great work with others. And remember. James Thomas Vice President. Adding visual components to display spreadsheet results.

Practices best 2008 xcelsius pdf dashboard

You can also manage their properties so that they are truly interactive. Mapping visual components on the dashboard to drive the inputs on the spreadsheet. The secret to its power is how it is joined at the hip with spreadsheets. From a dashboard layout perspective. It sounds like everybody ought to be using Xcelsius As you keep cloning. First and foremost. If you are busy worrying about monitoring and meeting production quotas. If your dashboard serves you well. So what is stopping you from building better dashboards?

The biggest challenge holding most people back is lack of time. Like many of those other professionals. To get a roaring and self-sustaining fire. Excel lacked some essential features that I was looking for: Xcelsius is remarkably easy to use. Two product generations later. Preface A broad and growing community of professionals regularly prepares or needs to prepare dashboards and interactive visualizations and reports.

This is. Xcelsius has undergone a metamorphosis. This quick bang for the buck is like kindling wood in a furnace: The problem is that unless I incorporated extensive amounts of one-off code.

It is not nearly agile enough to keep up with changing requirements or expectations.

Practices dashboard xcelsius 2008 pdf best

Xcelsius is a serious tool for building interactive dashboards and intelligent visualizations. Say that you want to add a second product line. You start with your already working dashboard design as your template and add more features.

Who knows? Maybe you need to enable weekly or daily analysis in addition to monthly analysis. Maybe for an occasional dashboard. I have used Excel to create useful reports and dashboards. Xcelsius now includes a well-honed and highly integrated spreadsheet and dashboard design environment.

At some point not far down the road. This is great stuff. For instance. I help you build up your spreadsheet skills in an Xcelsius-centric way. I show how you can work smarter by using best practices. When these need to be scaled up to do complex things.

Show you how to use the new and important features of Xcelsius so that you can quickly transition to this newer technology. Every step of the way. I get you started with setting up your Xcelsius workspace. To save you valuable time. In this book. Describe how the preparation and processing of data. I know that time is premium for you. I cover the standard features such as drill down and alerts. Show how to design simple and effective dashboard interfaces.

Cover the essential components you will regularly be using in dashboards. I introduce you to essential components and show you how to use them. Explain how to construct custom components. Devote whole chapters to constructing spreadsheet formulas embedded in dashboards. Show how to utilize features of Xcelsius for remote data connectivity. I do a few other things: It is for everyone. Loren Abdulezer December He served as the technical editor of Crystal Xcelsius For Dummies.

Loren also started the website Xcelsius Best Practices www. He has a long-standing record in the Xcelsius community and has been a staunch proponent of the technology since its early days. He can be reached at dashboards evolvingtech. Loren is the editor-in-chief of Xcelsius Journal www. Dedication To my wife. Claire Maytum. You would not be reading this book were it not for their involvement.

Dennis Blasius. Their involvement helped me to produce a far better book. I am grateful to my acquisitions and project editor. Saskia Battersby and John McNaughton clearly perceived the need for an Xcelsius-centric book on dashboard best practices. David Harper. Betsy Harris. Kirk Cunningham. Acknowledgments In writing this book. They were tireless in opening up doors and making extensive resources available. Charles Sampankanpanich. Jim Shields. Danny Ficetola. Those of you who know me know that Xcelsius Dashboard Best Practices is a book of personal significance to me.

Jon Teopaco. Nicko Martadinata. Todd Brakke. Blair Wheadon. Howard Dammond. Chris McMahon. Mike Alexander. Paul Clark. Katy Zarty. Nick Tenzing. Javier Jimenez is a superb technical editor. They went above and beyond the call of duty. I have drawn heavily on my discussions and interactions with countless individuals and companies.

Takin Babaei. John Picard. Kalyan Verma. Steve Newberg. In writing this book. From the outset. Chuck Vietrogoski. The writing of a book on best practices can hardly be undertaken in a vacuum. Michelle Newcomb. Connie Sevillo. Sean Bolte. David Lopez.

Xcelsius® 2008 Dashboard Best Practices

Ryan Goodman. Gerrit Neve. Mico Yuk. Andy Brathwaite and Matt Lloyd played a critical role in opening up key technical aspects of Xcelsius. Caryn Brannen. The team from Business Objects Press is an exceptional group to work with.

I also wish to thank the following individuals in alphabetical order by first name: Andrew Bentnick. Bill Good. Denise Baker. Ashton Holt. Philip Campbell. I will carefully review your comments and share them with the author and editors who worked on the book. We Want to Hear from You!

As the reader of this book. I might not be able to reply to every message. When you write. Please note that I cannot help you with technical problems related to the topic of this book. At the cost of increased spreadsheet design complexity. Xcelsius needed to catch up to its own revolutionary ideas. Xcelsius intentionally blurs the distinction between spreadsheets and presentation-layer dashboards. After Service Pack 1 for Xcelsius solidified. Back in With early versions of Xcelsius. Most of all.

As Xcelsius moved past the drawing board. This means you have to control the data. The first lesson you are going to learn in this book is that if you really want your Xcelsius dashboard to shine. The task ahead of you is to use Xcelsius to catapult your dashboards and visualizations beyond toy demonstrations.

I developed a solution to this problem. They could be tethered by statically linking component properties to fixed cell coordinates. This opened the floodgates so that I could redesign imported spreadsheets with impunity and not have to worry about upsetting the mapping between components and spreadsheets. From time to time. Using Xcelsius is easy when you understand the ins and outs of building and designing dashboards.

Xcelsius as a product and technology has caught up with its revolutionary ideas and is ready for primetime. That is half the battle. Over the years I developed a wealth of techniques and best practices so that the data and computational side of the Xcelsius dashboards could be on par with the stunning visualizations so often associated with Xcelsius.

Back then. Xcelsius supports some new spreadsheet functions. In effect. In earlier versions of Xcelsius. I often found myself more on the bleeding edge than cutting edge of this new technology. I reworked and substantially extended those techniques for the new Xcelsius. Best practices provide a structured methodology for dealing with issues of this kind and for taking what might be inefficient or unmanageable and keeping the process sane and contained.

How can you build a dashboard to assess your competitive positioning. Locating Specific Techniques Quickly This book covers a broad range of topics in 16 chapters. The chapters are organized by subject matter rather than by best practice. To help you locate the details within the chapters. The chapters are chock full of valuable techniques. You may want to approach the text differently.

Dashboards are interactive. The data in a dashboard is generally not static and is subject to ongoing updates and revisions. There are things you can do to keep your dashboards out of hot water. How to Read This Book This book will be valuable to you whether you are new to Xcelsius or already have some experience under your belt.

For example. To complicate matters.

Xcelsius 2008 Dashboard Best Practices

To help you locate best practices. N OTE You can find the dashboard files that accompany this book on www. The Xcelsius workspace may take some getting used to. From there on. Now you can jump to pretty much any other chapter in the book. Instead of trying to retrofit a legacy Xcelsius file. Think of Chapter 3 as your first day of on-the-job training. The process of converting legacy files to Xcelsius may not be so easy.

Then you may be able to open them by using Xcelsius Xcelsius version 4. I do not view such strategies as best practices. Then read through Chapter 1. If you want. Read through that section thoroughly to learn how to set up and use those functions in a dashboard setting. As you need. If you have files built with Xcelsius 4. They may give you ideas on how to redesign some of your own. Best Practices Versus Shortcuts Some quick solutions to vexing problems cut corners and work.

Move on to Chapter 3. Make sure you go through Chapters 5 and 6. I summarize the new and revised features introduced with Xcelsius In summary. I point out where you can find more about specific dashboards or dashboard features. I also show some techniques for handling known charting problems.

This chapter is a comprehensive reference guide that covers essential spreadsheet functions. I point out in the chapter that this is not a best practice. Chapter 1. Chapter Chapter 5. In this chapter. I also list this as an item in Appendix C. I do make some exceptions. I balance this with practical techniques.

If you want to do really powerful and astounding things with Xcelsius. Chapter 3. Chapter 4. Chapter 2. What This Book Covers 5 talking about practices of this kind. It also sets the stage for building full-featured dashboards. The powerhouse behind Xcelsius is the underlying spreadsheet.

This chapter also addresses an interesting technique involving box plots. A common criticism of dashboard dials and gauges is that they consume large swaths of screen space.

Chapter 9. Part II. Chapter 7. I show a technique that allows you to share a single component. This chapter shows how to meaningfully integrate statistical techniques with Xcelsius. I cover Xcelsius themes to show how you can alter the appearance of your dashboards. Value at Risk dashboards. Chapter 8. When you discover that you can pack a lot of punch in your dashboards with the wide array of components.

This book includes three helpful appendixes. Web Connectivity components. Selector components. I spell out the essential setup needed for designing custom components. This complements Chapter 4.

Practices xcelsius pdf 2008 dashboard best

Contain components. Single Value components. Appendix B. Engage Server. Conventions Used in This Book This book uses several special elements: TIP Tips provide advice or describe a different way of accomplishing a task. Map components. N OTE Notes present extra information about a topic. Xcelsius Present. Text components. Appendix C. Trend Analyzer. It identifies valuable techniques and where to find each in the book.

Appendix A. I also run through a comprehensive list of component types. The code is wrapped to the next line and the continuation is preceded with a code-continuation arrow. Along came the PC. The Original Killer App The spreadsheet could arguably be called the killer application from the s through the mids.

In addition. All this capability was at your fingertips without requiring you to learn a stitch of programming! In short. Like an apple pie without the cinnamon. The paradigm was brilliant. Looming over this topic are two questions: Why should you use dashboards at all?

What benefits are conferred by using Xcelsius ? The subtlety of these kickers is really quite remarkable. Doing anything new and useful almost always required substantial expertise in any of a number of often-terse programming languages.

With a modicum of skills. There were a couple of kickers that really slammed the ball out of the ballpark—enough to turn the spreadsheet into a killer app. Early spreadsheet programs such as VisiCalc. You could specify formulas such as sums and averages. With a spreadsheet. Spreadsheets personified a newfound freedom that wonderfully complemented the advent of the personal computer. Until the start of the PC revolution.

Multiplan the forerunner of Excel. There were a few things that intensified the value of this instant gratification. It needed that spice to deliver on its promise and make the user want more. Before the advent of spreadsheets. The virtual paper was much larger than the screen. The ability to save a spreadsheet to a floppy disk and mail it to a colleague sewed the seeds of electronic collaboration.

For one thing. Back in those days. So unless the text explicitly states otherwise. To get the correct count. Among the many purposes spreadsheets serve. In this example. The Spreadsheet as an Open-Source Dashboard One of the remarkable features of a spreadsheet is its ability to present numeric data in graphical form.

Column C shows the count of the numbers in the gray region that are greater than the value in column D.

Xcelsius Dashboard Best Practices [Book]

Getting this rather tidy-looking histogram to work requires a bit of elbow grease. Xcelsius If you carefully examine all the numbers in the gray region. Adding another 6 results in 38 the value in cell D N OTE Although there are numerous spreadsheet programs.

As Figure 1. The numbers in column D are all separated by 6 the value in cell B4. As a result. The only drivers that forced spreadsheet technology to change were the continual improvements in computing technology—those allowing for more disk space. The spreadsheet has proven to be a very successful Swiss Army knife.

Adding 6 to 26 results in 32 the value in cell D9. During the s. Figure 1. It may not be a dashboard connected to a practical application. I can assure you that all the steps are purposeful. The problem is that spreadsheets used to build dashboards are effectively open-source dashboards. Given the choice.

The key. On the negative side. Unless you are armed with advanced knowledge. The chances are that the CEO of your company will not respond well to having all the formulas exposed. Is your head spinning? While many of the steps may seem arbitrary.

Excel has plenty of graphical features. It provides spreadsheet functions and formulas galore. The notion of open-source software can connote different things. You could have formulas that use some kind of lookup to retrieve values from a table.

And that CEO will certainly not be happy if he or she accidentally clobbers a complicated formula. It would surely spell disaster if your dashboard based on an open-source spreadsheet got into the wrong hands. Giving away a sliver of your analyzed data is one thing.

A spreadsheet loaded with complicated formulas and conditional logic is just teeming with proprietary knowledge in its purest form. This spreadsheet with the histogram in some ways qualifies as a dashboard. If you start changing the numbers in the gray region. Even if users of a deployed dashboard respect the spreadsheet enough to avoid tinkering with its structure.

If you are preparing a dashboard. This is a contrived example of a most rudimentary dashboard in a spreadsheet. You might ask them the following questions: Would you like the ability to retain the spreadsheet formulas in the imported file so that the spreadsheet continues to work inside the dashboard? Would you like to overlay the internal spreadsheet with a visual interface or canvas composed of fully interactive components.

Excel does provide a basis for safeguarding deployed spreadsheets. Would you like to be able to map these components on the canvas so that they interact with the underlying spreadsheet? Would you like the ability to invent your own custom components if none of the available visual components suits your needs? As you refine your dashboard. The good news is that Xcelsius makes this possible.

If you could export the dashboard to one of these alternative formats. As you might guess. Would you like to be able to create a dashboard that you can run from your website by simply exporting it as a file? Would you like to be able to export your dashboard to alternative formats. There are other Microsoft options. What features do you think you would choose to incorporate? It sure would be nice to have some of the computational features of spreadsheets without the drawbacks cited in the past few pages.

As product development director in a software company. PDF file. So without further ado. A Walk-Through of Xcelsius The purpose of this chapter is to familiarize you with some of the features of Xcelsius That is not a typo. Chances are.

This scenario—being in charge of a software development group on a mission to develop a software application to meet these requirements—sounds like a tall order.

It allows your mouse and keyboard to work correctly with Xcelsius Would you like to be able to endow your dashboard with the ability to send and receive data to and from remote data sources. Besides Flash Player. VMWare Fusion. Getting Started with Xcelsius To build dashboards using Xcelsius. The fractional piece is Flash Player. In terms of an operating system. I highly recommend that you install the VMWare Tools onto the guest operating system. Notice that the top half of the screen is principally occupied by a blank canvas and the bottom half is occupied by what appears to be an Excel spreadsheet.

During the Xcelsius installation. When you create and export your dashboard. The trialware versions of Excel and Xcelsius have a timeout period. If you are installing both trialware packages. The Quick Start pane is kind of like training wheels you might have with your first bicycle. If you encounter difficulties. If the Quick Start pane is closed. The customized features of your Excel environment. This way. If you are installing the trial version of Excel.

When Excel is installed and working. The first time you start using Xcelsius. Xcelsius needs Excel. There are different editions of Xcelsius which are outlined in Appendix B. If all goes well. Right now. Xcelsius looks to your Internet Explorer configuration to determine where Flash is installed.

If at a later point you need to install an updated version of Flash Player for your browser. You can work with either Excel or Excel The environment where you create dashboards is known as the Xcelsius workspace. As shown in Figure 1. The Components pane appears see Figure 1. From Excel to Xcelsius 19 Figure 1.

When you release the mouse button. Using the Accordion view for viewing and depositing components onto the canvas has a number of advantages. If you are following along on your computer and have Xcelsius running. When you drag the component. To place a component onto the canvas.

Registration

N OTE You can resize most of the components you place on the canvas. Accordion view as shown on the left side of Figure 1. To find this slider. Canvas Only. TIP When you are designing dashboards. My Workspace. The spreadsheet formulas in your virtual workbook cannot reference any remote workbooks or external data sources. Xcelsius can display many things at one time.

Quick Views. To view the virtual spreadsheet by itself. For all intents and purposes. The behavior in the virtual spreadsheet is very much the same as it is when you run Excel on its own. If you switch to List view. Is the virtual spreadsheet real? To convince yourself. Without a clear set of marching orders of where to find the dashboard data and how to interact with it.

List view may prove more practical to use than Accordion view. It is. At any time. There are some differences between the virtual spreadsheet and your standalone Excel environment: The key to invigorating your dashboard and bringing the components to life is to tap into a spreadsheet.

Your workbook can have as many worksheets as you need. Spreadsheet Only. Sometimes the screen can get too crowded. The obvious difference with Xcelsius is that Excel is running live inside the Xcelsius environment. In the spreadsheet portion of your Xcelsius workspace. Xcelsius gives you the ability to exclude everything but the portion of the dashboard you want to concentrate on.

The other half is the virtual spreadsheet. To see how this works. Another is to right-click it. One way is to double-click the component. It contains a variety of attributes. By communicating. Your VBA code and macros will not work in your deployed Xcelsius dashboards. The left vertical panel is the Properties panel. Not every Excel function is supported or fully supported in Xcelsius The concept is simple: The visual components in your dashboard need to be able to communicate with the underlying spreadsheet.

I mean that the visual components. Xcelsius supports about Excel functions. That macro could run in the virtual spreadsheet at design time. Many of the functions you use such as SUM. Properties to open up the Properties panel. One of the halves is the canvas. Because Xcelsius supports remote connectivity through alternative means. Right-click the Horizontal Slider component on the dashboard to open up its Properties panel see Figure 1. TIP There are a number of ways to open the Properties panel of a component.

In Figure 1. From Excel to Xcelsius 23 Figure 1. The Alerts tab works much like conditional formatting in Excel. Binding the Attributes of Components to the Underlying Spreadsheet The Properties panel exposes the attributes of your components. There will always be a General tab in the Properties panel for any single selected component on the canvas. To the immediate right of the Data text box is a small cell selector box with a red pointer.

The Behavior tab allows you to set things such as when to make a particular component visible or invisible and to tell the component how to behave. You click the desired tab to display and set the appropriate attributes.

With this slider. Immediately underneath the title bar of the Properties panel. This gives lots of flexibility as you can pick pretty much any range you want. You can change these values by simply typing in numbers of your choosing in the corresponding attribute input fields for the components. Depending on the kind of component. If you click this box. With the Appearance tab. You can simply click the desired component. If some of the reported figures are dangerously low.

Say that you are displaying the production efficiency of various manufacturing plants. From Excel to Xcelsius 25 back to the component. If you click the Gauge component and map its data field to cell B4 of the spreadsheet.

You can then click the OK button on the Select a Range dialog box to complete the mapping. Typing in a cell range could be error prone. Click the one labeled Preview.

Sometimes you might want to map a single spreadsheet cell. Running along the top of the Xcelsius workspace are a bunch of toolbar icons. In this particular case. Now comes the moment of gratification. Your computer might pop up a brief message. You can just click the cell you want. The sliders and gauges all work for your colleague as they do on your computer.

Your colleague only needs to have his or her PowerPoint software and be Flash enabled. To get back to your workspace. Such files are called XLF files because that is the suffix used in their filenames.

You can email this PowerPoint presentation to a colleague. When he or she opens the file and presses the F5 key for the slide show. After you click the OK button in the dialog box. There is one more step you need to take to complete the process of dashboard production: You need to create a deployable dashboard. In the world of Xcelsius. A dialog box appears. PowerPoint Slide.

When you export an Xcelsius dashboard. Not only does it move in sync. You have the option of exporting your dashboard into a number of different file formats. Your dashboard appears as a PowerPoint slide. The steps for exporting a dashboard are ridiculously simple.

From the application menu. If you can view Flashbased videos on YouTube or see Flash animations in your browser as you surf the web. As you move the marker along the slider. Click the Text subtab and highlight Value see Figure 1. Before resting on your laurels. It is often a good idea to create a legend in your spreadsheet to say what the different colors represent input from the dashboard, calculations in the spreadsheet, lookups, and dynamic data — that way, you can decide on a color scheme that makes sense for your organization or team.

Bright Yellow. Light Green. Dynamic Visibility. Table 1: To make your spreadsheet easier to understand, it is a good idea to lay out your data in a logical fashion. For example, group related items together — again using colors, labels, and borders.

See Figure 1. One of the features introduced in Xcelsius is the embedded Microsoft Excel spreadsheet at design time. The embedded spreadsheet means you can insert or remove rows or columns, and the components track the ranges they are bound to.

See Figure 2. If you insert or remove rows in an external spreadsheet and import it, the components cannot track range changes.

Figure 2: Often you bind data from your spreadsheet into components, to make it easier to select the data you want and to minimize the amount of scrolling you have to do.

It is a good idea to place frequently used or common logic or data at the top-left of the tab in your spreadsheet.

See Figure 3. Figure 3: If you find that you have to keep scrolling your spreadsheet tab to see your logic or data, you may want to consider using multiple tabs or worksheets instead. See Figure 4. Figure 4: Using Multiple Tabs in the Spreadsheet. Remove yourself from the data you want to visualize. Create a rough drawing on paper away from your computer. This can be useful to get a general idea for the visualization you want to create and also to use to sign off the basic design of your visualization.

Dashboards does not support using spreadsheets that have links to other spreadsheets or have macros in them. So it is a good idea to start with the empty spreadsheet that is embedded within the designer. Using the empty spreadsheet will also reduce the risk that you use Microsoft Excel functions or plug-ins that are not suppoorted.

The more data or logic you put into your spreadsheet, the larger your generated SWF will be and the longer it will take to open. Also, the more logic and nested functions and cell references you put in your spreadsheet, the longer it can take when the data changes, so the cell values and related cells values have to be recalculated.

If you have any data or logic that is not used within your visualization, get rid of it from your spreadsheet. If you have functions for values that do not change so are not dynamic or used by what-if scenarios , then to make sure your visualization is more efficient, convert the data to fixed hard-coded values using Copy and Paste Special as Values in the spreadsheet. Using the design you created on paper earlier, mock up your visualization using components.

At this point, there is no need to add data to your spreadsheet; you are just creating the basic visual layout for your visualization. However, it is a good idea to share your design at this point as a second stage of feedback before you start adding more complexity. Add in some dummy data to your spreadsheet — just enough so that you can test your components and interactivity. Again, share your design to get feedback before you add more complexity.

Often you want to re-use the real estate within your dashboard by hiding and showing components based on user interactions or data changes. You can control when a component is shown or hidden by using Dynamic Visibility in the Behavior tab. When the value in the Dynamic Visibility Key cell matches the value in the Status cell the component will be shown, otherwise it is hidden.

Test the interactivity of hiding and showing components, and again, share your design to gather feedback. Now it is time to replace your dummy data with actual data or data to be fed from outside of your dashboard. If the data in your dashboard is of a secure nature, it is a good idea to remove the dummy data from your spreadsheet but leave the cells and cell coloring as they were.

Thus, before the data is retrieved and displayed, there is no data to see until the end user has successfully authenticated. Make sure you test your SWF in preview mode and also wherever you will deploy your visualization. Because the Dashboards designer is an application, we choose not to apply the security restrictions — so you can query data from wherever you need to at design time or preview time.

If you see an error number refer to the list of Adobe runtime errors at http: