Description This course provides step-by-step instructions for creating ad-hoc queries in Oracle Business Intelligence Answers and incorporating them into Interactive Dashboards, which compose business intelligence applications.
Learn to build a simple Oracle BI Interactive Dashboard starting with basic requests created in Answers, then add more complexity as the course progresses, including pivot tables, charts, gauges, prompts, embedded content, navigation links, and Oracle BI Publisher reports.
Use Oracle BI Delivers to send real-time, personalized alerts to Interactive Dashboards for subscribed users. In addition to building Interactive Dashboards, learn to configure and maintain them and how to customize their user interface using cascading style sheets, dashboard styles, and XML message files.
Use Oracle BI Publisher to build reports based on Answers requests as well as Oracle BI subject areas, and use Oracle BI for Microsoft Office to integrate Oracle BI data and views in Microsoft Office presentations and spreadsheets.
Finally, explore recommended design principles and best practices for presenting information in Interactive Dashboards. Oracle BI Publisher (formerly known as XML Publisher) is a revolutionary reporting and document output management solution from Oracle.
In this course participants gain expertise with Oracle BI Publisher 10g R3 (10.1.3.3) by gaining a foundation in the fundamentals, and underlying standards.
By the end of the course, attendees will be able to create reports based on various data sources such as Oracle Database, Web Services, RSS feeds, and Files.
Oracle BI Publisher can be used as a stand-alone reporting product or integrated with the Oracle Business Intelligence Suite Enterprise Edition, and also with Oracle BI Discoverer.
So, participants will also learn about these integrations, and be able to create BI Publisher reports based on Oracle BI Server subject area, and Oracle BI Answers.
This course also teaches how to install BI Publisher Desktop (an MS-Word add-in to create report templates), how to create and publish multiple templates for the BI Publisher reports.
Students will also perform various administrative tasks such as configuring the scheduler, configuring report delivery media, and setting up Excel analyzer.
This course also covers advanced features of BI Publisher such as creating reports with hyperlinks, scheduling and managing scheduled reports, bursting the reports, using online and Excel analyzers to analyze the data in BI Publisher reports, and creating reports from data templates.
Hands-on exercises reinforce concepts taught in class. Learn To: Create and use a PDF template Set up, configure, and use Oracle BI Publisher Enterprise server Build queries in Oracle BI Answers Create and modify Oracle BI Interactive Dashboards Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts Create and use an RTF template