Excel is a great tool that allows businesses to analyze data and make important decisions. In this lab, you will be using Microsoft Excel to complete some basic business intelligence tasks for Adventure Works Cycles, a fictional company that manufactures metal and composite bicycles for sale to commercial distributors in North America, Europe, and Asia. Adventure Works also sells bicycles and related products direct to consumers over the Internet. Adventure Works is a multinational company headquartered in Bothell, Washington. The company is currently seeking to expand its market share by targeting high-volume customers, expanding availability of products on the Web, and lowering production costs.
You have been hired as a data analyst for the company. Adventure Works managers have requested that you analyze 3 years of sales and cost data to help them answer specific business questions. In the course of this analysis, you will perform the following in Excel.
- Importing, cleaning, and converting data
- Table analysis
- Pivot tables
- What if analysis
After completing the above tasks, you will write a short opinion paper with your findings and recommendations for Adventure Works.