EFASA
A Microsoft Certified Power BI Data Analyst Associate proficient in Power BI, MSSQL, Databases Development and Ms Excel
Dedicated Data Analyst and Data Visualization Expert with experience in driving business growth through data-based insights. Leveraging expertise in data analysis, database development and data mining, I specialize in efficiently analysing data, designing insightful reports, and guiding stakeholders in making data-driven decisions..
Expertise
BI Projects
Marketing Campaign Analysis
Using key performance and traffic KPIs, we effectively track campaign success across various channels and locations. Conversion Rate, Engagement Rate, and Return on Advertising Spend help measure user actions and revenue, while Impressions, Clicks, and Click-Through Rate gauge campaign visibility and engagement. Despite a positive cost-to-profit ratio of 0.10 and an ROI of 10.41%, continuous optimization is crucial for sustained growth and profitability..
View READMETechnical Support Analysis
In today’s world, businesses of all sizes rely heavily on technology for their daily operations. Technical support plays a crucial role in maintaining these systems efficiently. This analysis provides an overview of the performance of the Technical Support Centre.
ViewElectronic Products Ratings and Reviews Analysis
The dataset included ratings and reviews for electronic products from various brands across different stores. Reviews and ratings significantly influence product sales and popularity. I found analyzing diverse product and brand reviews intriguing. My objective was to meticulously analyze and visualize the data, identifying top-performing and highly recommended products and brands. I was the runner-up winner of the Onyx DataDNA Electronics Product Rating Challenge for February. Tools utilized: Power Query and Power BI.
ViewEnd-To-End Microsoft Fabric Project: Exploring Fabric Medallion Architecture Using Pillsbay Reward Dataset
Pillsbay Pharma utilizes the Quickbooks application for daily transactions. In an effort to enhance sales and customer retention, the Quickbooks reward program ensures that customers receive a 2% discount for every 10,000 Naira purchase, which they can redeem on their next purchase. The program was initiated in 2015, and the analysis provides a historical summary to date and a daily summary of reward activity
View READMENorth America Retail Sales Optimization
The project involves a comprehensive analysis of key performance indicators within the retail logistics domain. The primary focus is on dissecting metrics such as loss revenue transactions, extended delivery timelines, and return rates to derive valuable insights.
View READMEXmas Sales Analysis
The dataset under consideration spans Christmas sales data from November to December across the years 2018 to 2023. The primary objective of the analysis is to scrutinize trends in Christmas sales, with a particular emphasis on assessing the impact of events and promotions on sales performance.
View READMEYouTube Data Analysis
The project, initiated by OnyxData on LinkedIn, presented a challenge that required a meticulous analysis of a YouTube dataset within a specific timeframe. The primary objective was to extract valuable insights from the data and formulate actionable recommendations.
View READMESQL Projects
Phone Sales Analysis with SQL
Analysis of Phone Sales. The dataset comprises of sales details for different phone brands across several regions by different distributors.
ViewDanny's Dinner Sql Analysis
In early 2021, Danny, a passionate lover of Japanese cuisine, took a bold step and opened a small restaurant named "Danny’s Diner." Specializing in his top three favorites – sushi, curry, and ramen – the diner needs assistance in leveraging the basic operational data collected during the initial months to enhance business management.
ViewFIFA Dataset Analysis
The football dataset I studied provides extensive information on players, clubs, countries, ratings, and wages. Analyzing trends in player salaries across leagues and countries, I explored the relationships between a player's performance, age, and wages. This comprehensive dataset informs decisions on player recruitment, team management, and salary negotiations in the football industry.
View