victor langat

Performance Analyst

[email protected] +254 0791226765

Resume

Hello, I am

victor langat.

1

Excel
Project

3

PowerBI
Projects

1

Python
Project

About Me

Welcome to my professional space! I am a driven data analyst with a keen eye for transforming raw data into meaningful insights. Armed with a Bachelor's degree in Computer Science, I discovered my natural knack for data analysis and embarked on a journey to master key tools such as Excel, Power BI, SQL, and Python.

Currently, I serve as a Performance Analyst at Kenya Revenue Authority, where I oversee end-to-end performance management processes. Here, I have successfully integrated my expertise in Power BI and Excel to craft a dynamic performance monitoring dashboard, significantly enhancing the efficiency of Performance reporting.

Beyond my role, I have passionately undertaken various business projects, showcasing my ability to leverage analytical skills in real-world scenarios. My portfolio, linked below, serves as a testament to the impact of my work. As an individual deeply committed to continuous learning and growth, I am excited to bring my unique blend

Key Skills

SQL

Python

Effective Communication

Project & Stakeholder management

My Projects

Sales Analytics(FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Sales, Marketing and Supply Chain

Toman Bike Share Dashboard

Domain/Function: Sales

AtliQ Mart Dashboard for Supply Chain

Domain/Function: Supply Chain

Expense Management System

Domain/Function: Personal Finance

My Experience

1.) Designed, developed and maintained an interactive dashboard in Power Bi to track performance of staff on consequence management program. This improved efficiency and data accuracy by 90%.

2.) Conducted an impact assessment survey, analyzed results in SPSS and prepared an impact assessment report with recommendations which improved the Performance Contract Quality Assurance exercise by 90%.

3.) Designed a multi-view dashboard in Power BI for 6 departments (sales, finance, supply chain, executive, marketing, and products) of AtliQ hardware to understand sales trends and facilitate data-driven decisions, which aimed to scale the business processes by 10%.

4.) Imported 2 different data sources (MySQL, and Excel) with more than 1 million records and performed data modeling.

5.) Optimized the report using DAX studio, which saved 30% of storage and improved performance by 10%

Awards & Certificate

Google Data Analytics

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/victor-langat-891756104/

Call Me

+254 0791226765

GitHub

https://github.com/0791226765

Excel Project

Sales Analytics(FMCG)

Created four(4) reports for the sales team which will help them to evaluate customer performance, track Key Performance Indicators using the P&;L statement i.e. Net Sales, Cost of Goods Sold (COGs) & Gross Margin (GM) and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights.

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to build one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Toman Bike Share Dashboard

Domain/Function: Sales

Development of a dashboard to track revenue/profit performance on various KPIs including: 1. Hourly Revenue Analysis 2. Profit and Revenue Trends 3. Seasonal Revenue 4. Rider Demographics Thereafter provide a recommendation on raising prices in the following year

Hourly sales data across a week

KPIs performance over Time

Project Details

Problem Statement: Development of Toman Bike Share Dashboard
Requirements
1. Hourly Revenue Analysis
2. Profit and Revenue Trends
3. Seasonal Revenue
4. Rider Demographics

Design and Aesthetics: Use of company colors and make the dashboard easy to navigate
Data source: Create a database in SQL Server Management Studio from the Excel data provided

Data Analysis Workflow
1. Create a Database
2. Develop SQL queries
3. Connect Power Bi to DB
4. Build a dashboard in Power Bi
5. Answer the Analysis question

Live Interactive Dashboard

PowerBI Project

AtliQ Mart Dashboard for Supply Chain

Domain/Function: Supply Chain

The customers for AtliQ Mart did not renew their contracts with the company. My goal is to build a dynamic dashboard for service level tracking and eventually improve reliability of AtliQ's Supply Chain.

Key Metrics visualization

Metrics performance over time

Project Details

In this project, the goal is to build a dashboard that will be used by the Company's Director and the Supply Chain Team. The following are the focus areas:
1. Tracking of key Supply Chain Metrics
2. Drillable Insights
3. User empathetic design

I learned the following implementing the project:
1. Key supply chain metrics i.e. On Time delivery (OT%), In Full delivery (IF%), On Time In Full delivery (OTIF%), Line Fill Rate (LIFR%), Volume Fill Rate (VOFR%)
2. Importance of asking questions during requirements gathering
3. Data Modelling

Live Interactive Dashboard

Python Project

Expense Management System

Domain/Function: Personal Finance

A web app for tracking and analyzing personal or business expenses. It features dynamic dashboards using Streamlit, allows users to filter spending by category and date and provides insights for better financial decision-making.

View Project
on GitHUB

Visualizes spending by category with bar charts and tables. Users can filter data by date to gain financial insights

Displays daily spending trends over a selected period using Area charts to help users monitor and understand spending patterns.

Project Details

This Expense Management System is a web application designed to help users manage, track and analyze personal or business expenditures. The system allows users to add and update expenses through a clean, user-friendly interface built with Streamlit. It features date filtering, category-based analytics,monthly analytics and Daily Trend Analysis using Altair charts. Backend APIs built with FastAPI handle data processing and analytics requests, while the frontend ensures smooth interaction and real-time feedback. The platform supports insights generation by displaying total and percentage-based expenditures per category, month and day within a selected date range, helping users make better financial decisions.