From the course: Business Analytics: Sales Data
Join today to access over 24,900 courses taught by industry experts.
Overcome the most common sales data challenges
From the course: Business Analytics: Sales Data
Overcome the most common sales data challenges
- [Instructor] When you analyze your sales data, you may notice it's incomplete, inconsistent, or filled with duplicates. Don't worry, you're not alone. In the real world, almost every salesperson encounters these challenges. In this lesson, I'll walk you through the most common sales data problems and show you how to solve them. The first challenge is incomplete data. You might see missing customer names, absent contact information, like geolocation or phone numbers, blank revenue fields, or skipped dates. This often happens when data is entered manually, imported from sources with mismatched formats, or collected through forms that don't require all fields. To fix this, start by identifying blanks, using filters or conditional formatting. Then decide whether you can fill them in or flag them for follow up. Second is inconsistent naming. For instance, Widget A versus widget-a and all caps WIDGET A might all refer…
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.