Private - IT and Software Skills for Business Analysts (2 Days)
About course

This course is designed to equip the Business Analyst (BA) with skills necessary to perform effectively as the conduit between two worlds - the business with the need/the users of the end result, and the developers that will actually design, build and implement the IT solution. In order to be successful in the role of an interpreter/translator, the BA must be able to speak the languages of both sides. This course looks at SQL, the history of computing, the Web environment, and general IT terms to enable the BA to think in terms of the technical team’s position and knowledge. 

The second part of this course deals with the software packages and associated skills that are needed for the Business Analyst to be truly effective on a project team. Word processors, spreadsheets and drawing tools are examined, focusing on critical and often overlooked functionality than will prove to be highly useful in IT project work.

Who should attend

This course will benefit business analysts, executives, functional managers, project managers and programmers interested in expanding their effectiveness, and any other individuals involved in IT project work. While not mandatory, it is recommended that students in this class bring their own laptop computers with Microsoft Access® for use with class exercises.

Course features

Through instruction, dialog, real-world examples and exercises, upon completion of this course you will: 

  • Understand the role that a BA must play while working with the technical staff 
  • Be able to use elements of Structured Query Language to perform basic queries 
  • Possess an understanding of computer processing, programming and program flow control 
  • Understand the basic history and structure of the web development environment 
  • Comprehend the methods and terms involved in software configuration management and version control
Course outline

The Technical Role of the BA 

  • Definition of Business Analysis 
  • Why Learn Technical Skills? 
  • Role of the Technical Team 
  • Technical Teams 

Structured Query Language 

  • Relational Database Concept 
  • SQL Components 
  • Basic Queries 
  • Table Joins 
  • Database Structures 

Web Applications 

  • History and Evolution 
  • Pieces of the Web Environment 
  • Stateless Nature of the Web 

Configuration Management 

  • Version Control 
  • Concurrent Development 
  • Branching and Merging 

Software Skills 

  • Word Processor Usage 
  • Styles, Tables of Contents, Headers and Other High-Level 

Features of Word Processors 

  • Spreadsheets Usage 
  • Complex Formulas, Transformations and Other High-Level Features of Spreadsheets 
  • Drawing Tool Usage 
  • Hands-on Process Model Exercise
Course information
Duration: 14 hours
Earn: 14 PDUs
Delivery Method: Virtual or Traditional Classroom
Knowledge areas addressed

IIBA® Knowledge Areas Addressed:

  • Elicitation
  • Requirements Management and Communication
  • Requirements Analysis
  • Solution Assessment and Validation