ExcelR
ExcelR Logo

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 External Link Icon

    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
    Details Icon

    Business Analyst Certification
     at 
    ExcelR 
    Course details

    Who should do this course?

    Finance and accounting proffesionals

    Management proffesionals

    Proffesionals from any domain who have logical and analytical skills

    More about this course

    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

    Requirements for 12th gradeUp Arrow Icon
    • N/A
    GraduationUp Arrow Icon
    • N/A

    Business Analyst Certification
     at 
    ExcelR 
    Admission Process

      Important Dates

      Dec 13, 2024
      Course Commencement DateOngoing

      Other courses offered by ExcelR

      40 K
      160 hours
      – / –
      – / –
        – / –
      – / –
      – / –
      38 K
      6 months
      – / –
      – / –
        – / –
      – / –
      86 K
      View Other 40 CoursesRight Arrow Icon
      qna

      Business Analyst Certification
       at 
      ExcelR 

      Student Forum

      chatAnything you would want to ask experts?
      Write here...

      Business Analyst Certification
       at 
      ExcelR 
      Contact Information

      Address

      #49, 1st Floor, 27th Main,
      1st Cross, Behind Tata Motors,
      BTM 1st stage

      Bangalore ( Karnataka)

      Go to College Website ->