DAT 520 Module Five Lab Worksheet
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
520
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by JusticeBravery13171
Module Five Lab Worksheet
More Model Practice Overview
Now that you have built out both a top-down and bottom-up decision tree using Power BI, it’s time to get some more practice building and interpreting these analytic tools. In this lab, you will build two decision trees leveraging the same data set and identify where each of these tools’ strengths and weaknesses lie.
Scenario
You are working as a data scientist for a large international organization that sells several products in different global markets. Your CEO wants to discuss expansion opportunities and understand how some pieces of business data impact the decisions being made. Being the brilliant individual you are, you volunteered to dive into the analysis!
Instructions
Complete the steps in the uCertify lab 7.1 More Model practice. Then,
replace the bracketed text with the relevant information. Please note: This assignment will be submitted and graded in Brightspace. 1.
Take a screenshot of the filtered bottom-up decision tree and insert it below.
a.
Explain what is happening here.
[we have used the product (Montana) that contributes the most to the average profit]
b.
What does this bottom-up model attempt to address?
[The bottom-up model helps understand how the selected variables influence profit. ]
2.
Take a screenshot of your top-down decision tree and insert it below.
a.
Explain what is happening here. [Breaking down the products that fall under the lowest value in cost of goods sold.]
b.
What does this top-down model attempt to address?
[Highlights which products are the most profitable when COGS is lowest]
3.
If your boss wanted to expand the business and wanted to identify which products historically created the highest profits based on the cost of goods sold, which type of model would you want to present? [The bottom- up approach works here. We are able to see the select the highest value and see which products influenced that factor. ]
4.
If your boss wanted to predict (based on historical sales numbers) the profits of a given product based on the number of units sold and the cost of goods sold, which type of model would you use?
[Top-down model works here. We see how the historical data influences profits and show how it
could influence profit in the future.]
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