A skilled data analyst with strong background in statistical and visualization tools, I excel at transforming complex data sets into actionable insights. With a proven record of leveraging data visualization tools to communicate findings effectively, I am good at identifying trends and patterns that driven strategic decision making. My expertise in SQL, Power BI, Tableau and Excel enables me to analyze data with precision and deliver valuable solutions to optimize business growth
Microsoft Excel Project
Analytical Tool: Microsoft Excel Project Title: Analysis of research survey Project requirement Build a dashboard that answer the following questions. 1. I). Total amount spent for subscription ii). Sum of the average cost of transportation per week iii). Total number of people that participated in the survey 2. How much was spent for each of the network for subscription 3. What is the distribution of network used by the people? 4. Which of the meal for breakfast is most preferred? 5. What is the distribution of favorite drinks base on age bracket?This analysis provides insights into the spending habits and preferences of a survey group.Key insights include: • The majority of participants (65%) use the MTN network, followed by GLO (21%) and Airtel (14%). • MTN subscribers spend the most on subscriptions (211,500), followed by GLO (50,800) and Airtel (30,000). • The average cost of transportation is significantly higher (321,150) than the total amount spent on subscriptions (302,300). • The most preferred meal for breakfast is white rice and stew (17), followed by bread and beans (7), akara and pap (7), yam and sauce (6), and jollof rice (6). • Soft drinks are the most popular beverage choice across all age groups (26-40, 40+, and 19-25). • The majority of participants (32) prefer sachet water over bottled water (11).Recommendations for Business Opportunities 1. Telecommunication: The dominance of MTN in the survey group suggests a potential business opportunity to offering services that cater to MTN subscribers. 2. Food and Beverage: The preference for white rice and stew, as well as soft drinks, indicates a demand for these products. When considering starting a food business, Rice and stew should be giving priority in the morning for breakfast to cater to this demand. 3. Water and Beverage Sales: The popularity of sachet water presents an opportunity to start sachet water business. 4. Transportation Services: The high average cost of transportation suggests a need for affordable and efficient transportation services. Considering starting a transportation business or partnering with existing transportation providers as this will generate more revenue.Basic Analytical Skills Deploy 📌Data Cleaning 📌Pivot table 📌Data Visualization 📌Slicer
Project Description: This analysis is to examine the attrition of a company with 780 employees base on year of services, department, performance rating, job satisfaction rating etc.
Executive Summary: The results show that the out of 780 employees in the company, the retention rate is 70% while an attrition rate is 30%. The analysis highlights key trends and insights into the factors contributing to attrition.
Insights 1. Age Group Attrition: Young adults (91) and young employees (65) have the highest attrition rates. 2. Salary Range Attrition: Employees in the medium salary range (122) have the highest attrition rate. 3. Performance Rating Attrition: Employees with poor (76) and average (70) performance ratings have higher attrition rates. 4. Department Attrition: HR (49), Finance (46), and Sales (44) departments have the highest attrition rates. 5. Job Satisfaction Attrition: Average employees have a higher attrition rate (190), Dissatisfied employees (38) while satisfied employees have list attrition rate (6). 6. Job Roles Attrition: Specialists (86) and Engineers (51) have higher attrition rates. 7. Year of Service Attrition: Attrition rates fluctuate across different years of service.Recommendations 1. Targeted Retention Strategies: Develop targeted retention strategies for young adults, medium-salary range employees, and those with poor or average performance ratings. 2. Department-Specific Initiatives: Implement department-specific initiatives to address high attrition rates in HR, Finance, and Sales. 3. Employee Engagement and Satisfaction: Focus on improving employee engagement and satisfaction, particularly for dissatisfied employees. 4. Professional Development Opportunities: Provide professional development opportunities for specialists and engineers to reduce attrition rates. 5. Exit Interviews and Feedback: Conduct exit interviews and gather feedback to better understand the reasons behind attrition and identify areas for improvement.
Project DescriptionThe analysis of the Bike Store Sales dataset reveals key insights into revenue generation, product sales, and seasonal trends. . The United States generates the most revenue, followed by Australia and the United Kingdom. Bikes are the best-selling product category, accounting for 61% of total revenue. Accessories and clothing are also significant contributors to revenue. The analysis also reveals seasonal trends in product sales, with December and June being the most profitable months.
Project Requirement 📍Total quantity order 📍Sum of revenue 📍Total Cost 📍Sum of profit 📍Sum of revenue generated by Country 📍Sum of revenue generated by Product 📍 Product category with the highest sales 📍Trend of sales 📍Profit generated per month
Basics Analytical skills deployed📌Power Query Editor 📌Data Cleaning 📌Power BI DAX 📌Power BI Data Visualization 📌Slicer
Project Requirement📌The Organization is planning to gift the best performing manager who made the best sales and want to know the region which the manager belongs to? 📌how many times was delivery truck used as the ship mode? 📌how many orders were returned, and which product category got rejected the most? 📌which Year did the company incurred the least shipping cost? 📌display the day of the week in which customer segment has the most sales? 📌The company want to determine its profitability by knowing the actual orders that were delivered. 📌The Organization is eager to know the customer names and persons born from 1980? 📌what are the aggregate orders made by all the customers? 📌The company intends to discontinue any product that brings in the least profit, you are required to help the organization to determine the product? 📌what are the top 2 best-selling items that the company should keep selling?
Key Findings📍 Best performing manager: Pat from west, Ontario, Quebec and Yukon regions 📍Shipping mode: Delivery Truck used 2,166 times 📍 Least shipping cost: $ 46,997.38 in 2011 📍 Delivered orders profit: $2,560,886.13 📍Aggregate orders made by all customers: 410K 📍Least profitable products: Tables ($185,744.06), Bookcases ($78,383.54), storage and organization ($32,756.77) and scissors, rulers and trimmers ($12,901.28) 📍Top selling products: Paper, Telephone & communication
