Pairview Training Services is a trading name of Pairview Limited
Company No. 06988921. Registered Office: The South Quay Building, First Floor, 189 Marsh Wall, London E14 9SH
Authorised and regulated by the Financial Conduct Authority (Firm Reference Number: 649638).
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:
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).
b) Analyse the financial contribution of each Segment – (i.e. order quantity, cost, revenue, profit) based on Gender, Marital Status, Education, occupation per segments.
c) Which country and city are the most profitable, assuming the currency value is the same across the world?
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.
Submission Instructions
1. Submission requirement
Please submit the pbix file for the Power BI assignment.
1. Email address for submission:
• To: [email protected]
Cc: [email protected]
The The South Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay Building South Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay BuildingSouth Quay Building South Quay BuildingSouth Quay Building
First FloorFirst Floor First FloorFirst FloorFirst FloorFirst Floor , 189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall189 Marsh Wall
London E14 9SHE14 9SHE14 9SHE14 9SHE14 9SHE14 9SHE14 9SH
T: 0800 907 8235 0800 907 82350800 907 8235 0800 907 8235
E: [email protected] [email protected]@pairview.co.uk [email protected]@[email protected] [email protected]@[email protected] [email protected]
www.pairviewtraining.co.uk www.pairviewtraining.co.uk www.pairviewtraining.co.uk www.pairviewtraining.co.ukwww.pairviewtraining.co.uk www.pairviewtraining.co.ukwww.pairviewtraining.co.ukwww.pairviewtraining.co.ukwww.pairviewtraining.co.ukwww.pairviewtraining.co.uk www.pairviewtraining.co.ukwww.pairviewtraining.co.uk www.pairviewtraining.co.ukwww.pairviewtraining.co.uk www.pairviewtraining.co.ukwww.pairviewtraining.co.ukwww.pairviewtraining.co.ukwww.pairviewtraining.co.uk
Pairv iew Training Services is a trading name of Pairview Limited
Company No. 06988921. Registered Office: The South Quay Building, First Floor, 189 Marsh Wall, London E14 9SH
Authorised and regulated by the Financial Conduct Authority (Firm Reference Number: 649638).
2. Assignment deadline
• Please refer to the email to which this document was attached.
3. Pairview Training Support contact details:
• To: [email protected]
Cc: [email protected]
• Please email us your query/problem first. Please attach a screenshot of what happened if it is regarding a technical issue. This helps us diagnose the cause of your problems to advise you more quickly and efficiently. We will try our best to respond to you within 24 hours of receiving your email.
• Available from Monday to Friday, from 9am to 5pm
We wish you all the best with your learning and career development.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
