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