Business Intelligence in Oracle APEX: Transition of BI from IT to End Users - Paperback

by Riaz Ahmed (Author)

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:

• Put the company data at the fingertips of end users with the help of a business intelligence application so that they could get insight from this data themselves anytime, anywhere.
• In contrast to the traditional sophisticated business intelligence solutions that everyone in John's organization is not able to run, the self-serving business intelligence application should be simple and user-friendly that a user with no technical skills could also use easily.

The flexible business intelligence application John is planning to develop will have two broad features:

1. Analyses creation - This includes the selection of columns from multiple tables, application of filters and aggregate functions, and generation of dynamic SQL queries through a user-friendly interface.
2. Visualization - Dig intelligence from data mine and visualize the analyses results on-the-fly via simple tables, multi-dimensional pivot tables, different types of charts, and master/detail maps.

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.

Author Biography

Riaz Ahmed is an IT professional with more than 25 years of experience. He started his career in early 1990's as a programmer and has been employed in a wide variety of information technology positions, including analyst programmer, system analyst, project manager, data architect, database designer and senior database administrator. Currently, he is working as the head of IT for a group of companies. His core areas of interest include web-based development technologies, business intelligence, and databases. Riaz possesses extensive experience in database design and development. Besides all versions of Oracle, he has worked intensively in almost all the major RDBMSs on the market today. During his career, he designed and implemented numerous databases for a wide range of applications, including ERP.