Business analyst for a logistics company

Assignment Help Business Management
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.

Reference no: EM13757963

Questions Cloud

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

Reviews

Write a Review

 

Business Management Questions & Answers

  Limitations of traditional strategic choice models

Limitations of traditional strategic choice models particularly in terms of rational choice expectations and assumptions about control as well as predictability

  Different types of product development teams

Contrast the different types of product development teams and describe the different situations when each type would be preferable

  Potential solutions that exist to remedy the situation

Provide the potential conflict of interest between Security Analysts, and the Investment Bankers working for the same firm - what are the potential solutions that exist to remedy the situation?

  Organizational behavior terminology and conceptsdescribe

organizational behavior terminology and conceptsdescribe the following key concepts and terminology using articles

  Some countries have omnibus data protection laws

Some countries have omnibus data protection laws which regulate all data about identifiable people. One country which has comprehensive data protection laws is.

  Recruiting motivation and managerial actions

Write Walter's parents, stressing that the scholarship will cover all of his tuition, room and board, and book expenses.

  Describe the four functions of management

Describe the four functions of management and Include an explanation of how each function relates to an organization.

  Details regarding organizational change

Details regarding Organizational Change - Explain the critical incident by the leader that caused the leadership to fail

  Business communication effective leadersconsider the

business communication effective leadersconsider the following statement an effective leader is always in control of

  Explain how are electronic communication devices

Based on your experiences, express both the advantages and disadvantages of these three devices over traditional communication methods, such as face-to-face conversations, written notes and phone calls.

  Forecast for total yearly amount of money

The given time series information represent the quarterly amounts spent on advertising by a large toy firm:

  Factors identified with high performing organizationsthis

factors identified with high performing organizationsthis solution provides the learner with an understanding of

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd