To be very honest with you, no one would be able to assist you with this question, reason being because first, they don't have access to your system. Second, The requirement would be organization specific i.e. a soln that fits one organization might not fit the another.
The only thing that I can ask you to do is go for some training course, or if you can take out time to go through the below address. It gives you a complete scenario of BI. A complete modelling scenario. Its a PDF that has almost a 3600 pages, Go through the topics carefully and may be you might be able to help yourself in here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.