Ssenjovu Brian

Data Analyst · Excel · Power BI · SQL · PostgreSQL

brianssenjovu17@gmail.com • Kampala, Uganda • LinkedIn Profile

Professional Summary

Data analyst with hands-on experience turning raw data into clear business insights. Skilled in Excel, Power BI, SQL, and PostgreSQL. I build dashboards, write queries, and clean datasets to support decision-making. Open to full-time, part-time, and freelance opportunities.

Core Skills

Excel — Advanced Formulas (XLOOKUP, INDEX/MATCH, SUMIFS)
PivotTables & PivotCharts
Power Query (ETL)
Power BI — Dashboards & Reports
DAX (Data Analysis Expressions)
SQL — JOINs, GROUP BY, Aggregate Functions
PostgreSQL — Database Design & Querying
Data Cleaning & Transformation
Data Visualization
Reporting & KPI Tracking
Conditional Formatting & Data Validation
Business Analysis

Featured Projects

1. Sales Performance Analysis Dashboard

Power BI · DAX · Power Query · Data Modeling · Data Visualization

Ssenjovu Brian's completed Power BI Sales Performance Dashboard showing KPI cards, revenue trends, product revenue, customer segments, and profit by category — Sales Performance Dashboard — Power BI report screenshot

Developed an interactive sales dashboard to monitor revenue, profit, customer and order KPIs. The report includes monthly revenue trends, revenue by category and product, customer-segment analysis, and a year slicer. DAX measures support total revenue, total profit, profit margin, previous-year revenue, and revenue growth analysis.

Business purpose: Make sales performance easier to review by bringing key metrics and trends into one interactive report.

Power BI Dashboard

DAX Measures

Interactive Year Filtering

2. Sales Analysis Dashboard

Power BI · Power Query · Data Modeling

Sales analysis dashboard built in Power BI

Built an interactive Power BI dashboard analyzing sales performance. Cleaned and transformed raw data with Power Query, standardized date and number formats, and created KPI cards and visuals to explore sales by region, category, and over time.

619.17K Total Sales

1,332 Orders

665 Customers

3. SQL Business Analysis (PostgreSQL)

PostgreSQL · SQL · Aggregate Functions · GROUP BY

Loaded a 9,800-row e-commerce dataset into PostgreSQL and wrote SQL queries to answer business questions, including top customers by revenue, sales by category, segment performance, yearly trends, and average order value. This project demonstrates database querying, aggregation, and business-oriented data analysis.

2,261,536.97 Total Sales

9,800 Orders

793 Customers

Education & Certifications

Self-taught: Excel, Power BI, SQL, PostgreSQL
Microsoft Office Specialist — Excel: In progress

Contact

📧 brianssenjovu17@gmail.com
🔗 Connect with me on LinkedIn