Comm 305 Assignment 1
.docx
keyboard_arrow_up
School
Concordia University *
*We aren’t endorsed by this school
Course
305
Subject
Communications
Date
Feb 20, 2024
Type
docx
Pages
10
Uploaded by BaronEchidna5024
© May not be copied or duplicated without the permission of the owner.
COMM 305 – Managerial Accounting
© Fall 2023, Section All Sections
Data Analytics Assignment 1
Report Sheet
Matthew Veiga-Bellini
40215269
PLEASE NOTE THE INSTRUCTIONS BELOW:
Fill out your name and student ID in the space above.
Copy and paste each of the 4 CEO questions that were randomly assigned to you in the Data Analytics Assignment 1 CEO Questions, in the dedicated spaces.
For each CEO question:
Paste a screenshot/picture of the corresponding Power BI visual for the question.
Select the correct visual name from the drop-down menu.
Type in your answers for each of the 4 follow up questions.
On the last page, paste a screenshot/ picture of your Power BI dashboard.
Once you have completed all these steps, save this document as PDF with the title “
COMM305_FT2023_DA1Report_STUDENT ID.pdf”
In addition, save your Power BI file with the title “COMM305_FT2023_DA1Report_STUDENT ID.pbix”
Upload your PDF document on the Data Analytics Assignment 1 Upload page, along with your Power BI file. IMPORTANT NOTE
: Make sure both documents are uploaded properly before the assignment
close date, listed on the top of the Upload page. If you upload a wrong document, you can edit your submission up until the assignment close date.
1
© May not be copied or duplicated without the permission of the owner.
CEO Question 1:
How profitable are we in each region?
a)
Insert below a screenshot/ picture of the corresponding Power BI visual for this question.
b)
Select the type of visual you used from the drop-down menu: c)
Answer “The What?” in one sentence. This summarizes your main finding from the visual prepared based on the data.
The south region is by far the weakest region when it comes to generating profit. Both in total profits generated & in average profit per order. d)
Answer the “So What?” in up to two sentences. This puts forward the key implication or takeaway from the finding.
The firm must find a way to increase the average profit per sale in the south which is at 15.99 compared to 200+ for all other regions. e)
Answer the “Now What?” in up to two sentences. This provides a concrete recommendation on
what needs to be done.
I believe a potential solution would be to reduce the shipping costs of the products sold in the south region. Their total shipping costs are higher than the east region who has 200k more in total sales. f)
Answer the “How to Implement?” in up to two sentences. This explains concretely how to implement the recommended action.
2
© May not be copied or duplicated without the permission of the owner.
CEO Question 2:
How much sales and contribution margin are we generating in each product category over time?
a)
Insert below a screenshot/ picture of the corresponding Power BI visual for this question.
b)
Select the type of visual you used from the drop-down menu: c)
Answer “The What?” in one sentence. This summarizes your main finding from the visual prepared based on the data.
Despite having the lowest total value of sales, office supplies category has the highest total contribution margin.
d)
Answer the “So What?” in up to two sentences. This puts forward the key implication or takeaway from the finding.
e)
Answer the “Now What?” in up to two sentences. This provides a concrete recommendation on
what needs to be done.
f)
Answer the “How to Implement?” in up to two sentences. This explains concretely how to implement the recommended action.
3
© May not be copied or duplicated without the permission of the owner.
CEO Question 3:
Who are our low-volume customers?
a)
Insert below a screenshot/ picture of the corresponding Power BI visual for this question.
b)
Select the type of visual you used from the drop-down menu: c)
Answer “The What?” in one sentence. This summarizes your main finding from the visual prepared based on the data.
Small Business and Consumer segments are responsible for the least number of sales at 363k & 357k respectively. d)
Answer the “So What?” in up to two sentences. This puts forward the key implication or takeaway from the finding.
Despite being ahead of Corporate customers in average quantity of order they (small-business & Consumer) still produce only 64-65% of the total sales compared to the leading customer segment.
e)
Answer the “Now What?” in up to two sentences. This provides a concrete recommendation on
what needs to be done.
I believe that to promote more sales from the low-volume customer segments the firm may want to alter their marketing strategy.
f)
Answer the “How to Implement?” in up to two sentences. This explains concretely how to implement the recommended action.
Create a marketing campaign that targets consumers and small businesses directly and makes your products seem more attractive to them. 4
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help