BIAM 500 WEEK 1 BUSINESS INTELLIGENCE

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.
Why did Nationwide need an enterprise-wide data warehouse?
How did integrated data drive the business value?
What forms of analytics are employed at Nationwide?
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.