BYGB/ISGB 7975 SPRING 2023 – BUSINESS ANALYTICS FOR MANAGERS

PROTOTYPE (5% of grade)

Upload zipped file by 3/22/23, Wednesday, 11-59 pm.

Complete surveymonkey by 3/2523, Saturday, 11-45 pm.

Follow the listed instructions carefully:

  1. You may continue to work in your team.
  2. Group members must complete the team member evaluation form and submit confidentially by surveymonkey web site by due date/time. See syllabus for improper or ‘no submission’ individual penalties. When a majority of team members designate lower scores for a team member the individual score would be reduced proportionately. Please complete this form carefully, completely, and thoroughly. Penalties apply for non-compliance.
  3. Penalty for late submission of report itself is 10% for each day delay up to 3 days.

4 Each report must have a cover page with title, names, class, section, date, and name of the course.

  1. The team is responsible for the project, not individual team members.

 

Completeness – is work complete?

Correctness – is the design technically sound? Is correct terminology used?

Consistency – is the report cohesive, or does it appear choppy? Is there flow and continuity?

Communicability – is report formatted professionally? Does report communicate design in easily understood language?

 

 

What to do?

 

  1. Revise concept design based on feedback and zoom meeting (e.g., choosing relevant variables, data size, data file preparation – transpose, normalization, etc.)
  2. Create a Word report with cover page. Include the following:

 

  1. Table of independent variables (REVISED AS PER CONCEPT DESIGN REVIEW).

-name/scale/type/example/control variable – Y/N?

  1. Table of dependent variables (REVISED AS PER CONCEPT DESIGN REVIEW).

-name/scale/type/example).

  1. Data Description REVISED AS PER CONCEPT DESIGN REVIEW).

-size (show calculation), # of years, period, complete

web link to data.

  1. Visual Analytics Matrix Table.

 

VISUAL ANALYTICS MATRIX TABLE FORMAT

 

Research question:

# Hypothesis Question Analytic type Variable(s) Chart Conclusion
1            
2            
3            
4            
5            
             
             

 

Note: submit only a total of 5 hypotheses/questions – one for each chart.

  1. Create 5 Tableau charts. Each team member must do at least one chart.
  2. Each chart should be different (e.g., bubble chart, heat map, trend line, etc.).
  3. Each chart must include a different set of variables.
  4. Examine correlation between independent and dependent variables.
  5. Include a scatter plot/trend line for association between KEY independent and dependent variables.
  6. Charts must be technically correct, and aesthetically designed (e.g., data type, transform data, etc.).
  7. Have a balance of descriptive and predictive analytics.
  8. Chart itself must be free of titles etc. Put title (caption) and name of group member above each chart in Word (e.g., Figure 1: Heat Map of sales/profit for each state – RP Raghupathi). No captions/titles in the chart itself.
  9. Copy/paste chart into Word report, 1 per page. No screenshots, menu items, etc.
  10. For each chart have the following 3 sentences below the chart:
  11. What is the chart (complete sentence)?
  12. What does it show – insight (complete sentence)?
  13. What is implication/recommendation (complete sentence).
  14. Page # in top right corner.
  15. Each page must have a title at top.
  16. Use Times New Roman 14 font.

 

What to submit?

Designate a group member to upload a zipped file with 3 files, all properly labeled (put group name in all file names -spell correctly).

File 1 – Word document.

File 2 – Tableau file(s) (INCLUDE DATA FILE/SOURCE – CHECK – SAVE AS TABLEAU PACKAGED WORKBOOK – TWBX).

File 3 – Exact Excel data file you used (revised from Concept Design).