Renate Mofu

Computer Science Graduate with hands-on experience in Power BI dashboard development, SQL-based data extraction, and data cleaning within a large corporate environment. Strong foundation in computer science, statistics, and machine learning, with experience working with stakeholders to understand business requirements and translate them into clear, actionable insights.

CII Graduate Trainee (Data Analyst) - MultiChoice South Africa - Randburg, Gauteng

(2025-07 - 2026-07)

• Developed four enterprise Power BI dashboards from concept to deployment using SQL Server and SharePoint data sources to support Digital Media Sales, Content & Insights, Content Scheduling and SuperSport reporting across 16 MultiChoice African markets.
• Enhanced and maintained enterprise dashboards by adding rolling 12-month trend analysis, year-on-year comparisons (N 1 vs N), Row Level Security (RLS) for external vendors, improved navigation and additional metrics to increase usability and governance.
• Standardised and updated 14+ Power BI dashboards to align with the new company theme, financial year structure and reporting requirements following the MultiChoice–Canal+ integration.
• Combined, transformed and modelled data from multiple SQL Server tables and SharePoint lists using SQL, Power Query (M), DAX and Excel; created calculated columns, measures and temporary tables to support reporting needs.
• Authored complex T-SQL (JOINs, CASE, CTEs, temp tables, window functions) to extract, validate and prepare data for BI reporting.
• Performed data cleansing, transformation and validation to ensure reporting accuracy and consistency.
• Investigated and resolved data discrepancies by tracing dashboard figures through stored procedures and temporary table logic, identifying incorrect filters that caused underreporting.
• Partnered with cross-functional stakeholders to gather requirements and translate business needs into interactive Power BI dashboards and reporting enhancements.
• Delivered reporting solutions for advertising inventory, content performance vs annual targets, content barters, audience viewership and SuperSport combat sports across multiple African markets.
• Produced ad hoc SQL extracts via SSMS for subscription analysis, customer contract reporting, device migration investigations and DStv Internet non-billable customer analysis.
• Maintained executive and operational reporting by incorporating new channels and programmes into CEO and viewership dashboards.

Computer Science Tutor and Graduate Lecturing Assistant - University of the Western Cape - Bellville, Western Cape

(2024-02 - 2025-07)

• Facilitated tutorial sessions for second-year Computer Science modules.
• Provided academic guidance and constructive feedback on assignments and assessments.
• Assisted with lesson preparation, grading, and student evaluation.
• Supported students with problem-solving in programming and theoretical concepts.

BSc (Hons) - Computer Science - University of the Western Cape (2025-02 - 2025-11)

BSc - Computer Science - University of the Western Cape (2022-02 - 2024-11)