SAP_BI_Workshop_end user Training_One.ppt

SAP BI Training workshop

1. Somil Tiwari
SAP BI Workshop
Day One

2. Hail with a rich SAP industry experience of 8+ years
Started career in SAP-ABAP and progressed to the SAP Data Analytics implementing
tools like SAP BW/BI & SAP HANA.
Has been a key system architect for customers such as VOLVO AG (Sweden) ,
Unilever (Thailand) and adidas (Germany).
Currently implementing the SAP BW/BI solution for multiple functions at adidas
Headquarters in Germany.
A seasoned Professional Trainer in SAP technologies, with 150+ candidates from
Contact/Virtual Classrooms.
Getting Startedwith a ‘Hello’!

3. Pandora’s Box for Today
We learn SAP BI, together!
What is
SAP?
Why SAP-BW?
The Workshop
Plan

4. What is SAP?
SAP ~ Solves-All-Problems

5. What is an ERP software…an Organization’s Soul!
Material
Customers
Finance
Employees
Factory
Sales
MM
CRM
FI
HR
PM
SD
ERP
Enterprise Resource Planning

6. “SAP is a European Multinational which provides ERP
Softwareto manage business operations and customer
relations”
It is headquartered in Walldorf, Germany.
Key SAP Products –
1. ERP Software (SAP R/3)
2. Business Datawarehouse(SAP BW)
3. In-Memory Computing (SAP HANA)
Has a total of 58 acquisitions under its belt since 1991, the latest
one being in May’14 of SeeWhy(USA).
SAP
SAP
"System Analysis and Program Development“.

7. Why SAP BI?
Searching for Intelligence!

8. Business searching for Intelligence
Sales Order No. Item QuantityDate of Sale Outlet Amount
101 Ferrari 2 12/1/2014 New York 300,000
102 Mercedez 1 14/2/2014 Berlin 95,000
103 Toyota 4 22/2/2014 London 400,000
104 Audi 2 1/3/2014 Tokyo 220,000
105 Ferrari 1 15/3/2014 Bangalore 150,000
106 Audi 3 22/4/2014 Berlin 330,000
107 Toyota 2 30/04/2014 London 100,000
108 Mercedez 1 14/5/2014 New York 95,000
109 Ferrari 2 20/5/2014 Bangalore 300,000
110 Toyota 4 18/6/2014 Amsterdam 400,000

9. Top Job –Top Questions
Which is my best-sellingproduct
in terms of ‘units sold’?
Which Outlet has lowest sales during Q1?
What is the percentage increase in sale across Asia
Q-o-Q?
Which product is falling below the organization
growth guideline?
Rank the Regionsbased on revenue generated
for Q2?

10. SAP Business Intelligence is the Answer!
Source
Systems
(Transactional
Systems)
SAP R/3
Other OLTPs
SAP BI
System
SAP BI Reports

11. SAP Business Intelligence : Architecture
PSA
Persistent
Staging
Area
DSO
Data
Store
Object
Info
Cube
InfoObject/ Master Data
SAP BEx
Report
SAP BI System

12. In SAP Words..

13. The Workshop Plan
Get, Set, Go!

14. The Workshop Plan –Theory & Hands-On
Business Scenario
•Understanding a Live Business Case
•Determining the need of implementing a SAP BI system
Source System
•Building a Source System (SAP & non-SAP)
•Creating a transactional system for an organization and preparing data for analysis
Extraction
•Extracting source data into SAP BI
•Creating PSA and datasourcesfor extraction
Modeling
•Creating Data Models in SAP BI
•Building DSO, Infocubes and implementing Business specific logic in BI
Reporting
•Building real-life business Reports in BI
•Creating user reports based on ‘real’ business requirements

15. Automation of daily data extraction
through Process Chains
Master Data/Transaction Data
Concepts
Implementing BI-specific logic
using ABAP
Star-Schema Modeling in Infocubes
and more!
…and some more!

16. The Path to Grow!

17. Your turn now!