Business Analyst Training Course in Columbus

• Learn the basics of SQL, such as tables and commands, such as DDL, DML, DQL, and DCL.
• Understand the working of different types of joins, data time functions, string functions etc.
• Deep dive into advanced SQL – Subqueries, Rules, Views, pattern matching, UDFs, stored procedures, RANK(), DENSERANK(), PARTITION(), Window functions, CTEs etc.
• Learn best practices, such as indexing, clustered indexing, searching, record grouping, etc., to improve the database’s overall performance.

Tools covered

• Get started with PowerBI and understand data modelling, visualisation and analytics.
• Learn about Data Analysis Expressions (DAX) to create custom metrics and Power Query Editor to perform advanced data transformation.
• Learn about different connectors for ingesting data from outsourced databases like Azure SQL.
• Create interactive dashboards and reports to visualise your data and chalk out better inferences or conclusions.

Tools covered

• Get introduced to business analysis and understand the role of a business analyst and its governing body, i.e. IIBA.
• Understand core concepts such as SDLC, requirement analysis, BABOK, UML, agile methodologies, and flowcharts.
• Analyse different strategies and manage the requirements life cycle to understand the status and assess risk.
• Evaluate different solution’s performance according to model requirements and carve out a feasible solution.
• Use Microsoft Visio for creating UML diagrams.

Tools covered

• Get started with CBDA, eligibility criteria and the six business data analytics domains.
• Get introduced to data science and analytics, its use cases, lifecycle, and types, along with an overview of AI and machine learning.
• Implement techniques such as decision modelling, interface analysis, EDA, stakeholder analysis, visualisations, hypothesis formulation, etc.

• Get started with an overview of agile principles such as sprint, scrum, town hall, etc. Compare and contrast agile with other frameworks and choose one that is suitable.
• Learn about different scrum roles, flows, artifacts, and events to plan, monitor and control the overall lifecycle.
• Create reports, scrums, and Kanban boards using Jira. Understand different Jira issue types, story points, and backlog management.

Tools covered

• Understand Unified Modeling Language (UML), a standard way to create designs, sketches and models.
• Deep dive into the different diagrams, such as class diagrams, component diagrams, deployment diagrams, object diagrams, and sequence diagrams.
• Use Microsoft Visio to create diagrams such as package diagrams, profile diagrams, activity diagrams, state machine diagrams, use case diagrams, sequence diagrams, and timing diagrams.

• Working with stakeholders and managing directors requires good communication and leadership skills to convey the analysis.
• Analyse some case studies from the industry to strengthen your problem-solving and business skills.

• Learn how to use Generative AI and concepts such as transformers and LLMs in business analysis.
• Understand how to write effective prompts and give proper context to ChatGPT for desired results.
• Learn principles to write effective prompts and put them in a feedback loop to get better results.

Substantiate your learning experience and Business Analytics skills via this practical, industry-based capstone project based on our course and showcase your skills in Business Analysis.

• Get started by creating an ATS-friendly resume and defining a job search strategy to land your dream job.
• Create a LinkedIn profile to increase your visibility in the market.
• Schedule mock interviews with industry experts to familiarise yourself with the types of questions asked in the interviews.