Skip to content
View piwekasumba's full-sized avatar
🎯
Building SQL & Data Analytics projects (self-taught)
🎯
Building SQL & Data Analytics projects (self-taught)

Block or report piwekasumba

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
piwekasumba/README.md

Hi, I'm Piwe πŸ‘‹

Junior Reporting Analyst | SQL (PostgreSQL) | Business Reporting | KPI Analysis

I’m building practical SQL projects toward a 2026+ Junior / Entry-Level Reporting Analyst career, with a primary focus on Johannesburg/Gauteng and credible remote opportunities.

My work focuses on using PostgreSQL and SQL to work with relational data, investigate business questions, analyse KPIs and trends, prepare reporting data, and apply data-quality checks before drawing conclusions.

Rather than treating SQL as query writing alone, I’m interested in the full reporting process:

Business question β†’ Data β†’ SQL analysis β†’ KPI / measure β†’ Validation β†’ Reporting β†’ Business interpretation

What I Work On

  • SQL reporting using PostgreSQL
  • Business and management reporting
  • KPI and performance analysis
  • Data preparation and transformation
  • Data quality and validation
  • Relational databases and SQL joins
  • Reporting-ready datasets
  • Trend and performance analysis
  • Business-focused data investigation
  • Translating data findings into reporting information

My Reporting Approach

I approach reporting as a process of turning business questions into clear, validated information.

A useful reporting workflow should ask:

What is the business question? β†’ What data is needed? β†’ Are the relationships and values reliable? β†’ How should the data be prepared? β†’ What does the SQL analysis show? β†’ How should the KPI or trend be interpreted? β†’ What could the business learn from the result?

My portfolio projects are built around this way of thinking.

Featured Projects

1. RetailMart Executive Reporting SQL Project

A PostgreSQL portfolio project focused on management reporting, KPI analysis, retail performance and data-quality thinking using a simulated South African retail business scenario.

The project investigates store, product, employee, customer, returns and target performance and demonstrates how SQL can be used to answer management-oriented reporting questions.

Focus: Executive reporting β€’ KPI analysis β€’ Retail/FMCG β€’ Performance analysis β€’ Data quality

View Project

2. Insurance Claims Risk Analytics SQL Insights

A PostgreSQL project focused on insurance claims reporting, KPI analysis, claim severity and risk-oriented business analysis using simulated data.

The project examines claims activity, claim costs, approval patterns, time trends and reporting considerations such as KPI definitions and data validation.

Focus: Claims reporting β€’ Risk indicators β€’ KPI analysis β€’ Data quality β€’ Business analysis

View Project

3. Retail Sales Analytics ETL Data Pipeline

A PostgreSQL project focused on preparing and transforming retail data before it is used for reporting and analysis.

The project demonstrates SQL-based data preparation, transformation, relational data handling and the importance of reliable source data for downstream reporting.

Focus: Data preparation β€’ ETL concepts β€’ Data transformation β€’ Relational data β€’ Reporting data

View Project

4. SQL Data Analytics Fundamentals for Business Reporting

A foundational PostgreSQL project covering the core SQL and relational database concepts used throughout my reporting portfolio.

It includes querying, filtering, joins, aggregation, table relationships and analytical SQL exercises using practical business-data scenarios.

Focus: SQL fundamentals β€’ PostgreSQL β€’ Relational databases β€’ Joins β€’ Aggregation

View Project

Portfolio Progression

The projects are intentionally connected rather than being four unrelated SQL exercises:

SQL Fundamentals β†’ Build reliable relational-querying foundations

Retail Sales ETL β†’ Prepare and transform data for downstream analysis

RetailMart Executive Reporting β†’ Apply SQL to management-focused reporting and KPI analysis

Insurance Claims Risk Analytics β†’ Apply the same reporting discipline to a different business context

This progression reflects the type of evidence I am building for entry-level reporting and data-analysis work.

Skills

SQL & Database

  • SQL
  • PostgreSQL
  • SQL Joins
  • Common Table Expressions (CTEs)
  • Aggregate Functions
  • Relational Databases

Reporting & Analysis

  • Business Reporting
  • KPI Analysis
  • Executive Reporting
  • Trend Analysis
  • Data Analysis
  • Performance Analysis
  • Reporting-Ready Datasets

Data Preparation & Quality

  • Data Cleaning
  • Data Transformation
  • Data Quality
  • Data Validation
  • Relational Data Preparation

Career Direction

I’m building toward Junior / Entry-Level Reporting Analyst opportunities, particularly in Johannesburg/Gauteng, with credible remote opportunities as a secondary target.

I’m interested in roles where SQL and reporting skills can support:

  • Business and operational reporting
  • KPI and performance measurement
  • Data validation and quality checks
  • Reporting-data preparation
  • Trend and variance investigation
  • Business analysis
  • Clear communication of data findings

My portfolio is intentionally focused on building evidence of practical SQL and reporting ability, while continuing to strengthen my analytical skills.

About This Portfolio

These projects use simulated or learning datasets and are portfolio exercises rather than claims of production experience.

My goal is to demonstrate what I can actually do with SQL/PostgreSQL today, while continuing to build stronger reporting and analytical capability.


Junior Reporting Analyst | SQL (PostgreSQL) | Business Reporting | KPI Analysis

Pinned Loading

  1. RetailMart-Executive-Reporting-SQL-Project RetailMart-Executive-Reporting-SQL-Project Public

    PostgreSQL 18 retail reporting project using simulated South African sales data to practise management reporting, KPI calculations, SQL analysis, data validation and business interpretation.

    PLpgSQL

  2. Insurance-Claims-Insurance-Claims-SQL-Reporting-Project-SQL-Insights-Project Insurance-Claims-Insurance-Claims-SQL-Reporting-Project-SQL-Insights-Project Public

    PostgreSQL SQL portfolio project using simulated insurance claims data to practise claims reporting, customer and policy analysis, KPI calculations, data-quality checks and operational monitoring.

    PLpgSQL

  3. Retail-Sales-Analytics-ETL-Data-Pipeline-Project Retail-Sales-Analytics-ETL-Data-Pipeline-Project Public

    PostgreSQL retail data-preparation project using simulated data to practise SQL-based ETL concepts, relational table design, data transformation, validation and reporting dataset preparation.

  4. -SQL-Data-Analytics-Fundamentals-for-Business-Reporting-PostgreSQL- -SQL-Data-Analytics-Fundamentals-for-Business-Reporting-PostgreSQL- Public

    PostgreSQL SQL learning project covering relational data, filtering, sorting, joins, aggregation and business-question practice using simulated data.cises.