Hello. I am Oluwarotimi

I am a Data Analyst with experience analysing operational data to support informed decision-making. Leveraging SQL, Power BI, and Excel, I develop reports, dashboards, and data-driven solutions that help organizations understand performance, identify trends, and uncover opportunities for improvement.

• View Projects
• View Resume

Insight into the relationship expressed over time between climate factors and their effects
on crop production

An analysis of sales, product performance, and customers interaction with various toy categories of Maven Toys.

AFRICAN CLIMATE AND CROP PRODUCTION ANALYSISPROJECT OVERVIEWAgriculture is highly dependent on climate conditions, making environmental factors such as precipitation, rainfall, and temperature critical determinants of crop productivity. This project explores the relationship between climate variables and agricultural production across Africa's major regions using an interactive Power BI dashboard.The objective was to identify climate patterns, examine their relationship with crop production, and provide insights that can support agricultural planning and decision-making.BUSINESS QUESTIONS• How do precipitation, rainfall, and temperature vary across African regions?
• What relationship exists between climate conditions and crop production?
• Which climate variables appear to have the strongest influence on agricultural output?
• How do regional climate differences impact agricultural performance?KEY FINDINGS• Climate conditions vary significantly across African regions, creating distinct agricultural opportunities and challenges.• Precipitation and rainfall show observable relationships with crop production, highlighting the importance of water availability for agricultural success.• Temperature fluctuations appear to influence agricultural performance, particularly in regions exposed to more extreme climate conditions.• Correlation analysis indicates measurable relationships between climate variables and crop output, demonstrating the impact of environmental factors on agricultural productivity.• Regional differences suggest that agricultural policies and climate adaptation strategies should be tailored to local environmental conditions rather than applied uniformly across the continent.BUSINESS IMPACTThis analysis provides a data-driven framework for understanding how climate conditions influence agricultural performance. The insights can support agricultural planning, climate adaptation initiatives, food security strategies, and resource allocation decisions by helping stakeholders identify environmental risks and opportunities.

MAVEN TOYS SALES PERFORMANCE ANALYSISPROJECT OVERVIEWMaven Toys is a retail toy company operating across multiple store locations and product categories. This project analyzes sales performance, product trends, category performance, and store-level results through an interactive Power BI dashboard. The objective was to identify revenue drivers, evaluate product and category performance, uncover sales trends over time, and provide insights that can support inventory planning, merchandising decisions, and overall business growth.BUSINESS QUESTIONS• Which product categories generate the highest sales performance?
• How do sales trends change over time?
• Which stores are performing above or below expectations?
• Which products contribute most to revenue generation?
• How does product performance vary across store locations?
• What opportunities exist to improve sales and inventory decisions?KEY FINDINGS• Sales performance varies significantly across product categories, indicating that certain categories contribute disproportionately to overall revenue.• Product demand is not evenly distributed, with a relatively small number of products driving a substantial share of sales performance.• Sales trends fluctuate over time, highlighting seasonal patterns and periods of increased customer demand.• Store performance differs across locations, suggesting opportunities to identify best-performing stores and replicate successful practices.• Product performance varies by location, indicating that customer purchasing behavior differs between stores and markets.• Performance monitoring at both product and store levels can help improve inventory allocation and reduce the risk of overstocking or stock shortages.BUSINESS IMPACTThis dashboard provides a centralized view of sales performance across products, categories, and store locations. The analysis enables stakeholders to make data-driven decisions regarding inventory management, product assortment, store operations, and revenue optimization.
By identifying top-performing products, categories, and stores, the business can better allocate resources, improve operational efficiency, and support future growth initiatives.