Events



Upcoming events

    • 17 Oct 2017
    • 7:00 PM
    • 12 Dec 2017
    • 10:00 PM
    • Online
    Register

    IIBA Toronto Hybrid

    BABOK v3.0 Study Group

    Fall 2017 Program

     

    Program is a Weekly Online Study Group

    October 17, 2017 to December 12, 2018

    Study Group evening is Tuesday


    If you have comments or questions, ask here


    The 9 week online study group covers the content in the IIBA BABOK v3.0.  The 9 week duration is 27 Professional Development (PD) credit hours. 


    Other IIBA Toronto events that will assist the Fall 2017 BABOK v3.0 Study Group

    1. The IIBA Certification Application Workshop **
    2. Small Group Meetups *
    3. Chapter Community Nights (more on these shortly) **
    4. Jamfest where we apply the BABOK to a live situation/case study, to allow you to apply the knowledge learned and get real applied experience. **

    Online BABOK Study Sessions

    October |  17, 24, 31

    November |  7, 14, 21, 28

    December |  5, 12


    Weekly Study Meetups Across GTA

    This is open to all studying the BABOK and or preparing for the IIBA Certification Exams

    Hwy 401 & Hurontario area, Mississauga

    Eglinton & Yonge area, Toronto

    Online


    In-Person Community BABOK Evenings

    These are Thursday evenings in-person events

    November | 2, 23

    December | 14


    *PD and CDU credit hours may be earned

     **PD and CDU credit hours are earned 


    Our IIBA BABOK v3.0 Study Group Program

    • Are you interested in learning about the practice of Business Analysis?
    • Are you interested in ECBA, CCBA or CBAP certification?
    • Would like to dive into the body of knowledge to learn more about the content of A Guide to the Business Analysis Body of Knowledge(IIBA BABOK v3.0)?
    • Are you looking to advance your career by growing your technical competencies?

    This fall, IIBA Toronto is once again having an online IIBA BABOK v3.0 Study Group for those individuals interested in learning the BABOK IIBA for any reason.


    The Program includes meetups and peer-to-peer connection during the Program. You can collaborate with others in the Program and benefit from others as they grow their competencies.


    IIBA Chapter will run the study group for about 9 sessions on Tuesday evenings through the fall. This study group will provide minimum 27 Professional Development (PD) credit hours for those students seeking certification, and provide a practice test opportunity for all students. Students will be provided with study group material.


    This study group will be facilitated by multiple facilitators. Individuals will be present as a coach during the sessions and thru the week. 


    If you have any questions concerning this study group, please email president@iibatoronto.org.



    Level:

    Curious

    Entry-Level

    Junior

    Intermediate

    Senior

    Team Lead

    Management

    Experienced with Analysis

    Exposed to portions of Business Analysis



    OUR APPROACH

    IIBA Toronto uses peer-to-peer learning tools, deliver instructor led content, practice exam questions, have coaches, small group meetups, and more.


    CREATING RESULTS

    The result is we are able to encourage, motivate and help participants take ownership of the processes (building and submitting the application, pacing and studying for the certification exams) through the use of various learning methods, collaboration tools and community.


    HOW WE HELP YOU

    IIBA Toronto offers a full exploration of the IIBA BABOK v3.0. The mystery is removed and studying the IIBA BABOK v3.0 becomes manageable. We do not offer an exhaustive survey of the material in BABOK v3.0. We do encourage engagement, community, collaboration as you grow your competencies with the powerful assistance of IIBA Toronto's BABOK v3.0 based study group.


    IIBA CERTIFICATIONS

    http://www.iiba.org/Certification-Recognition/certificationlevels.aspx


    IIBA BABOK v3.0

    https://www.iiba.org/babok-guide.aspx


    The BABOK v3.0 content covered will include

    • BABOK v3.0 Introduction
    • Business Analysis Key Concepts
    • Business Analysis Planning and Monitoring
    • Elicitation and Collaboration
    • Requirements Life Cycle Management
    • Strategy Analysis
    • Requirements Analysis and Design Definition
    • Solution Evaluation
    • Underlying Competencies
    • The Fifty Techniques Presented in the BABOK


    Payment Policy

    The IIBA Toronto BABOK v3.0 Study Group (Program) fees must be paid upon registration in the Program prior to attending. Pricing, registration terms, and conditions are subject to change without notice.


    IIBA Toronto Chapter reserves the right to make changes to the Program described or to cancel the Program at any time without notice or liability. The Chapter's sole liability will be limited to the refund of registration fees paid in respect of the workshop and the Chapter shall not be responsible for any incidental or consequential loss arising whatsoever. The Chapter will endeavor to give enrollees as much advance notice as possible of any change to the Program or registrant’s enrollment.


    Registration Fee

    The registration fee covers participation only.


    Refund Policy

    Cancellations will be allowed prior to 3 day of the Program start date and a full refund will be issued. Cancellations will not be permitted within 3 days of the Program start date; however, substitutions will be permitted. It is up to the registrant to find and arrange a substitute. The Chapter will process the substitution by changing the registrant name but is not responsible for any financial transactions between the registrants.


    No refunds will be issued within 3 days of the Program start date. If a registrant does not attend the start date event of the Program and has not given adequate notification, it will result in full forfeiture of the registration fee.


    If you are unable to attend the Study Group, or have comments or questions, please contact  president@iibatoronto.org.

    • 18 Oct 2017
    • 6:30 PM - 8:00 PM
    • George Brown College Casa Loma Campus, 146 Kendall Avenue, Toronto, ON (Dupont TTC Subway Station)
    Register

    Networking & Presentation

    The Hydraulic Brian of NASA's Space Launch System Umbilical Arms

    (Motion-Control Subassemblies)



    NASA's Requirements 

    • Migrate to hydraulic, motion control technologies from legacy systems
    • Design/Engineering Service Capabilities
    • IP/Engineering teams to augment NASA teams
    • Manufacture Product
    • Assemble – Test – Validate Final Products





    Installed


    Event Particulars


    ROOM  E430
    George Brown College 
    Casa Loma Campus
    146 Kendal Avenue, Toronto
    October 18, 2017  6:30 pm

    Map



    Wednesday, October 18, 2017
    Time: 6:30 – 7:30 pm
    Registration & Networking: 6:00 – 6:30 pm
    Presentation: 6:30 – 7:30 pm

    Networking: 7:30 - 8:15 pm

    Room E430


    Event Partner


    Lynch




    George Brown College Casa Loma Campus


    146 Kendal Avenue, Toronto, ON M5R 1M3

    Map


    Transportation

    Dupont TTC Subway Station
    400 Meters from entrance.
    Paid parking and street
    parking in area



    About the Speaker



    Kenward Mah

    M.A.SC., P.ENG.

    Director of Strategic Partnerships & Programs

    Lynch Group of Companies

    www.lynch.ca



    Presently, Ken is the Director of Strategic Partnerships & Programs for Lynch Group of Companies.

    Focused on hydraulic, motion control solutions and state-of-the-art manufacturing, Lynch is recognized as a role model for Canadian SMEs who are centers of global excellence for their market niches. His responsibilities include sales, marketing as well as program management for strategic accounts including National Aeronautics and Space Administration (NASA).

    After graduating from the University of Toronto, Ken worked in the mining and oil industry in the northern parts of Canada including: The Yukon, British Columbia, Ontario, Quebec and Newfoundland. His experience includes exploration, mineral processing, manufacturing, metallurgical operations in both hard and soft rock.

    With a career migrating into the Information Technology space, Ken’s duties ranged from technical service, support and sales with an overseas posting in the Far East supporting China, Taiwan, Japan, Korean markets. During his tenure, he helped close, deliver and program manage multi-million dollar projects sponsored by UNDP and The World Bank.

    Senior Disaster Recovery and Business Continuity Consultant for GE Capital IT Solutions followed by experiences with Northrop Grumman, eBRP Software Solutions provides real world value to organizations. With expertise for intangibles, enterprise wide issues, and disruptive technology sales in unique environments, Ken’s real strength is his strong interpersonal (Soft) skills.







    • 18 Oct 2017
    • 6:30 PM - 8:00 PM
    • George Brown College Casa Loma Campus, 146 Kendall Avenue, Toronto, ON (Dupont TTC Subway Station)
    Register

    Networking & Town Hall


    The future is already here – it's just not evenly distributed yet.
     ~William Gibson, 2003


    TOWN HALL MEETING
    October 18, 7:45 PM

    After the Networking &
    the Speaker Series Presentation


    Suddenly there has been a flood of queries and interest about participating with IIBA Toronto and volunteering. Come to the Speaker Series and we will have an update of what is happening, what you can volunteer for(coordinators, mentoring, coaching, facilitating, research, jamfest committee, membership, hackfest committee, Deloitte recommendations design & implementing, business intelligence and data analytics on ourselves, branding, and more...)




    Event Particulars


    ROOM  E416
    George Brown College 
    Casa Loma Campus
    146 Kendal Avenue, Toronto
    October 18, 2017  7:45 pm

    Map



    Wednesday, October 18, 2017
    Time: 7:45 – 8:45 pm
    Registration & Networking: 6:00 – 6:30 pm
    Speaker Series Presentation: 6:30 – 7:30 pm

    Networking: 7:30 - 8:15 pm

    Town Hall Meeting: 7:45 - 845 pm

    Room E416


    Event Partner


    Lynch




    George Brown College Casa Loma Campus


    146 Kendal Avenue, Toronto, ON M5R 1M3

    Map


    Transportation

    Dupont TTC Subway Station
    400 Meters from entrance.
    Paid parking and street
    parking in area










    • 19 Oct 2017
    • 7:00 PM - 9:00 PM
    • 1799 Argentia Rd Mississauga, Ontario L5N 3A2
    Register

    IIBA Mississauga
    Toastmasters Club

    meets on the 1st & 3rd Thursday each month


    7:00 PM
    October 19, 2017

     

    Meeting Location

    Lynch Fluid Controls Inc
    1799 Argentia Road
    Mississauga, Ontario L5N 3A2

     

    https://www.facebook.com/IIBA.TO.TM

    https://www.linkedin.com/groups/8439421


     


     

    IIBA Mississauga Toastmasters
    Club Home Page

        


    IIBA Toronto Meetup.com Page
    including Toastmasters Activity





    • 23 Oct 2017
    • 6:00 PM - 8:30 PM
    • TBA
    Register

    Introduction to

    IIBA BABOK v3.0


    You are registering for
    An Introduction to the IIBA BABOK v3.0
    on October 23, 2017
    It is similar to the first session
    of the IIBA Toronto Study Group


    Click here for the full
    ONLINE Fall 2017 Study Group


    Space is limited. Conditions apply.


    SESSION ONE

    • What is Business Analysis
    • What is the Business Analysis practice
    • What is the IIBA BABOK v3.0 Guide
    • Key Concepts of Business Analysis
    • The Business Analysis Core Concept Model
    • IIBA Toronto, You and the Core Competency Model
    • 29 Underlying Competencies in 6 Groupings
    • The 5 Perspectives in the IIBA BABOK v3.0 and Beyond
    • Practicing Business Analysis but not as a dedicated Business Analyst
    • Creating new uses for the Business Analysis practice
    • The IIBA Toronto Learning Experience
    • The IIBA Toronto Support Experience
    • The IIBA Toronto's IIBA Certification and Exam Support Experience
    • IIBA Toronto and the Business Analysis Community is supporting you.



    THE NEW IIBA REQUIREMENTS

    The study group program IIBA Toronto offers is 35 Professional Development (PD) credit hours in duration. IIBA Toronto uses peer-to-peer learning tools, deliver instructor led content, practice exam questions, have coaches, small group meetups, and more.


    CREATING RESULTS

    The result is we are able to encourage, motivate and help participants take ownership of the processes (building and submitting the application, pacing and studying for the certification exams) through the use of various learning methods, collaboration tools and community.


    HOW WE HELP YOU

    IIBA Toronto offers a full exploration of the IIBA BABOK v3.0. The mystery is removed and studying the IIBA BABOK v3.0 becomes manageable. We do not offer an exhaustive survey of the material in BABOK v3.0. We do encourage engagement, community, collaboration as you grow your competencies with the powerful assistance of IIBA Toronto's BABOK v3.0 based study group.


    CHANGES IN THE IIBA CERTIFICATIONS

    IIBA Toronto's changes are in response to the changes IIBA has made to both the IIBA BABOK in v3.0 and in three of the existing and new IIBA Certifications (ECBA, CCBA, and CBAP).


    IIBA Toronto's study group satisfies the IIBA CBAP certification requirement of 35 PD credit hours, and the IIBA ECBA and IIBA CCBA certification requirement of 21 PD credit hours.


    http://www.iiba.org/Certification-Recognition/certificationlevels.aspx


    CHANGES IN THE IIBA BABOK v3.0

    IIBA Toronto's study group deals with the reality that the 'meat' in the BABOK v3.0 grew to 440 pages from its previous 222 pages. That is an effective doubling of the material! In total the BABOK Guide has gone from 265 pages in v2.0 to 502 pages in v3.0, again almost doubling its previous size.


    That said, the main changes are redesigning the knowledge areas slightly, adding five perspectives, and sixteen techniques. This allows the BABOK to address project based projects, enterprise based projects, and help keep the practice and the practitioner from becoming irrelevant to the enterprise's evolving business outcome.


    https://www.iiba.org/babok-guide.aspx


    We will also be reviewing the new Case Studies method used in the new BABOK v3.0 exams. 


    Cancellation by participant

    Students will receive a refund only if IIBA Toronto receives a notice of cancellation more than 10 full calendar days (not including the class date) before the class start date.

    If a student does not attend a scheduled session, there will be no refund or reschedule given. Payment is forfeited.

    Student substitutions are allowed.


    Cancellation or reschedule by IIBA Toronto


    The IIBA Toronto chapter, who is providing this workshop, reserves the right to cancel or reschedule this event.


    Questions


    Should you have any questions or need assistance, please contact us at events@iibatoronto.org.


    • 23 Oct 2017
    • 6:00 PM
    • 22 Jan 2018
    • 8:00 PM
    • TBA
    Register

    IIBA Toronto

    The Analysis Practice 

    Skills Coaching & Mentoring Program

    Fall 2017 Program

     

    Program is 12 Week Mentoring/Coaching

    Week of October 23, 2017 to
    Week of January 22, 2018

    With a Christmas Break


    Click here for full program brochure 


    Our Program

    Our program is a blend of coaching and mentoring that is focused on skills by default. The Skills Coaching Program is located between the transfer of information where the mentor is a resource and advisor, and a full mentor including acting as life coach, consultant and or sponsor.


    Between the mentor and the IIBA Toronto Skills Coaching Program, the coachee will receive training about tasks and techniques that may be organization specific, plus the coach will provide first-hand references and be themselves a role model.


    The Program spans entry-level needs to senior evolving practices and aiding those in looking what are the options outside the current organizational environment.


    The Program includes meetups and peer-to-peer connection during the Program. You can collaborate with others in the Program and benefit from others as they grow their competencies. The Program is not a crash course in everything business analysis. 


    Growing the Relationship

    Our introductory session takes you through the steps of starting and growing your coaching relationship.


    A coach will help you do what you need to do,

    A mentor will help you do what you want to do.


    IIBA Toronto Skills Mentoring Program Takes From Both

    Our program is skills based. We encourage you to outline what you propose to achieve in the twelve weeks, and then we will help you execute your program and reach your targets.


    Supporting Individual Development

    The intent of mentoring is to support individual development through both career and personal functions.


    Definition of a Mentor

    A mentor facilitates personal and professional growth in an individual by sharing the knowledge and insights that they learned through the years. A mentor's purpose is to be a role model, a coach, a broker, and an advocate.


    Definition of a Mentee

    A mentee also known as a protégé, refers to the less experienced person who is receiving and benefiting from the acquired wisdom and years of practice of the more experienced individual.



    Reasons Why Coaching and Mentoring Work

    Effective mentoring relationships are reciprocal: Both parties gain access to information, ideas, and new ways of doing things.

    Experience is the best teacher

    Mentoring survives because having another person explain something to you and answer your questions is a preferred way of learning values, skills, and information over seeing it on video or reading about it.

    Synergy: Result is greater than the sum of individual capabilities

    Synergy is the ability of two or more people to achieve an outcome that each is incapable of doing alone. The energy and confidence that comes from a mentoring partnership are powerful forces.

    Perpetuation of positive influences

    How many secrets that would benefit humankind have been lost with the passing of the discoverers? Mentoring allows the tips and tricks of an accomplished master to be passed on to the upcoming generation without the information becoming part of the public domain. It ensures that the positive effects of the mentor's actions will continue without him or her.

    Natural transition of life

    Often it is a person in the mid-stages of their career that is interested in becoming a mentor. Not only does it provide them with an opportunity to pass on the wisdom they have learned over the years, it affords them a chance for introspection and reassessment of their career.




    Payment Policy

    The Coaching/Mentoring Program (Program) fees must be paid upon registration in the Program prior to attending. Pricing, registration terms, and conditions are subject to change without notice.


    IIBA Toronto Chapter reserves the right to make changes to the Program described or to cancel the Program at any time without notice or liability. The Chapter's sole liability will be limited to the refund of registration fees paid in respect of the workshop and the Chapter shall not be responsible for any incidental or consequential loss arising whatsoever. The Chapter will endeavor to give enrollees as much advance notice as possible of any change to the Program or registrant’s enrollment.


    Registration Fee

    The registration fee covers participation only.


    Refund Policy

    Cancellations will be allowed prior to 3 day of the Program start date and a full refund will be issued. Cancellations will not be permitted within 3 days of the Program start date; however, substitutions will be permitted. It is up to the registrant to find and arrange a substitute. The Chapter will process the substitution by changing the registrant name but is not responsible for any financial transactions between the registrants.


    No refunds will be issued within 3 days of the Program start date. If a registrant does not attend the start date event of the Program and has not given adequate notification, it will result in full forfeiture of the registration fee.


    If you are unable to attend the workshop, or have comments or questions, please contact president@iibatoronto.org.


    • 25 Oct 2017
    • 8:00 PM - 9:00 PM
    • Online
    Register
    Mind Mapping & Brainstorming for the Business Analyst
    Alumni Event Online 8 PM



    If you have participated in a Brian Band Mind Mapping Workshop, you will be receiving an invitation to join his online Mind Mapping Alumni Meetup.



    Duration


    1 day - 1 hours


    Instructor

    Brian Band
    • 26 Oct 2017
    • 7:00 PM - 9:00 PM
    • Milliken Mills Community Centre, 7600 Kennedy Rd, Markham, ON L3R 9S5
    Register

    IIBA Markham
    Toastmasters Club

    meets on the 2nd & 4th Thursday each month


    7:00 PM

    October 26, 2017

     

    Room A or B
    Milliken Mills Community Centre
    7600 Kennedy Road
    Markham, Ontario

     

    https://www.facebook.com/IIBA.TO.TM

    https://www.linkedin.com/groups/8439421


     


     

    IIBA Markham Toastmasters
    Club Home Page

        


    IIBA Toronto Meetup.com Page
    including Toastmasters Activity





    • 28 Oct 2017
    • 9:00 AM - 4:30 PM
    • George Brown College Casa Loma Campus, 146 Kendall Avenue, Toronto, ON (Dupont TTC Subway Station)
    Register
    Mind Mapping & Brainstorming for the Business Analyst
    Solving With Powerful Tools

    Workshop



    Are you looking for a better way to capture what you aren't successfully capturing?


    Have the required templates tied your hands from being able to better capture and better deliver?


    Do you spend more time trying to get a better grasp of the issues that need to be addressed?


    The benefits of this workshop

    • be competent in the basics of mind mapping
    • have actively practiced it on key business analyst task groupings
    • have observed the limitations of current business analysis tools and the advantages of mind mapping
    • be able to explain why it is an important business analysis tool
    • understand the advantages of mind maps as a tool for business analysis
    • have practiced the n mind mapping principals individually and collectively
    • have started developing a person mind mapping style

    Syllabus


    • Business Analysis Tasks & Tools
    • Organizing Hierarchies
    • Organizing Principles


    Mind Mapping Principles

    • Basic Ordering Ideas
    • Branching Patterns
    • Budding Patterns
    • Branching & Budding Patterns
    • Iconography
    • Active Capturing
    • Branch Attributes
    • Creative Connections
    • Summary Branches
    • Mind The Gaps - Visual & Textual
    • Propert Lineage

    Where to use Mind Mapping

    • Performing BABOK Techniques Using Mind Maps
    • Performing Tasks Using Mind Maps
    • Resume
    • Job Interview Preparation
    • Skills Inventory
    • Study Plan
    • IIBA Certification Application
    • IIBA Certification Examination Preparation
    • Others?


    Every participant will leave the workshop starting to develop a personal mind mapping style.



    Duration


    1 day - 6 hours


    Instructor

    Brian Band

    Senior Consultant

    ca.linkedin.com/in/brian-band-cbap-96138217




    Particulars:

    Class time duration: 6.00 hours

    IIBA CDU credits: 6.0 credits

    Chapter Member Price: $300

    Non-Member Price: $360

    Chapter Member Early Bird Price: $199

    Non-Member Early Bird Price: $249


    Cancellation by participant

    Students will receive a refund only if IIBA Toronto receives a notice of cancellation more than 10 full calendar days (not including the class date) before the class start date.

    If a student does not attend a scheduled session, there will be no refund or reschedule given. Payment is forfeited.

    Student substitutions are allowed.


    Cancellation or reschedule by IIBA Toronto


    The IIBA Toronto chapter, who is providing this workshop, reserves the right to cancel or reschedule this event.


    Questions


    Should you have any questions or need assistance, please contact us at events@iibatoronto.org.



    • 30 Oct 2017
    • 9:00 AM
    • 31 Oct 2017
    • 5:00 PM
    • 481 University Avenue 1st Floor, Suite 104 Toronto, Ontario M5G 2P1
    AGILE Requirements
    Moving From Vision To Value

    October 30 & 31



    Notice
    The following is offered by a third party.  Links will take you to third party websites not managed by IIBA Toronto.


    Click here for a full description of this offering.


    Agile Requirements: Moving from Vision to Value

    Do you yearn for practical and productive ways to discover requirements? 


    Are you puzzled about how to elicit, verify, and validate requirements on an Agile project? 


    Do you struggle with bloated backlogs or not getting backlog items (e.g., stories) “done”?


    EBG Consulting and arSensa Inc. are teaming up to bring the Discover to Deliver agile framework to Toronto for a public offering on Monday, October 30th and Tuesday, October 31st.



    The early bird rate has been extended for IIBA Toronto members.


    Click here for registration, full description and discount




    Five Reasons You Will Want To Attend


    You learn how to:

    • Conquer the chaos of backlog bloat and story hell.
    • Identify and vet new product opportunities in a way that invites, excites, and involves stakeholders as product partners.
    • Engage in discovery sessions that focus on what is useful, viable, and feasible.
    • Overcome requirements confusion and conflict by holistically exploring product options, making transparent decisions, and readying backlogs items to get to “done.”
    • Lead teams and stakeholders toward shared product outcomes through dynamic collaboration.

    Click here for course description and discount options.  


    We look forward to seeing you!




    The Team Bringing You This 2-Day Course



    Ellen Gottesdiener

    ellen@ebgconsulting.com

     

    www.ebgconsulting.com


    Ellen is an Agile Product Coach and CEO of EBG Consulting, focused on helping product and development communities create valuable outcomes through product agility.





    Michelina DiNunno

    michelina@arsensa.com


    www.arsensa.com 


    Michelina is a management professional with extensive experience building self-managing teams, leading organizational change initiatives and championing the business analysis profession. Michelina is a founding member of the IIBA Toronto Chapter, has served the chapter, including on the board, for over eight years, and is a co-creator of the IIBA Toronto Workshop Series.



    • 11 Nov 2017
    • 9:00 AM
    • 16 Dec 2017
    • 5:00 PM
    Register

    SQL FOR DATA ANALYTICS

    In this 36 hour SQL for Data Analytics workshop you will be able to confidently perform data data analysis. You will gain the knowledge and skills needed to understand what Structured Query Language (SQL) will deliver and how it deliver the information.  You will be have the capacity to answer business questions, using Microsoft SQL (MSSQL). And you will have the capacity to deliver a visualization of the data using Tableau.


    KEY Reasons To Learn

    This 36 hour SQL for Data Analytics workshop  will help you act on data for actual business gain, and not just about what a tool can do. You will leverage tools and techniques to foster better business decision making. Learn valuable ways to store, process and analyze data for business outcomes.


    This workshop is hands-on. You will learn the concepts and you will learn how to build and deliver using tools as Microsoft SQL and Tableau.


    Recommended Experience

    Working knowledge of the Microsoft Windows platform or Mac Platform


    Who Should Attend

    Anyone wants to start new career in data analytics or needing to implement data, engage your data environment, and wanting to advance their career by ensuring a SQL and analytics foundational knowledge.


    Typical job roles include

    Anyone wanting to start new career in data analytics or SQL Developer, Report Developer, Tableau Developer, Data Analyst, Business Analysts, Analysis based roles, Project Managers, Software Designers, IT Managers, Business Intelligence. Roles also include those who engage data as part of their job function, such as marketing, branding, strategy, design, solution evaluation, business architecture, research, and more.


    Meetups After the Workshop – Keeping it Real World

    We stay with you following the course. IIBA Toronto has meetups to answer questions and keep you growing as you apply what you learned.


    Dates

    SQL for Data Analytics

    November | 11, 18, 25

    December | 02, 09, 16


    Investment

    Full Member / Associate Member – Early Bird $895

    Full Member / Associate Member – Regular Rate $995

    Basic Member / Nonmember – Early Bird $1045

    Basic Member / Nonmember – Early Bird $1145


    Location

    George Brown College

    Casa Loma Campus

    146 Kendall Avenue, Toronto, ON


    Nearest Subway Station: DuPont

    Parking: Yes

    Type: Street

    Type: Parking Lot $6/day


    Payment Policy

    The IIBA Toronto Workshop fees must be paid upon registration in the Workshop prior to attending. Pricing, registration terms, and conditions are subject to change without notice.

     

    IIBA Toronto Chapter reserves the right to make changes to the Workshop described or to cancel the Program at any time without notice or liability. The Chapter's sole liability will be limited to the refund of registration fees paid in respect of the Workshop and the Chapter shall not be responsible for any incidental or consequential loss arising whatsoever. The Chapter will endeavor to give enrollees as much advance notice as possible of any change to the Program or registrant’s enrollment.

     

    Registration Fee

    The registration fee covers participation only.

     

    Refund Policy

    Cancellations will be allowed prior to 5 day of the Workshop start date and a full refund will be issued. Cancellations will not be permitted within 5 days of the Workshop start date; however, substitutions will be permitted. It is up to the registrant to find and arrange a substitute. The Chapter will process the substitution by changing the registrant name but is not responsible for any financial transactions between the registrants.

     

    No refunds will be issued within 5 days of the Workshop start date. If a registrant does not attend the Workshop and has not given adequate notification, it will result in full forfeiture of the registration fee.

     

    If you are unable to attend the Workshop, or have comments or questions, please contact  president@iibatoronto.org.


    COURSE OUTLINE

    Defining Data Analytics

    What is Data Analytics

    Types of Data Analytics

    Correlation

    Delivering Data Analytics business benefits

    • Data Analytics Applications Across Industries

    • Data Analytics Lifecycle

    • Technology Trends


    Defining SQL Language

    Introducing Relational Database and SQL

    Introducing SQL


    SQL Language – Getting Started with the Basics

    SQL Command Categories

    • Data Definition Language (DDL)

    • Data Manipulation Language (DML)

    • Data Query Language (DQL)

    • Data Control Language (DCL)

    • Data Transactional Commands

    Data By Types

    • Data Type and its Importance

    • Basic Data Types

    SQL Tables - Creating and Altering Tables

    • SQL Constraints

    • Not Null

    • Unique

    • Primary Key

    • Foreign Key

    • Default

    • Manipulating Data

    • Insert

    • Update

    • Delete


    SQL Language – Building Your Competency

    Retrieving Data

    • Retrieving Data with SQL

    • Select Query

    • Case Sensitivity

    • Counting the record

    • Column Aliases

    Operators

    • Using Operators to Categories Data

    • What is an Operator in SQL

    • Comparison Operators

    • Logical Operators

    • Conjunctive Operators

    • Negative Operators

    • Arithmetic Operators

    Data Results

    • Summarizing Data Results

    • Using WHERE to Filters Results

    • The Group by Clause

    • Having Clause

    • Restructuring the Appearance of Data

    Functions

    • Character Functions

    • Mathematical Functions

    • Date Functions

    Join

    • Joining : Getting Results from Multiple Tables • Inner Join or Equijoins

    • Outer Join (Left Join, Right Join)

    • Self-Join

    Cartesian Product

    Table Aliases

    Sub Queries

    Views


    Data Visualization with Tableau

    Tableau Basics

    Tableau Visualization


    Workshop Project – Keeping It Real!





Past events

12 Oct 2017 IIBA Markham Toastmasters Club - 12-Oct-2017
05 Oct 2017 IIBA Mississauga Toastmasters Club - 05-Oct-2017
28 Sep 2017 IIBA Markham Toastmasters Club - 28-Sep-2017
21 Sep 2017 IIBA Mississauga Toastmasters Club - 21-Sep-2017
21 Sep 2017 IIBA Certification Application - A Helping Hand - Sep 21 2017
14 Sep 2017 IIBA Markham Toastmasters Club - 14-Sep-2017
07 Sep 2017 IIBA Mississauga Toastmasters Club - 07-Sep-2017
29 Jul 2017 Interaction of Business Analysis and Architecture Through Design - 29-Jul
22 Jul 2017 Interaction of Business Analysis and Architecture Through Design - 22-Jul
19 Jul 2017 JULY Speaker Series - IT is Too Important to Leave to IT - Mark Smalley - 19-July 6:30 pm
06 Jul 2017 IIBA Toronto Analysis Coaching Program Summer 2017
29 Jun 2017 IIBA Markham Toastmasters Club - 29-Jun-2017
22 Jun 2017 IIBA Toronto Summer 2017 IN-PERSON Study Group
22 Jun 2017 FREE - IIBA Toronto Summer 2017 IN-PERSON Introduction to IIBA BABOK v3.0 - Jun 22
21 Jun 2017 June Speaker Series - John Wang - Security Requirements - 21-June 6:30 pm
20 Jun 2017 IIBA Toronto Summer 2017 ONLINE Study Group
20 Jun 2017 FREE - IIBA Toronto Summer 2017 ONLINE Introduction to BABOK v3.0 - Jun 20 & 27
15 Jun 2017 IIBA Markham Toastmasters Club - 15-Jun-2017
15 Jun 2017 IIBA Mississauga Toastmasters Club - 15-Jun-2017
13 Jun 2017 Prepare Your IIBA Certification Application - June 13 8 pm
10 Jun 2017 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - 10-Jun
08 Jun 2017 Volunteer This Summer Info Webinar
07 Jun 2017 Get Certified This Summer Info Webinar
03 Jun 2017 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - 03-Jun
01 Jun 2017 IIBA Mississauga Toastmasters Club - 01-Jun-2017
27 May 2017 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - 27-May
27 May 2017 The Process Modeling Workshop for Business Analysts - Day 2, 27-May
25 May 2017 IIBA Markham Toastmasters Club - 25-May-2017
24 May 2017 May Speaker Series - Michael Roy - Transforming the Business Analysis Practice - evangelism & change management - 24-May 6:30 pm
15 May 2017 PARTNER Event - ProjectWorld * BusinessAnalyst World 2017
13 May 2017 The Process Modeling Workshop for Business Analysts - Day 1, 13-May
04 May 2017 IIBA Mississauga Toastmasters Club - 04-May-2017
29 Apr 2017 Interaction of Business Analysis and Architecture Through Design - 29-Apr
27 Apr 2017 IIBA Markham Toastmasters Club - 27-Apr-2017
20 Apr 2017 IIBA Mississauga Toastmasters Club - 20-Apr-2017
19 Apr 2017 April Speaker Series - Judith Oja-Gillam - Less Risk Better Results - 19-Apr-2017 6:30 pm
13 Apr 2017 IIBA Markham Toastmasters Club - 13-Apr-2017
27 Mar 2017 PARTNER Event - ProjectTalks Toronto - 27-Mar
25 Mar 2017 Workshop - Mind Mapping and Brainstorming for Business Analysts - March 25
22 Mar 2017 March Speaker Series - Jacquie Chan and Requirements - 22-Mar-2017 6:30 pm
16 Mar 2017 IIBA Toronto Spring 2017 Study Group - Session 1 on 16-Mar
11 Mar 2017 IIBA Website Focus Group
09 Mar 2017 IIBA Toronto Spring 2017 Study Group
09 Mar 2017 IIBA Toronto Spring 2017 Study Group - Session 1 on 9-Mar
04 Mar 2017 Workshop - Building Use Cases 2.1 - 04-Mar-2017
25 Feb 2017 Workshop - Agile for Business Analysis - Defining Requirements in an Agile Project - Scrum & User Stories - 25-Feb
23 Feb 2017 IIBA Markham Toastmasters Club - 23-Feb-2017
16 Feb 2017 IIBA Mississauga Toastmasters Club - 16-Feb-2017
15 Feb 2017 February Speaker Series - Tim Hannan and User Stories - 15-Feb-2017 6:30 pm
11 Feb 2017 Workshop - Agile for Business Analysis - Defining Requirements in an Agile Project - Introduction - 11-Feb
09 Feb 2017 IIBA Markham Toastmasters Club - 09-Feb-2017
02 Feb 2017 IIBA Mississauga Toastmasters Club - 02-Feb-2017
01 Feb 2017 TD Wealth – Business Architecture & Business Analysis - Exclusive Recruiting Event - 1-Feb
22 Jan 2017 IIBA Toronto Business Analysis Skills Coaching Payment & Registration 22-Jan to 22-Apr
18 Jan 2017 January Speaker Series - Roger Burlton and Panel Discussion on Biz Architecture - 18-Jan-2017 6:30 pm
14 Jan 2017 The Process Modeling Workshop for Business Analysts - Day 2 - Jan 14
05 Jan 2017 IIBA Mississauga Toastmasters Club Welcomes the New Year - January 5th
14 Dec 2016 December Speaker Series - Adding Change Management to a Business Analyst Skill Set - 14-Dec 6:30 pm
08 Dec 2016 Design Thinking for Business Analysts Webinar - 08-Dec Noon
03 Dec 2016 The Process Modeling Workshop for Business Analysts - Day 1 - 03-Dec
23 Nov 2016 November Speaker Series - Product-Based Requirements Management Delivers Value to the Practice and Enterprise - 23-Nov 6:30 pm
17 Nov 2016 Prototyping Tool with JustInMind.com (BABOK v3.0, Chapter 10.36) 17-Nov 12:05 pm
16 Nov 2016 IIBA Toronto Study Group Information Webinar 16-Nov 12:30 pm
16 Nov 2016 IIBA Toronto Coaching Program Information Webinar 16-Nov 12:05 pm
11 Nov 2016 Just In Mind prototyping tool available to IIBA Toronto community
10 Nov 2016 IIBA Toronto Fall 2016 Study Group
01 Nov 2016 PARTNER Event - Project Talks - 01-Nov 8 AM
31 Oct 2016 PARTNER Webinar - Masters Certificate in Business Analysis Modules - Oct 31, 1 pm
29 Oct 2016 Workshop - Mind Mapping and Brainstorming for Business Analysts - October 29
22 Oct 2016 Small Group Meetup - IIBA Exam Study Support with Raissa Bernabe - October 22
22 Oct 2016 The Process Modeling Workshop for Business Analysts - October 22
20 Oct 2016 AGILE Small Group Meetup - October 20 5:00 pm
19 Oct 2016 October Speaker Series - User Experience and Business Analysis - October 19
15 Oct 2016 Introduction to Business Architecture and Business Analysis - October 15
01 Oct 2016 Workshop - Agile for Business Analysis - Defining Requirements in an Agile Project - October 01
21 Sep 2016 September Speaker Series - Getting People On Side: How To Be A Better Persuader
12 Sep 2016 PARTNER Event - Certificate in Strategic Enterprise Analysis and Consulting Skills - 12-Sep to 16-Sep
20 Aug 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - August 20
20 Aug 2016 Workshop - Agile for Business Analysis - Defining Requirements in an Agile Project - August 20
18 Aug 2016 IIBA Mississauga Toastmasters Club - August 18
13 Aug 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - August 13
13 Aug 2016 Workshop - More Advanced Business Analysis Requirements - August 13
23 Jul 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - July 23
21 Jul 2016 Small Group Meetup - In-person IIBA Certification Exam Study Support with Raissa Bernabe - July 21
20 Jul 2016 July Speaker Series - Presentation and Panel Discussion - Business Analyst: Your Value and Relevance
19 Jul 2016 Small Group Meetup - In-person IIBA Certification Exam Study Support with Victoria Bodnar - July 19
18 Jul 2016 Small Group Meetup - IIBA Certification Exam Study Support with Victoria Bodnar - July 18
16 Jul 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - July 16
14 Jul 2016 IIBA Markham Toastmasters Club - Charter Party July 14
14 Jul 2016 Small Group Meetup - In-person IIBA Certification Exam Study Support with Raissa Bernabe - July 14
12 Jul 2016 Small Group Meetup - In-person IIBA Certification Exam Study Support with Victoria Bodnar - July 12
11 Jul 2016 Small Group Meetup - IIBA Certification Exam Study Support with Victoria Bodnar - July 11
09 Jul 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - July 9
09 Jul 2016 Agile for Business Analysis - Defining Requirements in an Agile Project - July 9
07 Jul 2016 IIBA Mississauga Toastmasters Club - July 7
07 Jul 2016 Small Group Meetup - In-person IIBA Certification Exam Study Support with Raissa Bernabe - July 7
02 Jul 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe - July 2
30 Jun 2016 IIBA Toronto BABOK v2.0 Exam Primer & Study Group - 30-Jun to 11-Aug
27 Jun 2016 IIBA Toronto BABOK Exam Questions Review Workshop - June 27
25 Jun 2016 Small Group Meetup - IIBA Certification Exam Study Support with Raissa Bernabe
25 Jun 2016 Advanced Business Analysis Requirements Workshop
23 Jun 2016 IIBA Markham Toastmasters Club - June 23rd 7 pm, Network 6:45 pm
23 Jun 2016 Small Group Meetup - In-person IIBA Certification Exam Study Support with Raissa Bernabe
22 Jun 2016 IIBA Toronto Speaker Series June 2016 - Business Analyst: Making The Agile Transition
20 Jun 2016 IIBA Toronto BABOK Study, Learning and Memorization Workshop - June 20
16 Jun 2016 IIBA Mississauga Toastmasters Club - June 16th 7 pm
11 Jun 2016 Building Use Cases 2.1 Workshop
09 Jun 2016 IIBA Markham Toastmasters Club - June 9th 7 pm, Network 6:45 pm
31 May 2016 Blueprint Software Meetup - Analyze User Stories - May 31st
19 May 2016 IIBA Mississauga Toastmasters Club Charter Party - May 19th
18 May 2016 IIBA Toronto Speaker Series May 2016 - The Agile Perspective
14 May 2016 The Process Modeling Workshop for Business Analysts
10 May 2016 IIBA Durham Region Toastmasters Club
09 May 2016 SPONSOR EVENT - ProjectWorld * BusinessAnalyst World 2016
07 May 2016 Mind Mapping and Brainstorming for Business Analysts
05 May 2016 IIBA Mississauga Toastmasters Club - May 5th
30 Apr 2016 Business Analysis and Requirements Definition Workshop
20 Apr 2016 IIBA Toronto Speaker Series April 2016 with David Barrett
19 Apr 2016 IIBA Toronto BABOK v2.0 Online Study Sessions - 19-April to 14-June
19 Apr 2016 IIBA Markham Toastmasters Club - 1st Chartered Meeting!
07 Apr 2016 IIBA Mississauga Toastmasters Club
05 Apr 2016 PARTNER EVENT - ProjectTalks Toronto
23 Mar 2016 IIBA Toronto Speaker Series March 2016 with Jason Questor
17 Mar 2016 IIBA Mississauga Toastmasters Club
16 Mar 2016 IIBA Toronto Certification Workshop
12 Mar 2016 Work Planning in MS Project 2013 Workshop
10 Mar 2016 IIBA Markham Toastmasters Club
27 Feb 2016 Introduction to Business Architecture and Business Analysis
24 Feb 2016 IIBA Toronto BABOK v2.0 Live Study Sessions - 24-Feb to 04-May-2016
18 Feb 2016 IIBA Mississauga Toastmasters Club
18 Feb 2016 IIBA GTA West Toastmasters Club
17 Feb 2016 Lessons Learned and Forgotten - That We Need To Learn Again / IIBA Toronto February 2016 Speaker Series w Gerry de Koning
21 Jan 2016 IIBA GTA West Toastmasters Club
20 Jan 2016 Speaker Series - What is Culture? Process-centric change projects - Dealing with the hard and the soft stuff - Sasha Aganova
16 Jan 2016 Building Use Cases 2.0 with Cole and Tony
07 Jan 2016 IIBA GTA West Toastmasters Club
07 Dec 2015 ProjectWorld Business Analyst World Toronto Workshop Series
03 Dec 2015 IIBA GTA West Toastmasters Club
02 Dec 2015 IIBA Toronto Christmas Party Social - December 2nd
28 Nov 2015 Creating an Effective Business Case
21 Nov 2015 The Art of Building and Being an Independent Consulting Practice
21 Nov 2015 Introduction to Business Architecture and Business Analysis
18 Nov 2015 IIBA Toronto Speaker Series - November 18 with Kevin Brennan
22 Oct 2015 IIBA Toronto BABOK v2.0 Thursday Study Sessions - 22-Oct to 17-Dec, 2015
21 Oct 2015 IIBA Toronto Speaker Series - October 21 with Tim Hannan
23 Sep 2015 IIBA Toronto Speaker Series - September 23 with Natasha Kordonska
19 Aug 2015 There is no event for August, 2015
22 Jul 2015 IIBA Toronto Speaker Series - July 22 - BABOK v3.0
07 Jul 2015 IIBA Toronto BABOK v2.0 - Tuesday Exam Primer - July 7 to August 18, 2015
25 Jun 2015 IIBA Toronto BABOK v2.0 - CBAP/CCBA Application Prep Workshop
23 Jun 2015 IIBA Live Annual General Meeting (AGM) 2015
17 Jun 2015 IIBA Toronto Speaker Series - June 17 - Use Cases, User Stories and Agile Enterprise
08 Jun 2015 IIBA Toronto Core Skills - Member Benefits Series – Cloud Computing: How to Fly
04 Jun 2015 IIBA Toronto Chapter June 2015 Hackfest
30 May 2015 The Process Modelling Workshop for Business Analysts
28 May 2015 IIBA Toronto BABOK v2.0 - Get Your PD Hours for IIBA Certification
20 May 2015 IIBA Toronto Speaker Series - May 20 - Taming The Documentation Monster
04 May 2015 IIBA Toronto Career Lab – Midtown - Writing A Better BA Resume and How to stand out from the Crowd
22 Apr 2015 IIBA Toronto Speaker Series - April 22 - Business Analyst: Making the Transition - Dananthi Arnott
18 Apr 2015 IIBA Toronto BABOK v2.0 - Saturday Exam Primer
16 Apr 2015 IIBA Toronto BABOK v2.0 - Thursday Exam Primer - April 16 to May 21, 2015
02 Apr 2015 IIBA Toronto Core Skills - Member Benefits Series – Knowledge Session around a Use Case Description
25 Mar 2015 IIBA Toronto Speaker Series - March 25th - What Is Facilitation Anyways - Mara Svenne
24 Mar 2015 IIBA Toronto Career Lab - Mississauga - Meet the Recruiters & Resume Spring Tune Up
18 Feb 2015 IIBA Toronto Speaker Series - FEB 2015 - Learning at the Speed of Modern Analysis - Cole Cioran
09 Feb 2015 IIBA Toronto Core Skills - Member Benefits Series – Cloud Computing: How to Fly
04 Feb 2015 IIBA Toronto - FEB 2015 - CBAP® CCBA® Re-Certification Workshop
26 Jan 2015 IIBA Toronto Career Lab – Midtown – Writing a Better Business Analyst Resume
21 Jan 2015 IIBA Toronto Speaker Series - JAN 2015 - Journey to Requirements Quality - Natasha Kordonska
19 Dec 2014 IIBA Toronto - Holiday Volunteer Kaizen Event
10 Dec 2014 IIBA Toronto - Dec 2014 - Christmas Party
19 Nov 2014 IIBA Toronto November Speaker Series - Jason Questor, Achieveblue
25 Oct 2014 Effective Facilitation, Elicitation, Communication and Documentation Techniques Workshop for Business Analysts
22 Oct 2014 IIBA Toronto October Speaker Series - Judith Oja-Gillam, IAG Consulting
03 Oct 2014 Business Analysis Manager's Luncheon
30 Sep 2014 IIBA Toronto Live Study Group - September to December 2014
27 Sep 2014 IIBA Toronto Chapter - Live Board Meeting
25 Sep 2014 IIBA Toronto Virtual Study Group - September to November 2014
20 Sep 2014 The Essential Modelling Workshop for Business Analysts
17 Sep 2014 IIBA Toronto September Speaker Series - Demystifying Business Architecture with Joanne Dong
27 Aug 2014 IIBA Toronto Summer Bowling Night
23 Jul 2014 IIBA Toronto July Speaker Series - Jacquie Chan Partnering with Project Managers
08 Jul 2014 IIBA Toronto Live Study Group - July 8 to August 19
18 Jun 2014 IIBA Toronto June Speaker Series - Jason Questor Presents BABOK v3.0
11 Jun 2014 IIBA Toronto Chapter June 2014 Hackfest
21 May 2014 IIBA Toronto May Speaker Series - Authoring Business Rules - Know Your Facts with Giovanni Diviacchi
09 May 2014 IIBA Toronto Volunteer Committee
23 Apr 2014 IIBA Toronto April Speaker Series - The Techniques of Persuasion with Keith Ellis
03 Apr 2014 IIBA Toronto Live Study Group - 2014 Spring
01 Apr 2014 IIBA Toronto Online Study Group - 2014 Spring
19 Mar 2014 IIBA Toronto March Speaker Series - The Power of Influence in the Workplace with Jocelyn Bérard
19 Feb 2014 IIBA Toronto February Speaker Series - The Business Analyst and Project Recovery with Ori Schibi of PM Konnectors
23 Jan 2014 IIBA Toronto January Speaker Series - The Business Analyst Toolkit - What To Know About Modeling with Gerry De Koning of Global Knowledge
11 Dec 2013 IIBA Toronto Christmas Party & 2013 Annual General Meeting
20 Nov 2013 IIBA Toronto November Speaker Series - The Agile Mindset - Foundation For Success with Jas Phul
23 Oct 2013 IIBA Toronto Speaker Series - Building Effective BA Communities with Shane Tunney of CIBC
17 Oct 2013 IIBA Toronto Live Study Group
15 Oct 2013 IIBA Toronto Online Study Group

© IIBA Toronto Chapter

Bylaws | FAQ | Site Map | Contact Us
Powered by Wild Apricot Membership Software