From the course: Business Analytics: Sales Data
Join today to access over 24,700 courses taught by industry experts.
Categorical analysis
From the course: Business Analytics: Sales Data
Categorical analysis
- [Instructor] Categorical analysis is a very powerful tool at your disposal. It helps you identify which items, categories, or assortments are performing well. The well-performing items are a great place to start your sales strategy 'cause these are the items that are performing well out on the marketplace. This means that you've hit on something. In this video, I'm going to show you how to create a PivotChart in Excel that will help you identify which of your items are performing well. I'm using the exercise file from this course. So feel free to open up that file and follow right along. The first step is to select Cell A1, then hold down Shift + Ctrl and hit the right arrow and the down arrow. Once the entire dataset is selected, then toggle to the Insert tab and select PivotChart. Since we've highlighted the entire data set, this range will appear in the Create PivotChart dialogue box. So all you have to do is hit…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.