Talentdigit

It has been an incredible learning experience with Talentdigit. I’ve successfully enhanced my skills in data analysis, specifically using Power BI and Excel. With my background in business analysis, this training has helped me take my expertise to the next level, combining both data and business insights.

My first completed milestone in my Data Analysis learning path with Talentdigit

Memdal Retail Stores Sales Dashboard Analysis This project involved designing and developing a comprehensive sales dashboard for Memdal Retail Stores, focused on visualizing key business metrics from 2016 to 2019. The dashboard provides insights into the store’s revenue, expenses, profit margins, and sales trends across different products, branches, and customer segments. Key highlights of the dashboard include: Revenue, Expenses, and Profit Analysis: The store generated a total revenue of ₦29,357,978, with expenses amounting to ₦17,277,380, leading to a profit of ₦12,080,598 and a profit margin of 41%. Sales Insights: 27,658 total orders were processed, with a return rate of 3%. The analysis showcases the top products by profit, with Mountain and Road Bikes being the best-selling categories. Branch Performance: Ibadan led the way with the highest profit (₦6,459,327), followed by Surulere and Lekki branches. Customer and Product Returns: Product returns data are analyzed by reasons such as unmet expectations and wrong products. Customer segmentation is also done by gender, with nearly equal contribution from both male and female customers. Profit Growth Trends: Month-over-month and year-over-year profit growth trends highlight seasonal peaks in sales and yearly profit fluctuations, helping identify opportunities for improvement. This dashboard provides actionable insights to drive better decision-making in inventory management, customer targeting, and sales strategies. Tools used: Microsoft Excel (Pivot Tables, Data Visualization), Power Query. Talentdigit #DataAnalyst #Excel

I’m delighted to embark on a journey of becoming a certified data analyst, and I made the good decision to take this journey with the guidance of TalentDigits. So far, it’s been a smooth, interactive and educative journey. And I’ve been able to create a good dashboard using Microsoft excel. I’ll be doing more projects with time and also do other courses on data analytics like the use of Power Bi, SQL and others