In Collaboration with IBM and TCS - ExcelR


Tools covered in Business Analyst course - ExcelR
Who should do Business Analyst Course - ExcelR

Upcoming Batches

Select Your City

Click Here

Live Virtual Classroom
₹ 56999
₹ 49999

  • Top class trainers from various MNCs
  • 60+ case studies/assignments to ensure hands on experience
  • Capstone projects
  • Job Readiness Program
  • Network of 350+ corporate companies
  • Jumbo pass - Attend unlimited number of classroom/Live online batches for 1 year
  • Steinbeis Certification Cost is Additional




Upcoming Batches






Show All Batches Enroll Now
Combo Offer

  • Data Analyst + Data Science
    ₹ 115999
    ₹ 84999
  • Data Analyst + AWS
    ₹ 79999
    ₹ 65999
  • Data Science + Data Analyst + AWS
    ₹ 145998
    ₹ 115999
  • Data Analyst + Core Python
    ₹ 65998
    ₹ 45999
Upcoming Batches




Enquire Now Enroll Now

Course Description

Business Analyst Course In Collaboration with IBM :

The certified Business Analyst Course has been developed by ExcelR in collaboration with tech giant IBM. The students get certified by IBM once they qualify the written test.

The demand for business analysts has grown many fold over the last few years. This has created huge opportunities for people from non-programming backgrounds.

Why Business Analyst Course With ExcelR ?

Companies across the globe have taken the approach of analysing tons of data that they generate as a part of their business. The analysis helps these companies obtain valuable insights that take the profitability to great heights.

Being one of the pioneers of upskilling learners in the Data Analytics field, ExcelR has come up with a curriculum that matches the market requirement with great precision. Alongside the curriculum, ExcelR is known for its hallmark service.

There is a dedicated assignments team, that helps students solve their queries.


Road Map for Business Analyst Course :

Placement Process - ExcelR


Course Curriculum

  • Business Statistics
  • Excel: Basics to Advanced
  • MySQL
  • Tableau
  • Power BI
  • SAS
  • R Basics
  • Python Basics
  • Agile
  • Descriptive Statistics
    • Data Types, Measure Of central tendency, Measures of Dispersion
    • Graphical Techniques, Skewness & Kurtosis, Box Plot
  • Probability and Normal Distribution
    • Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value
  • Inferential Statistics
    • Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
    • Introduction to Hypothesis Testing
    • Hypothesis Testing (2 proportion test, 2 t sample t test)
    • Anova and Chisquare
  • Data cleaning and Insights
    • Data Cleaning(Invalid cells,Blanks,Outliers,Null values)
    • Imputation Techniques(Mean and Median)
    • Scatter Diagram
    • Correlation Analysis
  • Intorduction to Excel:Quantum of Excel and Basics
    • Workbook,Types of workbooks and their uses(XLSX,XLS,CSV,XLSM and XLSB)
    • Common uses of Excel
    • Cell,Row,Column,Range/Array,Name box
    • Formatting of cells(Wrap Text,Number,Text,Cell formatting ,commenting,etc)
    • Ribbon,Formula bar,Status bar
    • Basic operators(+,-,/,*,%,>,<,>=,<=,( ),{ },[ ],&,' ', "" "",!)
  • Intorduction to Functions:Commonly used Excel Functions
    • What is syntax,arguments(Optional,Mandatory)Navigations using keyboard,shortcuts
    • Sum,Average,Max,Min,Product
    • CountBlank,CountA,CountIF,If,Now,Today
    • Cut,Copy,Paste,Paste Special
  • Anchoring data:Referencing,Named ranges and its uses
    • Absolute,Relative,Mixed referencing
    • Name Manager,Named ranges,Creating Tables
    • Create functions using named ranges AND/OR referencing
  • Referring data from different tables:Various types of Lookup,Nested IF
    • Lookup,Vlookup,Nested Vlookup,Hlookup,Index,Index with Match function
    • If,If with combination of AND/OR(multiple ways to get the output),IFERROR
  • Referring data from different tables:Advanced functions
  • Data Handling:Data cleaning,Data type identification,Data restrictions
    • Data validation,Depended drop down,Protecting cell,Array,range,sheet,Workbook
  • Data Handling:Formatting and Filtering
    • Conditional formatting(Icon sets/Highlighted color sets/Data bars/custom formatting),Sort,Advanced Sort,Filtering
  • Data Summerization:Advanced functions,Charts
    • Sum,Average,Max,Min with IF and IF'S,CountIF'S
    • Various types of Charts
  • Data Summerization:Pivots,Preparing the Dashboard
    • Pivot table,Slicers,Pivot charts,Calculated field,Calculated item, ADD/REMOVE/CHANGE data into the pivot table,Refreshing pivot data
    • Dashboard creation
  • Power query,power pivot
    • Cleaning data,extracting data from multiple sources
    • Transforming data,imputation techniques.Getting data from CSV files,databases,workbooks,webpages
  • Power query,power pivot,Use case discussion:Data Preparation,Project Summarization
    • Consolidating data from multiple sources,merging data from different workbooks/worksheets,relationships.
    • Use Data handling steps taught in the previous session,Use Data summarization techniques,Populate output in Excel,Combining multiple functions
  • Intro to Automation:Macros(Recorded /VBA)
    • How VBA works,Record a sample macro(Recording macros,Absolute mode,relative mode,different methods of executing macros)
  • VBA
    • If constructs,Select construct,User defined functions,input box, message box,procedures,automatic macros, methods to cleanup the codes
  • Introduction to Databases, Software Installation
    • Introduction to RDBMS,Explain RDBMS through normalization,Different types of RDBMS
  • Types of SQL Commands; Data Types in SQL
    • DDL,DML,DQL,DCL,TCL,Datatypes:int,float,char,varchar,date,date&time,UTC
  • DDL and DML and TCL commands
    • DDL:Create,Drop,Rename,Alter,Truncate,DML:Insert,Update,Delete,TCL:Commit,rollback,savepoint
  • Database Constraints
    • Domain Constraint,Key Constraint,Referential Integrity Constraint,Primary key,Foreign Key
  • Operators in SQL
  • Grouping operations
    • Select query,Order by,Group by,Having Classes,Aggregating functions
  • Ranking functions,Analytical functions
    • Rank,Dense rank,row number,percentile rank,lead and lag functions
  • Joining Tables
    • Inner,Left,Right,Cross,Self Joins,Full outer join, Interview Scenarios
  • Views,Triggers
    • Simple views,Complex views,Different types of triggers
  • Introduction to subqueries, different types of subqueries
    • Explaintion of subqueries with interview scenarios
  • Indexing,Sequence Objects
    • B.Tree Index,Hash Index,Unique index,Advantage of Index,Creation of Sequence on primary key column
  • Stored procedures
    • Parameters in stored procedures,Exception handling in stored procedures
  • Intro to Tableu Tool
    • What is data,Types of Data(Structured,Unstructured,Semi Structured),Visualization basics,Different visualizaion tools,Popularity of the tools, Licencing Cost,Different products of Tableau,Installation (student id), ,Connecting to Static files,Mysql
  • Data pane window
    • Live Vs Extract,Data source window,Navigating to work sheet,Data pane,Analytics pane,Dimensions,Measures,Auto generated fields,Data visualization window explaination,Data source window operations
  • Groups,Sets,Parameters
    • Hierarchy(In built hierarchy,Manual),Grouping ,Sets,Parameter with filters and Parameter with Sets,Usage of meausre names and Measure Values
  • Filters in Tableau
    • Dual axis,Blended axis,Dimension filters,Measure filters(Record level filters,summary level filters),Date filters,Cascading Filters,Context filters,Data source filters,Extract filters,
  • Calculated fields
    • Quick table calculations,Introduction to calculated fields,string calculated fields,Number calculated fields,date calculated fields,logical calculated fields,ZN Function
  • Data Blending and Joins
    • Mixing up of all calculated fields,Conditional Formatting in Tableau, Data blending,Data joins,Unions,Relationships,Basic Charts and use cases, Introduction to Show me,Development of In built charts part1,
  • Charts in Tableau
    • Development of inbuilt charts part2,Customized graphs(Donut, Waterfall,Bump,Barometer,Butterfly,Gauge meter,Basic Funnel, Advanced Funnel,Word cloud,Gantt Bar),Animated Chart
  • Reference lines,Bands,Distributions
    • Arbitary formatting,Explaination of Marks Card,Reference lines, Reference Bands,Reference Distribution
  • LOD's, Intro to Dashboard,Story
    • Forecasting,Introduction to Dashboard,Story board interfaces,LOD's(Fixed,Include,Exclude)
  • Creating a Dashboard
    • Creating of a Basic Dashboard with both Tiled,Floating layouts, Explaination of objects in the Dashboard interface,Action filters on Dashboards
  • Creating a Advanced Dashboard
    • Advanced level dashboard(Drill down dashboards),Designing of Basic Story board
  • Tableau public server
    • Publishing Dashboards on Tableau public server,Exposure to the websites which consists of real time data,Interview cracking resources,introduction to Tableau certification
  • "Introduction to R,Installation of Rstudio,Data Types in R
    • Data types(Numeric,Char,Logical,Complex,Vector,List,Matrix,Factor,Array,Dataframe),Relational operators,Logical operators
  • Decision making statements,Loops,Functions
    • If,Ifelse,For loop,While loop,Repeat,Functions
  • Built in Functions in R,Joins,dplyr and ggplot2
    • Merging dataframes,Analyzing Iris Dataset using apply functions,dplyr package(Filter,Sel,Arrange),Data visualization using ggplot2,Scatterplot,Histogram,Boxplot
  • Anaconda Installation,Introduction to python,Data types,Opearators
    • Variables,data types(integer,Boolean,Float,List,tuple,string),Opearators in python
  • Data types Contd,Slicing the data,Inbuilt functions in python
    • Dictionaries,Sequence methods,Concatenate,Repetition,len,min,max functions,Index position,Addition and deletion of elements,Reverse,Sorting
  • Sets,Set Theory,Regular Expressions,Decision making statements
    • Sets,re module(findall,search,split,match),if,elifGetting input from user,Identity Operators
  • Loops,Functions,Lambda functions,Modules
    • For,While loops,Functions,Lambda functions,Math module,Calender module,Date & time module
  • Pandas,Numpy,Matplotlib,Seaborn
    • Data frame creation using different methods,Using Pandas anlysis on Universities,Salary data sets,Visualization using Matplotlib and Seaborn,Numpy introduction
  • Power BI Introduction
    • Introduction to Power BI Desktop
    • Getting data (Excel and RDBMS, Web, SharePoint)
    • Naming for Q&A
    • Direct Query vs Import data
  • Modelling with Power BI
    • Introduction to Modelling
    • Set up and Manager relationships
    • Cardinality and cross filtering
    • Creating hierarchy in the model
    • Default summarization and sort by
    • Creating calculated columns
    • Creating measures and quick measures
  • Power BI Desktop Visualizations
    • Creating visuals
    • Colour and conditional formatting
    • Setting sort order
    • Scatter and bubble charts and play axis
    • Tool tips
    • Slicers, timeline Slicers and sync Slicers
    • Cross filtering and highlighting
    • Visual, Page and Report level filters
    • Drill down/up
    • Hierarchies
    • Constant Lines
    • Tables, Matrix and Table conditional formatting
    • KPI’s, Cards and Gauges
    • Map Visualizations
    • Custom visuals
  • DAX Expressions
    • Introduction to Dax (how to write Dax and basic functions in Power BI)
    • Important Dax used in Power BI along with its applications
    • Introduction to Dax (how to write Dax and basic functions in Power BI)
    • how to create calculated columns and measures in Power BI and difference in its application
    • Scenarios with Questions on Dax & explanation
    • Creating date dimension in Power BI using calendar functions and its importance
  • Publishing and Sharing
    • Sharing options
    • Publish from Power BI Desktop
    • Publish reports to Web
    • Sharing reports and Dashboards
    • Workspaces
    • Apps
    • Printing, PDF’s and exports
    • Row level Security
    • Exporting data from Visualizations Refreshing Datasets
    • Understanding data refresh
    • Gateways
  • Introduction to Agile
    • Project Definition
    • Difference Between Traditional & Agile Project Mgmt.
    • Agile Manifesto and Principles
    • Agile Methodology
    • Agile Principles
    • Agile Frameworks and Terminology
  • Agile Methodologies
    • Scrum
    • XP
  • Agile Analysis and Design
    • Product Roadmap
    • Product Backlog
    • Story Maps
    • Agile Modeling
    • Wireframes
    • Charting
    • Personas
  • Planning and Monitoring
    • Iteration and Release Planning
    • Progressive Elaboration
    • Time Boxing
    • Cumulative Flow Diagram
    • Kanban Boards
    • WIP Limits
    • Burn Charts
    • Retrospectives
    • Innovation Games
  • Agile Metrics and Estimations
    • Relative Sizing
    • Story Points
    • Wideband Delphi Technique
    • Planning Poker
    • Affinity Diagram
    • Ideal time
    • Velocity
    • Cycle Time
    • EVM
    • Escaped Defects
  • Quality
    • Frequent Verification and Validation
    • Test Driven Development
    • Definition of Done
    • Continues Integration
    • Feedback Techniques
    • Incremental Delivery
    • Continuous Improvement
  • Value Based Prioritization
    • Customer Valued Prioritization
    • Compliance
    • Relative Prioritization
    • Value Stream Mapping
    • Minimum Marketable Feature
  • Risk Management
    • Risk Adjusted backlog
    • Risk Burn down charts
    • Risk based spike
  • Agile Communications
    • Team Space
    • Information Radiator
    • Agile Tooling
    • Daily Stand-ups
    • Osmotic Communication

Contact Our Team of Experts

Participants Placed Through ExcelR



Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence


Certified Business Analytics / Data Science Course Training locations in Delhi : Asaf Ali Road [110006] , Bhikaji Cama Place [110029] , Chandni Chowk Old Delhi [110006] ,Chattarpur [110074 ], Chirag Enclave [110048] , Civil Lines [110054] , Connaught Place [110001] , Defence Colony [110024] , Diplomatic Enclave [110021] , Dwarka [110075] , East of Kailash [110065] , Friends Colony [110025] , Golf Links [110003] , Greater Kailash [110048] , Green Park [110016] , Karol Bagh [110005] , Lajpat Nagar [110024], Mayur Vihar [110091] , Mehrauli Gurgaon Road [110037] , Naraina [110028] , Narela [110040] , Nehru Place [110019] , Nizammuddin [110013] , Paharganj [110055] , Panchshil Enclave [110017] , Paschim Vihar [110063] , Patel Nagar [110008] , Pushpanjali Farms [110037] , Qutabgarh Village [110039] , Rajendra Place [110008] , Rajokri [110038] , Saket [110017] , Samalkha [110037] , Shahdara [110032] , Shalimar Bagh [110088] , Shiv Murti [110037] , Sukhdev Vihar [110025] , Sundar Nagar [110013],Vasant Kunj [110070] , Vasant Vihar [110057] , Janakapuri [110058] , Noida [201301] , Ajmeri Gate [110002] , Aram Bagh [110055] , Sidipura [110005] , Azadpur [110052] , Karol Bagh 110005, Old rajinder nagar 110060, Rajouri garden 110027, Vishwa vidyalaya 110009, Kamla nagar 110007, Kalu sarai 110016, Nehru park 190001, (N.S.P) Netaji Subhash Place 110034, J N U 110067,Connaught Place 110001, Saket 110017, Pitampura 110034, East kidwai nagar 110023 , Shakur pur [110034].

Locations Offered : Data Science Training in delhi, Data Science Course in delhi, Data Science Training in Connaught Place, Data Science Training in Karol Bagh , Data Science Institute in Delhi, Data Science Training in kamla nagar, Data Science Training in kalu sarai, Data Science Training in J N U, Data Science Training Institute in Connaught Place, Data Science Course in Connaught Place, Data Science Course in Saket, Data Science Course in old rajinder nagar, Data Science Course Connaught Place , Data Science Training in (N.S.P) Netaji Subhash Place, Data Science Training in Pitampura, Data Science Classes in Connaught Place, Data Science Classes in J N U, Data Science Classes in Connaught Place, Data Science Classes in Delhi, Data Science Course in vishwa vidyalaya, Data Science Training in kalu sarai, Data Science Certification in Delhi, Data Science Certification Training in Delhi, Data Science Certification in Connaught Place, Data Science Certification in Karol Bagh, Data Scientist course in Delhi, Data Scientist Course in Connaught Place, Data Scientist training in Delhi, Data Scientist Certification Training in Delhi, Data Scientist Certification Training in Connaught Place, Data Scientist Certification in Connaught Place, Data Scientist Certification in Delhi, Data Scientist Institute in Delhi, Best Data Science Training, Best Data Science Course, Best Data Scientist course, Best Data Scientist Training


Call Us