DATA ANALYTICS CONCEPTS

BUS2DAC

2020

Credit points: 15

Subject outline

Any modern business today will utilise some form of spreadsheet tool to review, manipulate and visualise data (in the form of charts for reporting). A spreadsheet tool also enables one to undertake advanced tasks on business data, such as to performing a scenario analysis and undertaking complex data analytics, for example creating a forecasting model. In this subject, you will learn how to use two technological tools to undertake data analysis. The first tool is Structure Query Language (SQL), which we will use to pull relevant data into Excel and facilitate further analysis. Next, various advanced Excel analyses including pivot tables, statistical analysis, and creation of basic forecasting models will be covered. Upon successful completion of this subject you will be proficient in basic data analysis using Excel and SQL, setting you up to become an analytical and data driven problem solver. With these skills, you will also be ready to identify insights allowing you to disrupt typical business operations systematically and with a higher chance of success.

School: La Trobe Business School (Pre 2022)

Credit points: 15

Subject Co-ordinator: Binh Tran

Available to Study Abroad/Exchange Students: No

Subject year level: Year Level 2 - UG

Exchange Students: No

Available as Elective: No

Learning Activities: N/A

Capstone subject: No

Subject particulars

Subject rules

Prerequisites: BUS1DIB

Co-requisites: N/A

Incompatible subjects: N/A

Equivalent subjects: N/A

Quota Management Strategy: N/A

Quota-conditions or rules: N/A

Special conditions: N/A

Minimum credit point requirement: N/A

Assumed knowledge: N/A

Career Ready

Career-focused: No

Work-based learning: No

Self sourced or Uni sourced: N/A

Entire subject or partial subject: N/A

Total hours/days required: N/A

Location of WBL activity (region): N/A

WBL addtional requirements: N/A

Graduate capabilities & intended learning outcomes

Graduate Capabilities

DISCIPLINE KNOWLEDGE AND SKILLS

INQUIRY AND ANALYSIS - Creativity and Innovation

INQUIRY AND ANALYSIS - Critical Thinking and Problem Solving

INQUIRY AND ANALYSIS - Research and Evidence-Based Inquiry

PERSONAL AND PROFESSIONAL - Adaptability and Self-Management

Intended Learning Outcomes

01. Use SQL proficiently to retrieve data from a database.

02. Calculate common statistical functions in a spreadsheet/SQL on business data.

03. Solve forecasting problems through model building using a spreadsheet tool.

04. Explain data trends using appropriate data visualisations created from a spreadsheet tool.

05. Use a spreadsheet tool to solve complex business problems using data analytics.

Melbourne (Bundoora), 2020, Semester 2, Blended

Overview

Online enrolment: Yes

Maximum enrolment size: N/A

Enrolment information: N/A

Subject Instance Co-ordinator: Binh Tran

Class requirements

WorkShopWeek: 31 - 43
One 2.00 hours workshop per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.
In addition, students are expected to undertake between 1-3 hours of learning and assessment activities each week prior to class.

Assessments

Assessment element	Comments	Category	Contribution	Hurdle	%	ILO*
Data retrieval exercise using SQL1,000-word equivalent individual written report.	N/A	N/A	N/A	No	30	SILO1, SILO2
Effective data visualisation using Excel and SQL1,000-word equivalent individual written report.	N/A	N/A	N/A	No	30	SILO2, SILO3, SILO4
Create a data driven solution to a business problem2,000-word equivalent individual written report.	N/A	N/A	N/A	No	40	SILO3, SILO4, SILO5