Master Essential Skills & Topics for Retail and CPG

Having strong foundations in Excel is a critical skill that most business professionals require at a basic level in order to be effective and efficient at data analysis. This needs to go beyond a training course that simply teaches how to calculate a mortgage and perform other basic functions that will most likely never be used, or an online course that covers generic use of data. This virtual classroom training dives into the most important elements of Excel to give participants confidence while working in the application, including: moving around a spreadsheet, writing basic formulas like SUM, COUNT, RANK, UNIQUE, IFERROR, and conditional formulas, formatting cells, understanding absolute and relative ranges, and creating basic charts and PivotTables. We use examples that are very common in retail and CPG, so it also helps participants learn some best practices in analyzing and calculating key measures in their data. There are many hands-on workshops in this fast-paced session. We can adjust focus areas based on the unique needs of your organization with an emphasis on specific topic areas. We can also use data and examples from your business to increase relevancy. SESSION DETAILS: Optimum class size: 10-15 participants (maximum 25) Length of session: 120-150 minutes Cost: Starts at $3,000 USD (includes development, customization, delivery, student notes, hands-on workshops). Multiple sessions of the same topic are at a reduced price. Core Competency: DATA AND ANALYTICS This session can be combined with other training topics to create a virtual training series over days, weeks or months.

This virtual training session gives participants a strong foundation of the considerations when using data, including a review of the unique data sources available to their organization, how they are derived, and how and when they should be used. Following the data overview, we will review the key measures from each data source, practice the calculations, and learn how to drill through data (geography, time period, product, measures) for improved business understanding. Finally, we will discuss ways to draw relevant insights by looking across multiple data sources. This virtual classroom training will give your team a hands-on learning that includes workshops using your data and examples for incredibly powerful learnings that consider all the nuances of the data that is most relevant for your business. The session is relevant for retailers, suppliers and 3rd party solution providers who want to get more proficient at drawing actionable insights from their data. SESSION DETAILS: Optimum class size: 10-15 participants (maximum 25 participants) Length of session: 120 minutes Cost: Starts at $3,000 USD (includes development, customization, delivery, student notes, hands-on workshops). Multiple sessions of the same topic are at a reduced price. Core Competency: DATA TO INSIGHTS This session can be combined with other training topics to create a virtual training series over days, weeks or months.