Skip to content

Marketing Analytics Course

About This Class

This 3 day course will equip marketing managers and analysts in a variety of industries with the skills to make data-driven decisions. Delegates will gain the ability to extract and interpret key business insights for competitive advantage. Furthermore, it will help individuals understand and forecast how customers purchase products and services and how they respond to marketing initiatives.

This course is designed specifically for individuals working in marketing, aspiring to work in marketing analytics, or those in leadership positions looking to boost the efficiency and effectiveness of their marketing departments. It will also benefit middle and senior managers seeking to upgrade their knowledge and move their careers in a new direction.

The course will enable delegates make data-driven marketing decisions, define and evaluate brand, measure customer lifetime value, test hypotheses, and interpret outputs.

All principles and concepts are demonstrated with practical examples in Excel, which will form a portfolio of examples to which delegates can refer back to.

Local Fee

R 12,999

International Fee

$ 900

Book my seat

Share

Download Brochure

Day 1

01 Practical Dashboard Applications
02 Visualisation of Data into a selection of Charts
03 Combo Charts; Progress Charts; Sunburst Chart
04 Gauge Chart (including Spin Buttons)
05 Advanced Conditional Formatting

Day 2

01 Power Query and Power Pivot
02 Table Tools and Pivot Tables
03 Timelines and Slicers
04 Advanced Filters
05 Solver, Goal Seek
06 Data validation and protection

Day 3

01 Statistical analysis and sample tools
02 Logical functions (including nested IF statements)
03 Maths functions (including SUMIF and SUBTOTAL)
04 Date and time functions
05 Useful tools and shortcuts

Who should attend

Expert Trainer

The trainer for this course is a Chartered Accountant (SA), Associate Chartered Management Accountant, Chartered Global Management Accountant, with strong academic and industry experience. She holds a Master’s degree in Management Accounting and has more than nine years of lecturing experience at the University of Pretoria and North-West University respectively, for which she has received distinctive teaching awards.

As a lecturer, she specialised in Management Accounting, Costing, Financial Management and Business Strategy to students of various levels. This is besides providing business simulations, supervising research projects and external moderation and reviewing of other universities’ exam papers and study guides.

She has been delivering training to both government institutions and private sector companies in similar subject areas, including Microsoft Excel, financial and business skills training, as well as consultation in fields related to financial modelling in Excel, optimising power tools in Excel and Power BI.

Recommended Courses

Strategic Learning & Development Masterclass

17 – 19 April

Virtual Online

HR Analytics & Metrics Program  

20 – 22 May

Live Online Training

HR Business Partnering Program

5 – 7 June

Live Online Training