BIAM 500 Week 1 Complete Work DeVry
Just Click on Below Link To
Download This Course:
https://bit.ly/2zfgyfc
BIAM 500 Week 1 Complete
Work DeVry
BIAM 500
WEEK 1 BUSINESS INTELLIGENCE
Read
“End-of-Chapter Application Case: Nationwide Insurance Used BI to Enhance
Customer Service” at the end of Chapter 1 in the textbook, and answer the
following questions.
1. Why
did Nationwide need an enterprise-wide data warehouse?
2. How
did integrated data drive the business value?
3. What
forms of analytics are employed at Nationwide?
4. With
integrated data available in an enterprise data warehouse, what other
applications could Nationwide potentially develop?
Week 1 Lab
Rubric-500
|
Week 1 Lab Rubric-500
|
|||
|
Criteria
|
Ratings
|
Pts
|
|
|
This criterion is linked to a
Learning OutcomeStep 1 –
Importing, Cleaning, and Converting Data
Sales data sheet contains data
imported from the text file, professionally formatted, with added columns
OrderTotal, FullName, and OrderCategory. Any spelling errors are corrected
and duplicate records, or records with missing data, are removed.
|
10.0 pts
|
||
|
This criterion is linked to a
Learning OutcomeStep 2 – Table
Analysis
Mountain-500 U.S. Orders and
Touring-3000 Australia Orders sheets contain records filtered as indicated.
Sales by Product Category and Sales by Country sheets contain appropriate
subtotals and pie charts.
|
15.0 pts
|
||
|
This criterion is linked to a
Learning OutcomeStep 3 – Pivot
Tables
Sales Pivot by Product Country sheet
contains a pivot table and pivot chart as described in instructions. A second
pivot sheet contains a pivot table and pivot chart using different fields
selected by the student.
|
15.0 pts
|
||
|
This criterion is linked to a
Learning OutcomeStep 4 – /What If
Analysis
Mountain-200 What If sheet contains
baseline model, two one-variable data tables, and two two-variable data
tables. Scenario Summary sheet contains a scenario summary report as described
in instructions.
|
15.0 pts
|
||
|
This criterion is linked to a
Learning OutcomeStep 5 – Opinion
Paper
Provide at least two findings and
recommendations.
|
15.0 pts
|
||
|
Total
Points: 70.0
|
|||
Comments
Post a Comment