User Account

All Pages

What year had the highest sales quantity

Assignment Help Other Subject
Reference no: EM132299938

Reporting Assignment

Scenario

You work as a report developer and analyst for Global Bike International (GBI). Your manager has supplied you with some data related to sales and has requested a number of reports. You task, with a partner, is to create the required reports to answer each of the questions below.

You have been requested to use Microsoft PowerBIto analyse the data. Once you have created the required reports you will need to record the answer and insert a screen shot of the report with the answer highlighted, (in the area below). Each screen shot should include your student ID. Your manager has also asked you to interpret the data and provide an explanation for the results for certain questions.

You need to create a save a separate report for each question.

Question: 1. What is the overall Revenue?

Question: 2. What is the Revenue for E-Bike in 2017?

Question: 3. What is the Revenue for E-Bike in 2016?

Question: 4. What is the Sales Quantity of T-shirts to Airport Bikes in 2014?

Question: 5. What year had the highest Sales Quantity?

Question: 6. What year had the lowest Revenue?

Question: 7. In the year with the lowest Revenue, what Material had the lowest revenue?

Question: 8. Which material has the lowest revenue?

Question: 9. In the year that had the highest Net Sales, what division had the least Net Sales?

Question: 10. For the Division and Year in the previous Question, which customer had the least Net Sales?

Question: 11. In the year with the highest Revenue, what division had the highest sales revenue?

Question: 12. For the Division and Year in the previous Question, which Customer had the highest Net Sales?

Question: 13. What City provided the highest Revenue for Accessories in 2014?

Question: 14. In 2015, for Bicycles what is the total revenue for the top three customers?

Question: 15. What is the average customerRevenuein the Bikes Division in 2016?

Question: 16. What material has had the highest Quantity sold?

Question: 17. Explain the annual revenue trends for the USA and Germany? Develop an appropriate visualisation.

Question: 18. Did GBI ever gain or lose a customer? Explain

Question: 19. Which Material had the biggest drop in Revenue over a one year period? Develop an appropriate visualisation.

Question: 20. What Year and Material did the highest Revenue from a single customer occur in?

Question: 21. Is there any major change in revenue during the five years of data? What were the Materials that contributed to this change? Explain and develop an appropriate visualisation.

Question: 22. Is there seasonality in revenue during the year? If so, what month has the highest revenue? Is the seasonality similar from year to year? Why?

Question: 23. Are there any materials that show dramatic change in revenue?

Question: 24. What is the average % discount of the different deluxe touring bikes (red, silver, black)?

Question: 25. Which bike is the most profitable? Profit = Revenue-(cost of goods+discount) and what is the profit?

Question: 26. What percentage of total revenue was achieved from Chicago in 2014?

Attachment:- Reporting Assignment.rar

Verified Expert

This document is regarding analysis of a dataset using the power bi tool.Answer to different questions has been provided in analysis using various charts and graphs.

Reference no: EM132299938

Questions Cloud

Write code of ethics that business analyst : Write a code of ethics that a Business Analyst needs to follow.
The most successful ideological effects : “The most successful ideological effects are those which have no need for words, and ask no more than complicitous silence.”
Does zappos effectively focus on stakeholder happiness : Does Zappos effectively focus on stakeholder happiness, and how does this approach affect the ethical culture?
Explanation of each of their value in business planning : Explain the following financial tools used for control. Include an explanation of each of their value in business planning.
What year had the highest sales quantity : create the required reports to answer each of the questions - What Year and Material did the highest Revenue from a single customer occur in
New belgium brewing-crafting fresh social responsibility : New Belgium Brewing: Crafting fresh social responsibility-sustainability initiative. Why do you think company has taken such strong stance toward sustainability
Consider the five major types of e-commerce : Consider the five major types of E-commerce. Consider the eight features of E-commerce technology.
Managing business unit following differentiation strategy : What skills should a person have for managing a business unit following a differentiation strategy? Why?
Create organizational chart for that department : Create an organizational chart for that department to include the name and title of the head of that department.

Reviews

Write a Review

Other Subject Questions & Answers

  Create a character analysis

USING EXAMPLES FROM 3 of the 'books/episodes' assigned, CREATE a "character analysis" of one (or more) of Homer's characters in "The Odyssey" and how it affected the success of the entire famous story

  How does reluctance to discuss information found

How does reluctance to discuss information found on the web affect an individual's decision to follow the provider's treatment plan.

  Does the plain view doctrine authorize a warrantless entry

May law enforcement officers take an item off the shelf in an antique store and examine it to determine whether it is stolen? May officers do the same thing in a private home into which they have been invited by a person who does not know they are..

  Discuss romantic love and dating

Marriage and committed relationships, Romantic love and dating

  When is the onset for schizophrenia

When is the onset for Schizophrenia? Do the symptoms appear the same for the genders? What type of therapy do you believe is most effective in working with Schizophrenia?

  Write a summary of the day of atonement

Write a summary of the Day of Atonement (Leviticus 16-17) and show how Christ is the fulfillment of it, focusing particularly on Hebrews 9:1-10:18.

  What does your experience tell you about this situation

What is the article's main point? Do you agree or disagree? Why? What does your experience tell you about this situation

  Our freedom to vote and assemble

The Al Qaeda hate what they see right here in this House chamber [i.e., the U.S. Congress]: a democratically elected government; they hate our freedoms: our freedom of religion, our freedom of speech, our freedom to vote and assemble and disagree ..

  Develop a community teaching proposal of your community

Applying what you have learned thus far, develop a community teaching proposal designed to address the needs of your community.

  Security program-strategic-technical and operational view

A security program should address issues from a strategic, technical, and operational view. The security program should be integrated at every level of the enterprise's architecture. List a security program in each level and provide a list of securit..

  Three differential diagnoses and the usual presenting signs

Reference to at least two current journal articles that show evidence-based practice as how to best treat this disorder related to the primary differential.

  Why are some towns more saturated the others

Examine the history of drug trafficking. Which countries do they come from, how can we control the problem, why are some towns/cities more saturated the others.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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