DATA WRANGLING AND R

BUS5DWR

2021

Credit points: 15

Subject outline

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.

SchoolLa Trobe Business School

Credit points15

Subject Co-ordinatorBinh Tran

Available to Study Abroad/Exchange StudentsNo

Subject year levelYear Level 5 - Masters

Available as ElectiveNo

Learning ActivitiesLectures, workshops and assessment tasks

Capstone subjectNo

Subject particulars

Subject rules

Prerequisites Enrolled in LMBAN or LCBAN or LGBAN or HMDH

Co-requisitesN/A

Incompatible subjectsN/A

Equivalent subjectsN/A

Quota Management StrategyMerit based quota management

Quota-conditions or rulesBy the order of application to subject coordinator.

Special conditionsN/A

Minimum credit point requirementN/A

Assumed knowledgeN/A

Readings

Data Wrangling with R (Use R!)

Resource TypeRecommended

Resource RequirementN/A

AuthorBoehmke, B.

Year2016

Edition/VolumeN/A

PublisherSpringer International Publishing

ISBN9783319455983

Chapter/article titleN/A

Chapter/issueN/A

URLN/A

Other descriptionN/A

Source locationN/A

Microsoft SQL Server 2016: A Beginner's Guide

Resource TypeRecommended

Resource RequirementN/A

AuthorPetkovic, D.

Year2016

Edition/VolumeN/A

PublisherMcGraw-Hill Education

ISBN9781259641794

Chapter/article titleN/A

Chapter/issueN/A

URLN/A

Other descriptionN/A

Source locationN/A

The Essentials of Data Science

Resource TypeRecommended

Resource RequirementN/A

AuthorWilliams, G.

Year2017

Edition/VolumeN/A

PublisherCRC Press

ISBNN/A

Chapter/article titleN/A

Chapter/issueN/A

URLN/A

Other descriptionN/A

Source locationN/A

Career Ready

Career-focusedNo

Work-based learningNo

Self sourced or Uni sourcedN/A

Entire subject or partial subjectN/A

Total hours/days requiredN/A

Location of WBL activity (region)N/A

WBL addtional requirementsN/A

Graduate capabilities & intended learning outcomes

Graduate Capabilities

Intended Learning Outcomes

01. Design good structured database for data wrangling.
02. Compare and contrast various data formats and motivations for data wrangling.
03. Construct SQL and R code to wrangle data.
04. Formulate data needs and propose data wrangling questions for a new problem.

Subject options

Select to view your study options…

Start date between: and    Key dates

City Campus, 2021, Semester 1, Night

Overview

Online enrolmentYes

Maximum enrolment size120

Subject Instance Co-ordinatorKok-Leong Ong

Class requirements

Lecture/WorkshopWeek: 10 - 22
One 3.00 h lecture/workshop per week on weekdays at night from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Individual Assignment (2000 words), SQL design Demonstrate knowledge in database design and proficiency in data wrangling using SQL.

N/AAssignmentIndividualNo40 SILO1

Individual Assignment (1000 words), Report on recent data wrangling topic Demonstrate knowledge on various data sources, data format and motivation for data wrangling and its implications to business analytics.

N/AAssignmentIndividualNo20 SILO2

Individual Assignment (2000 words), R and SQL coding Demonstrate proficiency in data wrangling using R and SQL.

N/AAssignmentIndividualNo40 SILO3, SILO4

City Campus, 2021, Semester 2, Night

Overview

Online enrolmentYes

Maximum enrolment size120

Subject Instance Co-ordinatorKok-Leong Ong

Class requirements

Lecture/WorkshopWeek: 31 - 43
One 3.00 h lecture/workshop per week on weekdays at night from week 31 to week 43 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Individual Assignment (2000 words), SQL design Demonstrate knowledge in database design and proficiency in data wrangling using SQL.

N/AAssignmentIndividualNo40 SILO1

Individual Assignment (1000 words), Report on recent data wrangling topic Demonstrate knowledge on various data sources, data format and motivation for data wrangling and its implications to business analytics.

N/AAssignmentIndividualNo20 SILO2

Individual Assignment (2000 words), R and SQL coding Demonstrate proficiency in data wrangling using R and SQL.

N/AAssignmentIndividualNo40 SILO3, SILO4