Hi, I'm Rukayat Rauf

A result-driven Data Analyst with over 2 years of experience in data extraction, cleaning, transformation, and visualization. Proficient in Power BI, SQL, Excel, Tableau and Python with proven track record of providing actionable insights and collaborating with cross-functional teams to drive business decisions. Experienced in leveraging data to identify trends, and optimise processes, and enhance decision-making capabilities. Demonstrates excellent problem-solving skills and effectively communicates complex data insights to stakeholders.

Car Insurance Claim Analysis Using Power BI

Performed in-depth analysis of Car Insurance Claims data providing valuable insights into the distribution of claims and factors influencing claim amounts. By employing statistical analysis techniques and leveraging demographic and vehicle data, the project offers actionable insights that can inform insurance company's policies, pricing strategies, and customer engagement activities.

Data cleaning in SQL

Cleaned and transformed data from two databases comprising eight tables by handling missing and empty values, resolving name inconsistencies, correcting datatypes to ensure accuracy and consistency for subsequent Analysis.

Financial Analysis of NYSE Data - Excel

This project involved measuring the Profit and Loss statements and developing a forecasting model for S&P 500 companies. An exploratory analysis of historical financial data was conducted, followed by the creation of a forecasting model to predict Revenue, Gross Profit, and Operating Income under three scenarios: Base, Best, and Weak cases. This analysis provides actionable insights to inform strategic financial decisions.

Call Center Performance Analysis - Power BI

Conducted a comprehensive analysis of call center performance to evaluate service quality and understand customer perception. This project aimed to measure customer satisfaction and sentiment, providing insights into how well the company meets customer needs and identifying opportunities for service improvement.

Exploratory Data Analysis of Chinook Music Store

Conducted an exploratory data analysis using SQL and Power BI to gain insights into the Chinook Music Store's media inventory, customer and employee demographics, and invoice information. This analysis provided valuable understanding of the store's operations and helped identify key trends and patterns in their data.

Customers Segmentation and Profiling - RFM Analysis

Conducted RFM analysis to segment customers based on their transaction history. This analysis evaluates Recency (recent purchases), Frequency (purchase frequency), and Monetary value (total purchase value). Customers were scored across these dimensions to better understand their purchasing habits and optimize marketing strategies.

Tuberculosis Disease Analysis Using Python and Power BI

Performed an analysis of the spread of tuberculosis across WHO countries from 2000 to 2020. This project provided critical insights into the most affected regions, enabling stakeholders to identify areas requiring increased intervention. The analysis supports global efforts to eradicate tuberculosis and achieve a TB-free world.