Business Analyst With Advance Excel
User Avatar By admin
Modular Courses

Business Analyst With Advance Excel

  • 0

  • meta-icon 0 Lessons
  • meta-icon 0 Students
User Avatar

Business Analyst With Advance Excel

4 Weeks
0 lessons
0 quizzes
0 students

Business Analyst With Advance Excel


1. Introduction to Business Analysis:

  • Introduction to Business Analysis
  • Business Analysis Overview & Origin.
  • What is Business Analysis?
  • Who is a Business Analyst (Functions).
  • Types of IT companies.
  • IT hierarchy.
  • Stakeholders and types of Stakeholders.
  • Business Analyst Prerequisites.
  • Roles and Responsibilities of a BA.
  • Do’s and Don’ts of a B


2. Requirement Planning

  • Introduction to Requirements Planning
  • Identifying Stakeholders
  • Stakeholder Management
  • RACI Matrix
  • Defining roles and responsibilities
  • Types of requirements
  • Business Analysis


3. Requirement Analysis

  • Pareto analysis
  • Fishbone analysis
  • SWOT analysis
  • GAP analysis
  • Feasibility study
  • Analyse Current State
  • Define Future State
  • Business case writing
  • Project Objective
  • Project Background
  • Project Driver

4. Requirement Documentation

  • Importance of Documentation
  • Business Requirements Document (BRD)
  • Functional Requirements Document (FRD)
  • Software Requirements Specification (SRS)
  • Scope of Work Document (SoW)
  • Requirements Traceability Matrix (RTM)
  • Work Breakdown Structure (WBS)
  • Use Case Document


5. Business Statistics

  • Descriptive Statistics
  • Data Types, Measure Of central tendency, Measures of Dispersion
  • Graphical Techniques, Skewness & Kurtosis, Box Plot Probability, and Normal Distribution
  • Random Variable, Probability, Probability Distribution, Normal Distribution, SND, Expected Value
  • Inferential Statistics
  • 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 Chi-square
  • Data cleaning and Insights
  • Data Cleaning(Invalid cells,Blanks,Outliers,Null values)
  • Imputation Techniques(Mean and Median)
  • Scatter Diagram
  • Correlation Analysis


6. Advanced Excel

  • Introduction to Excel: Quantum of Excel and Basics
  • Workbook, Types of workbooks and their uses(XLSX,XLS, CSV,XLSM, and XLSB)
  • Common uses of Excel Cell, Row, Column, Range/Array, Name box
  • Formatting of cells(Wrap Text, Number, Text, Cell formatting ,commenting,etc)
  • Ribbon, Formula bar, Status bar
  • Basic operators(+,-,/,*,%,>,<,>=,<=,( ),{ },[ ],&,’ ‘, “” “”,!) Introduction to Functions: Commonly used Excel Functions
  • What is syntax,arguments(Optional,Mandatory)Navigations using keyboard,shortcuts
  • Sum, Average, Max, Min, Product CountBlank, CountA, CountIF, If, Now, Today
    Cut, Copy, Paste, Paste Special
  • Anchoring data: Referencing, Named ranges and their uses Absolute, Relative, Mixed
  • Name Manager, Named ranges, Creating Tables
  • Create functions using named ranges AND/OR referencing
  • Referring data from different tables: Various types of Lookup, Nested IF
  • Lookup, Vlookup, Nested Vlookup, Hlookup, Index, Index with Match function
  • If with a combination of AND/OR(multiple ways to get the output),IFERROR
  • Referring data from different tables: Advanced functions • RANK, RAND, RANDBETWEEN, INDIRECT with ADDRESS &MATCH, OFFSET
  • Data Handling: Data cleaning, Data type identification, Data restrictions
  • Data validation, Depended on the drop-down, Protecting cell, Array, range, sheet, Workbook
  • Data Handling: Formatting and Filtering
  • Conditional formatting(Icon sets/Highlighted color sets/Data bars/custom formatting), Sort,Advanced Sort,Filtering
  • Data Summarization: Advanced functions, Charts
  • Sum, Average, Max, Min with IF and IF’S, CountIF’S
  • Various types of Charts
  • Data Summarization: Pivots, Preparing the Dashboard
  • Pivot table, Slicers, Pivot charts, Calculated field, Calculated item, ADD/REMOVE/CHANGE data into the pivot table, Refreshing pivot data
  • Dashboard creation
  • Power query, power pivot
  • Cleaning data, extracting data from multiple sources
  • Transforming data, imputation techniques.Getting data from CSV files, databases, workbooks, and webpages
  • Power query, power pivot, Use case discussion: Data Preparation, Project Summarization
  • Consolidating data from multiple sources, merging data from different workbooks/worksheets, and relationships.
  • Use Data handling steps taught in the previous session, Use Data summarization  techniques, Populate output in Excel, Combine multiple functions
  • Intro to Automation:Macros(Recorded /VBA)
  • How VBA works, Record a sample macro(Recording macros, Absolute mode,relative mode, different methods of executing macros)
  • VBA
  • If constructs, Select construct, User defined functions, input box, message box, procedures,automatic macros, methods to clean up the codes


7. Tableau:

  • Intro to Tableau Tool
  • What is data, Types of Data(Structured, Unstructured, Semi Structured), Visualization basics, Different visualization tools, Popularity of the tools, Licencing Cost, Different products of Tableau, Installation (student id),  Connecting to Static files, Mysql
  • Data pane window
  • Live Vs Extract, Data source window, Navigating to worksheet, Data pane,Analytics pane, Dimensions, Measures, Auto-generated fields,Data visualization window explaination, Data source window operations
  • Groups, Sets, Parameters
  • Hierarchy(Inbuilt hierarchy, Manual), Grouping, Sets, Parameter with filters and Parameter with Sets, Usage of measure names and Measure Values
  • Filters in Tableau
  • Dual axis, Blended axis, Dimension filters, Measure filters(Record level filters, summary level filters), Date filters, Cascading Filters, Context filters, Data source filters, Extract filters
  • Calculated fields
  • Quick table calculations,  Introduction to calculated fields, string calculated fields, Number calculated fields, date calculated fields, logical calculated fields,ZN Function
  • Data Blending and Joins
  • Mixing up of all calculated fields, Conditional Formatting in Tableau, Data blending,Data joins, Unions, Relationships, Basic Charts, and use cases, Introduction to Show me, Development of Inbuilt charts part1
  • Charts in Tableau
  • Development of inbuilt charts part2,Customized graphs(Donut, Waterfall,Bump,Barometer,Butterfly,Gauge meter,Basic Funnel, Advanced Funnel,Word cloud,Gantt Bar),Animated Chart
  • Reference lines, Bands, Distributions
  • Arbitrary formatting, explanation of Marks Card, Reference lines, Reference
    Bands, Reference Distribution
  • LODs, Intro to Dashboard, Story
  • Forecasting, Introduction to Dashboard, Storyboard interfaces, LODs (Fixed, Include, Exclude)
  • Creating a Dashboard
  • Creating a Basic Dashboard with both Tiled, Floating layouts, Explanation of
    objects in the Dashboard interface, Action filters on Dashboards
  • Creating an Advanced Dashboard
  • Advanced level dashboard(Drill down dashboards), Designing of Basic Storyboard
  • Tableau public server
  • Publishing Dashboards on Tableau public server, Exposure to the websites which
    consists of real-time data, Interview cracking resources, introduction to Tableau


Write a comment

Your email address will not be published. Required fields are marked *


  • 0
  • 0
  • 0 students
  • 4 weeks
  • Expert
  • English
Share Now :
[forminator_form id="7879"]

This will close in 20 seconds