This hands-on course follows on from COMP 1630, COMP 2362 and MATH 1060. It introduces data analytics fundamentals to students who have previously acquired skills in Excel spreadsheets, database systems, Structured Query Language (SQL) programming and statistics. Starting with an overview of the business cycle for data mining, students learn how to translate a business problem into a data mining problem. Through a number of problems and case studies, students will build, assess, and deploy different models to gain insights into the data by testing probable hypotheses using primarily SQL and Excel. Discussions include the fundamentals of using the R Language for data analytics. Labs and exercises include: using advanced analytics with SQL, advanced Excel and R Studio to clean data and perform analysis. Participants will gain experience with data exploration, testing hypothesis, and predictive analytics. This is a required course in the Applied Data Analytics Certificate, ADAC from BCIT Computing. Upon successful completion, participants will be able to identify the process of data analysis, the roles of data analytics practitioners and how to create analytics models. Students will be prepared to move on to MATH 3060 Advanced Statistical Techniques for Data Analytics and COMP 4254 Advanced Topics in Data Analytics.
If you are taking this course, but are not taking it through either Distance
Education or Online Learning, nor at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Burnaby Bookstore.
Data Analysis Using SQL and Excel
Gordon S. Linoff
No information on books is currently available for Spring/Summer 2018 offerings of this course.
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 2854 - Data Analytics Fundamentals?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.