Hi-Tech Business Analysis
Conducted a business performance analysis in Power BI,
creating dynamic dashboards for strategic decision-making.
Key insights identified microchips as the top-selling product,
contributing 38%, 40%, and 37% of sales in the industrial,
consumer electronics, and automotive sectors.
This led to prioritizing microchip production and marketing,
boosting sales. Additionally, recognizing the USA as the highest
profit margin contributor refined market strategy, enhancing profitability.
Loan Portfolio
A loan portfolio analysis from September 2018 to September 2021
revealed a £22.8 million total loan volume with an average APR of 20.6%.
Most borrowers were employed (64%), male (74%), and 42 years old.
Mortgage loans led at £6.8 million, with credit scores mainly between 601-800.
These insights helped optimize marketing, refine loan offerings,
and improve risk assessment, enhancing profitability
LA Crime Data
Analyzing Los Angeles crime data from January 2020 to January 2024 using Power BI revealed
932,000 incidents, with a January peak of 92,000. Wilshire and West LA were the most impacted areas.
Key crimes included 73,759 cases of simple battery assault and 100,225 vehicle thefts,
mainly occurring between 12 PM and 10 PM. Demographics showed 65.54% male victims, with 36.4% of
Hispanic descent. These insights helped law enforcement optimize resource allocation and target
high-risk areas, resulting in reduced crime rates and enhanced public safety.
Health Insights Report
I analyzed the client's health data, showing a stable heart condition with an average resting heart rate
(RHR) of 52.90 bpm, a Heart Rate Variability (HRV) [LF/HF Ratio] of 1.39, and an RMSSD of 35.05 ms,
suggesting some stress but a normal daily stress index. Sleep quality was good, averaging
6 hours and 55 minutes, with healthy SpO2 levels. I recommended maintaining regular exercise,
stress management, a consistent sleep schedule, and a restful sleep environment, while continuing to
monitor these health metrics for balanced heart health, optimal sleep, and manageable stress.
Sales Executive Insights
The Sales Executive Dashboard in Tableau shows a 20.36% increase in total sales and a 14.24% rise in profit
year-over-year. Regions like California and New York drove significant profits.
However, Illinois, Ohio, and Pennsylvania faced losses. Strong sales were seen in Accessories, Appliances,
and Phones, while Chairs and Machines underperformed.
The data indicates overall growth but also highlights areas for strategic improvement.
Supply Chains Returns
The Returns Dashboard shows 509 returns totaling £179,000, with 44% due to dented items.
Key products like malt (183 returns) and chips (134 returns) were most affected. ShipExpert
and Rex Express had the highest return rates, with 53% of complaints categorized as high-risk.
The data highlights significant variability in returns and financial impacts, with Galkus facing
the highest costs at £70,635, and Kaysee leading with £116,000 in return expenses.
