You can now join over 400+ students in this SAP BEx Analyzer Video Academy Course.
This in-depth SAP BW BEx training course will teach you how to master the BEx Analyzer and Query Designer tools - the key reporting component of the SAP BW & Business Intelligence suite of applications used by thousands of the worlds largest companies to help them analyze their own business data.
This course is a complete A to Z online learning course for the SAP BEx Analyzer (SAP Business Explorer) and Query Designer. No stone is left un-turned.
The SAP Business Explorer (BEx) offers a high focus on user productivity, with formatted reporting, intuitive ad-hoc analysis, advanced Excel integration, and model-driven BI applications.
This course will teach you how to fully master this toolset. It is fully up-to-date for SAP NetWeaver BW 7.x and provides end users and functional consultants with a detailed reference on how to use all aspects of BEx reporting, from designing queries to linking reports together. You will gain a deep knowledge of BEx and its many uses.
First, learn how to use existing reports already available in your system then create and design flexible query definitions that can be used by a wide variety of users, with a focus on performance and usability. You will delve into the capabilities of BEx Analyzer and enhanced navigation features, such as drag and drop to facilitate end-user interaction, the new design mode to develop reporting applications within MS Excel, and additional integration with Excel formatting and formulas.
You'll quickly master advanced techniques such as using cell definitions, creating Exceptions & Conditions in your queries as well Report-Report-Interfacing (RRI), a tool that enables users to link reports and jump from one report to another containing additional information.Highlights
A key feature of this course is you will have direct access to Peter Moxon - a seasoned SAP BI consultant to answer any questions.
After you have completed this course you will be able to create unlimited SAP reports, create and use both simple and complex query definitions using the BEx Query Designer and create full Analysis Applications.
Being able to create reports and analyses is an integral part of using a BI solution. This course is all about how we can use the BEx query designer and the BEx Analyzer tools to create queries for reporting and analysis purposes inside SAP BW.
One of the main reasons why companies purchase of Business Intelligence solutions is so that they can have visibility of the data that they collect within their business systems.
Companies realise that they have so much valuable data sat in their business systems that they are losing out by not putting that data to good use.
SAP BW was created to enable companies to get at their data and turn that data into meaningful information to help business decision-makers:
The first thing we’re going to do in this course is use the BEx Analyzer to run queries and perform ad-hoc analysis using the Microsoft Excel application. SAP developed the BEx Analyzer to work as a plug-in with Microsoft Excel because Excel is the most popular analysis tool used by businesses today and it makes perfect sense to use an application that has so many functions and people are comfortable using.
SAP also created a web version of the BEx Analyzer and this is called the BEx Web Analyzer but, we’re not going to cover that in this course. It does function in a very similar way and the majority of the information that we will cover in this course will also apply to creating BEx web queries.
So without further ado let’s get cracking. We will take a look at how we can analyse data using the BEx Analyzer and the procedures used to build your own analysis application within Excel.
Test your knowledge on how to open existing BEx reports
In this video, we will focus on the Default Output that we see on the screen and we will look at some of the features that are presented to us immediately the query runs.
Here we will go through the detailed functions made available through the SAP BEx Analyzer toolbar.
In this lesson we look at the architecture that makes up the SAP BW BW reporting landscape.
Here you get to see how to add the options to enable and disable your query Exceptions at report runtime.
This lesson shows how to add Text Elements onto your analysis application.
You have made it all the way through the course. This sections of videos takes you through an example project where we create a SAP BEx Analysis Application from scratch.
Lets get started!
SAP consultant and the #1 SAP instructor on Udemy.