Manjinder Software Test Engineer and Interview Preparation
No reviews yet

• CA$1000
• Duration: 25 hours
• Delivery mode: Online
• Group size: Individual
• Instruction language: English
• Certificate provided: Yes

POWER BI COURSE CONTENT:

Topic Content Covered Hours

Definitions *ETL, Queries, Visuals,
*Row Context and Filter
Context
*Fact table and Dimensions
table

1 Hour

Transform Data *Get Data, Power query, first
row headers, change column
data type
*Remove or keep rows/col
*Split col, extract, merge col
*Perform number funx and date
functions on cols
*Pivot or unpivot columns
*Replace values or errors,
remove duplicates, clean/trim
col
*Custom col from examples,
add custom col or conditional
col
*Column quality, col
distribution and col distribution
*merge queries and append
queries.

5 to 6 hours

Data Model * Many to many,
*One to many
*many to one
*one to one
*Row and Filter context revise

1 hour

DAX functions *Definition of measures and

calculated cols
*Arithmetic function
*text Functions
* Calculate and filter function
*ALL(), AllEXCEPT() and
KEEPFILTERS() function
*Rank and rankx() Function
*Conditional functions
*Time Intelligence function

6 to 6:30 hours

Report building *Create Chart,

*Types of charts based on the
info to be analysed
*Formatting Canvas and charts
* Drill down and drill through

4 to 5 hours

• CA$1000
• Duration: 40 hrs
• Delivery mode: Online
• Group size: Individual
• Instruction language: English
• Certificate provided: Yes

Business Analysis Fundamentals
What is a Business Analyst and what value do they provide?
Broad Responsibilities of a Business Analyst
Types of Business Analyst Roles
Top Business Analyst Skills
Validate Understanding of the Basics

Software Development Life Cycle
Case Study – Telecom Service Provider
Why Software Required?
Software Development Lifecycles (SDLC)
SDLC Phases
SDLC Live Use Case
High Level Design
Low Level Design
Quiz - SDLC
Learning Content & Interview Questions

Testing Techniques
Assignment Review, Teach back & Mock Interview
What is Black-Box Testing
Equivalence Partitioning
Boundary-Value Analysis
Practical Example of BVA: Finding a defect in a live project
Important Notes About EP & BVA
Quiz - EP & BVA
Decision Table Testing
State-Transition Testing
Home Assignment
Learning Content & Interview Questions

SDLC Models
Assignment Review, Teach back & Mock Interview
SDLC - Different Models
Waterfall Model
V-Model (Verification & Validation)
Agile Overview
Quiz - SDLC Models
Home Assignment
Learning Content & Interview Questions

Agile Framework Overview
Assignment Review, Teach back & Mock Interview
Agile 4 Values
Whole Team Approach
Vision, User Stories
Product Backlog & Sprint Backlog

Ceremonies in Agile
Sprint Grooming
Sprint Planning
Daily Scrum Meeting
Sprint Review
Sprint Retrospective
Home Assignment
Learning Content & Interview Questions

Trello - Project Management Tool
Assignment Review, Teach back & Mock Interview
What is Trello?
Setting Up Trello
Live Activity using Trello
Home Assignment
Learning Content & Interview Questions

Live Project HCM Overview
Assignment Review, Teach back & Mock Interview
Discussion on LIVE Project Flow
Client Requirements
Software Requirement Document (SRS)
Home Assignment
Learning Content & Interview Questions

Initiating a Project
Activity: Begin to think logically - Solution and Explanation
Understanding the Business Objective
Creating a Business Case
What is a Stakeholder and How to Identify Them
Assigning Responsibilities to Stakeholders using a RACI Matrix

Requirement Basics
Overview of Requirements
SMART Requirements
SMART Requirements Clarification
Tips for Producing Valid Requirements
Phases of the Requirements Process
Business Rules

Requirement Elicitation
Requirement Elicitation Basics
Elicitation Technique: Brainstorming
Elicitation Technique: Requirement Workshops
Elicitation Technique: Interviewing
Elicitation Technique: Surveys
Elicitation Technique: Documentation Review
Elicitation Technique: Analyzing Interfaces

Requirement Analysis
Introduction to Requirement Analysis
Visual Modeling Concepts
Business Models
Technical Models
BPMN vs UML
Engaging Your Technical Team

Requirement Specification
Introduction to Requirement Specification
Categorizing Requirements
Deriving Requirements
Assigning Requirement Attributes
Prioritizing Requirements
Prioritizing Requirements Example
Validating Requirements
Business Requirements Document (BRD)

Requirements Approval
Introduction to Requirements Approval
Gaining the Business Approval
Gaining the Technical Approval
Gaining Sponsor or Committee Approval

After the Project
Conducting a Project Review
Verifying the Completion of a Project

Azure DevOps Walkthrough
DevOps Walkthrough
Live Project delivery using DevOps
Activity - Planning Poker
Create and Assign Work Item
Home Assignment
Learning Content & Interview Questions

Live Project Delivery using Agile
Live Workshop

Testing Types
Black Box Testing
White Box Testing
Smoke Testing
Regression Testing
Sanity Testing
UAT Testing
Alpha/Beta Testing

Defect Management
What is Bug?
Bug Life Cycle
Differences between Severity and Priority
Screenshot & Recording to Report a Defect

SQL – Database Testing
Assignment Review, Teach back & Mock Interview
What is SQL?
SELECT Command
DISTINCT, IN, Not IN
SUM, AVG, MIN, MAX
DDL, DQL, and DML Commands
LIKE, ORDER BY, GROUP BY, and HAVING
Quiz - SQL
Home Assignment - I
Learning Content & Interview Questions
Assignment Review, Teach back & Mock Interview

SQL – Database Testing
INNER JOIN
FULL JOIN
RIGHT JOIN
LEFT JOIN
CROSS JOIN
SELF JOIN
Home Assignment - II
Learning Content & Interview Questions
Assignment Review, Teach back & Mock Interview
CREATE, ALTER, DROP Table
UPDATE Table
INSERT INTO Table
Difference between DELETE, TRUNCATE & DROP Commands
Home Assignment - III
Learning Content & Interview Questions

Interview Preparation