Corprate Training Courses

Avenue Impact > Corprate Training Courses

Data Analytics/ Business Intelligence

The Data Analytics and Business Intelligence Training Course is designed to provide participants with a comprehensive understanding of data analysis and visualisation using Excel and PowerBI.
Through theoretical knowledge and hands-on practical exercises, participants will learn essential skills and techniques to extract insights from data and make informed business decisions.
The course covers topics ranging from basic data manipulation in Excel to advanced data visualisation in PowerBI. With Avenue Impact’s on-the-job support on our Bookamentor Platform, participants can access additional resources and mentorship to enhance their learning experience further.

Course Breakdown Below

5-Day Data Analytics and Business Intelligence Training Course

Introduction to Excel for Data Analysis
Overview of Excel for data analysis: Functions, formulas, and data manipulation techniques
Data cleaning and preparation in Excel
Introduction to pivot tables and pivot charts for data visualisation
Hands-on exercises and demonstrations
Q&A session and discussion

Advanced Excel Techniques for Data Analysis
Advanced functions and formulas in Excel for data analysis
Working with large datasets: Filtering, sorting, and conditional formatting
Introduction to Excel’s statistical functions and analysis tools
Creating dynamic dashboards and reports in Excel
Practical exercises and real-world examples
Q&A and troubleshooting session

Introduction to Power BI for Business Intelligence
Overview of Power BI: Features, capabilities, and benefits
Connecting to data sources and importing data into Power BI
Transforming and cleaning data in Power BI
Creating basic visualisations: Bar charts, line charts, and pie charts
Hands-on labs and guided exercises
Q&A session and best practices discussion

Advanced Power BI Development
Building interactive dashboards and reports in Power BI
Implementing advanced data modeling techniques: DAX formulas and relationships
Using Power Query for data transformation and manipulation
Incorporating custom visuals and themes in Power BI reports
Practical exercises and real-world case studies
Q&A and troubleshooting session

Practical Applications and Case Studies
Applying Excel and Power BI skills to real-world business scenarios
Case studies and practical examples from various industries
Group projects: Analyzing datasets and creating actionable insights
Presentation of findings and recommendations
Final assessment and certification
Q&A and feedback session

Training Schedule
Weekday: Monday to Friday @ 10am – 2pm
Weekend: (4 Saturdays): Time: 12:00 noon – 4:00 pm
Similar modules to the weekday schedule, spread over four Saturdays to accommodate participants with weekend availability.

What Candidates Will Gain:
Proficiency in Excel for data analysis, including advanced functions and pivot tables
Skills in creating dynamic dashboards and reports in Excel
Mastery of Power BI for business intelligence, including data modelling and visualisation
Ability to connect to various data sources and transform data for analysis
Experience in building interactive dashboards and reports in Power BI
Practical knowledge of applying data analytics and business intelligence techniques to real-world scenarios
Certification upon successful completion of the course

Delivery Format:
Instructor-led training with live demonstrations and hands-on labs
Access to Avenue Impact’s Bookamentor Platform for on-the-job support and mentorship
Course materials and resources provided digitally
Interactive discussions and Q&A sessions throughout the training

Target Audience:
Beginner to intermediate users interested in gaining proficiency in data analytics and business intelligence tools, including Excel and Power BI.

Read More Collapse

Power Apps and Power Automate

The 5-Day Power Apps and Power Automate Training Course is a comprehensive program designed to equip participants with the skills and knowledge needed to effectively leverage the Microsoft Power Platform. Over five days, participants will gain hands-on experience building custom applications with Power Apps and automating workflows with Power Automate.

Throughout the training, candidates will learn the fundamentals of Power Platform, including Canvas Apps and Model-Driven Apps, and advanced development techniques. They will also explore Power Automate’s capabilities, including triggers, actions, and flow control, and learn how to integrate Power Apps and Power Automate to create seamless solutions.

Course Breakdown Below

Introduction to Power Platform and Power Apps
Overview of Microsoft Power Platform and its components
Introduction to Power Apps: Canvas Apps vs Model-Driven Apps
Building your first Canvas App in Power Apps
Hands-on exercises and demonstrations
Q&A session and discussion

Intermediate Power Apps Development
Understanding data sources and connectors in Power Apps
Creating simple forms and screens in Power Apps
Working with controls and layouts in your app
Adding basic functionalities like buttons, labels, and input fields
Practical exercises and guided tutorials
Q&A and troubleshooting session

Advanced Power Apps Development
Implementing navigation and user authentication in Power Apps
Introduction to formulas and expressions for app customisation
Creating reusable components and templates
Integrating Power Apps with Microsoft 365 services like SharePoint and Outlook
Hands-on labs and guided exercises
Q&A and best practices discussion

Introduction to Power Automate
Understanding Power Automate: Triggers, actions, and flows
Building basic automated workflows in Power Automate
Integration with Power Apps: Triggering flows from app actions
Introduction to templates and pre-built connectors
Hands-on labs and guided exercises
Q&A session and tips for efficient workflow design

Advanced Power Automate Development
Working with expressions and conditions in Power Automate
Advanced flow control: loops, switches, and parallel branches
Error handling and exception management
Custom connectors and HTTP requests inflows
Practical scenarios and troubleshooting challenges
Q&A session and best practices discussion

Training Schedule
Weekday – (Monday to Friday) Time: 10 am – 2 pm
Weekend – (4 Saturdays): Time: 12:00 noon – 4:00 pm
Similar modules to the weekday schedule, spread over four Saturdays to accommodate participants with weekend availability.

Target Audience: Beginners with little to no experience in Power Apps and Power Automate, including business users, Business Analysts, and citizen developers

By the end of the course, participants will have gained:

Proficiency in building Canvas Apps and Model-Driven Apps in Power Apps.
Ability to integrate data sources and connectors into Power Apps.
Understanding of formulas, expressions, and templates for app customisation.
Mastery of creating automated workflows and approval processes with Power Automate.
Skills in error handling, exception management, and custom connectors.
Knowledge of best practices for app and workflow design, deployment, and optimisation.

Candidates will emerge from the course with the ability to harness the full potential of Power Apps and Power Automate to streamline business processes, enhance productivity, and drive digital transformation within their organisations.

To Register, Contact us on 08000541072

Read More Collapse

Business Analysis Course

5-Day Business Analysis Training Course

Course Description:
The Business Analysis Training Course is designed to provide participants with a comprehensive understanding of the principles, techniques, and tools used in business analysis. Through theoretical knowledge and practical hands-on exercises, participants will learn essential skills to analyse business processes, identify requirements, and propose practical solutions. With Avenue Impact’s on-the-job support on our Bookamentor Platform, participants can access additional resources and mentorship to enhance their learning experience further.

Course Breakdown

Introduction to Business Analysis
Overview of business analysis and its importance in project management
Roles and responsibilities of a business analyst
Business analysis framework and methodologies
Introduction to requirement elicitation techniques
Hands-on exercises and case studies
Q&A session and discussion

Understanding Business Processes
Identifying and documenting business processes
Process modelling techniques: BPMN, Use Cases, and Flowcharts
Analysing process efficiency and identifying improvement opportunities
Stakeholder analysis and communication strategies
Practical exercises and real-world examples
Q&A and troubleshooting session

Requirement Gathering and Analysis
Techniques for gathering requirements: Interviews, workshops, surveys, and observation
Documenting requirements: Business requirements document (BRD) and functional requirements document (FRD)
Prioritising requirements and managing stakeholder expectations
Introduction to user stories and acceptance criteria
Hands-on labs and guided exercises
Q&A and best practices discussion

Solution Design and Evaluation
Introduction to solution design: Logical vs. physical design
Identifying and evaluating alternative solutions
Cost-benefit analysis and risk assessment
Developing solution prototypes and wireframes
Practical exercises and case studies
Q&A and troubleshooting session

Business Analysis in Practice
Applying business analysis techniques to real-world projects
Group projects: Analyzing business requirements and proposing solutions
Final assessment and certification
Access to Avenue Impact’s Bookamentor Platform for on-the-job support and mentorship
Q&A and feedback session

Training Schedule
Weekday: Monday to Friday @ 10 am – 2 pm
Weekend: (4 Saturdays): Time: 12:00 noon – 4:00 pm
Similar modules to the weekday schedule, spread over four Saturdays to accommodate participants with weekend availability.

What Candidates Will Gain:
Proficiency in business analysis techniques and methodologies
Skills in requirement gathering, documentation, and analysis
Ability to analyse business processes and propose practical solutions
Experience in solution design and evaluation
Certification upon successful completion of the course
Access to Avenue Impact’s Bookamentor Platform for ongoing support and mentorship.

Read More Collapse

Agile Scrum Master Training

5-Day Scrum Master Training Course

Course Description:
The Scrum Master Training Course is designed to equip participants with the knowledge and skills required to effectively serve as Scrum Masters in Agile development environments. Through theoretical concepts, practical exercises, and real-world case studies, participants will deeply understand the Scrum framework and learn how to facilitate Agile practices within their teams. With Avenue Impact’s on-the-job support on our Bookamentor Platform, participants can access additional resources and mentorship to enhance their learning experience further.

Course Breakdown

Introduction to Agile and Scrum
Overview of Agile principles and values
Introduction to the Scrum framework: Roles, artefacts, and ceremonies
Understanding the responsibilities of a Scrum Master
Agile mindset and principles
Hands-on exercises and simulations
Q&A session and discussion

Scrum Roles and Responsibilities
Deep dive into Scrum roles: Scrum Master, Product Owner, and Development Team
Understanding servant leadership and its application in Scrum
Facilitating influential Scrum events: Sprint Planning, Daily Stand-up, Sprint Review, and Sprint Retrospective
Handling impediments and fostering team collaboration
Practical exercises and case studies
Q&A and troubleshooting session

Agile Planning and Estimation
Agile estimation techniques: Planning Poker, Relative Estimation, and Story Points
Release planning and creating product backlogs
Understanding velocity and capacity planning
Agile metrics and reporting: Burndown charts, Velocity charts, and Cumulative Flow Diagrams
Hands-on labs and guided exercises
Q&A and best practices discussion

Agile Coaching and Facilitation
Coaching Agile teams: Active listening, Powerful questioning, and Feedback techniques
Conflict resolution and fostering a collaborative team culture
Facilitating effective meetings and workshops
Techniques for managing change and adapting to feedback
Practical scenarios and role-playing exercises
Q&A and troubleshooting session

Advanced Scrum Master Techniques
Advanced topics in Agile and Scrum: Scaling frameworks (e.g., SAFe, LeSS), Kanban, and Lean
Continuous improvement and Kaizen mindset
Leading organisational change and influencing stakeholders
Certification preparation and exam tips
Final assessment and certification
Access to Avenue Impact’s Bookamentor Platform for on-the-job support and mentorship
Q&A and feedback session

Training Schedule
Weekday: Monday to Friday @ 10 am – 2 pm
Weekend: (4 Saturdays): Time: 12:00 noon – 4:00 pm
Similar modules to the weekday schedule, spread over four Saturdays to accommodate participants with weekend availability.

What Candidates Will Gain:

In-depth understanding of Agile principles and Scrum framework
Mastery of Scrum Master responsibilities and techniques
Ability to facilitate Agile ceremonies and coach Agile teams effectively
Skills in Agile planning, estimation, and reporting
Certification as a Scrum Master upon successful completion of the course
Access to Avenue Impact’s Bookamentor Platform for ongoing support and mentorship.

Read More Collapse