Marketing Analyst Course

This foundational module covers the theoretical aspects of marketing at Post-Graduation (RQF Level 7) standard. Topics are applicable across all industries and are the starting point for every student on this course.

• What is Marketing? | History and Future of Marketing
• P's of Marketing | Consumer Behaviour | Market Segmentation
• Pricing Strategies | Brands and Brand Development
• Product Life Cycle | Marketing Lifecycle
• Distribution Channels | Promotion in Marketing
• Marketing Ethics and Laws

This module focuses on using data to answer key marketing questions and inform campaign strategy. It includes essential marketing KPIs, competitive analysis frameworks, and Google Analytics.

• Why Analysis Matters and Stakeholders
• KPIs | Competitive Analysis | 7 Dimensions of Marketing
• Budgeting and Forecasting
• Google Analytics

Learn how to improve organic search rankings and drive traffic using proven SEO techniques. This module covers on-page, off-page, local and image SEO, as well as voice search and Microsoft Bing.

• What is SEO? | Why SEO Matters | How Search Engines Work
• On-Page SEO | Off-Page SEO | Site Audit
• Keywords Analysis and Generation | Local SEO | Images SEO | Voice Search
• Google Keywords Planner | Google Trends | Google Search Console
• Google Business Profile Manager | Google Merchant Centre
• Microsoft Bing SEO

Master social media advertising and content management across Facebook, Instagram, LinkedIn, YouTube, and WhatsApp. This module covers both B2C and B2B channels with full campaign management.

• Facebook Business Manager | Pages, Groups and eCommerce Setup
• Facebook/Instagram Advertising and Ads Account (Creation and Optimisation)
• WhatsApp Marketing Setup | Instagram Setup and Linking
• LinkedIn Overview, Page Setup and Marketing
• YouTube Overview, Channel Setup and Essentials
• Hashtags Overview | Social Media Management Tools

Learn to plan, create, and optimise paid advertising campaigns across Google and Microsoft. Covers the full lifecycle from account setup to campaign analysis and tracking integration.

• Account Setup | Ads Setup | Campaign Analysis and Optimisation
• Integration and Tracking | Keywords Analysis

One of the highest ROI channels in digital marketing. This module uses Mailchimp to teach campaign creation, email automation, and customer list management.

• Email Marketing Overview | Why Email Marketing Matters
• Email Content Strategy | Email Marketing through Mailchimp
• Email Automation | Generating Customer Lists — Best Practices

Excel is the most widely used tool in marketing reporting and data analysis. This module covers the full range from basic functions through to Macros and advanced analytical tools.

• IFERROR, VLOOKUP, HLOOKUP, INDEX & MATCH
• PivotTables and PivotCharts — Grouping, Slicers, Timelines
• Audit Tools — Trace Precedents/Dependents, Formula Checker, Watch Window
• Macros and VBA Basics | Scenarios and Goal Seek

SQL enables fast retrieval and analysis of data from relational databases — a core skill for any marketing analyst working with customer, campaign, or web data.

• DDL and DML in MySQL | ERD Diagrams | Data Normalisation
• Basic Queries | Advanced SQL — Joining, Subquery, Views
• Database Security | Multiple Activities to Perform

Python is the leading language for marketing data analysis and automation. Learn to handle large datasets, build reports, automate tasks, and create data visualisations.

• Python Setup | Data Types, Syntax and Operators
• Loops, Statements, Functions and Error Handling
• Modules, Packages and Libraries | File Management
• Multiple Activities and Real-World Projects

Create interactive marketing dashboards and reports with Power BI — one of the most in-demand tools for business intelligence and marketing analytics.

• Introduction to Power BI — Overview, Desktop vs Service
• Data Sources, Connections and Transformation
• Visualisation — Charts, Filters, Customisation
• DAX Functions — Formulas, Aggregation, Expressions
• Sharing, Collaboration and Advanced Topics
• Case Studies and Hands-On Marketing Projects

Using Zoho CRM, this module covers data management, automation, and workflow setup in a marketing context — directly supporting ad campaigns and email marketing.

• CRM Overview | Configuring Zoho CRM Modules
• CRM Automations and Workflow | Web Forms Setup | Social Media Integration

Build and manage a WordPress website with zero coding required — from a personal portfolio through to a full eCommerce store.

• WordPress Setup | Pages, Posts and Customisation
• WooCommerce eCommerce Integration | Mailchimp Integration

Manage marketing projects and client work efficiently using industry-standard methodologies and tools.

• Agile, Scrum, Kanban, PMBOK, Waterfall
• Project Proposal Documents | Project Management Tools

Understand graphic design fundamentals and use Canva to create marketing assets for digital campaigns.

• Raster vs Vector | Composition and Colour Scheme Best Practices
• Canva Software Overview | Video Editing Basics