Business Analyst Certification Course Training offered by ExcelR
4.8 /5Business Analyst Certification Course Training at ExcelR Overview
Duration | 160 hours |
Total fee | ₹39,999 |
Mode of learning | Online |
Credential | Certificate |
Business Analyst Certification Course Training at ExcelR Highlights
- Earn a certificate from IBM after completion
- Students will work on live projects
- Get placement assistance from ExcelR
- Learn from top class trainers from various MNCs
- Attend unlimited number of classroom/Live online batches for 1 year
- Get 60+ case studies/assignments to ensure hands on experience
Business Analyst Certification Course Training at ExcelR Course details
- For Graduates
- For Finance and accounting professionals
- For Management professionals
- For professionals from KPO and BPO domains
- Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value
- Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
- Introduction to Hypothesis Testing
- Introduction to DBMS
- Popular DBMS Software
- Concepts of RDBMS
- Types of SQL Commands
- The course has been developed by ExcelR in collaboration with IBM
- 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
- It offers a curriculum that matches the market requirement with great precision
Business Analyst Certification Course Training at ExcelR Curriculum
Business Statistics
Data Types, Measure Of central tendency, Measures of Dispersion
Graphical Techniques, Skewness & Kurtosis, Box Plot
Descriptive Stats
Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value
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
Imputation Techniques
Scatter Diagram
Correlation Analysis
Advanced Excel
Advanced Excel 'Basic
Customizing the Ribbon
Worksheets
Format Cells
Various selection techniques
Shortcuts Keys
Protecting and un-protecting worksheets
SQL
Introduction to Databases
Databases
Introduction to DBMS
Popular DBMS Software
Concepts of RDBMS
Types of SQL Commands
Data Definition Language
Create, Drop, Truncate, Alter and Rename Objects
Data Query Language
Tableau
What is Data Visualization
Advantages & Disadvantages of visualizations
Age of Big data
Why Data visualization Important
Understanding data
Examples of Data visualizations in Action
Different data visualizations
Principles of Visualizations
Design Principles
Best Practices
Basics Of R
Introduction of R
Data Types
Data Structures
Decision Making Statements
Conditional Loops
Flow Control Statements
If Statements
For loops
While Loops
Built Functions in R : Base, datasets, dplyrand ggplot
Basics Of Python
Introduction to Python
Introduction to Python & Data Science Python Installation on laptops
Python Basics -Variables -Python Build in functions -Modules -Python Libraries installation using PIP
Python Basics -Python Operators
Python Basics -Flow Control Statements -If Statements -While Loops
Python Basics -Data & time modules in python -Interfaces in Python -For Loops
Power BI
Introduction
Introduction to PowerBIPreview
Download the Training Data Files
Introduction to Signing Up for Power
Signing up for PowerBIPreview
Load Data into the Power BI Service Preview
Practical Activity
Other courses offered by ExcelR
Student Forum
Anything you would want to ask experts?
Business Analyst Certification Course Training at ExcelR Contact Information
#49, 1st Floor, 27th Main,
1st Cross, Behind Tata Motors,
BTM 1st stage
Bangalore ( Karnataka)