Information Technology Data Analytics (Part-time)
- Certificate of Achievement
- Program Code:
- Engineering & Information Technology
About the ProgramTo improve their competitive position and increase growth, companies are continually being challenged with how to examine the vast amounts of raw data that they collect and turn that data into useful information. Data analytics is quickly becoming one of the most useful elements used in business to unlock new possibilities and help in achieving goals. In this program students will practice database development and data mining techniques, while becoming familiar with relational database design and management systems.
Program InformationAll courses must be completed within 3 years of acceptance into the program.
Admission RequirementsOntario Secondary School Diploma (OSSD), or equivalent, OR 19 years of age or older.
- Submit a completed Conestoga College Application Form.
- Attach proof of the admission requirements.
Program RequirementsCredit will be given for any qualifying course successfully completed up to two (2) years prior to admission into the program.
How to ApplyStudents may obtain a Conestoga College Program Application Form from any Conestoga College campus, OR by writing directly to the Registrar's Office, OR by using the college website at www.conestogac.on.ca/admissions/forms
Send completed applications to:
299 Doon Valley Dr
Canada N2G 4M4
How to Register for CoursesGo to How to Register for detailed registration information.
Prior Learning Assessment and Recognition (PLAR)Conestoga recognizes prior learning of skills, knowledge or competencies that have been acquired through employment, formal and informal education, non-formal learning or other life experiences. Prior learning must be measurable at the required academic level and meet Conestoga standards of achievement for current courses. Challenge exams and portfolio development are the primary methods of assessment. Other methods of assessment may be available depending upon the nature of the course objectives. Successful completion of the assessment results in an official course credit that will be recorded on the student's Conestoga transcript. PLAR cannot be used by registered Conestoga students for the clearance of academic deficiencies, to improve grades or to obtain admission into a program.
Learn more about PLAR.
Graduate OpportunitiesData analytics is quickly becoming one of the most useful elements used in business to unlock new possibilities and help in achieving goals. This program prepares students for data analytics roles that are required in such positions as Analytics Support, Data Curation, Data Analytics Associate, and Data Analysis. The skills learned in this program can be utilized by any organization that has a need to identify trends and patterns with all of the data that they collect.
For more details on related occupations, job market information and career opportunities, see the Government of Canada website: http://www.workingincanada.gc.ca
Program Related Resources
- Design an appropriately normalized relational database to support the development of well-formed intuitive data sets that have a clear hierarchical structure.
- Discuss the available Data Base Management Systems (DBMS) models and architectures that are used in business today to determine what model and architecture is best used for the client's needs.
- Collect, manage, and interpret data to identify trends and issues in the workplace to create and develop levels of measure.
- Differentiate between the different frameworks and models for continuous process improvement.
- Apply statistical analysis and process analysis techniques to help drive business solutions.
Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the status column will open a new browser tab or window in the Student Portal.
|Course Code||Course Title||Status|
|INFO1970||Database Development Applications
Description: This course will explore how databases can support business needs through the identification of important Key Performance Indicators (KPIs) and how these KPIs support or influence business decisions. Specifically students will be engaged in exploring how data can be; gathered, manipulated, formatted, and presented as valuable information to specified end users through forms, reports and application designs.
|INFO1980||Data Mining Techniques
Description: This course will examine the hierarchy, flow, architecture and control of records stored within data warehouses and data marts. Students will apply the techniques concerning high-level data manipulation searching for causal links between available information sets. Students will apply statistical analysis techniques and methodologies to transform information sets into useable knowledge assets.
Description: Analysis of process workflows utilizing proper techniques and tools is a fundamental skill for process design. The key focus will be to analyze, enhance and promote change to processes in order to increase process effectiveness, timeliness and/or reduce costs while mitigating risks. A variety of case studies will be used to practice this skill set, including common case studies from previous program courses.
Description: This course will introduce students to relational database management systems and database design. Topics will include: table design, table relationships, database normalization, database optimization, query definition, functions, stored procedures, forms and report development. These concepts are reinforced with practical exercises in creating queries, forms and reports to maintain and display the data in a database. The course also introduces students to data validation and security to ensure database integrity.
Annual Delivery Schedule
|Course Code||Course Title||Spring||Fall||Winter|
|INFO1970||Database Development Applications||X|
|INFO1980||Data Mining Techniques||X|
All efforts will be made to adhere to this schedule, however the college reserves the right to make adjustments when necessary.
* To learn more about online course offerings, visit Distance Learning - OntarioLearn.
The College reserves the right to alter information including requirements and fees and to cancel at any time a program, course, or program major or option; to change the location and/or term in which a program or course is offered; to change the program curriculum as necessary to meet current competencies in the job market or for budgetary reasons; or to withdraw an offer of admission both prior to and after its acceptance by an applicant or student because of insufficient applications or registrations, over-acceptance of offers of admission, budgetary constraints, or for other such reasons. In the event the College exercises such a right, the College’s sole liability will be the return of monies paid by the applicant or student to the College.
Students actively registered in cohort delivered programs who take longer than the designed program length of time to complete their studies are accountable for completing any new or additional courses that may result due to changes in the program of study. Unless otherwise stated, students registered in non-cohort delivered programs must complete the program of study within seven years of being admitted to the program.