BIAM 500 All Weeks Labs DeVry

BIAM 500 All Weeks Labs DeVry
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
Week 2 Lab Rubric-500
Week 2 Lab Rubric-500
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeStep 1: Creation of Formulas with Constraints
Touring Bike Model Mix sheet has correct set up of problem with all parameter values, constraints, and formulas.
15.0 pts
This criterion is linked to a Learning OutcomeStep 2: Use Solver to find an optimal solution.
Objectives, variables, constraints, and solution method are correctly set in the Solver dialog, and the correct optimal production quantities are shown on the Touring Bike Model Mix sheet. Answer, sensitivity, and limits reports for the solution were generated correctly.
15.0 pts
This criterion is linked to a Learning OutcomeStep 3: Perform Sensitivity Analysis
Perform sensitivity analysis showing how changing parameters by plus or minus 10% affects the solution. A scenario summary sheet was created showing how the optimal product mix is affected by changing the gross profit per unit of each model by plus or minus 10% compared to the original solution.
15.0 pts
This criterion is linked to a Learning OutcomeStep 4: Create Monte Carlo Simulation
Monte Carlo simulation calculates and charts the average gross profit over 100 simulations for the specified range of production quantities.
15.0 pts
This criterion is linked to a Learning OutcomeStep 5: Opinion Paper
Write a one-page paper explaining your findings and making recommendations. Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis.
10.0 pts
Total Points: 70.0
Week 3 Lab Rubric-500
Week 3 Lab Rubric-500
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeStep 1: Analysis of Simple Six-vertex Network
Provide a NodeXL-based workbook that contains analysis of simple six-vertex network. Network vertices and edges entered correctly; directed network graph displayed with vertices labeled, color-coded by gender, and sized by in-degree.
25.0 pts
This criterion is linked to a Learning OutcomeStep 2: Capture and Analyze Twitter Feed
Provide a NodeXL-based workbook that contains analysis of simple six-vertex network. Network vertices and edges entered correctly; directed network graph displayed with vertices labeled, color-coded by gender, and sized by in-degree.
25.0 pts
This criterion is linked to a Learning OutcomeStep 3: Opinion Paper
Write a one-page paper explaining your findings and making recommendations. Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Paper includes a list of 10 specific key influencers with the reason why each was chosen.
20.0 pts
Total Points: 70.0
Week 4 Lab Rubric-500
Week 4 Lab Rubric-500
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeCreate Dashboard with Summary of Key Metrics
Summary of key metrics with call numbers, trend lines, abandon rate with traffic light status indicator, and orders for all shifts and each shift individually
10.0 pts
This criterion is linked to a Learning OutcomeCreate Calls Handled by Auto Response Chart
Column chart for percent of calls handled by auto response, including target line and slicers for day type and date
10.0 pts
This criterion is linked to a Learning OutcomeCreate Additional KPI Displays
At least two additional KPIs of your choosing relevant to the strategic objective displayed on the dashboard with appropriate visual representations and clear descriptive labeling.
20.0 pts
This criterion is linked to a Learning OutcomeFinalize Workbook
Dashboard is professionally formatted with data and calculation sheets hidden; gridlines, formula bar, and row/column headings not visible on the dashboard sheet; and professional use of colors, fonts, borders, and shapes.
10.0 pts
This criterion is linked to a Learning OutcomeWrite Opinion Paper and Submit
Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Findings and recommendations are relevant to the strategic objective and are supported by the dashboard.
20.0 pts
Total Points: 70.0
Week 5 Lab Rubric-500
Week 5 Lab Rubric-500
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeStep 1: Create Simplified Star Schema in Student Data Warehouse
Screenshot showing successful copying of the FactCurrencyRate, DimCurrency, and DimDate tables from the AdventureWorksDW data warehouse to the student data warehouse
10.0 pts
This criterion is linked to a Learning OutcomeStep 2: View Data from Related Tables in the Data Warehouse
Screenshot showing data from the FactCurrencyRate, DimCurrency, and DimDate tables in the student data warehouse
10.0 pts
This criterion is linked to a Learning OutcomeStep 3: Create and Deploy a Data Cube
Screenshot showing the measure and dimensions of the Internet Sales data cube, with a status message indicating successful deployment of the cube
10.0 pts
This criterion is linked to a Learning OutcomeStep 4: Browse the Cube
Screenshot showing a pivot table and pivot chart generated by browsing the cube, with SalesTerritoryCountry as the columns, the Fiscal Year-Quarter-Month date hierarchy as the rows, and SalesAmount as the values
10.0 pts
This criterion is linked to a Learning OutcomeStep 4(d): Browse the Cube (d: on your own)
Screenshots showing at least two additional pivot tables and corresponding pivot charts generated by browsing the cube, with different choices for the row and column dimensions
20.0 pts
This criterion is linked to a Learning OutcomeWrite Opinion Paper and Submit
Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis.
10.0 pts
Total Points: 70.0
Week 6 Lab Rubric-500
Week 6 Lab Rubric-500
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeStep 1: Load and Prepare Data
Workbook contains worksheets for the OldCustomer and NewCustomer data sets. Age column was added to both sheets with formula to calculate customer age. CustomerClassification column was added to both sheets, with formula to determine customer classification on the OldCustomers sheet only.
15.0 pts
This criterion is linked to a Learning OutcomeStep 2: Define the Training/Testing and Prediction Data Sets
A training and testing data set is defined based on the OldCustomer data, and a prediction data set is defined based on the NewCustomer data. Variable types are set appropriately for both data sets.
15.0 pts
This criterion is linked to a Learning OutcomeStep 3: Train and Test Neural Network
Neural network is trained based on the training and testing data set, and tested using a randomly selected sample of 20% of the cases. Individual case test results are in the OldCustomers sheet, and summary results are in the Lab6_yourlastname_Summary workbook.
15.0 pts
This criterion is linked to a Learning OutcomeStep 4: Predict Classifications for New Customers
Predicted classifications generated by the neural network are recorded in the NewCustomers sheet.
15.0 pts
This criterion is linked to a Learning OutcomeStep 5: Write Opinion Paper and Submit
Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Findings and recommendations are relevant to the strategic objective and are supported by the dashboard.
10.0 pts
Total Points: 70.0

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
BIAM 500 All Weeks Labs DeVry
Get a 15% Discount on this Paper
Order Now
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with MyCoursebay
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Other
great
Customer 452813, June 25th, 2022
Nursing
Completed early! Awesome job!!!!!
Customer 452453, March 8th, 2023
Human Resources Management (HRM)
Thanks
Customer 452701, August 22nd, 2023
Nursing
Thank you!
Customer 452707, April 3rd, 2022
English 101
Although a little late, the content and structure of the paper was great! I would definitely use this writer again!
Customer 452561, July 12th, 2021
Social Work and Human Services
Excellent Work
Customer 452587, November 22nd, 2021
Social Work and Human Services
Thank You!
Customer 452587, November 17th, 2021
Nursing
Thanks
Customer 452521, May 13th, 2021
Human Resources Management (HRM)
Thank you so much for your time.
Customer 452701, September 5th, 2023
Criminal Justice
Looks good! Thank you Jason
Customer 452711, January 25th, 2022
Strategic Management
Thanks for the help, really appreciate it
Customer 452821, September 8th, 2022
Other
GOOD
Customer 452813, July 5th, 2022
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Good News ! We now help with PROCTORED EXAM. Chat with a support agent for more information

NEW

Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now