This course provides essential knowledge and skills required to support students’ future learning in future data analytic modules.
Without prerequisite knowledge in data analytics, this module will cover spreadsheet analytics and relational database tools used in many business cases.
The spreadsheet modelling includes an introduction to basic spreadsheet functions, moving onto a range of more complex functions and a variety of data manipulation methods, including producing appropriate graphs. Students will experience the range of what is possible within spreadsheets through learning specific techniques.
The relational database section starts with database modelling, database implementation, query execution and business problem solving using Structured query language (SQL). The focus will be on the underlying principles, modelling methodologies, and implementation using appropriate software packages.