QSO 320 H3236 SNHU Improving Performance Through Analysis Excel

Finding out about organizational inefficiencies is the first step to improving performance. To determine what inefficiencies exist, you need to perform a data analysis. A good place to start is with sales. You have to know what data to study and how to use specific tools for data analysis. It’s important to use the IF function, pivot tables, pie charts, bar charts, and histograms. These can help you isolate specific data and organize it in a way that makes it easier to read. Studying measures of central tendency also helps you find out important information. First, you find where inefficiencies in sales exist. Then, you need to be able to talk about the effect this has on the organization.

Directions

For this assignment, you’ll use the Vinho Winery Scenario, linked in Supporting Materials, and other course resources to look at raw data sets. These data sets will explain the production, sales, and distribution of wine. You’ll need to study the different types of wine and distribution centers to figure out their financial effects on the organization’s total profits. All your analyses need to be submitted in an annotated Excel file, and each analysis needs to include your reasons for using the appropriate Excel functions.