Overview

A warm welcome to the SAP BW course by Uplatz.SAP BW (Business Warehouse) is an end-to-end data warehousing solution from SAP with multiple features and functionality. The emerging requirements for storage and use of huge and important data has resulted in great demand for certified SAP BW professionals.SAP BW is a data warehouse tool/application. In simple terms, it integrates data from different sources, transforms and consolidates, cleanse and stores data as well. It also includes data modeling, administration and staging area. The content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance because it's pre-configured with intelligence about a company's business process, providing a faster return on information. SAP BW remains open to the different source systems and is known for its ease of introduction and maintenance. SAP Netweaver Business Warehouse (SAP NetWeaver BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing solution produced by SAP AG. It was originally named SAP BIW (Business Information Warehouse), then abbreviated to SAP BW, but is now known as "SAP BI" at the end user level. In contrast, "BW" is still used to describe the underlying Data Warehouse Area and Accelerator components. In simple words, SAP BW/BI is leading data warehousing and reporting tool which helps transforms raw data into information and business insights. SAP BW supports better business decision-making and can be called a decision support system (DSS). Though the term SAP business intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, SAP BW (Business Warehouse) uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors.Organizations have different kinds of data such as finance, Human resource, customer, supplier data etc., which can be stored on different kinds of storage units such as DBMS, Excel sheets, SAP R/3 systems etc. Even the company's internal data is often distributed across many different systems and is not particularly well formatted. A Data Warehouse can help to organize the data. It brings together heterogeneous Data Sources which are mostly and differing in their details. Using BI Tools one can derive meaningful reports.The demand from end user companies needing expertise in the integration of ERP data into corporate data warehouses is growing exponentially. Thus has resulted in great opportunities for certified SAP BW professionals in defining their career path.Uplatz provides this end-to-end training on SAP BW module. This training will put you on the path to becoming a highly proficient SAP BI/BW Analyst. Through this SAP BW course, you will master data modelling, Data Warehousing, Data Extraction, Business Explorer and Metadata Repository, Multidimensional Modeling, Data Flow in BW, Extraction of data from R/3 system, and more. This training program will help you achieve SAP BW Certification.In SAP BW course, you will be learning the core as well as advanced concepts of SAP BW like Data Extractions, Reporting, Hybrid Providers and Data Transfer Process.Course ObjectivesGain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscapeExpertise skills in Modelling concepts like DSO, DTP, and Multi-dimensional modelAttain knowledge in basic concepts of Data ExtractionsUnderstand basics and advanced concepts of ReportingEnhance their knowledge in new features of SAP BW like Hybrid Provider, Open Hub Services, etc.Gain ability to perform Web Reporting using new Web Application DesignerBe able to design and implement an end to end BW projectUnderstand basic administration within SAP BWUnderstand data flow within BWSAP BW - course syllabusI. MODELINGLesson 1: The Multi-dimensional Model in SAP BIThe SAP BW Star Schema ConceptData warehousing Workbench (DWB)PREVIEWInfo ObjectsInfo CubesLesson 2: Data Extraction and Data Flow within SAP BI 7.3 NW 2004S3.x DataflowOverview of BI 7.3 DataflowComparison of 3.x and BI 7.3 Data flowsLoading Master Data (Attributes, Texts, Hierarchies)Loading Transaction DataLesson 3: New Data source Concept of BI 7.3Overview of new DatasourceEmulation of Data source in BI 7.3Datasource Lifecycle with In BI 7.3 NW 2004SMigration of 3.x data source to BI 7.3 data sourceLesson 4: Transformation in BI 7.3(ETL)In depth coverage of TransformationRoutines in Transformations (Start routine, End routine, Expert routine, transformation routine) with different Real Time examplesTransformation GroupsUnit and currency ConversionsLesson 5: DTP (Data Transfer Process)Overview of DTPSTrouble shooting techniques in DTPSDebugging ABAP routines Using DTPSLesson 6: UPGRADING DATAFLOWS FROM 3.X TO BI 7.3Lesson 7: Business ContentBusiness Content (BCT)Lesson 8: Administration of InfoCubes and AggregatesManaging Basic CubesAggregatesBI AcceleratorsLesson 9: DSO (DATA STORE OBJECTS)DTP and its role in loading data to InfoCube in Extraction modeReal-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubesLesson 10: SLT Configuration, MultiProviders and ExtractionsSteps for performing SLT ConfigurationData Store Objects conceptLesson 11: Virtual Cubes and Multi ProvidersVirtual CubesMulti ProvidersII. DATA MANAGEMENTLesson 1: Overview of ECC6.0 ExtractionsTypes of ECC extractionsLesson 2: Generic ExtractionsGeneric Extraction usingDatabase TableViewClassical Info setsFunctional ModuleLesson 3: Business Content ExtractionsOverview of Business Content ExtractionsExamples from Financial, Logistics, HRMS modulesLesson 4: CO-PA Extractions (COST PROFITABLE ANALYSIS)Lesson 5: LO-COCK PIT Extractions (LOGISTICS)Lesson 6: FI-SL Extractions (Financial special purpose ledger)SAP CRM extractionsMarketing ExtractionsCRM SALES ExtractionsCRM SERVICE Extractions (CRM Extractions are Very High in demand)Lesson 7: Delta ManagementBusiness Content (BCT)Lesson 8: Extracting Master Data from CC (Attributes, Text, Hierarchies)Managing Basic CubesAggregatesBI AcceleratorsLesson 9: Datasource EnhancementDTP and its role in loading data to InfoCube in Extraction modeReal-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubesLesson 10: Process Chains in Detail covering all process TypesSteps for performing SLT ConfigurationData Store Objects conceptLesson 11: Virtual Cubes and Multi ProvidersReal time examples on process Chains (Meta Chains)Multi ProvidersIII. REPORTINGLesson 1: Introduction to BI Enterprise ReportingThe SAP BI OverviewLesson 2: Navigating in ReportsLesson 3: First Steps in Query DesignerQuery DesignerInfo providers in query DesignerLesson 4: Key FiguresRestricted Key FiguresCalculated Key FiguresProperties of Key FiguresStructures and cellsLesson 5: CharacteristicsProperties and Attributes of CharacteristicsIntegrating attributes and hierarchies in reportsLesson 6: AttributesCharacteristic VariablesHierarchy variablesHierarchy Node variablesFormula VariablesText variablesVariable Processing typesLesson 7: Exceptions and ConditionsExceptionsConditionsLesson 8: RRI (report to report interface)Lesson 9: Bex AnalyzerLesson 10: Bex Web AnalyzerLesson 11: Overview of Information BroadcasterLesson 12: Web Reporting using new Web Application DesignerIn depth of Web reporting using New Web Application DesignerDetail Coverage of Dash Board Reports and each and every Web item of new WADDetailed-level TopicsIntroduction to the SAP Business WarehouseImportance of BI ContentThe impact of SAP HANA on BWLoading ECC data into BWInfoProvider types and usesUnderstand the BW Transport and Migration ProcessImportant Transaction Codes in BWCreate Source Systems and DataSourcesNavigating the Data Warehousing Workbench (RSA1)Understand OLTP vs OLAPDescribing Data Warehouse ArchitectureData Modeling in SAP BWCreate Key Figure InfoObjectsCreate Unit InfoObjectsCreate Characteristic InfoObjectsCreate InfoObject CatalogsCreate InfoAreasCreate DataStore Objects (DSOs)Create InfoCubesLearn SAP BW Table StructuresFact tablesDimension tablesLine-Item DimensionsSID tablesUnderstand how Master data is sharedDSO tables (active, new data, change log)PSA tablesLoad Master Data into BWLoad Transactional Data into BW (DSO and Cube)Describe the Extended Star Schema of an InfoCubeDSO activationTransform your dataAssign an InfoObject to be an InfoProviderModeling a Master Data FlowLearn various Data FlowsCreate InfoPackages and Data Transfer Processes (DTP)Learn to Optimize Query Performance (Transaction RSRT)Monitor BW System Performance (SM37 / SM51 / SM66)Understand AggregatesLearn about the Business Warehouse Accelerator (BWA)In-memory data accelerationBW Administration and MonitoringExplore the differences between Delta and Full DTP loadsCreate Process ChainsManaging your InfoCubes and DataStore ObjectsAdministrative Tasks and ToolsKey Components of SAP BI SystemBusiness Intelligence is a core component of SAP NetWeaver.Data warehousing - This is mainly to Extract, Transform and Load data from Source systems.BI platform - The BI platform layer contains BI services to support complex analysis tasks and functions. It contains the Analytic Engine, which processes the data requested through BEx analysis navigation. Its interface allows entry and manipulation of data as part of BI Integrated Planning. It also has special analysis tools such as the Analysis Process Designer (APD) and the Data Mining which provide analysts at your company with the tools to merge, mine, pre-process, store, and analyse data.BI Suite - These tools helps in creating reports for analysis purpose. It contains the Business Explorer (BEx) which provides flexible reporting and analysis tools.The following areas in the Business Explorer can be used for Data Analyses:BEx Analyser (Microsoft Excel-based analysis tool with pivot-table-like features)BEx Web Analyser (Web-based analysis tool with pivot-table-like features)BEx Web Application Designer (customer-defined and SAP BI Content provided)BEx Report Designer (highly formatted Web output)SAP BI/BW ArchitectureDatabase Server: Where data is physically stored.( ODS, PSA, InfoCube and metadata repository).Application Server: The application server is based on the OLAP processor. It is used to retrieve data stored in the database server.Presentation Server: Manages reporting and data access.Data is extracted from the Source Systems.Data is staged at the Persistent Storage Area(PSA). This holds Source like data.Data is cleansed, loaded and stored in Data Store Object.Data is viewed at multiple dimensions in the InfoCube.Data is available by the OLAP processor to the Business Explorer to display data as per Analysis requirements of the Business.Data can be made available to SAP/Non-SAP, Data Marts by the Open Hub Service (InfoSpoke).SAP BW 7.3 CertificationSAP BW 7.3 certification verifies the knowledge in the area of the SAP NetWeaver Business Intelligence solution for the consultant profile in SAP NetWeaver Business Intelligence. This certificate builds on the basic knowledge gained by a BI Consultant and preferably refined by practical experience within a BI team. The BW Consultant can implement this knowledge in the specialized areas practically in the projects.SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 and SAP BI 4.0SAP Certified Application Associate certification validates a professional's ability to work on SAP BW 7.3. The trainee can apply the knowledge to implementation activities as an Application Consultant under expert supervision.Exam Details1. Exam duration is 180 minutes2. There are 80 Questions3. Passing mark is 69 percent4. This is Associate level Certification Exam

Skills

Reviews