When I was 19 years-old, I decided I wanted to learn car mechanics. I could have gone to a training college but I wanted to “learn by doing” and from a real professional so I walked into a car service company that specialized in Rolls Royce’s and Bentley’s. I figured ...
Read More »To Cache or not to Cache – Boosting performance in Xcelsius Tech Tip
I was recently asked this question on how best to handle a 13 month dataset when in the dashboard the goal is to only display monthly detail and summary data. This is a good question and in my opinion worth sharing here because it is dealing with boosting Xcelsius backend ...
Read More »Keeping IT Executives Current with BI Technology
I recently interviewed a college student who told me that his ambition was to be an IT Director. He was completing a college program in computer security and had worked as an intern doing network support in the IT department at a large organization. I did not want to burst ...
Read More »Inspiring Business Intelligence
A few weeks ago I was participating in a career event at a State University where undergraduate students from both Business and I.T. schools were looking for internships with local businesses. As they stopped by the InfoSol table, the number one question was “What do we do?” This gave me ...
Read More »Leading Zeros in Xcelsius – Tech Tip
What can I do if Xcelsius is chopping off the leading zero’s in my order numbers? This question comes up often when I’m teaching an Xcelsius training class. Often enough that I’ve decided to discuss the solution here in a tech tip on our blog. This scenario can happen with different data ...
Read More »Bursting Xcelsius Dashboards
A company recently approached us with an interesting requirement concerning how to more efficiently distribute information about mobile phone usage to each of their hundreds of customers. The method they were currently using was manual and labor intensive as they were pulling information into Excel spreadsheets, creating graphs and then ...
Read More »Xcelsius Dashboards – Best Practices – Data Layout
In addition to the Xcelsius Dashboard Maintenance – Best Practices – Using Labels in Excel I wanted to share other important aspects of making Xcelsius dashboards easy to maintain and for other developers to understand. One such practice is having some kind of conformity in your approach to how you lay out ...
Read More »Xcelsius Dashboard Maintenance – Best Practices – Using Labels in Excel
In this post I will share with you a sample of what I consider to be one of many “best practices” to help in the ongoing maintenance of Xcelsius dashboards; Using labels in your Excel Spreadheet. Some of the content in this post is extracted from the Excel for Xcelsius ...
Read More »