Business Analyst

Jira Module

The Jira Module is designed to help learners master project management, Agile methodologies, and workflow automation using Jira. This module covers project setup, issue types, workflows, Scrum and Kanban boards, sprint planning, epics, user stories, advanced JQL (Jira Query Language), dashboards, reports, automation rules, permissions, and user management. Learners will also explore integrations with tools such as Confluence, Bitbucket, GitHub, and CI/CD platforms. Through hands-on exercises and real-world projects, participants will gain practical experience in managing software development and business processes efficiently. By the end of this module, learners will be able to configure, customize, and administer Jira, enabling them to streamline team collaboration, optimize workflows, and successfully manage Agile projects in enterprise environments.

Confluence Module

The Confluence Module is designed to help Business Analysts create, organize, and manage project documentation effectively. This module covers creating and managing spaces, pages, templates, meeting notes, business requirements documents (BRDs), functional requirement documents (FRDs), user stories, acceptance criteria, process documentation, and knowledge repositories. Learners will also explore collaboration features, version control, page permissions, macros, and seamless integration with Jira for Agile project management. Through hands-on exercises and real-world business scenarios, participants will gain practical experience in documenting requirements, collaborating with stakeholders, maintaining project knowledge, and ensuring clear communication across cross-functional teams. By the end of this module, learners will be able to use Confluence as a central platform for business analysis, documentation, and project collaboration.

Excel Course

The **Excel Course** covers basic to advanced concepts for Business Analysts in the IT Services and Consulting industry, including workbook management, formulas, functions, data validation, sorting, filtering, conditional formatting, Pivot Tables, Pivot Charts, XLOOKUP, INDEX-MATCH, Power Query, Power Pivot, business data analysis, KPI reporting, trend analysis, dashboards, What-If Analysis, Solver, VBA automation, financial analysis, statistical functions, reporting automation, data visualization, and interactive dashboards to analyze business requirements, generate actionable insights, improve reporting efficiency, and support strategic business decision-making.

Visio/Lucidchart Course

The **Visio/Lucidchart Course** covers basic to advanced concepts for Business Analysts in the IT Services and Consulting industry, including process mapping, flowchart creation, business process modeling, BPMN diagrams, UML diagrams, use case diagrams, ER diagrams, wireframes, organizational charts, system architecture diagrams, data flow diagrams, collaboration features, template management, document sharing, stakeholder presentations, workflow visualization, integration with productivity tools, version control, and documentation standards to design clear business processes, communicate requirements effectively, and support successful project planning and implementation.

SQL (Basic) Course

The **SQL (Basic) Course** covers basic concepts for Business Analysts in the IT Services and Consulting industry, including database fundamentals, SELECT queries, filtering, sorting, joins, aggregate functions, GROUP BY, HAVING, subqueries, Common Table Expressions (CTEs), window functions, CASE statements, views, basic stored procedures, indexing fundamentals, query optimization basics, data extraction, business reporting, data validation, KPI analysis, and large dataset querying to retrieve, transform, and analyze business information for requirement analysis, reporting, and informed business decision-making.