BIAM 500 Applications of Business Analytics I Full Course
BIAM 500 Applications of Business Analytics I Full Course
BIAM 500 All Weeks Discussions
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?
BIAM 500 WEEK 2 DATA MODELING AND DECISION MAKING
Read the end-of-chapter application case HP Applies Management Science Modeling to Optimize Its Supply Chain and Wins a Major Award at the end of Chapter 10 in the textbook, and answer the following questions.
Describe the problem that a large company, such as HP, might face in offering many product lines and options.
Why is there a possible conflict between marketing and operations?
Summarize your understanding of the models and the algorithms used in this case.
What benefits did HP derive from implementation of these models?
BIAM 500 WEEK 3 TEXT MINING AND SOCIAL MEDIA ANALYSIS
Read the end-of-chapter application case BBVA Seamlessly Monitors and Improves its Online Reputation at the end of Chapter 7 in the textbook, and answer the following questions.
How did BBVA use text mining?
What were BBVAs challenges, and how did BBVA overcome them with text mining and social media analysis?
In what other areas do you think BBVA could use text mining?
BIAM 500 WEEK 4 STRATEGIES AND PERFORMANCE
Read the end-of-chapter application case Smart Business Reporting Helps Healthcare Providers Deliver Better Care at the end of Chapter 4 in the textbook, and answer the following questions.
What is Premier, and what does it do?
What were the main challenges for Premier to achieve its vision?
What was the solution provided by IBM and other partners?
What were the results and benefits from Premiers adoption of the integrated system described in the case?
BIAM 500 WEEK 5 BIG DATA ANALYTICS
Read the end-of-chapter application case Discovery Health Turns Big Data into Better Healthcare at the end of Chapter 13 in the textbook, and answer the following questions.
How big is big data for Discovery Health?
What big data sources did Discovery Health use for their analytic solutions?
What were the main data/analytics challenges Discovery Health was facing?
What were the main solutions they have produced?
What were the initial results/benefits, and what additional benefits do you think Discovery Health may realize from big data analytics in the future?
BIAM 500 WEEK 6 DATA MINING
Read the end-of-chapter application case Coors Improves Beer Flavors with Neural Networks at the end of Chapter 6 in our textbook, and respond to the following questions.
Why is beer flavor important to Coors profitability?
What is the objective of the neural network used at Coors?
Why were the results of Coors neural network initially poor, and what was done to improve the results?
What benefits might Coors derive if this project is successful?
What modifications would you make to improve the results of beer flavor prediction?
BIAM 500 WEEK 7 EMERGING TRENDS IN ANALYTICS AND BUSINESS INTELLIGENCE
Post a one or two paragraph summary of the emerging trend in BI and analytics that you chose to write about for your Course Project paper, describing the most important or interesting things you have learned about it so far. Why did you choose this topic to write about? What is the most surprising thing you found during your research? How does your topic relate to other topics chosen by your classmates?
BIAM 500 All Weeks Labs
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
BIAM 500 All Weeks Course Project Deliverables
BIAM 500 WEEK 2 COURSE PROJECT
Topic Selection
Write a one-paragraph description of the topic you have selected for your paper. The topic should be an emerging trend in data analytics. It may be one of those discussed in Chapter 14 of the textbook or one you discovered through your own research. The professor may require that you change or refine your proposed topic. See the Course Project page in the Introduction & Resources area under Modules for details.
Dont forget to submit your assignment.
BIAM 500 WEEK 4 COURSE PROJECT
Annotated Bibliography
Provide an annotated bibliography listing at least five authoritative, outside references suitable for use in your paper. Requirements for references given in the Guidelines section must be followed. References should be in APA format. Following each reference, write a brief one-paragraph summary of the content of the reference and how it relates to your topic. For any web page used as a reference, include the authors expert qualifications in your summary. See the Course Project page in the Introduction & Resources area under Modules for details.
Dont forget to submit your assignment.
BIAM 500 WEEK 7 COURSE PROJECT
Final Paper
The Final Paper describes an emerging trend in data analytics and business intelligence. It must describe the trend in a way that would be understandable to a nontechnical business manager; provide at least two examples of how the trend is being applied in organizations currently; predict how the trend is likely to develop over the next 5 years; analyze how the trend may impact businesses organizations in the coming years, including both positive and negative impacts; and recommend what you think interested business organizations should do with regard to this trend. See the Course Project page in the Introduction & Resources area under Modules for details.
Dont forget to submit your assignment.
