There's this analogy in my field of work that says "Dashboards are like sausages, you don't want to know how they're made but are very good to look at".
In the past month after training, I've been developing SAP Dashboards (Formerly Xcelsius) and it can be a daunting task. Here are the steps of how to solve complex problems when building a real enterprise dashboard with real data sets.
1) Draw out your solution on a piece of paper
2) Import your raw data from QRY's/QaaWS/etc
3) Start to normalize your raw data into data sets so that it can be easily linked to other components
4) Write out your formulas so that you don't get stuck changing hundreds of cells because of a logic error
5) Create your design after you've planned all of your details :-)
6) Put the finishing touches on it
Creating dashboards can be an easy task if planned out accordingly. I spent 30 hrs on my first one but only 10 hrs on the rest of them because I was developing like a monkey at first lol.
No comments:
Post a Comment