Retail diagnostic BI project shared

A retail analyst published a Power BI case study showing how a store can trace profit, returns and delivery problems across four years of transactions. (github.com) Joy Ibe’s public GitHub profile links the X account in the post and describes her as a Nigeria-based data analyst documenting portfolio work. One of the repositories, “BWZ Sales Performance Analysis Report,” lays out a three-page retail dashboard built in Power BI with DAX and Power Query. (github.com 1) (github.com 2) The BWZ project says the sample business generated $2.30 million in sales, posted a 46.7% profit margin and recorded a 5.91% return rate. The analysis breaks performance into product categories, shipping and delivery, sales representatives and customers. (github.com) Business intelligence is software that turns raw rows of orders into patterns managers can act on, like a store ledger that updates itself by product, customer and route. Microsoft’s Power BI retail sample uses the same approach to compare sales, units and gross margin across stores and time periods. (learn.microsoft.com) In Ibe’s case study, Technology produced about 36.4% of sales and 41.59% of profit, even though it accounted for 18.32% of quantity sold. Furniture trailed on profit, while Office Supplies carried a higher return rate and stronger sales in September and November. (github.com) The report also focuses on delivery and shipping mode bottlenecks, a common retail problem because late or inefficient fulfillment can erase margin after the sale. Ibe says the dashboard was built to answer stakeholder questions about category strategy, returns, loyal customers and efficient sales representatives. (github.com) The underlying method is standard for modern retail analytics: clean the data, split it into smaller linked tables, calculate measures such as profit and return rate, and then visualize the results. Microsoft says retail dashboards in Power BI are designed to track year-over-year performance and gross margin in exactly that way. (github.com) (learn.microsoft.com) Ibe’s other public retail project, Durv Stores Sales Analysis, uses a similar structure and reports year-over-year changes from January 2023 to August 2024, including a 46.73% drop in unit sales alongside a 58.26% rise in revenue. That second repository shows the same emphasis on pricing, cost efficiency and product mix rather than sales volume alone. (github.com) Taken together, the published work shows the kind of diagnostic reporting retailers use to decide which categories to push, which customers to retain and where delivery or returns are eating into profit. The thread’s core point is simple: the sale is only the start of the margin story. (github.com)