From the course: Excel for Business Analysts
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Troubleshooting at the organization - Microsoft Excel Tutorial
From the course: Excel for Business Analysts
Troubleshooting at the organization
- [Instructor] The ultimate goal of business analytics is to make recommendations to management based on what the data tells us might happen going forward. But at its core, business analytics starts with just understanding what's going on at the firm, so we can make recommendations based on the current situation. Let's take a look at an example. I'm in the 03_04_Begin Excel file. Now what we have here are data on six hypothetical retail locations for a store chain. And we've got data on their daily number of customers over a three month timeframe as well as data on their daily sales over that same timeframe from January through March, 2020. Now the first problem that I see here, kind of looking at it, we've gone through and summed up the number of customers. And we have kind of an average number, etc, but it's very hard for me to kind of interpret this. Sure, I see that it looks like location three and four are doing…
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.