From the course: Business Analytics: Sales Data
Join today to access over 24,700 courses taught by industry experts.
How data is structured
From the course: Business Analytics: Sales Data
How data is structured
- [Instructor] Your organization is probably creating a ton of data, then storing that data in Excel or some sort of database. In this video, I'll explain how your data needs to be structured so that you can successfully analyze it. Simply put, your data needs to be deep rather than wide. I've worked with some extremely wide datasets that have had over 1,000 columns. This was a nightmare to try to make sense of, but on the other end of the spectrum, I've worked with some really shallow datasets. If your data only has eight rows, then you're not able to derive any useful insights from studying that dataset. You just don't have enough data points to conduct a deep analysis. Now let's see this in action. I've created these two different datasets in Excel just to illustrate the point I'm making. So we have dataset one, which is in Columns A through C, and then dataset two, which is A through the rest of the…
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.