Class Details
Business Analytics Course: Data-Driven Decision-Making
Course summary
In today's business environment, data is everywhere. But collecting data and actually using it to make smarter decisions are two very different things. This hands-on business analytics course gives you the frameworks, tools, and confidence to bridge that gap, turning raw data into clear insights, and clear insights into better decisions.
Designed for professionals, this intensive one-day course takes you through the full analytics journey — from understanding what your data is telling you today, to predicting what is likely to happen tomorrow, to recommending what your organisation should do next. You will work with real datasets, industry-relevant tools, and practical frameworks you can apply in your workplace from day one.
You will learn to think analytically, communicate findings to non-technical audiences, evaluate the ethical implications of data-driven decisions, and navigate the rapidly evolving role of AI in analytics. The analytical tools covered can be applied to data generated within operations, sales, marketing, finance, human resources and customer functions.
Aims
The aims of this course are to:
- introduce you to the world of business analytics with evidence based and data-driven decision-making
- instruct you how to perform a range of analytics techniques across a wide range of organisational settings
- assist you to understand the role of software in facilitating the implementation of analytics techniques
- assist you with extracting insight from data and telling an evidenced based story
- address information privacy and ethics considerations with the use of data
- examine the future of business analytics with Artificial Intelligence assisted technology.
Learning outcomes
By the end of this course, you should be able to:
- discern the best type of data for making an evidenced-based decision
- decide how to best store and access data, taking into account cybersecurity, privacy and ethics considerations
- perform a range of analytics tasks across a wide variety of organisational settings
- decide the type of software that can best assist you when applying analytics techniques to a business problem
- tell data-driven stories by extracting pertinent insight from data
- prepare for future use of data with Artificial Intelligence assisted technology.
Content
Module 1: Business analytics fundamentals
- The distinction between analytics, data science and statistics
- The 4 levels of business analytics – descriptive, diagnostic, predictive and prescriptive
- The business analytics cycle – from discovery through to operationalisation
- Exercise – working through the full analytics cycle from defining the business problem to data modelling and interpretation
Module 2: Data types, storage and access
- Nature of data – metric and non-metric variables
- Types of data – structured, semi-structured, and unstructured data
- Data storage architectures – data warehouse, data lake, and data hub
- Accessing data – relational databases and SQL versus non-relational databases and NoSQL
- Relational database design – primary keys, data elements, data types, and data domains
- Data governance – data dictionaries and data catalogues
- Exercise – data preparation, pivot table analysis, visualisation, and interpretation
Module 3: Data Insights with analytics
- Principles of data visualisation for business decision-making
- Key considerations for effective data visualisation
- Chart selection – eight relationship categories and when to use each
- Principles of storytelling – the Situation-Complication-Resolution framework
- Data insights with non-numerical data
- Exercise – text analytics: transforming unstructured sentiment data into a visual story
Module 4: Ethics, information privacy, bias and data governance
- Ethics in an analytics context – the three practical questions every analytics professional should ask
- Online behavioural targeting
- Information privacy
- Secure data management
- Algorithmic bias
- Practical decision-making framework for analytics professionals
- Activity – ethical dilemmas: applying the framework to analytics scenarios
Module 5: The future of analytics with AI
- What AI means for business analytics professionals
- Three types of AI relevant to analytics practice – machine learning, natural language processing, and generative AI
- What AI is changing and what it is not: the skills that become more valuable in an AI-enabled analytics environment
- Where analytics is heading
Prerequisites
This course requires basic Excel skills.
Who this course is for
This course is intended for people without prior knowledge of analytics who are keen to use data to make better informed decisions and persuade others with insights derived from objectively prepared data.
This course will assist people interested in analytics from all backgrounds. You may be progressing towards management, be a new manager, or a manager with many years of experience across any of the following fields:
- Sales & marketing professionals
- Customer Experience Officers/Managers
- Supply chain/ Logistics/Operations Managers
- Finance Officers/Managers
- Business Managers
- Business Analysts
- General Managers
- anyone who wants to develop their data skills.
Delivery modes
- Face-to-face, presenter taught workshop
- Online workshop via the platform Zoom
Delivery style
Delivered as a one-day workshop using various techniques including lectures, analytical thinking, break-out discussions and exercises, as well as demonstrations using practice datasets.
Materials
Course materials (presentation and datasets) are shared electronically using Dropbox.
What you need to do before the course
Face-to-face classes
Please bring your own laptop with Excel pre-installed.
Sessions
Location
Face-to-face (CCE Building, Sydney)
Public transport
As bus and train timetables regularly change, we suggest you visit the Transport for NSW trip planner before you set out.
The nearest train stations are Newtown Station and Macdonaldtown Station. Macdonaldtown Station is closer by distance than Newtown Station, however trains do not stop as frequently as at Newtown Station.
Other information
Parking
Nearby parking is available at Wilson Parking - RPA Medical Centre Car Park (entry via Elizabeth Street off Carillon Avenue).
A Flexi Saver Rate is available but must be booked in advance online and includes the booking fee. Bookings can be made via the Wilson website or by downloading the Wilson Parking App. Otherwise, hourly parking rates will apply, as advertised on the Wilson Parking website.
Meet the facilitators
John Le Mesurier
John brings a wealth of business, management, IT, consultancy and training experience to many of the professional development courses on offer at CCE. This experience has included senior corporate and general management roles in American, British and Chinese multinationals, as well as consultancies for several leading UK and Irish management firms. His consulting projects have covered advanced practice studies in leadership, sales & customer service processes, strategic sourcing, human resource models and organisational issues. These projects have been undertaken in North & South America, Europe and China. His international client list includes Procter & Gamble, Red Bull, Johnson & Johnson, SC Johnson, Eli Lilly, Roche, Mitsubishi, Vodafone/ Hutchison Telecoms, Danone, Heineken, BOC/ Linde, Boehringer Ingelheim, British Government and Qantas. John also works for an Australian consulting firm, Newfocus, conducting projects in the government and Not-For-Profit sectors. John has been involved in projects at PwC and Macquarie University.
John is currently undertaking a M. Phil/ PhD and holds a Master of Business Administration (with Distinction), Bachelor of Arts (with Distinction), majors in Psychology and Statistics, sub-majors in Accounting and Economics; Diplomas in Management, Change Management, Risk Management, Project Management; Digital Badge in Advanced Analytics, Graduate Certificate in Learning & Teaching, and Certificate IVs in Competitive Manufacturing (Lean) and Training and Assessment. John has been awarded the highest qualification by The Australian Research Society, namely Qualified Professional Researcher. John is an accredited Sydney Lifeline counsellor, where he also trained counsellors for more than 20 years.
John has lectured in Bachelor of Business at Torrens University, Master of Business Analytics at Kaplan Business School and Master of Community Development offered through Southern Cross University (SCBIT Sydney campus). John has been an Executive Coach at UNSW, where he has also been a guest lecturer in marketing and change management. He has taught 1st year statistics at UTS (Insearch) and Macquarie University (Navitas) and delivered IT training in corporate settings for 30 years.
