Over the past three weeks several Xcelcius Gurus have been exposing several students to the world of dashboarding and more importantly Xcelcius. Briefly in the first session, we were introduced to dashboarding, and informed about the basic functionalities of various components, such as column charts, selectors and other charts. This first session was lead by guru Tammy Powlas.
The second session was led by guru Kumar Subramanian and it was entitled ‘What If Analysis.’ Within the session we learnt how to adjust various speadsheets using formulas, and the various components within Xcelcius that interact well with the ‘What If Senario’ and with the spreadsheet.
As summarized by guru Tammy,
‘He suggested when building your dashboard, you debug as you go. For instance, hard code the figures in the target area to ensure your values are correctly being calculated. You should display the spreadsheet as a component table when building the dashboard. He dragged a spreadsheet table component to the canvas.
Some other quick tips:
1) Give components name as you are building the model
2) Send the background to the back
3) If you have several components to display on your canvas copy them. They first appear hidden but you have to drag them.
4) For the divide by zero display issue put in a conditional IF statement in the spreadsheet, and then the divide by zero is fixed’
To conclude, I would like to invite all post secondary students in North America to participate in the Dashboading Contest. It is a great way for you to display your skills, creative, and your ability to transform a complex, real world problem into a dashboard. You will be judged on usefulness, creativity and desirableness. I have attached the link to the teams and conditions on to this post. Also check out what you can win!
Lastly, I would like to thank the entire team (Kirby, Xcelcius Gurus, and our Mentors) who have been working with all of us as we continue to learn about the world of Dashboarding and how it can make a vast difference in many situations, business decisions and various industries.