Undergraduate | LTU-BUS1001 | 2024
Data Analytics Concepts
Course information for 2024 intakeView information for 2023 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.
- Study method
- 100% online
- Subject may require attendance
- Start dates
- 29 July 2024,
- View 2023 dates
- Entry requirements
- Prior study needed
- 12 weeks
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.
Explore La Trobe courses.
- QS Ranking 2024:
- Times Higher Education Ranking 2024:
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.
No additional requirements
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.
What to study next?
Once you’ve completed this subject it can be credited towards one of the following courses
Single subject FAQs
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.
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.
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 .
Close of enrolment times vary between universities and subjects. You can check the cut-off dates for upcoming study terms by visiting key dates.