Daniel Van Blerk

Excel · SQL · Tableau · Power BI

Data Analyst with a proven track record of improving data-related processes, enhancing reports and optimizing usability.

Selected Projects

Sales Performance Dashboard

Dynamic dashboard highlighting sales performance across various metrics. Dashboard is informed by a robust data model created using Power Query & Power Pivot. QOL enhancements made with VBA.

Excel VBA Data Visualization

Download Excel File

SQL Stock Analysis

High-grade SQL shown through advanced financial queries on historical stock index data.

SQL CTEs Window Functions

Link To GitHub

SQL E-Commerce Analysis

Comprehensive analyis of an e-commerce dataset, uncovering sales patterns, product performance, and customer behaviour

SQL Aggregate Functions Data Cleaning

Link To GitHub

About

Detail-orientated analyst highly proficient in Excel and SQL to deliver accurate and actionable insights. With proven experience in improving operational efficiency and facilitating data-driven decision-making.