Embedded Files
I am a Data Analyst passionate about turning complex datasets into visual stories. I specialize in Power BI, Excel and SQL to help businesses make data-driven decision.
SKILLS:
Power BI
Power Query
Advanced Excel
Data Modelling
Financial Fraud & Risk Analysis Dashboard
Financial Fraud & Risk Analysis Dashboard
The Challenge
Detecting hidden patterns in high-volume financial data to prevent fraudulent losses.
The Data
Size: 100,010 individual credit card transactions.
Focus: Risk factors like location mismatch, foreign transactions, and device trust scores.
Tool used
Microsoft Excel: Data cleaning and initial 'Analytical & Quantitative' audit
Power BI: Advance DAX modelling and interactive 'Performance Dashboard' development.
Key Result:
Risk Score: Identified a 34% fraud rate in targeted high-risk test cases.
High-Risk Category: Found that Travel Marchant carry the highest risk of fraud
Security Gap: Proven correlation between low and device trust scores and fraudulent activities.
Retail Time-Series & Sales Analysis
Retail Time-Series & Sales Analysis
Analyzed over500,000 rows of retail data to identify sales trends and optimize business operations.
The Results:
Seasonality: Identified December as the peak sales month.
Promotions: Recommended 11:00 AM as the ideal time for marketing.
Inventory: Spotted an 82% sales surge on the 31st, requiring a specific restocking cycle.
Global Population Growth & Demographic Insights
Global Population Growth & Demographic Insights
Analyzed historical population data to identify growth patterns across different regions and income groups.
Page updated
Google Sites
Report abuse