Data Analytics Concepts
UndergraduateLTU-BUS10012024
Course information for 2024 intake View information for 2025 course intake
Get up to speed with basic data analysis using SQL and Excel. You’ll delve into the data analytics concepts and processes used in business today. Find, present, and explain data trends. Solve complex business problems.
Enrolments for this course are closed, but you may have other options to start studying now. Book a consultation to learn more.
- Study method
- 100% online
- Assessments
- Subject may require attendance
- Entry requirements
- Prior study needed
- Duration
- 12 weeks
- Loan available
- HECS-HELP and FEE-HELP available
Data Analytics Concepts
About this subject
On successful completion you will be able to:
- Use SQL proficiently to retrieve data from a database
- Apply common statistical functions and hypothesis testing techniques on business data
- Explain data trends using appropriate data visualisations created from a spreadsheet tool
- Use a spreadsheet tool to solve forecasting problems and address complex business challenges through data analytics
- Introduction to Data Analytics Concepts and Processes
- Descriptive Analytics with Excel
- Data Visualisation Using Excel
- Data Modelling and Storytelling Using Excel
- Probability Distribution
- Bivariate Analysis
- Hypothesis Testing Using Excel
- Data Retrieval and Manipulation Using Structure Query Language (SQL)
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 performing scenario analyses 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.
- Effective data analysis and visualisation using Excel (1500 words equivalent task).The assignment has two parts. Part A (10%) is a 300-word equivalent task, and Part B (15%) is a 1200-word equivalent task. (25%)
- Create a data-driven solution for a business problem (1200 words equivalent task) (25%)
- One 2-hour final examination (equivalent to 1,500 words) (50%)
For textbook details check your university's handbook, website or learning management system (LMS).
The third university established in Victoria, La Trobe University has a diverse community of more than 38,000 students and staff. Its commitment to excellence in teaching and research prepares students to make a bold and positive impact in today's global community. La Trobe provides Open Universities Australia with its core tenets, entrepreneurship and sustainability.
Learn more about La Trobe University.
Explore La Trobe courses.
- QS Ranking 2024:
- 17
- Times Higher Education Ranking 2024:
- 18
Entry requirements
Others
Past La Trobe University students who have previously completed BUS2DAC (Data Analytics Concepts) or BUS1ABX (Analyzing Business Data) are ineligible to enrol in this subject.
Additional requirements
No additional requirements
Study load
- 0.125 EFTSL
- This is in the range of 10 to 12 hours of study each week.
Equivalent full time study load (EFTSL) is one way to calculate your study load. One (1.0) EFTSL is equivalent to a full-time study load for one year.
Find out more information on Commonwealth Loans to understand what this means to your eligibility for financial support.
Student feedback
6 student respondents between 19 Oct - 11 Nov 2024.
83%of students felt the study load was manageable
83%of students felt this subject helped them gain relevant skills
What to study next?
Once you’ve completed this subject it can be credited towards one of the following courses
UndergraduateLAT-BUS-DEG
UndergraduateLAT-ART-DEG
Bachelor of Information Technology
UndergraduateLAT-TEC-DEG
Bachelor of Psychological Science
UndergraduateLAT-PYS-DEG
UndergraduateLAT-HSC-DEG
UndergraduateLAT-CYS-DEG
UndergraduateLAT-ART-DIP
Single subject FAQs
What’s a single subject?
Single subjects are the individual components that make up a degree. With Open Universities Australia, you’re able to study many of them as stand-alone subjects, including postgraduate single subjects, without having to commit to a degree.
Each of your subjects will be held over the course of a study term, and they’ll usually require 10 to 12 hours of study each week. Subjects are identified by a title and a code, for example, Developmental Psychology, PSY20007.
How can I use single subjects to get into a full degree?
First, find the degree that you would like to study on our website.
If that degree allows entry via undergraduate subjects, there will be information about this under the Entry Requirements section. You will find a list of 2-4 open enrolment subjects you need to successfully complete to qualify for admission into that qualification.
Once you pass those subjects, you will satisfy the academic requirements for the degree, and you can apply for entry.
Our student advisors are here to help you take that next step, so don’t hesitate to reach out when you’re ready! We’ve also made it easier to figure out the right way to get started on our pathways page.
Can anyone help me choose a subject?
Our student advisors are more than happy to help you plan your online study. Get in touch with an advisor by:
How do I pay for my subjects?
You can pay up front with your credit card, or you may be eligible for a HELP loan from the Australian government depending on your citizenship status and where you’ll live during your studies.
For more information about how to pay for your studies visit our fees page or contact a student advisor.
How do I enrol?
When you’ve made your choice, click ‘Enrol now’ on the relevant course page and follow the prompts to begin your enrolment. We’ll ask you to supply some supporting documentation, including proof of your identity, your tax file number, and a unique student identifier (USI) during this process.
Your university will get in touch with you via email to confirm whether or not your application has been successful.
If you get stuck at any time, reach out to us and we’ll talk you through it.
You can also take a look at our online self-service enrolling instructions.
When is the cut-off date for enrolling?
Close of enrolment times vary between universities and subjects. You can check the cut-off dates for upcoming study terms by visiting key dates.