Certification will be delivered as per Industry criterion for SAP BW/BI-BO training which would benefit fresher/Experienced to up-skill at Corporate.
Professional & Expert SAP BW/BI-BO Consultant/Implementor Trainers With 10+ Years of working experience will deliver the workshop sessions.
When 70% of training will be completed of learners then devoted placement team will start to process of scheduling your interviews.
Expand your proficiency with extreme aligned of Corporate with set of technical test series with practical session to glaze your potential.
Learners will grasp real time & practical training sessions with thorough case studies & workshops at SLA Noida
Will get 7 Days assistance for upcoming batch schedule/re-scheduling classes/arrange or ask to arrange a backup or doubt sessions
Course Duration: 40 – 50 HRS with Highly Skilled Corporate Trainers (SAP BW/BI-BO Training Course) for 18 Modules-Weekdays/Weekend
SLA Consultants Noida – SAP BW/BI-BO Certification Training Delivery Method:
Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
And, Or, If, Iferror, Not, Nested If
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
And, Or, If, Iferror, Not, Nested If
Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display
With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot
|BW/BI-BO Course Module||Course Duration|
|SAP BW/BI-BO||40 – 50 (Hours)|
|SAP BW/BI-BO + Ad Excel + SQL||60 – 70 (Hours)|
|BW/BI-BO Course Schedule||Course Timing|
|Monday to Friday||8:00 AM – 10:00 AM|
|Monday to Friday||10:00 AM – 12:00 PM|
|Monday to Friday||2:00 PM – 4:00 PM|
|Monday to Friday||4:00 PM – 6:00 PM|
|Saturday/Sunday||8:00 | 12:00 | 2:00 | 4:00|
|Sunday||8:00 AM – 10:00 AM|
|Sunday||10:00 AM – 12:00 PM|
|Sunday||2:00 PM – 4:00 PM|
|Sunday||4:00 PM – 6:00 PM|