This subject introduces you to the various techniques of data wrangling with a strong focus on hands-on experience in R and Structured Query Language (SQL) programming. It will cover the basic concepts in relational database design including Entity Relationship (ER) modelling and SQL as a tool for basic data wrangling. … For more content click the Read more button below.
This subject introduces you to the various techniques of data wrangling with a strong focus on hands-on experience in R and Structured Query Language (SQL) programming. It will cover the basic concepts in relational database design including Entity Relationship (ER) modelling and SQL as a tool for basic data wrangling. You will also learn various types of data sources and common data formats. The subject teaches you R programming language for you to perform data wrangling tasks, including data import and export, basic data integration and data assessment. Upon completion, you will be able to perform a variety of data wrangling tasks using SQL and R for different kinds of data types.
Capstones provide students with a way of integrating and applying knowledge and skills gained throughout their course.
No
Academic progress review - Schedule A subject
No
Subject instances
To view instance specific details which include - Assessments, Class requirements and Subject instance coordinators - please select your preferred instance via the drop-down menu at the top right-hand side of this page.
Learning resources
Recommended - Book - The Essentials of Data Science
Title:The Essentials of Data Science
Resource requirement:Recommended
Author/editor:Williams, G.
Year:2017
Publisher:CRC Press
Recommended - Book - Microsoft SQL Server 2016: A Beginner's Guide
Title:Microsoft SQL Server 2016: A Beginner's Guide
Resource requirement:Recommended
Author/editor:Petkovic, D.
Year:2016
Publisher:McGraw-Hill Education
ISBN:9781259641794
Recommended - Book - Data Wrangling with R (Use R!)
Title:Data Wrangling with R (Use R!)
Resource requirement:Recommended
Author/editor:Boehmke, B.
Year:2016
Publisher:Springer International Publishing
ISBN:9783319455983
Career ready
Work based learning (placement):No
Graduate capabilities
COMMUNICATION - Communicating and Influencing
DISCIPLINE KNOWLEDGE AND SKILLS
INQUIRY AND ANALYSIS - Critical Thinking and Problem Solving
Subject intended learning outcomes
On successful completion you will be able to:
1.
Design, formulate and compose database schema and query structures for analytics initiatives
2.
Compare and contrast various data formats and motivations for data wrangling.
3.
Construct SQL and R code to wrangle data.
4.
Formulate data and data wrangling requirements based on the technical challenges of an analytics task
Learning activities
Lectures, workshops and assessment tasks.
Requisite rules
Admitted in LMMGTM or LMIBUS or LMMKT or BM004 or LMMBA or LMMBAO or LGBUA or LGBUAO or HZMBHO or LMMBAA or HZMBHA or HX002CI or HX0020 or LZFABA or SMDS or HMSA or HGSA or LMBAN or LCBAN or LGBAN or BM005 or LMBISC or LGIS or LCISM or BG007O or BC007O
