BIAM 500 Applications of Business Analytics I Full Course
Just Click on Below Link To
Download This 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.
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?
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.
1. Describe
the problem that a large company, such as HP, might face in offering many
product lines and options.
2. Why
is there a possible conflict between marketing and operations?
3. Summarize
your understanding of the models and the algorithms used in this case.
4. 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.
1. How
did BBVA use text mining?
2. What
were BBVA’s challenges, and how did BBVA overcome them with text mining and
social media analysis?
3. 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 Premier’s 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.
1. How
big is big data for Discovery Health?
2. What
big data sources did Discovery Health use for their analytic solutions?
3. What
were the main data/analytics challenges Discovery Health was facing?
4. What
were the main solutions they have produced?
5. What
were the initial results/benefits, and what additional benefits do you think
Discovery Health may realize from big data analytics in the future?
https://bit.ly/2Jwcyf6
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.
1. Why
is beer flavor important to Coors’ profitability?
2. What
is the objective of the neural network used at Coors?
3. Why
were the results of Coors’ neural network initially poor, and what was done to
improve the results?
4. What
benefits might Coors derive if this project is successful?
5. 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
|
|||
https://bit.ly/2Jwcyf6
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.
Don’t 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 author’s expert qualifications in
your summary. See the Course Project page in the Introduction & Resources
area under Modules for details.
Don’t 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.
Don’t forget to submit your assignment.
Comments
Post a Comment