<ul> <li>What is SAP BO?</li> <li>View, analyze and sort BI data using BI</li> <li>Components of BO <ul> <li>Crystal reports</li> <li>Web intelligence tool</li> <li>Ad hoc queries</li> </ul> </li> </ul>

<ul> <li>Introduction to data warehousing</li> <li>Deployment in real world scenarios</li> <li>Features of data warehousing</li> <li>Data marts and tables</li> <li>Star schema and multiple star schema</li> </ul>

<ul> <li>Overview of database</li> <li>Characteristics of database</li> <li>DCL, DML, DDL, TCL</li> <li>Data types of tables structuring</li> <li>Set Operators</li> <li>Join types and conditions</li> <li>Group By</li> <li>Having and Where conditions</li> <li>Numeric Functions, Character Functions, Date Functions, Aggregate Functions</li> </ul>

<ul> <li>FDD features</li> <li>BRD business requirements</li> <li>Technical design</li> <li>Project plan</li> <li>Execution</li> <li>Preparation of unit test case</li> <li>Deployment check list</li> </ul>

<ul> <li>Backend non SAP apps</li> <li>Comprehension of SAP BW and BI</li> <li>HANA expertise</li> <li>ODBC connections</li> </ul>

<ul> <li>Universe designer tool <ul> <li>Personal connection</li> <li>Personal connection</li> <li>Linked universe</li> <li>Secured connection</li> </ul> </li> <li>Information Designer tool <ul> <li>Local connection</li> <li>Secured connection</li> <li>Data foundation connection, parameters, etc</li> <li>Business layer, parameters, etc</li> </ul> </li> <li>Conditions</li> <li>Developing objects and types</li> <li>Managing security</li> <li>Trap issues and derived tables</li> <li>Hiding and un-hiding objects</li> <li>Table creation</li> <li>Usage of @functions &ndash; @ Prompts</li> <li>Usage of @Where</li> <li>Usage of @Select</li> <li>Usage of @Aggregate Awareness</li> <li>Data integrity &amp; Business layer</li> <li>Single data source and multiple data sources</li> <li>Performance tuning techniques</li> <li>Business Intelligence Consumer Services (BICS)</li> </ul>

<ul> <li>Adhoc Reports <ul> <li>Overview of web reporting</li> <li>Creation Query &amp; Report, view, modifying report</li> <li>Filters and other operators</li> <li>Section vs break</li> <li>Alerter, sorting and ranking</li> <li>Merged queries and dimensions</li> <li>Types of charts and usage</li> <li>Special functions</li> <li>Transforming horizontal and vertical cross tabs into charts</li> <li>Hyperlinking</li> <li>Input controls</li> </ul> </li> <li>Crystal reports <ul> <li>What is Crystal reports?</li> <li>Repository explorer and database expert</li> <li>Report Templates and inbuilt functionalities</li> <li>SAP platform interaction</li> <li>RDBMS interaction</li> <li>MS access interaction</li> <li>Standard, blank and cross tab report</li> <li>Different data source connections</li> <li>Maintenance and scheduling</li> <li>Development of CR with and without universe</li> <li>Working with charts, dashboard and sub-reports</li> <li>Groups and calculations</li> </ul> </li> <li>Web Intelligence Report <ul> <li>Introduction of web reporting</li> <li>Charts, types of charts and various usage</li> <li>Info Providers and Data Providers</li> <li>Working with special Functions</li> <li>Formation of reporting</li> <li>Converting Horizontal, Vertical, Cross Tabs into Charts</li> <li>Developing query&rsquo;s and Drilling Functionalities</li> <li>Viewing and Modifying a report Purging of objects</li> <li>Query Filters &amp; various operators</li> <li>Export Options (PDF, excel, CSV etc.,)</li> <li>Query Prompts Document Properties/Formatting</li> <li>Sections/ Breaks</li> <li>Input Controls</li> <li>Report Level Variables</li> <li>Difference between Section &amp; Break</li> <li>Hyper Linking Functionalities</li> <li>Alerter</li> <li>Usage of Web Intelligence Rich Client Application</li> <li>Ranking, Scheduling of Webi Report and Sorting</li> <li>Folding and Unfolding of Reports</li> <li>Merged Dimensions</li> <li>Combined Queries</li> <li>Canned Reports</li> </ul> </li> </ul>

<ul> <li>Overview of dashboards</li> <li>Features of types of dashboards</li> <li>Information providers</li> <li>Creating dashboard</li> <li>Static and dynamic dashboard</li> <li>Work with dual axis dashboard, data by range, series, Calender and bar chart dashboards</li> <li>Import and export of data</li> <li>Data management</li> <li>Different layers (data, canvas, components, properties)</li> <li>Query builder</li> <li>QAAWS connectivity</li> </ul>

<ul> <li>Creation of web intelligence reports</li> <li>Scheduling crystal and webi reports</li> <li>Transferring crystal and webi repors</li> <li>Data storage</li> <li>Folder structuring</li> </ul>

<ul> <li>Universe level tuning</li> <li>Report level tuning</li> <li>Database level tuning</li> <li>Query optimization methods</li> </ul>

<ul> <li>SAP Lumira</li> <li>Widgets</li> <li>BO Explorer</li> <li>Query as a web service</li> </ul>

<ul> <li>Real-time error handling methods</li> <li>Different scenarios</li> <li>Troubleshooting</li> </ul>

<ul> <li>Overview of project life cycle</li> <li>Project domain</li> <li>Template and workflow design</li> <li>Requirement of report templates</li> </ul>