Variations on like for like comparison - Unplugged #45
In this episode of Unplugged, we explore how to answer a student's question about a variation of the like-for-like calculation. Specifically, the student is interested in computing sales in stores other than the base store, considering only those stores that have the same product assortment. This is an interesting twist on the traditional like-for-like comparison, which compares sales in stores that are geographically close and have a similar product mix.
Through this video, you'll learn how to approach this problem and calculate the sales for the selected stores using Excel. We'll walk you through each step, highlighting the key formulas used and explaining the reasoning behind them. By the end of the video, you'll have a better understanding of how to perform like-for-like comparisons with a twist.
Whether you're a student looking to enhance your analytical skills or a business analyst looking for new ways to analyze your sales data, this video will provide you with valuable insights and techniques.
The video can be accessed through the following link: https://www.youtube.com/watch?v=JfqQxGzlCHk
Published on:
Learn more
Related posts
Retail Management & Demand Forecasting Reports In Power BI
In this Power BI Showcase, the focus is on retail management reports which provide detailed analysis on individual store sales and demands. Th...
Configure Sales Copilot for D365 Sales (preview)
If you're a Dynamics 365 user looking to streamline your sales process, Sales Copilot is a powerful tool that can help you achieve your goals....
How to compare Last Year Last Month Sales Vs Current Year Sales Dynamically? #Daxsundays #powerbi
In this video tutorial, you'll learn how to compare sales data from the last month of the previous year to the current year in Power BI. The t...
Dynamics 365 Sales: Product Forecasting – Part 2
In part 2 of this series on product forecasting with Dynamics 365 Sales, the author continues their discussion on the topic, building upon the...
Dynamics 365 Sales: Product Forecasting – Part 1
In this post, you'll gain insight into the forecasting feature that comes with Dynamics 365 Sales. The product is like an org chart and presen...
Enhanced Trend and Flow Chart in Sales Forecasting within Dynamics 365 CRM
Sales forecasting is a crucial aspect of any business, and having efficient sales processes enables smooth operations and successful outcomes....
Sales Forecasting-Increase Accuracy with AI Predictive Forecasting
Sales Forecasting is a crucial aspect of any business, as it helps businesses to predict their future sales and enables them to make informed ...
Exploring sales usage reporting feature in Dynamics 365 CE sales analytics
Microsoft is constantly improving the reporting capabilities within Dynamics 365, and one of the latest features is the sales usage reporting ...
Exploring additional filtering capabilities in Sales Forecasting
If you're a seller or manager looking to track sales performance, Dynamics 365's sales forecasting feature is an invaluable tool. In the 2022 ...