Data Analytics Concepts
Your upfront cost: $0
Subjects may require attendance
- 18 Jul 2022
QS RANKING 2022
Times Higher Education Ranking 2022
- Use SQL proficiently to retrieve data from a database.
- Apply common statistical functions and hypothesis testing techniques on business data.
- Solve forecasting problems through model building using a spreadsheet tool.
- Explain data trends using appropriate data visualisations created from a spreadsheet tool.
- Use a spreadsheet tool to solve complex business problems using 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)
Past La Trobe University students who have previously completed BUS2DAC Data Analytics Concepts are ineligible to enrol in this subject.
No additional requirements
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 visualisation using Excel (1200 words 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%)
Current study term: 17 Jul 22 to 14 Oct 22
Textbook information is pending.
Bachelor of Business
- Digital Business
- Archaeological and Heritage Studies
- Creative and Professional Writing
- Crime, Justice and Legal Studies
- Digital Media
- Human Geography
- Psychological Science
- Visual Cultures