Today is the most tiring day for John who is the only Oracle APEX developer in his company. He is exhausted because he answered several analytic queries raised by different departments of his organization. Addressing such queries from colleagues has become a daily routine for John. And, there is not a single day when he is not privileged to see Karen - the sales manager. As expected, she hops into John's office, and as usual, with a list of her simple but time-consuming queries.
Tired John is seriously considering developing a solution to lighten his load. The solution will serve the following objectives:
The flexible business intelligence application John is planning to develop will have two broad features:
John will develop this self-service app single-handedly, and will also provide some simple hands-on training to his colleagues on the development side to make them self-reliant. Let's see how John undertakes this unique project in Oracle Application Express that will act as the first stepping-stone toward business intelligence.