Devry BIAM410
Week 5 Lab: Plotting Entities in Network Navigator
Scenario
The CEO of your organization is looking for some specific analytics from the AdventureWorks data warehouse, particularly any network relationships. Your responsibility is to select several Entities from the AdventureWorks data warehouse and plot them in NetworkNavigator found in PowerBI. You have access to MS PowerBI and will need to develop multiple charts from the data warehouse results and report back to the manager.
Server: ML-RefVm-820127
Database: AdventureWorksDW2017
Deliverables
After completing the steps below, submit a single Microsoft Word file named LabWeek5xxx.docx (where xxx = your initials). This file will contain the following:
A network chart screenshot containing the following fields: FrenchDescription, ProductLine, and Freight.
A screenshot viewing the tables with relationships in the PowerBI window.
A screenshot of a network chart you have created using 3 fields of your choice.
A discussion of your results and recommendations for the CEO.
You will be graded based on the rubric below:
Step
Deliverable
Points
3
Create network chart using the following fields: FrenchDescription, ProductLine, and Freight. Take a screenshot. View the tables with relationships in the PowerBI window and take a screenshot.
30
4
On your own create a network chart using three fields of your choice. Hint: select first two fields from Dim table with third field from Fact table. Take a screenshot.
30
5 – Reflection
Include a discussion of your results and recommendation for the CEO.
20
Total
A quality assignment will fulfill all criteria
80
