Gain a competitive advantage in Business Intelligence and become certified as an SAP Professional
This is an in-depth Combo Course that includes the complete Training Courses on SAP HANA, SAP BI/BW and SAP Business Objects clubbed into one to give you an unassailable advantage. You will gain full proficiency in real-time data analysis, data warehousing techniques and Business Intelligence methodologies upon completion of this Course.
SAP today is one of the biggest players in the Business Intelligence and data analysis domains. This combo course gives you all the necessary skills to be a complete SAP professional and appear for the SAP Certification test. On completion of the Course and the ensuing Certification your skills will be in much demand in companies regardless of industry domain.
Introduction to SAP HANA, the difference between HANA and other tools available in the market, the best of OLAP and OLTP in one tool, the expansive nature of SAP HANA, understanding SAP BW, SAP in-memory strategy.
An overview of the SAP HANA architecture, the various component and concepts on which SAP HANA works, the basic terminology, learning about ABAP based scenarios, understanding the SAP Landscape Transformation, trigger-based approach, working with the multi system support, configuring and monitoring dashboard, start and stop replication, integration with SLT, SLT and HANA compatible matrix.
Understanding the ABAP language for developing SAP R/3 platform, learning about the various non-application server ABAP-based scenarios.
Learning about the data transformation in SAP HANA, the process of data integration, data cleansing and consolidation, the process of loading data from one BI object to another, converting a field of source into target object format, various types of transformation, merge transformation, history preservation transformation, row generator, table comparison, slowly changing dimensions.
Introduction to SAP HANA Studio, connection and session management, request processing and execution control, learning about Transaction and Metadata Manager, row and column data storage, system generated schema, backup and recovery, defining Star Schema, introduction to Studio Modeler, grasping the different terminologies, the Graphical User Interface in SAP HANA.
Clear understanding of SAP HANA modeling, creating modeling views, types of information views like analytical, attribute and calculation view, view processing using various engines in SAP HANA.
Introduction to search in SAP HANA, the various type of data search available, searching for tables, and views, querying data suing OData services, deploying SQL queries.
Learning about SAP HANA database connectivity, studying detailed interface between SAP HANA and SAP BO, designing universe using HANA tables, report creation, crystal report in HANA database using ODBC connection, report creation in dashboard based on HANA universe.
Introduction to SAP Business Objects analysis, learning about multidimensional ad hoc analysis of OLAP sources in Excel, working with SAP HANA Explorer.
Managing and processing of models, rules of model validation, understanding referencing to Model, deploying auto documentation and learning about delivery units.
Introduction to HANA backup and recovery processes, understanding High Availability, Disaster Tolerance, learning about Persistent Layer, method of taking data backup and facilitating recovery, the concept of sizing in SAP HANA.
Learning about HANA Appliance and Appliance Model, the various techniques of data storage in HANA, row-based and column-based storage, deployment options in HANA.
Managing the SAP HANA platform, understanding user provisioning, concepts of SAP HANA sizing for working in different scenarios, security management and authorization features, learning about multi-tenant database containers.
The various types of privileges in SAP HANA – system, object, analytic and package, understanding various entities and relationships, managing of connection attempts, learning about SQL analytic and class analytic privileges, creating procedure using NoSQL methods.
Learning about attributes, creation of attribute views, learning about derived attributes, the concept of calculated attributes, understanding levelled hierarchy, calculated and restricted measure.
Introduction to calculation view, powerful and flexible information view, deploying complex calculations on tables, creating calculation view using graphical and SQL scripting.
Learning about data provisioning, designing and enabling a network to provide data to users, loading of data to SAP HANA before it is loaded to front-end, provisioning of data using flat files, SAP BO Data Services, configuring database and data services platform, ETL transformation.
Introduction to ABAP data flow to work with large volumes of records, generating ABAP program files, deploying SAP Landscape Transformation, the business features of it.
Use of SAP HANA Modeler, Template tables, Configure and Monitor dashboard
Introduction to SAP, the SAP architecture, understanding the SAP BI landscape, understanding the SAP BI/BW, overview of SAP BW Works, the description of BW works model, understanding PSA data sources, data transfer process, Char and Key Figure Model.
Understanding the data warehousing module, ETL and Reporting, introduction to data warehousing work bench, complete SAP BW Architecture, concepts, and description.
Introduction to SAP BW data modelling, understanding the source system, learning about SAP Source and Non SAP Source, PSA Info Providers like cubes, info, char, do modelling.
Learning about the SAP BW Data Transformation, and Scheduler, extracting data from flat files to SA P BW, changing data sources, difference between internal and external sources, editing info object catalog, creating and working with meta data of target, creating of company application, and working with Scheduler.
Understanding of SAP BI/BW data schema, understanding Master Data Table, learning about Extended Star Schema, master data load, attribution of master data, hierarchies and text of master data.
Understanding the SAP BW info providers, introduction to data store object, designing and working with standard data store object, editing and displaying data store object, loading of data in DSO as an info provider, display and change transformation in DSO.
Functionality of DSO, advantages, drawbacks and creation of DSO.
Understanding the concept of write-optimized data store objects, learning to create write-optimized data store objects, the basic characteristics and rules.
Introduction to Infoset, a specific kind of Info providers, learning about the rules of Infoset, deploying Infoset for data modelling, the Join Concept and knowing when to use Infoset.
Understanding the multidimensional data structure, the various types of info cubes, creating a standard info cube, characteristics and key features, the most important rules for designing an info cube, understanding Star Schema, Extended Star Schema and fact tables.
Introducing the concept of Multi provider, combining data from various info providers, the rules of updating, learning about Virtual and Hybrid providers.
Understanding the concept of routines in transformation, local ABAP classes, learning about the Data Transfer Process, troubleshooting techniques, process chain and business content in BI.
Learning about Data Extraction in BW, extracting data from various tables in BW, learn how to extract data from R/3 systems to BI, various types of SAP extracts – cross-application, application-specific, creating a generic data source and standard extraction procedure, creating BI Side Info Package.
Introduction to Logistics Cockpit data extraction, the standard extract procedure, the various concepts like event, delta initialization and extraction, the methods and modes of update, understanding Delta Queue, setup table and LUV.
Introduction to CO-PA Extractor, working with COPA data source, delta mechanisms, challenges faced while extracting data during implementation.
Introduction to SAP BW Reporting, understanding the Business Explorer, BEx query designer, the query designer panel, standard tool bar, the various query elements, query properties, filter in query designer.
Learning about the SAP BW restrictions and exceptions, defining exceptions in BEx query designer, restricting characteristics to single value, hierarchy nodes, or value variables, understanding conditions, exceptions, restricted key figures, structure, new selection and formula.
Understanding the SAP BO business intelligence tool to view, sort and analyze BI data, introduction to various components of SAP BO like crystal reports, Dashboards, web intelligence tool, ad ho queries.
Learning about the basics of Data Warehousing and its deployment in real world scenarios.
Understanding the SAP BO Architecture, the various tiers in it like client, processing, intelligence.
Understanding Web Intelligence Overview, ad hoc reporting, analysis tool, discovering insights from any data source and any device, creation of Prompts, applying various conditions, deploying various formula and functions, Drill Functions, understanding Variable in Web Intelligence environment.
Learning about SAP BO Reports, creation of Chart Reports, Table Reports, sorting and aggregating of Reports, various elements of Reports, graphs, text elements, data processing features.
Learning about creating Conditional Reports, understanding the concept of Ranking, working with Session Report and Break Reports.
Learning about SAP BO data source, introducing personal data source, Business Explorer as a Data Source, multiple query overview, deploying queries for generating results, merging dimensions, deploying web services as a data source.
Introduction to the Universe Designer Tool, creation of the Universe, understanding of the Semantic layer, star schema, working with shared, secured and personal connections, setting up tables with parameters, creation of Joins, applying restrictions, understanding List of Value objects.
Advanced methods of formatting in SAP BO, identifying Chasm trap and resolving Chasm traps with various methodologies, detection and resolving of loop, understanding Fan Trap, learning to identify and resolving Fan Trap, creation of various classes and objects.
Introduction to SAP BO information design tool, extracting data from various sources using OLAP methodologies, relational connection, creating of Universe with IDT, comparing the IDT and UDT, working with IDT as an Integration tool.
A powerful data visualization tool for creating interactive dashboards, point-and-click features, understanding the various dashboard features and interface.
Detailed design of Crystal Dashboard, Live office
Project –Develop reports using SAP HANA
Dataset – Sales
This project is involved with creation of reports using SAP HANA. You will get in-depth understanding of creating SAP HANA reports with SAP Business Objects explorer, learning to deploy different SAP HANA views like attribute, analytic and calculation views, understanding how to create SAP HANA Crystal Report, deploying MDX Provider for connecting HANA system to Excel data, data modeling techniques. Upon completion of the project you will gain expertise to develop reports from multiple data sources and view it to glean valuable insights.
Project – BExAnalyzer
Learning about BExAnalyzer, analytical, reporting and design tool, performing drill down operations, applying filter on tables, table to chart format conversion, workbook and reporting broadcast.
Project – Publishing Business Objects Universe
This project will give you a complete experience in working on a real-world SAP Business Objects Universe deployment. You will learn about SAP BO publishing universe which consists of a data foundation, a connection and a business layer. Learn how to create a connection from relational sources, creating data foundation, checking the universe using a query panel, creating a business layer and deploying cascading LOV and parameter. Upon completion of the project you will learn to successfully publish a universe file to a repository.
This Intellipaat SAP BI combo training will help you gain complete proficiency in working with the SAP range of tools for real-time data analysis, data warehousing and various Business Intelligence technique and methodology deployment. You will learn about SAP HANA, SAP BI/BW and SAP BusinessObjects. This entire course content is in line with the requirements of clearing the SAP HANA CERTIFICATION, SAP BI BW Professional Certification Exam, Business Objects BI Professional Certification Exam.
You will be working on real time SAP projects that have high relevance in the corporate world, step-by-step assignments and curriculum designed by industry experts. Upon completion of the training course you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 Support, and course material upgrading to latest version at no extra fees. Hence it is clearly a one-time investment.
Intellipaat basically offers the self-paced training and online instructor-led training. Apart from that we also provide corporate training for enterprises. All our trainers come with over 12 years of industry experience in relevant technologies and also they are subject matter experts working as consultants. You can check about the quality of our trainers in the sample videos provided.
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact Intellipaat even after completion of training to get support and assistance. There is also no limit on the number of queries you can raise when it comes to doubt clearance and query resolution.
The Intellipaat self-paced training is for people who want to learn at their own leisurely pace. As part of this program we provide you with one-on-one sessions, doubt clearance over email, 24/7 Live Support, lifetime LMS and upgrade to the latest version at no extra cost. The prices of self-paced training can be 75% lesser than online training. While studying should you face any unexpected challenges then we shall arrange a Virtual LIVE session with the trainer.
We provide you with the opportunity to work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready. These projects could be in exciting and challenging fields like banking, insurance, retail, social networking, ecommerce, marketing, sales, high technology and so on. The Intellipaat projects are equivalent to six months of relevant experience in the corporate world.
Yes, Intellipaat does provide you with placement assistance. We have tie-ups with 80+ organizations including Ericsson, Cisco, Cognizant, TCS, among others that are looking for skilled & quality professionals and we would be happy to assist you with the process of preparing yourself for the interview and the job.
Yes, if you would want to upgrade from the self-paced training to instructor-led training then you can easily do so by paying the difference of the fees amount and joining the next batch of classes which shall be separately notified to you.
Upon successful completion of training you have to take a set of quizzes, complete the projects and upon review and on scoring over 60% marks in the qualifying quiz the official Intellipaat verified certificate is awarded.The Intellipaat Certification is a seal of approval and is highly recognized in 80+ corporations around the world including many in the Fortune 500 list of companies.
This course is designed for clearing SAP HANA CERTIFICATION. At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
This course is designed for clearing “SAP BI BW Professional Certification Exam” conducted by SAP . At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
This course is designed for clearing “Business Objects BI Professional Certification Exam” conducted by SAP . At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
You will get Lifetime access to high quality interactive tutorials along with life time access to complete Course Material .There will be 24/7 access to video tutorials with email support. If you stuck in any unexpected problem we will provide online interactive sessions with trainer for issue resolving.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
This course is designed for clearing SAP HANA CERTIFICATION, SAP BI BW Professional Certification Exam and Business Objects BI Professional Certification Exam conducted by SAP .
At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org