Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity SAP BEx Analyzer

Learn SAP BEx Analyzer - Training Course

Learn SAP BW BEx Analyzer Reporting with Peter Moxon. In-Depth SAP BI Training Course - Unlimited Access + Updates!
Bestseller
Rating: 4.4 out of 54.4 (563 ratings)
4,793 students
Created by Peter Moxon
Last updated 4/2013
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • By the completion of this online training course, you will be able to create and run your own BEx Analyzer reports.
  • You will be able to create BEx Analysis Applications in Microsoft Excel
  • You will be able to customize existing reports and produce reports that can be distributed throughout you organisation.
  • Fully understand how the front end BW Reporting tools work
  • Integrating key figures, characteristics, hierarchies, variables, properties, exceptions and conditions in the query definitions
  • Delivering reports and adhoc-analysis using the BEx Analyzer
  • Configuring report-report interfaces
  • Navigation in SAP BW reports
  • Architecture and functions of the SAP BW analysis tools
Curated for the Udemy for Business collection

Requirements

  • User level understanding of how to navigate the SAP GUI or previously completed course: https://www.udemy.com/learn-sap/

Description

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
  • BEx Query Designer
  • Accessing InfoProviders
  • Creating Custom Templates
  • Defining Jump Targets
  • Build Analysis Application
  • Integrate Exception & Conditional reporting techniques
  • Embed multiple reports into your Workbooks
  • Learn to build new reports in less than 2 minutes!

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.

Who this course is for:

  • Financial Accountants
  • Business Reporting specialists
  • Information and Data analysts
  • SAP Power Users
  • SAP Functional Consultants
  • SAP BW Consultants
  • Solution consultants responsible for implementing SAP NetWeaver Business Warehouse
  • Project team members with basic knowledge of Data Warehousing and SAP ERP experience

Course content

11 sections • 59 lectures • 11h 11m total length

  • Preview02:23
  • Preview02:34
  • Preview10:46
  • How to open reports
    1 question
  • The BEx Analyzer Default Query Output
    06:11
  • The Functions of the BEx Analyzer Toolbar
    11:01
  • BEx Analyzer Data Analysis Functions - Part 1 - Filters and Navigation options
    24:24
  • BEx Analyzer Data Analysis Functions - Part 2 - More Filters
    23:09
  • BEx Analyzer Data Analysis Functions - Part 3 Characteristic & Query Properties
    32:13
  • Saving BEx Workbooks and Query Views
    04:55

  • Overview of the SAP BW Reporting tools landscape
    06:08
  • Starting the BEx Query Designer And Screen Layout
    07:49
  • BEx Query Designer Menus and Toolbar
    05:28
  • Creating our first BEx query
    15:07
  • Enhance our first BEx query
    06:03
  • Defining filters for our BEx query
    15:27
  • Compress and Expand Key Figures and Hierarchies
    11:14

  • Dynamic Filters
    01:32
  • OLAP Variables
    23:49
  • Hierarchy Variables
    07:52
  • Hierarchy Node Variables
    08:19
  • Replacement path variables
    17:30
  • Text Variables
    17:27
  • Formula Variables
    09:37
  • Authorisation Variables
    05:38
  • SAP Exit Variables
    03:16
  • Customer Exit Variables
    06:27

  • Structures
    10:40
  • Cell Definitions
    14:01
  • Reusing Structures
    04:53

  • Selections and Formulas Overview
    03:36
  • Selections
    20:17
  • Formulas
    11:53

  • Restricted Key Figures
    06:04
  • Calculated Key Figures
    06:19

  • Characteristic Query Element Properties
    14:55
  • Key Figure Query Element Properties
    11:23
  • Query Element Properties
    25:42

  • Creating Conditions
    28:19
  • Creating Exceptions
    23:34
  • Report to Report Interfaces (RRI)
    34:01

  • BEx Analysis Applications Introduction
    02:42
  • Design Mode and the Analysis Grid
    20:59
  • Navigation Pane
    15:22
  • List of Filters
    06:25
  • Add interactive Buttons
    27:09
  • Drop-Down Boxes
    06:26
  • Check-Box Groups
    05:43
  • Radio Button Groups
    04:40
  • Adding Conditions
    05:54
  • Add Exceptions
    07:29
  • Text Elements
    06:36
  • BEx Messages
    04:07
  • Workbook Settings
    12:19

  • Part 1 - Introduction and Manager Report Setup
    06:33
  • Part 2 - Employee Report Setup
    07:29
  • Part 3 - Multi Report Filtering with DropDown Boxes
    07:46
  • Part 4 - Add a Button, Refine and Position Elements of our BEx Reports
    06:52
  • Part 5 - Adding Dynamic Charts
    13:41

Instructor

Peter Moxon
Head Trainer at Sap Training HQ
Peter Moxon
  • 4.3 Instructor Rating
  • 12,438 Reviews
  • 54,514 Students
  • 7 Courses

SAP consultant and the #1 SAP instructor on Udemy.

I hope you find my courses interesting and I really hope you enjoy them.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.