Sean Kamugasa

1. NORTHWIND TRADERS

THE SITUATION:
Northwind Traders executives are interested in building a top level KPI dashboard to help them quickly understand the company's performance in various key areas.

DATA CLEANING TOOL USED:
SQL, Microsoft Power BI Desktop, Python, Excel

2. VIOLENCE AGAINST WOMEN

OVERVIEW:
The UN describes violence against women and girls (VAWG) as: “one of the most widespread, persistent, and devastating human rights violations in our world today. It remains largely unreported due to the impunity, silence, stigma, and shame surrounding it.”

Violence Against Women manifests itself in physical, sexual, and psychological forms, encompassing:

Intimate partner violence (battering, psychological abuse, marital rape, femicide).

Sexual violence and harassment (rape, forced sexual acts, unwanted sexual advances, child sexual abuse, forced marriage, street harassment, stalking, cyber-harassment).

Human trafficking (slavery, sexual exploitation).

Female genital mutilation and

Child marriage.

Violence against women continues to be an obstacle to achieving equality and peace, as well as to the fulfillment of women and girls’ human rights. All in all, the promise of the Sustainable Development Goals (SDGs) - to leave no one behind - cannot be achieved without putting an end to violence against women.

DATA TOOLS USED:
SQL, Microsoft Power BI, Python, Excel

3. TRIPPLE J TELECOM CHURN ANALYSIS

THE SITUATION:
Tripple J Telecom is losing customers at a very high rate to competitors. As a Business Data Analyst Consultant,
You've been hired to help the company improve retention by identifying high value customers and churn risks.
DATA TOOLS USED:
SQL, Microsoft Power BI, Python, Excel

KELVIN GALABUZI Senior Devops Engineer @ Trainer Road, USA

“Sean is one of the few people that is always learning and improving on the way of completing a task. I would definitely recommend him for any software development project not only because of his passion for career development, but the skills he embraces when learning and explaining the inner workings of even the most complex software systems."

RONNIE LUTARO Consultant @ UN WOMEN

“Sean is a very hardworking individual with great work ethic and whose goal oriented personality yielded great results for the organization. He was able to derive insights from complicated and complex datasets through the usage of data tools like Python, SQL, Power BI & Excel. This enabled the organization to make data driven decisions thus improving ROI."