Reference no: EM13757963
Instructions
Overview- The projects in lesson 5 will provide you an opportunity to practice using Excel Pivot Tables. The pivot table feature is very powerful, and very useful, especially for gaining business intelligence. Understanding how to create, and manipulate, Pivot Tables, is an essential skill.
Project 1
In this project, you will explore data regarding truck routes/deliveries. You are a business analyst for a logistics company, and have been asked to produce reports an upcoming meeting.
1. Open the PivotTable - Truck Route.xlsx file.
2. Review the data to gain an understanding of what is provided in the spreadsheet.
a. Your manager has asked you to produce three pivot tables, showing the following summaries:
i. Total net revenue, by destination, for each year. Your manager also wants to be able to change the data shown using different truck sizes.
ii. Total maintenance hours, by truck size, for each year.
iii. Total driver hours, by destination, for each year. Your manager also wants to be able to change the data shown using different truck sizes.
b. Each pivot table should be created on its own worksheet.
3. Saves the file as Project 5-1_YourLastName.
Project 2
For this project, imagine you are working as a Business Analyst for a Department Store. You have been provided data for the past 5 month's sales (Nov, Dec, Jan, Feb, Mar), and have been asked to provide useful business intelligence, that can be used to improve decision making.
1. Open the Department Sales.xlsx file.
2. Review the data to gain an understanding of what is provided in the spreadsheet.
3. You have been asked to provide two separate BI reports, from this data. You realize Pivot tables would be a useful method for showing this data, and decide to create the following Pivot tables:
a. Total sales value, by department, for each month.
b. Total number of items sold, by department, for each month. You also include the ability to change the data by year.
c. Each pivot table should be created on its own worksheet.
4. Save the file as project 5-2_YourLastName.
|
Benefits of the wireless local area network
: What are primary benefits of the wireless local area network (WLAN)-based mobile computing system and wearable monitoring devices
|
|
Write a program to find the nearest common parent
: Using C#, write a program to find the nearest common parent of any two nodes in a binary tree. Aside from stacks and queues, do not use any data structures that are built into the language.
|
|
How has the music tv industry been affected by the internet
: How do computer viruses spread and in what ways do they affect computers. How has the Music/TV industry been affected by the internet and digital downloading
|
|
Write a research essay on theatre in prisons
: Write a research essay on Theatre in Prisons, Early Theatre: The Greek City Dionysia Festival, The Tony Awards, Christopher Marlowe: The Other Elizabethan Playwright and American Musicals by Stephen Sondheim.
|
|
Business analyst for a logistics company
: The projects in lesson 5 will provide you an opportunity to practice using Excel Pivot Tables. The pivot table feature is very powerful, and very useful, especially for gaining business intelligence. Understanding how to create, and manipulate, ..
|
|
How to put social perception skills into action
: This perception, a process heavily used by management, is the process of interpreting information about other people. In this assignment, you will consider how to put social perception skills into action.
|
|
Analyze test-taking skills by studying certain aspects
: This assignment will ask you to analyze your test-taking skills by studying certain aspects of a test that you recently took.
|
|
Write a memo to linda explaining your position
: Write a memo to Linda explaining your position on this problem and why you think it would be the best solution.
|
|
Logistics criteria for decision making
: Would the logistics criteria for decision making be the same as for mass merchandising? Why or why not
|