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

DAY 1

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

DAY 2

Power Query and Power Pivot
Table Tools and Pivot Tables
Timelines and Slicers
Advanced Filters
Solver, Goal Seek
Data validation and protection

DAY 3

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

Who should attend

Marketing Mangers
Sales Managers
Marketing Analysts
Business Analysts
Business Intelligence Managers
Managers using data insights to make business decisions
Executives handling large datasets
Any general users of Excel for financial applications

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

People Analytics Course

This 3 day course will equip finance/supply chain managers and analysts in a variety of industries with the skills to make data-driven decisions.

Supply Chain Analytics

This 3 day course will equip finance/supply chain managers and analysts in a variety of industries with the skills to make data-driven decisions.

Advanced Data Analytics Course

In today’s data-driven world, managers need to be able to effectively use data to make informed decisions and drive innovation.