This essay has been submitted by a student. This is not an example of the work written by professional essay writers.
Uncategorized

Course Assignment

Pssst… we can write an original essay just for you.

Any subject. Any type of essay. We’ll even meet a 3-hour deadline.

GET YOUR PRICE

writers online

 

Course Assignment

 

For the course: Analytics and Reporting with Power BI

Business Requirements

 

 

 

Question 1

ADW company would like to know the most profitable Customers within its online sales channel, in order to inform their campaign strategies

 

As the Insight Analyst, you have been requested to:

  1. a) Create 3 segments based on the value of profit per customer. Name the segments Low

Profitable (<=400), Mid Profitable (<1000) and High Profitable (>=1000).

 

  1. b) Analyse the financial contribution of each Segment – (i.e. order quantity, cost, revenue, profit) based on Gender, Marital Status, Education, occupation per segments.

 

  1. c) Which country and city are the most profitable, assuming the currency value is the same across the world?

 

  1. d) Which sales reason is driving the largest volume sales and revenue?

Complete the task using PowerBI and use the Adventureworks Datawarehouse as your main data source.

 

Question 2

Over the years AHG has expended a huge portion of their budget in improving their sales channels performance. You have been hired to provide a self-updating decision engine that would allow them to track performance across the sales channels at the click of a button.

 

 

Question 3

AHG is interested in understanding the best mix of campaign channel to adopt in order to optimise their campaign spend. Please provide visualisation to support the marketing department effort.

 

 

Question 4

You have been requested to develop a BI visualisation that would allow business users to understand the top 5 sales reason driving sales performance.

  Remember! This is just a sample.

Save time and get your custom paper from our expert writers

 Get started in just 3 minutes
 Sit back relax and leave the writing to us
 Sources and citations are provided
 100% Plagiarism free
error: Content is protected !!
×
Hi, my name is Jenn 👋

In case you can’t find a sample example, our professional writers are ready to help you with writing your own paper. All you need to do is fill out a short form and submit an order

Check Out the Form
Need Help?
Dont be shy to ask