training

Business Cum Data Analyst

Comprehensive Data Analyst (Business Analyst) with ETL and BI Background

  • Tool : Oracle SQL Developer with Informatica and Cognos
  • Database : Oracle
  • Duration : 50-60 hrs

  • Session: I - Basics on Database and Unix

    Coverage

    1. RDBMS Basics
    • Data Storage Structures
    • Relationship between tables
    • Various Entities used in RDBMS
    2. Basic UNIX OS Operations
    • Basic Line level commands
    • Scanning Log files and Param Files
    • Searching for a files and text
    3. Basics Data Exploration and analysis commands
    • Selection of data from tables
    • Joins and Indexes
    • Aggregation and Analytical functions

  • Session: II - Process and Project Execution

    Coverage

    1. Project Execution Methodology
    • SDLC
    • Agile
    • Stakeholders
    2. Domain details
    • Basics of Financial Domain
    • Lines of Business and their functions

  • Session: III - Data/Business Analysis

    Coverage

    1. Business/Data Analyst | Roles and Responsibilities
    • Understanding Business (Requirements)
    • Roles are Responsibilities
    2. Data Model
    • Various types of Modelling
    • Levels in Data Modelling
    • Defining Relationships

  • Session: IV - Advanced Data Analysis (ETL)

    Coverage

    1. ETL Concepts
    • Data Mapping & Data Profiling
    • Surrogate Key
    • Change Data Capture
    • Loading data into Integration and Semantic
    • Load Process

  • Session: V - Advanced Data Analysis (BI)

    Coverage

    1. Repot types
    • Tabular Report
    • Cross-tab Reports
    • Dashboards
    • Active Reports
    • Drill down Reports
    2. Data Storage and Processing
    • Cubes (Static and Dynamic)
    • Framework manger
    • Joins and transformations
    • Most frequently used operations

  • Session: VI - On the ground Experience

    Coverage

    1. Approach to an actual project
    • Walk-through on real world projects and their approach
    2. Examples and scenarios from other real projects
    • Taking a project use case and deriving a solution out of it

Besides the course training, INTERVIEW-SPECIFIC training will be given to the associate focusing towards placement. Conditional assistance will be provided to the candidate during his first 2 weeks on job.