BUSINESS ANALYST OF INFORMATION TECHNOLOGY CERTIFICATE (BA) – (LEA.CM) (AEC, QUEBEC)
Duration in years: 12 months
Placement: Project / internship (included)
Course list:
Introduction to SQL
- Introduction to SQL Server 2012
- Introduction to Transact SQL Querying
- Writing SELECT Statements
- Querying Multiple Tables
- Sorting Data
- Working with SQL Server Data Types
- Using Built-in Functions
- Grouping and Aggregating Data
- Using Subqueries, Table Expressions and Set Operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
Advanced Excel
- Basic functions: quick overview of the most fundamental functions of Excel (sorting, grouping, coloring, formatting)
- Calculations and expressions: IF, Lookup and VLOOKUP, data functions, array functions,
text functions
- Sparklines in Excel
- Pivot tables and pivot charts
- Solver, regressions and what if analysis
- Macros in Excel
- Troubleshooting
- Mini-project
Tableau
- Introduction
- Calculations
- Working with multiple data sources
- Advanced calculations
- Parameters
- Geocoding in Tableau
- Defining subsets
- Statistics and forecasting
- Dashboards / Stories
Introduction to Business Analysis
- Defining the role of a Business Analyst
- The makings of a Business Analyst
- Why become a Business Analyst?
- Structure of a development team
- Position of a Business Analyst in the development team
Requirements Gathering Strategies
- Importance of requirements gathering
- Different types of requirements
- Requirements gathering techniques
- Clarifying JAD sessions
- Role of a BA in JAD sessions
- Preparing JAD sessions’ agendas
- Arranging JAD sessions
- Creating functional requirement documents
- Creating software requirement specifications System Development Life Cycle (SDLC)
- Understanding the concept of business modelling
- Requirement gathering, analysis, design, implementation, testing, and deployment
Use Cases
- Understanding use cases
- Use case relationships
- Use case brainstorming
Exit Certification: Business Analysis certification
Job search workshops are included as a part of the course.
