Course Objective

Training Outcomes

1.     Aimed To Prepare You From A Beginner to the Advance Level JOBS 

2.     TCA Training Provides A Gateway to an Impressive Career Opportunity 

3.     Become Industry Ready Professionals By Learning Most In Demand Technology  

4.     Build Career Into A Distinguished And Globally Acknowledged Technology 

5.     Secure an Outstanding Hike of 80 to 100% By Learning Most in Demand Technology

6.     Enables you to gain complete set of technical expertise to clear interviews

7.     Intended to Master You for a Sustainable Career in Most Competitive JOBs

8.     Allows you to explore Cutting-Edge Technology & Hottest Job Market

Project Submission

1.     One Major Project will be assigned to everyone attending this course with us.

2.     The trainees you required to submit the final projects assigned to the for evaluation.

3.     We will also provide weekly assignments to practice practical aspects of the training

4.     There will be case-studies given to every participant to make entire learning process easier

5.     The Assignments, Case-Studies & Projects performance will affect the gradings during certifications

Online Evaluation

1.     To become eligible for TCA Certifications every trainee is evaluated 

2.      The evaluation process is done through comprehensive online test

3.     Assignments, Projects & Case-Studies Reports also add-ons to the CERTIFICATION

4.      The grades are decided on the basis of all of the above evaluation factors

Become Certified

1.     We provide course completion certificates to all the trainees 

2.     TCA Certificates are valued & recognized by TOP CORPORATES 

3.     For many of the courses we are authorized training partners of various MNCs

4.     The Authorized training partnerships also ads more values to the certifications

Job Placement Solutions

1.    We provide Placement assurance on completion on the course

2.    Our 3 Years of Free Membership also helps learners in re-placements 

3.    We have got TIE-UPS with many a company for placement services

4.     TCA is the TOP-MOST institution for Corporate Trainings & Leadership Development

5.    Our Corporate Training TIE-UPS further helps industries as well learners for building INDUSTRY-READY-WORKFORCE

6.    We provide Employability-Orientation-Sessions to Make our Trainees INDUSTRY-READY-PROFESSIONALS

tca india
Get Training Quote Free
tca india

Business Analyst Training Programme

Upcoming Batches

LEARNER CAREER OUTCOMES

75
Started a new career after completing this course.
45
Got a pay increase or promotion.

Can't find a batch? Pick your own schedule

Request Batch

Recently Placed Students

Business Analyst Training Programme

Download Curriculum
Syllabus of Business Analyst Training
Module 1: Basic Excel

ü Format Cells: Managing Row Height, Column Width, Merge, Alignment, merge cell.

ü Managing Worksheet: Creating, Renaming, Colouring, Printing Sheets etc.

ü Statistical Functions: sum(), min(), max(), count(), average(), round() etc.

ü Graphically Representing Data: Charts & Graphs

ü Analyzing data: Filter, Sorting, Subtotal, Advanced Filter, Freeze Panes etc.

ü Formatting worksheets, Securing & Protecting spreadsheets

ü Working with Functions & Formulae

 

Module 2: Logical Functions

ü AND(), OR() Functions

ü AND() with IF() Function

ü OR() with IF() Function

ü IFERROR() Function

üTRUE, FALSE
Module 3 : Data Validation

ü Basic Data Validation

ü How to create List in Data Validation

ü How to Clear Data Validation etc.

Module 4 : Text Functions

ü Left, Right, Mid

ü Find, Trim, Proper

ü Replace, Concatenating

ü Upper, Lower, Len, Text etc.

Module 5 : Date Functions

ü Today(), Now()

ü Date(), Datedif()

ü Weekday(), Day(), Month(), Year() etc.

Module 6 : Financial Functions

ü PMT(), PPMT()

ü IPMT(), PV(), FV()

ü RATE(), What-If Analysis

ü Goal seek, Data Table

Module 6: Direct Connectivity

ü  Custom Data Gateways

ü  Exploring live connections to data with Power BI

ü  Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services/ My SQL

ü  Introduction to Power BI Development API

ü  Excel with Power BI: Connect Excel to Power BI, Power BI Publisher for Excel

ü  Content packs

Module 7: Integrating Power BI and Azure ML

ü  Extracting data out of Azure SQL using R

ü  Using R, call the Azure ML web service and send it the unscored data

ü  Writing the output of the Azure ML model back into SQL

ü  read scored data into Power BI using R

ü  Publishing the Power BI file to the Power BI service

ü  Scheduling a refresh of the data using the Personal Gateway

Module 7: Charts & advanced charts

ü Basic Charts, Line Chart

ü Bar Chart, Column Chart

ü Comparison chart

ü Combo Charts etc.

Module 8 : Special Operations

ü Paste Special

ü Protecting sheets

ü Text-to-column

ü Remove Duplicates

ü Flash Fill

ü Consolidate

ü Locking sheets

ü Protecting Sheets

ü Linking Multiple Sheets Sheet Referencing

ü Absolute Value & Reference Value

ü Age Calculations

ü Hyperlink

ü Power View

ü Page Setup

ü Orientation

ü Margins

ü Page Break Preview

ü Proper Use of Column Function

ü Background

Module 9: Lookup Functions

ü vlookup, hlookup, double vlookup

ü vlookup & hlookup with index match

ü vlookup with column function

ü vlookup with match, vlookup with list etc.

Module 10: IF Functions

ü IF Functions

ü Nested IF

ü SUMIF, SUMIFS

ü COUNTIF, COUNTIFS,

ü SUMPRODUCT etc.

Module 11: Pivot Tables

ü Basic Pivot Table

ü Advanced Pivot Table on Real Life Projects

ü Find Sales Performance Report in Pivot Table

Module 12 : MACROS

ü How to record macro

ü How to assign macro on a button

ü How to run macro using short cut key or using button

Module 13: Dashboards

ü Dashboard using Pivot Table & Charts

ü Comparative Dashboard

ü Performance Dashboard

Module 14: Condition Formatting

ü Data Bars

ü Color Scales

ü Icon Sets

ü Top/Bottom Rules

ü New Rules

ü Manage Rules

Module 15: Python Training

ü Introduction to Python

ü Installation of Python

ü Python programs using Spyder, Command Prompt

ü Working with Jupyter Notebooks

ü Manage Package & Environment by Anaconda

ü Python Variables & Operators

ü Basic Data containers: Lists, Dictionaries, Tuples & sets

Module 16: Iterative operations & Functions in Python

ü For Loops in Python

ü List & Dictionary Comprehension

ü While loops and conditional blocks

ü List/Dictionary using loops

ü Functions in Python

ü User Define Classes & Functions

Module 17: Data Analysis Process

ü Need for data summary

ü Summarising numeric data in pandas

ü Summarising categorical data

ü Group wise summary of mixed data

ü Introduction to ggplot & Seaborn

ü Visual summary of different data combinations

Module 18: Data Handling in Python using NumPy & Pandas

ü Introduction to NumPy arrays, functions & properties

ü Introduction to pandas

ü Dataframe functions and properties

ü Reading and writing external data

ü Manipulating Data Columns

Module 19: Statistics with R Programming

ü Probability

ü Binomial Distribution

ü Conditional Probability

ü Bayes Rule

ü Standardizing

ü Sampling Distributions & Center Limit Theorem

ü Confidence Intervals

ü Hypothesis Testing

ü Regression

ü Multiple Linear Regression

üLogistic Regression

Module 20: Data Wrangling

ü Intro to Data Wrangling

ü Gathering Data

ü Assessing Data

ü Cleaning Data

Module 21 : Introduction to SQL

ü What is SQL

ü Why SQL

ü What are relational databases?

ü SQL command group

ü MS SQL Server installation

ü Exercises

Module 22 : SQL Data Types & Operators

ü SQL Data Types

ü Filtering Data

ü Arithmetic Operators

ü Comparison operators

ü Logical Operators

Module 23: Useful Operations in SQL

ü Distinct Operation

ü Top N Operation

ü Sorting results

ü Combine results using Union

ü Null comparison

ü Alias

Module 24: Aggregating Data in SQL

ü Aggregate functions

ü Group By clause

ü Having clause

üOver clause

Module 25 : Writing Sub-Queries in SQL

ü What are sub-queries?

ü  Sub-query rules

ü Writing sub-queries

Module 26: Common Function in SQL

ü Ranking functions

ü Date & time functions

ü Logical functions

ü String functions

ü Conversion functions

üMathematical functions

Module 27: Analytic Functions in SQL

ü What are analytic functions?

ü Various analytic functions

ü SQL syntax for analytic functions

Module 28: Writing DML Statements

ü What are DML Statements?

ü  Insert statement

ü  Update statement

ü Delete statement

Module 29: Writing DDL Statements

ü What are DDL Statements?

ü  Create statement

ü  Alter statement

üDrop statement

Module 30: Using Constraints in SQL

ü What are constraints?

ü  Not Null Constraint

ü  Unique constraint

ü  Primary key constraint

ü  Foreign key constraint

ü  Check constraint

üDefault Constraint

Module 31: SQL Joins

ü What are joins?

ü Cartesian Join

ü Inner Join

ü Left & Right Join

ü Full Join

üSelf-Join

Module 32: Views in SQL

ü What are views?

ü Create View

ü Drop view

ü Update view

Module 33: Introduction to Tableau

ü Why Tableau? Why Visualization?

ü Level Setting Terminology

ü Getting Started creating some powerful visualizations quickly

ü The Tableau Product Line

ü Things you should know about Tableau

Module 34: Getting Started

ü Connecting to Data and introduction to data source concept

ü Working with data files versus database server

ü Understanding the Tableau workspace

ü Dimensions and Measures

ü Using Show Me!

ü Tour of Shelves (How shelves and marks work)

ü Building Basic Views

ü Help Menu and Samples

ü Saving and sharing your work

 

Module 35: Analysis

ü Creating View

ü Marks

ü Size and Transparency

ü Highlighting

ü Working with Dates

ü Date aggregations and date parts

ü Discrete versus Continuous

ü Dual Axis / Multiple Measures

ü Combo Charts with different mark types

ü Geographic Map Page Trails

ü Heat Map

ü Density Chart

ü Scatter Plots

ü Pie Charts and Bar Charts

ü Small Multiples

ü Working with aggregate versus disaggregate data

ü Analyzing

ü Sorting & Grouping

ü Aliases

ü Filtering and Quick Filters

ü Cross-Tabs (Pivot Tables)

ü Totals and Subtotals Drilling and Drill Through

ü Aggregation and Disaggregation

ü Percent of Total

ü Working with Statistics and Trend lines

Module 36: Getting Started with Calculated Fields

ü Working with String Functions

ü Basic Arithmetic Calculations

ü Date Math

ü Working with Totals

ü Custom Aggregations

üLogic Statements

Module 37: Formatting

ü Options in Formatting your Visualization

ü Working with Labels and Annotations

ü Effective Use of Titles and Captions

ü Introduction to Visual Best Practices

Module 38: Building Interactive Dashboards

ü Combining multiple visualizations into a dashboard

ü Making your worksheet interactive by using actions and filters

ü An Introduction to Best Practices in Visualization

Read More

Why Choose TCA

Live Projects

Exposure to work on real time projects..

Affordable Fees

Courses are available at reasonable cost..

Globally Recognized Certificates

Our Certificates are valued by top corporates ..

Hands on Training

100% Practical based training model..

Membership

Get 3 Years Free Membership..

Expert Mentors

Learn from certified & experienced trainers ..

Job-Oriented Training

Industry-Endorsed curriculum to you job ready professional..

100% Placement Assistance

Opportunity to get placed in top MNCs..

Key Features

  • Online Live Interactive Sessions Available
  • Small batch size: customizable
  • Weekly Assignments provided
  • Topic wise case-studies provided
  • Prime focus on concept building
  • Employability Orientation Sessions
  • Courses are available at reasonable cost
  • In-depth Study Material with practice set
  • Permanent, full-time, highly qualified and dedicated faculty

Frequently Asked Questions

Authorized Training Partnership

TCA COACHING INSTITUTE IS AUTHORISED PARTNER OF VARIOUS LEADING GLOBAL TRAINING PROVIDERS

CERTIFICATION

GET CERTIFIED BY INDUSTRY RECOGNISED TCA CERTIFICATE

TCA Certification is ascribed by all major Global Companies around the world. We provide after conclusion of the theoretical and practical sessions to fresher's as well as corporate trainees. Our certification at TCA is accredited worldwide. It proliferations the value of your resume and you can attain leading job posts with the help of this certification in leading MNC's of the world.

  •  Earn your certificate

    Our Certified Angular js Training course is exhaustive and this Angular js  certification is proof that you have taken a big leap in mastering the domain.

  •  Differentiate yourself with a TCA Certification

    The practical knowledge and actionable skillset you've gained working on projects, simulations, case studies will set you ahead of the competition.

  • Share your achievement

    Talk about it on Linkedin, Whatsapp, Instagram, Facebook, Twitter boost your resume or frame it - tell your friends and colleagues about it.

BUSINESS ANALYST TRAINING PROGRAMME CERTIFICATION PROCESS OF TCA

1
Attend TCA’s Training

Learn from industries best trainers to get dream your JOBS. We Deliver 100% Practical-based training to enable you become industry ready professional..

2
Deliver Projects Assigned

Gather experience with real-world assignments and practical projects to upgrade your existing skills. Complete Real-Time Live Projects assigned and become eligible to get Globally Recognized Certificate..

3
Earn Training Certification

Post-successful completion of the course & submission of your project, earn TCA Course Completion Certification. Post it on social media, get it framed, and increase your value in the industry..

4
Get Placed in TOP MNCs

We will prepare your interpersonal skills and develop resume to make you ready for the selection. Trainees are also given Sessions to learn how to face interviews. We will keep sending for interviews by the time you get selected..

Our Corporate Training Partners

Train your Employees

We deliver corporate trainings solutions to some of India's largest private, public & Govt. Organizations

Ackonobel
MBS
TDK
EC
bright

Browse Courses By Domain

Computer Science Training
Analytics Training Programs
Cloud Computing Training
SAP ERP Training Programs
IT Professionals Training
Civil Softwares Training
Mechanical Softwares

Key Highlights

MENTOR SUPPORT
MENTOR SUPPORT
ALL INCLUSIVE STUDY MATERIAL
ALL INCLUSIVE STUDY MATERIAL
PRACTICAL (LIVE-PROJECTS)
PRACTICAL (LIVE-PROJECTS)
NO-COST EMI FEE PAYMENT
NO-COST EMI FEE PAYMENT
LIFETIME ASSISTANCE
LIFETIME ASSISTANCE
FLEXIBLE TIMINGS JOB ASSISTANCE
FLEXIBLE TIMINGS JOB ASSISTANCE
JOB ASSISTANCE
JOB ASSISTANCE
CERTIFICATION
CERTIFICATION

MEET OUR MENTORS

STUDENTS REVIEWS

Preeti Pal

Preeti Pal

Amarjeet Singh

Amarjeet Singh

Professional with more than 9 years’ experience in field of Data Analytics. Worked extensively in Development Reports and maintenance projects of Advanced Excel, MIS Reporting, Power BI, MySQL & has also worked on various projects of Machine Learning.
Professional with more than 9 years’ experience in field of Data Analytics. Worked extensively in Development Reports and maintenance projects of Advanced Excel, MIS Reporting, Power BI, MySQL & has also worked on various projects of Machine Learning.

Vijay Singh

Vijay Singh

Have more than  10 years of experience in  CAD CAM CAE HVAC & Product Management industries.
As a Mechanical engineer with various specializing in CAD/CAM/CAE and project management, I have handled various Projects of  designing and manufacturing  while using CAD, CAM, CAE & HVAC, and managing the entire project from concept to completion. I do have strong understanding of engineering principles and project management methodologies.

Ravi Pandey

Ravi Pandey

Seema Soni

Seema Soni

Professional with 10+ IT and Professional experience in field of Teaching and Development.
Worked extensively in Development Reports and maintenance projects of J2SE.
J2EE & Python, Power BI, MySQL & has also worked on various projects of JAVA.
Professional Enterprises Application and Web Application Developer with the ability to use Hibernate and Spring boot techniques and leverage algorithms to solve real-world business problems. effective predictive models across different industries to accurately forecast consumer
behaviour and deliver proven results.

Anish Sharma

Anish Sharma

Technical expert at TCA Training and Development since 4 years.
As a technical expert, I have a wealth of knowledge and experience in various fields such as software development using Python,  Object oriented Programming using C++, and MIS using Excel. My expertise allows me to provide unique Corporate & Classroom Training Sessions and solutions to complex problems.
I'm always staying up-to-date with the latest technologies and industry trends to ensure that I provide the most effective and innovative training Sessions.
My approach is to work closely with Students & Corporates to understand their needs and goals, and then provide tailored solutions that meet their specific requirements with High classified projects of MNCS and Domestic Industries. I'm dedicated to delivering high-quality Training and ensuring that my Corporates are satisfied with the results.

Rohit Singh

Rohit Singh

Highly skilled and experienced Technical Skills 6+ Years with a history of association with Education Industries (8+ Years) that provide training in the field of Accounting, MIS, ERP, Python, Java Development, & Data Analyses.
Trained 5000+ highly Qualified Students of Colleges and Universities to achieve their Career Goals on Python and Data Analytics.
Heaving 6+years in delivering Trainings to College faculties (FDP) & On-campus Project based Industrial trainings. 
Highly Trained on emerging Tools and Techniques like Internet of Things, with best in industry tools Raspberry Pie, Arduino, ESP 8266  AVRatMega 32+.
Delivered 10+ overseas sessions during Covid and post covid

Rahal Harode

Rahal Harode

Newsletter Subscription

TCA provide quality training as it helps in making you and our brand name. 28,690 + Students Currently Using Campus

100%
Placement
Practical
Classes
Innovative
Modules
best coaching in delhi
Enquire Now
Enter Name
Enter Email
Enter Phone
Message
upsc general studies material
tca india