BIAM 500 Week 1 Complete Work DeVry



BIAM 500 Week 1 Complete Work DeVry


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

Step 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

Step 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

Step 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

Step 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

Step 5 – Opinion Paper

Provide at least two findings and recommendations.
15.0 pts
Total Points: 70.0



There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Add to cart