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

100% Job Assured

1.    We provide 100% 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