1. Project Overview

• Title: IMPLEMENTING AN AFFILIATE PROGRAM AND REAL-TIME DASHBOARD FOR PQPLUS
• Objective: To boost sales of the Data Analytics course in Lagos, Nigeria, by implementing an effective affiliate program and real-time dashboard.

2. Key Responsibilities

• Implementation of an effective affiliate program and real-time dashboard for PQPLUS.
• Utilized Power Query and Power BI for data understanding, cleaning, modeling, analysis, and insight generation.
• Analyzed KPIs such as Total Revenue, Total Registration, Activation, Non-Activation, and Conversion Rate for both inbound and affiliate marketing.

3. Key Performance Indicators (KPIs) impacts

• Total Revenue: N43M
• Total Registration: 989
• Activated: 457
• Non-Activation: 532
• Conversion Rate: 46%
• Inbound Marketing Revenue: N41.4M
• Inbound Marketing Registration: 967
• Inbound Marketing Activated: 443
• Inbound Marketing Non-Activation: 524
• Inbound Marketing Conversion Rate: 45.8%
• Affiliate Marketing Revenue: N1M
• Affiliate Marketing Registration: 22
• Affiliate Marketing Activated: 14
• Affiliate Marketing Non-Activation: 8
• Affiliate Marketing Conversion Rate: 64%

4. Data Analysis Insights

• Highlight the significant growth and consistent revenue generation in inbound marketing, suggesting a strategic focus in this area. Optimization of the affiliate program and strategic campaign planning based on seasonal trends are recommended for increased activations and revenue. Budget allocation, customer segmentation, and continuous monitoring are emphasized for effective decision-making and goal achievement.

5. Key Achievements

• Identified trends in revenue generation and seasonality to optimize marketing strategies. Provided recommendations for optimizing affiliate marketing strategies and improving activation rates.

6. Recommendations

Based on the analysis and key findings, the following strategies are recommended to enhance sales performance, optimize marketing efforts, and improve overall business outcomes:

• Leverage Inbound Marketing: Given its high revenue contribution (₦41.4M), prioritize inbound marketing strategies for sustained growth.

• Optimize the Affiliate Program: Improve affiliate recruitment, incentives, and tracking to boost participation and conversion (currently at 64%).

• Utilize Seasonal Trends: Align marketing efforts with peak seasons to maximize activations and revenue.

• Allocate Budget Strategically: Distribute resources based on performance data, ensuring optimal ROI for both inbound and affiliate channels.

• Enhance Customer Segmentation: Tailor messaging and offers to different user segments for improved engagement and conversions.

• Continuous Monitoring & Analysis: Implement a feedback loop to refine strategies based on real-time performance data.

7. Impact Analysis

The implementation of the affiliate program and real-time dashboard has led to:

• Increased Revenue & Market Reach: Improved tracking and insights have enhanced sales strategies, generating a total revenue of ₦43M.

• Enhanced Activation Rates: Data-driven decisions have contributed to a 46% overall conversion rate, with affiliate marketing achieving 64% conversion.

• Improved Decision-Making: The dashboard provides real-time insights, enabling strategic budget allocation and marketing adjustments for higher ROI.

• Stronger Brand Awareness: A well-structured affiliate program has expanded reach, bringing in new prospects and increasing overall engagement.

Interactive Dashboard: Below, you can explore the interactive Power BI dashboard to test the full functionality and experience the KPIs, filters, and visualizations in real time.