Getting Started with Analytics - Sept-Dec 2021

This micro-credential refreshes existing knowledge and introduces new skills in analytical techniques. Use of spreadsheets to understand key concepts used by analytics professionals: summarising, interpreting and visualising data, forming and testing hypotheses, filtering and transforming data, building models to ask "what if?" questions, or optimising product features. This is an introduction to the technical and philosophical skills required, and the many applications of business analytics. Learning Outcomes • Develop superior skills using spreadsheets to summarise, model and visualise data to make decisions • Understand how data can be interpreted in different ways in line with an agenda, and ask appropriate questions Key Topics • The difference between Data Analysis and Statistics • Cleaning & formatting data • Bivariate analysis • Pivot tables & summary statistics • Advanced Excel and building models • Optimisation Activities • Self-directed online resources • Case studies, group work and in class exercises • A weekly spreadsheet demonstrating mastery of the techniques and methods introduced - assessed • Completion of specific spreadsheet task - assessed • Written reflections on the applying the knowledge - assessed • Excel portfolio reflecting the knowledge gained over the course of the unit - assessed Volume of Learning 75 hours Credit Points 5 AQF Level 8