Business & Data Analysis Training

Live Training Sessions To Learn Business & Data Analysis From Our Skillup Online Academy

More than ever before, companies are relying on business analysis and data to make business decisions. The Business & Data Analyst course equips you with the skills needed to be the bridge between the product onwers and stakeholders using modern tools to visualize data and make decisions from them. Without business and data analysis, new industry trends in Tech and product development would have stay undiscovered. In order to determine business goals, more and more companies are looking for analysts to fill in the gaps. Business and Data Analysis is now one of the fastest-growing and sectors of the tech industry.

Why Opt For The Business & Data Analyst Course?

- Access to a structured learning approach

- Learn the most popular Business Analytics tools

- The opportunity to work in just about any industry

- Learn to apply theoretical concepts to business problems

- Gain problem solving skills

- Multiple Specializations Options

- Ability to Make a Difference

- Required in Every Industry

Course Outline

MODULE 1 - BUSINESS ANALYSIS

a. Business Analysis Fundamentals

- The Basics
- Software Development Lifecycles
- Initiating A Project
- Requirement Basics
- Requirement Elicitation, Analysis, Specification & Approval
- Section Review

b. Agile Fundamentals: Scrum, Kanban, and Scrumban

- Understanding Agile
- Scrum Methodology
- Estimating in Agile
- Kanban Methodology
- Scrumban Methodology
- Section Review

c. Identifying and Defining the Problem with Business Analysis

- Problem Identification
- Problem Identification Techniques
- Making Things Practical + Root Cause Analysis
- Determining Value
- Project Proposal + Gaining Approval
- Section/Case study Review

d. Conduct A Strategy Analysis

- Project Basics
- Analyze the Current State
- Define the Future State
- Assess Risks
- Determine a Strategy
- Create a Business Case
- Sample Project Case Study
- Section/Case study Review

e. Plan The Project

- Initiate the Project Plan
- Create a Requirements Management Plan
- Define the Project Plan Details
- Conduct Stakeholder Analysis & Engagement
- Set Performance Measures
- Section/Case study Review

f. Understand and Elicit Requirements

- Understand and Elicit Requirements
- Requirements, Digging Deeper
- The Building Blocks of Requirement Elicitation
- Stakeholder Perspective
- Requirement Elicitation Process
- Requirement Elicitation Techniques
- Requirement Elicitation: Document Analysis
- Observation, Brainstorming, Surveys, Interviews & Requirement Workshop
- Section/Case study Review

g. Agile Business Analysis in Scrum

- Introduction to Agile Business Analysis
- Intro to Agile
- Horizons of Analysis
- Agile BA techniques - Strategy Horizon
- Agile BA techniques - Initiative Horizon
- Agile BA techniques - Delivery Horizon
- Facilitation skills of a BA
- Section/Case study Review

h. User Story Master Class

- Introducing User Stories
- Acceptance Criteria
- Write Better Stories with INVEST
- Non-User Stories
- Estimating
- Splitting User Stories
- Common Challenges
- User Story Mapping
- User Story - Final Activities
- Section/Case study Review

i. Essential Modeling Skills & Techniques

- Process Flowcharts
- SWOT Analysis
- Use Cases
- User Stories
- Stakeholder Maps
- RACI Matrices
- Scoring Matrices
- Organizational Charts
- Section/Case study Review

j. Essential Process Flowcharts

- Process Flowcharts
- Breaking Down the Process Flowchart: The Basics
- Process Mapping Tool: Draw.io or Microsoft Visio
- Beyond the Basics: Additional Symbols
- Creating a Swimlane Process Flowchart
- Enhance your Flowchart with Levels
- Section/Case study Review

MODULE 2 – DATA ANALYSIS

a. Excel Fundamentals

- How Excel is important to businesses
- Understanding the Excel Interface
- Basic Formatting in Excel
- Insertion and Deletion in Excel
- Data Types in Excel
- Applying the sort function
- Applying the advanced filter function
- Using the UPPER, LOWER and PROPER functions
- Using the LEFT, RIGHT and SEARCH function
- Using the TRIM, CONCAT and LEN functions
- Using the MIN, MAX AVERAGE functions
- Finding the Standard deviations
- Find the percentiles of data
- Finding the Outliers present in data
- Finding the Missing values in data
- Using the IF ERROR function
- Applying the COUNTIF function
- Applying the SUMIF function
- Applying the AVERAGEIF function

b. Excel for Data Analysis

- Applying VLOOKUP function
- Quiz on Lookup Functions
- Exercise on Lookup Functions
- Why to use Index and Match?
- Applying Index and Match
- Exercise on Index and Match Functions
- Making Pivot Charts
- Exercise on Pivot Tables
- Basics of Data Visualizations
- Making Dashboards
- Adding Slicers in Dashboards
- Formatting dashboards
- Goal Seek Analysis
- Data Tables
- Scenario Management
- Understanding Regression

c. SQL Introduction

- Introduction to SQL
- Building your first SQL query
- Basic SQL queries Part - 1
- Basic SQL queries Part – 2
- Section Exercise
- Installation of MySQL
- Interface walkthrough
- Creating Required Databases
- Type of SQL Commands
- Numerical Functions
- String Functions
- The Having Clause
- Filtering using the Like Operator

d. SQL Essentials

- Numerical Datatypes
- String Datatypes
- Exercise on DDL
- Creating Databases and Tables
- Alter, Drop, and Truncate
- Insert, Update, and Delete
- Joins
- Left, Right, and Outer Join
- Compound Joins, and Multiple Joins
- Star Schema
- Sub Queries Part 1
- Sub Queries Part 2
- Connecting MySQL through Python
- Loading Tables into a Pandas DataFrame

e. Python Fundamentals

- Why should you learn Python?
- Installing Python and Jupyter Notebook
- Understanding the Interface of Jupyter Notebook
- Naming Convention for variables
- Built-in Data Types and Type Casting
- Scope of Variables
- Arithmetic and Assignment Operators
- Comparison, Logical, and Bitwise Operators
- Identity and Membership Operators
- String Formatting
- String Methods
- If, elif, and else
- For and While

f. Python for Data Analysis

- Introduction to datetime
- The date and time class
- Meta Characters for Regular Expressions
- Built-in Functions for Regular Expressions
- Special Characters for Regular Expressions
- Sets for Regular Expressions
- Array Creation using Numpy
- Mathematical Operations using Numpy
- Built-in Functions in Numpy
- Reading Datasets using Pandas
- Plotting Data in Panda (Matplotlib)
- Indexing, Selecting, and Filtering Data using Pandas
- Merging and Concatenating DataFrames
- Lambda, Map, and Apply Functions
- Section Excercises

g. Tableau Fundamentals

- Getting Started with Tableau
- Navigating Tableau
- Creating Your First Visualization
- Building Your First Dashboard
- Introduction
- Green & Blue Pills
- Measures Names & Values
- Working with Time Series Data
- Aggregation and Granularity
- Aggregation Options
- Show Me Toolbar
- Marks cards & Level of Detail
- Custom Shapes
- Filtering Data
- Pages Shelf
- Exercise on Building Blocks of Data Visualization
- Highlight Table
- Highlight Table Bar Charts & Sorting
- Histogram
- Pie Charts
- Pie Chart Exercise Solution
- Tree Map
- Line Charts
- Area Chart
- Theme & Workbook Level Formatting
- Axis Lines and Formatting
- Parts of the View
- Formatting Pane - Part 1
- Formatting Pane - Part 2 (Fonts, Alignment & Shading)
- Formatting Pane - Part 3 (Borders & Lines)
- Number Format
- Titles & Captions
- Mark Labels
- Styling and Customizing a Tooltip
- Visualization in Tooltip
- Editing Axis
- Annotating the Viz
- Section Exercise - Data Ink Ratio
- Section Exercise Solution - Data Ink Ratio

Course Outcomes:

· Provide solutions, assessments and validation to a broad range of situations by eliciting, planning, monitoring and analyzing enterprise requirements.

· Demonstrate effective use of written, verbal, and non-verbal communication, employing relevant knowledge, skills, and judgment in a business setting.

· Document, manage, research and communicate business requirements from the initial stakeholder meeting, to the final solution assessment and validation phase.

· Perform a variety of quality control procedures including gap analysis, problem analysis, needs assessment, cost benefit analysis, business test plans and test cases.

· Collect, manage, and interpret data to identify trends and issues in the workplace to create, and develop levels of measure.

· Design, develop, implement, and maintain levels of measurement, accurate statistics, requirements lists and constraint documents.

· Load, explore, clean, analyze and plot data using Python, SQL and Excel

· Practice using various Python libraries

Skills Set Developed At The End Of The Online Business & Data Analyst Course

· Requirement Elicitation

· Visual Modeling

· Agile Business Analysis

· Project Management

· Basic data analysis in Python, Excel and MySQL

· Experience with NumPy, matplotlib, and pandas,

FAQs