Devry BIAM410
Week 4 Lab: Database Structure and Implementation
Scenario
The CEO of your organization is looking for some analytics from the AdventureWorks data warehouse. Your responsibility is to select several variable/Entities from the AdventureWorks data warehouse and analyze the results. 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 LabWeek4xxx.docx (where xxx = your initials).
Step
Deliverable
Points
2
Successfully import and open AdventureworksDW2017.
10
3
Create Donut Chart using the following fields: Freight, Dealer Price, Unit Price. Create Bar Chart using the following fields: Freight, Dealer Price, Unit Price.
10
4
On your own, develop two additional charts using the chart options you select and using the fields available (20 points per chart).
40
5 – Reflection
Include a discussion of your results and recommendation for the CEO.
20
Total
A quality assignment will fulfill all criteria
80
Required Software
