BIS155 Course Discussions Week 3

$4.50

BIS155 Course Discussions Week 3
Excel provides many different ways in which to analyze data.  Discuss the different…

SKU: BIS 155 Data Analysis  Categories: , Tags: , , ,

Description

BIS155 Course Discussions Week 3

BIS155 Course Discussions Week 3

All Students Posts – 37 Pages 

Data Analysis

Excel provides many different ways in which to analyze data.  Discuss the different methods by which you can analyze data in your spreadsheet.  Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amounts of sales data you have.  What are some of the ways Excel can be used to analyze this data?  What are some examples of reports you might want to review?  Using the concepts from this week, how will you determine where to start and what tools can you use within Excel to help you organize everything and make decisions? What types of data might a sales manager need to track?

A good way to use Excel by a Regional manager is to track the sales of each store bi-hourly or every 4 hours to see if any of your stores need more coverage during their respective peak hours. You can apply those sales figures to a chart to easily read your data. Another way is to individually track the sales of employees to see if any employees are struggling to meet their sales quota and train them in their problem areas…