Business Intelligence(BI) 7.3
The functions of BI within an organization include research, metrics, and regulations governing the legality of data collection. SAP Business Intelligence is a broad category of applications and technologies for gathering, storing, analyzing, and accessing data. SAP BI training covers a variety of subjects within SAP’s BI module and includes topics such as Data warehousing, Data Modeling, Reporting and Analysis, Data Extraction, Performance Tuning.
SAP Business Objects business intelligence (BI) can help organizations to achieve noteworthy results by allowing anyone with self service access to relevant information.
Upon completion of this course learner will able to understand Data Extraction, Modeling and layout of reports, creating simple and complex query definitions with the BEx Query Designer and BEx Web Analyzer, BEx Report Designer, BI integrated planning, BI Platform, etc.
Course Contents:
| Topics | Topics |
| Data Modeling | Metadata and Document Management |
| Info Objects: CharacteristicsInfo Objects: Key FiguresData store objects
Infocubes Infosets Multiproviders |
Installing BI content |
| Defining Extraction | Defining Transformations |
| Maintaining Data sourcesCreating Data sources for File source systems | Creating transformations |
| Defining Data distribution | Defining the data flow |
| Using the data mart interfaceCreating open hub destinations | Creating data transfer processesCreating process chains |
| Scheduling and Monitoring | Performance optimization |
| Checking process chain runsMonitor for extraction processes and data transfer processes | Creating the first aggregate for an Info CubeUsing the BIA index maintenance wizard |
| User management | |
| Setting up standard authorizationsDefining analysis authorizations | |
| Business Explorer | |
| BEx Query Designer | Web Application Designer |
| Queries: New queries, Restricting Characteristics, Formulas and Exception CellsQuery Design: Defining Exceptions, Conditions, Restricted and Calculated Key FiguresVariables: The Variable Wizard, Variable Types and Processing Types, query Properties
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures Structures: Creating Re-usable structures Functions on BW Server: Copying queries between Cubes, Deleting Query Elements |
WAD: Functions of WAD, Web Items Window, Template Window, Properties WindowWeb Applications: Creating Web Applications, Settings, Style sheets, Symbols and PropertiesDesign: Designing the Layout of Web Templates, working with Library for Web Items
Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes |
| Activities | BI Platform |
| BEx AnalyzerBEx Web Application DesignerBEx Report Designer | Information BroadcastingFunctions of the Broadcaster: Pre-calculating and Exporting into Enterprise PortalUser Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options |
| OLAP | Delta BI 7.0 to B1 7.3 |
| OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTPOLAP Functions: Aggregation, Currency Translation, Report-to-Report InterfaceMetaData Repository: Searching for MetaData | How to create and copy Graphical Data Flows.Introduction of Semantic Partitioned Objects and Hybrid Providers.New Analysis Process Designer capabilities with Analytic Indexes and Composite Providers.
Advanced BW Accelerator features, including the calculation engine, DataStore Object data indexing and MultiProvider handling. Enhanced Near-Line storage capabilities. More robust and detailed Process Chain monitoring tools. Additional features to improve performance for Master Data, DataStore Objects, InfoCube loads and Data Transfer Processes. New Technical Content for more detailed statistics on database usage and query runtime. New Administration Cockpit features, including a new Dashboard Design user inter |
| Hot Bonus Topics | Performance in depth |
| Integrated PlanningPlannig QueryPlanning Functions
Planning Functions Customizing Real Time Cube Aggregation Level Planning Sequence Integrated Planning Performance Business Object (BO) Introduction |
Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-DependentBW Statistics: Query Analysis Tools, Performance TablesReporting Performance: Effective query design,
Line-Item, Compression, Partitioning Aggregates: Creating Aggregates, Finding effective aggregates Data Load Performance: Parallelism, Impact of Aggregates Partitioning: Logical Partitioning, Table Partitioning |
Advanced Topic:
Overview of BO, BODS, Xcelcius and HANA
Foundation of BODS
Foundation of Xcelcius
Foundation of HANA
……………………………………….
SAP Training, SAP Training Toronto, SAP Training Mississauga
