bus2dac data analytics concepts
DATA ANALYTICS CONCEPTS
BUS2DAC
2019
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.
SchoolLa Trobe Business School
Credit points15
Subject Co-ordinatorBinh Tran
Available to Study Abroad StudentsNo
Subject year levelYear Level 2 - UG
Exchange StudentsNo
Subject particulars
Subject rules
Prerequisites BUS1DIB
Co-requisitesN/A
Incompatible subjectsN/A
Equivalent subjectsN/A
Special conditionsN/A
Graduate capabilities & intended learning outcomes
01. Use SQL proficiently to retrieve data from a database.
- Activities:
- Classroom simulations, peer feedback activities, enquiry based learning class room activities.
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Quantitative Literacy)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
02. Calculate common statistical functions in a spreadsheet/SQL on business data.
- Activities:
- Enquiry based learning class room activities, simulations.
- Related graduate capabilities and elements:
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Personal and Professional Skills(Adaptability Skills)
03. Solve forecasting problems through model building using a spreadsheet tool.
- Activities:
- Enquiry based learning class room activities, simulations, experiential exercises.
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Quantitative Literacy)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Personal and Professional Skills(Adaptability Skills)
04. Explain data trends using appropriate data visualisations created from a spreadsheet tool.
- Activities:
- Enquiry based learning class room activities, simulations, individual essay.
- Related graduate capabilities and elements:
- Literacies and Communication Skills(Quantitative Literacy)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
05. Use a spreadsheet tool to solve complex business problems using data analytics.
- Activities:
- Enquiry based learning class room activities, simulations, experiential exercises.
- Related graduate capabilities and elements:
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Inquiry and Analytical Skills(Critical Thinking,Creative Problem-solving,Inquiry/Research)
- Personal and Professional Skills(Adaptability Skills)
Subject options
Select to view your study options…
Melbourne, 2019, Semester 2, Blended
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorBinh Tran
Class requirements
WorkShopWeek: 31 - 43
One 2.0 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 | % | ILO* |
|---|---|---|---|
| Data retrieval exercise using SQL | 1,000-word equivalent individual written report. | 30 | 01, 02 |
| Effective data visualisation using Excel and SQL | 1,000-word equivalent individual written report. | 30 | 02, 03, 04 |
| Create a data driven solution to a business problem | 2,000-word equivalent individual written report. | 40 | 03, 04, 05 |