Data Management (Option #2)

The ‘Data Management’ specialty stream is intended to focus on providing students with exposure to common data management and systems analysis concepts. Completion of these courses will provide students with an introductory understanding of how data is structured and incorporated into a system; how that data can be extracted and used to make decisions and how to apply basic practical data application.

Data Management Modules(all modules must be completed)

1. Management Information Systems
Examine information systems, information flows, source document flows, design for effective data storage and retrieval, auditing controls and computer systems with a focus on information that executives could use to support decision making. MS Access will be used to provide illustration and practice in database concepts.

2. Microsoft Excel – Expert
Building on the introductory course, you will focus on some of the more sophisticated functions of Excel, including importing databases, queries, pivot table functions, macros and forms plus shortcuts. Prerequisite: Participants must have already mastered beginner/intermediate level skills.

3. Microsoft Access – Expert
Learn to use the advanced features of MS Access for Windows. Enhance tables by creating lookups, create various types of advanced queries, create advanced forms, create relationships between tables to ensure data accuracy, work with form controls, understand macro concepts, create, run and test Access macros, create and use switchboard forms, set Access defaults and apply Startup options. Prerequisite: Participants must have already mastered beginner/intermediate level skills.

4. Introduction to Business Analysis
Discover the fundamentals of business analysis and the business analyst’s role. You will examine techniques to provide context for your activities within the broader goals of organizations and their projects. Gain effective communication, interviewing and information gathering techniques, so you can act as a communication link between all business areas and deliver on your key role in project and organizational success. Learn to plan, structure and control the requirements gathering and management process to optimize results. These techniques are an important component for success for a wide variety of initiatives. You will gain insight into the interaction between the business analyst and the surrounding projects and the methodologies to identify and resolve business problems.