Business Analyst Certification offered by ExcelR
Business Analyst Certification at ExcelR Overview
Duration | 6 months |
Start from | Starts today |
Total fee | ₹75,999 |
Mode of learning | Online |
Official Website | Go to Website |
Credential | Certificate |
Business Analyst Certification at ExcelR Highlights
- Earn a certificate after completion of course
- 15+ Hours of Immersive Training at IIT Madras for 2 days
- Interactive sessions by professors of IIT
Business Analyst Certification at ExcelR Course details
Finance and accounting proffesionals
Management proffesionals
Proffesionals from any domain who have logical and analytical skills
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 profitability to great heights
Being one of the pioneers of upskilling learners in the Business Analytics field, ExcelR has come up with a curriculum that matches the market requirement with great precision
Business Analyst Certification at ExcelR Curriculum
Excel: Basics to Advanced
Introduction
Referencing, Named ranges,Uses,Arithemetic Functions
Logical functions
Referring data from different tables: Various types of Lookup, Nested IF
Advanced functions
Date and Text Functions
Data Handling,Data cleaning, Data type identification, Remove Duplicates, Formatting and Filtering
VBA and Macros
MySQL
Introduction to Mysql
SQL Commands and Data Types
DQL & Operators
Case When Then and Handling NULL Values
Group Operations & Aggregate Functions
Constraints
Joins
DDL
DML & TCL Commands
TCL
Indexes and Views
Stored Procedures
Function, Constructs
Union, Intersect, Sub-query
Exception Handling
Triggers
Tableau
Introduction to Tableau
Basic Charts & Formatting
Filters
Calculations
Data Combining Techniques
Custom Charts
Groups, Bins, Hierarchies, Sets, Parameters
Analytics & Dashboard
Dashboard Actions & Tableau Public
Power BI
Power BI Introduction and Installation
The Power BI user interface, including types of data sources and visualizations
Sample dashboard with Animation Visual
Power BI artificial intelligence Visual
Power BI Visualization
Power Query Editor
Modelling with Power BI
Power Query Editor Filter Data
Customize the data in Power BI
Business Statistics
Descriptive Statistics
Probability and Normal Distribution
Inferential Statistics
Data cleaning and Insights
Business Analyst Certification at ExcelR Entry Requirements
Business Analyst Certification at ExcelR Admission Process
Important Dates
Other courses offered by ExcelR
Student Forum
Business Analyst Certification at ExcelR Contact Information
#49, 1st Floor, 27th Main,
1st Cross, Behind Tata Motors,
BTM 1st stage
Bangalore ( Karnataka)