Business Analyst Training Course in Noida by Uncodemy

Detailed course contents:

• What is Business analyst?
• Scope of Business analyst
• Data for Business analyst
• Decision Models
• Problem Solving and Decision Making

Detailed course contents:

• Examples of Applications
• Visual Perspective of BA
• Impacts and Challenges
• Database Queries and Analysis
• Spreadsheets
• Data Visualisation
• Dashboards to Report Key Performance Measures
• Data and Statistical Methods
• Data Mining (Predictive Models)

• Illustrations
• Charts
• Text

• Sum / Average / Count / Max / Min
• Basic Text / date / time / lookup / information functions
• Name manager
• Formula Auditing

• Import from web
• Import from text
• Text to columns
• Remove duplicates
• Grouping and ungrouping

• Formulae that Add / Subtract / Multiply / Divide
• BODMAS / Formula Error Checking
• The Sum Function

• The VLOOKUP/ HLOOKUP Functions
• Creating, Formatting Simple PivotTables
• Page Field in a PivotTable
• Formatting a PivotTable
• Creating / Modifying a PivotChart

• IFs and Nested IF Functions
• Using AND / OR / NOT Functions
• Using The SUMIF / COUNTIF Functions
• Using The AVERAGE / COUNT / LARGER / SMALLER Functions

• Adding new calculated Fields / Items
• Changing the Summary Function
• Consolidate Pivot table
• MATCH with VLOOKUP Functions
• INDEX & MATCH Functions
• OFFSET / INDIRECT functions

• The Chart Wizard
• Chart Types
• Adding Title / Legends / Labels
• Printing Charts
• Adding Data to a Chart
• Formatting / Renaming / Deleting
• Data Series
• Changing the Order of Data Series

• If Loop and Nested IF Loop Functions
• Using IF / ISERROR Functions

• Using The Today
• Now & Date Functions
• Using The Datedif / Networkdays /
• Eomonth Functions
• Using The Weeknum Functions
• Using The Edate / Networkdays. Intl / Weekdays.Intl Functions

• The Mid / Search / Left / Right Functions
• Using The Trim / Clean / Upper/ Lower Functions
• Using The Substitute / Text Functions
• Using The Trim / Clean / Proper / Dollar Function

• Input Messages / Error Alerts / Drop-Down Lists
• Conditional Formatting
• Extracting Records with Advanced Filter
• Using Formulas in Criteria

• Sorting by Top to Bottom / Left to Right
• Creating / Deleting Custom List
• Sort by using Custom List
• Hyper linking data, within sheet / workbook
• Linking & Updating links between workbooks & application

• Importing Data from Database / Text Files / Web
• Exporting Data
• Changing External Data Range

• Displaying / Removing Dependent & Precedent Arrows
• Evaluate Formula – Step IN / Step Out
• Creating Custom Views
• Displaying Custom Views
• Deleting Custom Views

• Introduction to Databases
• How to create a Database instance on Cloud?
• Provision a Cloud hosted Database instance.
• What is SQL?
• Thinking About Your Data
• Relational vs. Transactional Models ER Diagram
• CREATE Table Statement and DROP tables
• UPDATE and DELETE Statements
• Retrieving Data with a SELECT Statement
• Creating Temporary Tables
• Adding Comments to SQL

• Basics of Filtering with SQL
• Advanced Filtering: IN, OR, and NOT
• Using Wildcards in SQL
• Sorting with ORDER BY
• Math Operations
• Aggregate Functions
• Grouping Data with SQL

• Using Subqueries
• Subquery Best Practices and Considerations
• Joining Tables
• Cartesian (Cross) Joins
• Inner Joins
• Aliases and Self Joins
• Advanced Joins: Left, Right, and Full Outer Joins
• Unions

• Working with Text Strings
• Working with Date and Time Strings
• Date and Time Strings Examples
• Case Statements
• Views
• Data Governance and Profiling
• Using SQL for Data Science

• How to access databases using Python?
• Writing code using DB-API
• Connecting to a database using DB API
• Create Database Credentials
• Connecting to a database instance
• Creating tables, loading, inserting, data and querying data
• Analysing data with Python

• What is Tableau ?
• What is Data Visulaization ?
• Tableau Products
• Tableau Desktop Variations
• Tableau File Extensions
• Data Types, Dimensions, Measures, Aggregation concept
• Tableau Desktop Installation
• Data Source Overview
• Live Vs Extract

• Overview of worksheet sections
• Shelves
• Bar Chart, Stacked Bar Chart
• Discrete & Continuous Line Charts
• Symbol Map & Filled Map
• Text Table, Highlight Table
• Formatting: Remove grid lines, hiding the axes, conversion of numbers to thousands, millions, Shading, Row divider, Column divider
• Marks Card

• What are Filters ?
• Types of Filters
• Extract, Data Source, Context, Dimension, Measure, Quick Filters
• Order of operation of 􀏐ilters
• Cascading
• Apply to Worksheets

• Need for calculations
• Types: Basic, LOD's, Table
• Examples of Basic Calculations: Aggregate functions, Logical functions, String functions, Tablea calculation functions, numerical functions, Date functions
• LOD's: Examples
• Table Calculations: Examples

• Dual Axis
• Combined Axis
• Donut Chart
• Lollipop Chart
• KPI Cards (Simple)
• KPI Cards (With Shape)

• What are Groups ? Purpose
• What are Bins ? Purpose
• What are Hierarchies ? Purpose
• What are Sets ? Purpose
• What are Parameters ? Purpose and examples

• Reference Lines
• Trend Line
• Overview of Dashboard: Tiled Vs Floating
• All Objects overview, Layout overview
• Dashboard creation with formatting

• Introduction to Power BI – Need, Imprtance
• Power BI – Advantages and Scalable Options
• Power BI Data Source Library and DW Files
• Business Analyst Tools, MS Cloud Tools
• Power BI Installation
• Power BI Desktop – Instalation, Usage
• Sample Reports and Visualization Controls
• Understanding Desktop & Mobile Editions
• Report Rendering Options and End User Access

• Report Design with Databse Tables
• Report Visuals, Fields and UI Options
• Reports with Multiple Pages and Advantages
• Pages with Multiple Visualizations. Data Access
• “GET DATA” Options and Report Fields, Filters
• Report View Options: Full, Fit Page, Width Scale
• Report Design using Databases & Queries

• Power BI Design: Canvas, Visualizations, and Fileds
• Import Data Options with Power BI Model, Advantages
• Data Fields and Filters with Visualizations
• Visualization Filters, Page Filters, Report Filters
• Creating Customised Tables with Power BI Editor
• General Properties, Sizing, Dimensions, and Positions
• Page Level Filters and Report Level Filters
• Visual-Level Filters and Format Options
• Report Fields, Formats and Analytics

• CHART Report Types and Properties
• STACKED BAR CHART, STACKED COLUMN CHART
• CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
• Field Properties
• Formats: Legend, Axis, Data Labels, Plot Area
• Data Labels: Visibility, Color and Display Units
• Analytics: Constant Line, Position, Labels
• Map Reports: Working with Map Reports
• Hierarchies: Grouping Multiple Report Fields
• Advanced Query Mode @ Connection Settings – Options

• Purpose of Data Analysis Expresssions (DAX)
• Scope of Usage with DAX. Usabilty Options
• DAX Context : Row Context and Filter Context
• DAX Entities : Calculated Columns and Measures
• DAX Data Types : Numeric, Boolean, Variant, Currency
• Datetime Data Tye with DAX. Comparison with Excel
• DAX Operators & Symbols. Usage. Operator Priority
• Parenthesis, Comparison, Arthmetic, Text, Logic
• DAX Functions and Types: Table Valued Functions
• Filter, Aggregation and Time Intelligence Functions
• Information Functions, Logical, Parent- Child Functions
• Statistical and Text Functions. Formulas and Queries
• Syntax Requirements with DAX. Differences with Excel
• Naming Conventions and DAX Format Representation
• Working with Special Characters in Table Names

• Data Types, Measure Of central tendency, Measures of Dispersion
• Graphical Techniques, Skewness & Kurtosis, Box Plot

• Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value

• Sampling Funnel, Sampling Variation, Central Limit Theorem, Con􀏐idence interval
• Introduction to Hypothesis Testing
• Hypothesis Testing (2 proportion test, 2 t sample t test)
• Anova and Chisquare

• Data Cleaning(Invalid cells,Blanks, Outliers,Null values)
• Imputation Techniques(Mean and Median)
• Scatter Diagram
• Correlation Analysis

• Project De􀏐inition
• Difference Between Traditional & Agile Project Mgmt.
• Agile Manifesto and Principles
• Agile Methodology
• Agile Principles
• Agile Frameworks and Terminology

• Product Roadmap
• Product Backlog
• Story Maps
• Agile Modeling
• Wireframes
• Charting

• Iteration and Release Planning
• Progressive Elaboration
• Time Boxing
• Cumulative Flow Diagram
• Kanban Boards
• WIP Limits
• Burn Charts

• What is Jira?
• Uses of Jira
• Jira Key Terms
• Features of JIRA
• JIRA Scheme
• JIRA Projects

• How to install JIRA
• Creating Projects
• Adding Users in JIRA
• Managing JIRA dashboard and Gadgets
• create epics
• features in JIRA
• create user stories
• Epic vs Feature vs user stories
• Sprint planning
• Start sprint
• sprint in JIRA