Individual Training

Avenue Impact > Individual Training

Excel, PowerBI, Tableau, SQL Basics

Comprehensive Data Analytics/Business Intelligence Course

Course Description:
The Comprehensive Data Analytics/Business Intelligence Training Course is designed to equip participants with the essential skills and knowledge to excel in data analysis and business intelligence. Through a combination of theoretical concepts, practical hands-on exercises, and real-world case studies, participants will gain proficiency in using Excel, PowerBI, Tableau, and SQL for data analysis and visualisation. With Avenue Impact’s additional services, including on-the-job support on our Bookamentor Platform, participants can access resources and mentorship to enhance their learning experience further.

Course Duration: 4 Months

Weekday Schedule (Monday to Friday):
Time: 7:00 pm – 9:00 pm

Weekend Schedule (Saturdays and Sundays):
Time: 12:00 pm – 5:00 pm

Course Modul

Module 1: Excel for Data Analysis
Introduction to Excel for data analysis
Data cleaning and manipulation using Excel functions
Advanced data analysis techniques: PivotTables, PivotCharts, and Data Validation
Statistical analysis with Excel
Data visualisation with Excel charts and graphs

Module 2: PowerBI Fundamentals
Overview of PowerBI and its components
Importing data into PowerBI: Connecting to various data sources
Data modelling and transformation in PowerBI
Creating interactive reports and dashboards
Sharing and collaborating with PowerBI

Module 3: Tableau Essentials
Introduction to Tableau and its Features
Data connections and data preparation in Tableau
Building visualisations: Charts, graphs, and maps
Advanced analytics and calculations in Tableau
Dashboard design and interactivity

Module 4: SQL Fundamentals
Introduction to SQL and relational databases
Basic SQL queries: SELECT, INSERT, UPDATE, DELETE
Data manipulation with SQL: Joins, Subqueries, and Aggregations
Data definition with SQL: Creating tables, views, and indexes
Introduction to stored procedures and functions

What Candidates Will Gain:
Proficiency in data analysis and visualisation using Excel, PowerBI, Tableau, and SQL
Ability to clean, manipulate, and analyse large datasets
Skills in creating interactive reports and dashboards for business insights
Knowledge of advanced data analysis techniques and best practices
Certification upon successful completion of the course

Live Project/Case Studies in Data Analytics Training

In addition to theoretical learning and hands-on exercises, our Data Analytics training program incorporates live projects and case studies to provide participants with practical experience and real-world application of their skills. These projects and case studies are designed to simulate scenarios encountered in professional data analytics roles, allowing participants to apply their knowledge to solve practical problems and gain valuable insights.

Benefits:

Real-world Experience: Participants can work on real-life datasets and projects, which helps bridge the gap between theory and practical application.
Skill Enhancement: Live projects enable participants to sharpen their analytical, critical thinking, and problem-solving abilities in a practical setting.
Portfolio Building: Completing live projects provides participants tangible examples of their work to showcase in their portfolio or during job interviews, enhancing their credibility as data analytics professionals.
Collaborative Learning: Working on projects in a group setting encourages collaboration and teamwork, fostering a supportive learning environment where participants can learn from each other’s experiences and expertise.
Industry Relevance: The projects and case studies are carefully curated to reflect real-world business challenges and trends, ensuring participants have skills and knowledge directly applicable to the workplace.
Feedback and Mentorship: Participants receive feedback and guidance from experienced instructors and mentors throughout the project, helping them refine their skills and improve their performance.

Access to Avenue Impact’s additional services, including on-the-job support on our Bookamentor Platform for ongoing learning and mentorship.

Show All Collapse

Business Analysis, Agile PM and Software Testing

Comprehensive Project Consultant Course

Course Description: The Comprehensive Project Consultant Training Course is a comprehensive program designed to equip participants with the skills and knowledge required to excel as project consultants. This course covers various aspects of project management and consulting, including Business Analysis, Scrum Master, Product Owner, and Software Testing. Through a combination of theoretical learning, hands-on exercises, and live project implementation, participants will gain practical experience and expertise in managing projects effectively. With Avenue Impact’s additional services, including on-the-job support on our Bookamentor Platform and professional Community platform, participants can access resources and mentorship to enhance their learning experience further.

Course Duration: 3.5 Months

Weekday Schedule (Monday to Friday):
Time: 7:00 pm – 9:00 pm

Course Modules:

Module 1: Business Analysis

  • Introduction to Business Analysis
  • Requirements gathering and documentation
  • Stakeholder management
  • Business process modeling
  • Use case analysis
  • Business analysis tools and techniques

Module 2: Scrum Master

  • Introduction to Agile and Scrum framework
  • Roles and responsibilities of a Scrum Master
  • Sprint planning, execution, and review
  • Facilitating Scrum ceremonies: Daily Standups, Sprint Planning, Sprint Review, and Retrospective
  • Agile project management tools: Jira, Trello, etc.
  • Handling impediments and fostering team collaboration

Module 3: Product Owner

  • Understanding the role of a Product Owner
  • Product backlog management
  • Prioritization techniques: MoSCoW, Value-based prioritization
  • User story writing and acceptance criteria
  • Stakeholder management and communication
  • Product roadmap and release planning

Module 4: Software Testing

  • Introduction to software testing concepts
  • Testing methodologies: Manual vs. Automated testing
  • Test planning, design, and execution
  • Defect management and tracking
  • User Acceptance Testing

Live Project Implementation: Participants will work on a live project throughout the duration of the course, applying the skills and techniques learned in each module to a real-world scenario. This project will provide hands-on experience in project management, business analysis, Agile methodologies, and software testing.

What Candidates Will Gain:

  • Proficiency in project management and consulting skills
  • In-depth knowledge of Business Analysis, Scrum Master, Product Owner, and Software Testing
  • Hands-on experience through live project implementation
  • Certification upon successful completion of the course
  • Access to Avenue Impact’s additional services, including on-the-job support on our Bookamentor Platform and professional Community platform for ongoing learning and mentorship.
Show All Collapse