Assignment 1

MSDA On-ground Course Syllabus DAT 6020: Database Design Principles and Technologies

Version 1 March 2018

Course Information Term and Year: August 2022 Class Location: Alliant International University, San Diego, CA Instructor Information Name: Dr. Dexter Francis Phone: 904.631.0525 Email: [email protected] Office Hours: Available by appointment; 1 hour before class University Mission Statement Alliant International University prepares students for professional careers of service and leadership and promotes the discovery and application of knowledge to improve the lives of people in diverse cultures and communities around the world. CSML Mission Statement

California School of Management and Leadership prepares individuals for professional careers in business, management and public affairs. We develop exceptional, intellectually engaged and culturally sensitive leaders in all sectors of society. As scholars and practitioners, we prepare our

students to successfully address professional challenges with integrity and compassion, with a view to advancing internationalism and multiculturalism.

Course Description This course presents with centralized emphasis on database design, implementation, and administration. The course provides comprehensive coverage of SQL, data modeling, normalization, storage management, transaction management, and query evaluation. Program Learning Outcomes • PLO1: Demonstrate an understanding of techniques for maximizing the value of data in organizations. • PLO2: Apply critical thinking skills in the context of problem solving in the business workplace. • PLO3: Project a positive, pro-active and non-judgmental attitude towards diverse cultural and

international identities in interpersonal and professional interactions. • PLO4: Demonstrate competence in communicating data solutions to organizational audiences. • PLO5: Apply knowledge and skills in data science in the context of the organization. • PLO6: Be able to make ethical and socially responsible decisions for data applications in business. • PLO7: Leverage teams in the applications of data analytics and information technology.

Course ID: Course Name

Course ID Version1ON September 2017

Page 2

Course Learning Outcomes • CLO1: Describe Database Systems, Relational Databases, and Data Models, • CLO2: Practice creating Entity Relationship Models and using advanced SQL. • CLO3: Research the latest trends in databases: including database cloud options. • CLO4: Analyze the decision-making process when technology is used to support managers. • CLO5: Design a data solution to meet specific enterprise needs and constraints. Professional Standards Alignment (if necessary)

Professional Standard(s) Addressed

(ASM MBA Program Learning Outcomes)

Outcomes (course level outcomes)

PLO1 CLO1: Describe Database Systems, Relational Databases, and Data Models

PLO1, PLO2, PLO4 CLO2: Practice creating Entity Relationship Models and using advanced SQL

PLO1, PLO2, PLO3, PLO4 CLO3: Research the latest trends in databases: including database cloud options.

PLO1, PLO2, PLO4, PLO6 CLO4: Analyze the decision-making process when technology is used to support managers

PLO1, PLO2, PLO4 CLO5: Design a data solution to meet specific enterprise needs and constraints. University Administrative Policies & Student Resources Administrative policies and students resources for the university can be accessed in the most current catalog posted on the university website http://catalog.alliant.edu/index.php Student Expectations Respectful Speech and Actions: As an institution of higher education, Alliant International University has the obligation to combat racism, sexism, and other forms of bias and to provide an equal educational opportunity. Professional codes of ethics and the academic code shall be the guiding principles in dealing with speech or actions that, when considered objectively, are abusive and insulting. Professional Behavior: This program is a graduate-level professional program, and each member of the program, both students and faculty, are expected to engage in professional behavior and conduct. Students should always display empathy, self-control, friendliness, generosity, cooperation, helpfulness, and respect in all of their interactions with other students, staff, and faculty. Students will strive to exemplify professional behavior in all aspects of their participation in this program, to be on time in all engagements, to thoughtfully and diligently complete activities and assignments, and to treat all other program members with respect and dignity. Expected In-class (Online) and Preparation Time per Week

Course ID: Course Name

Course ID Version1ON September 2017

Page 3

Weeks In-Class Time

(Discussions, interactions, delivering presentations, viewing lectures, exams)

Preparation Time (reading, major assignments, homework)

Week 1 5.5 hours 10 hours Week 2 6 hours 13 hours Week 3 8,5 hours 14 hours Week 4 9 hours 14.5 hours Week 5 7 hours 12 hours Week 6 6.5 hours 12 hours Week 7 6.5 hours 12 hours Week 8 6.5 hours 8 hours

Note. Expected weekly time is calculated at the number of hours per unit, times the number of units, divided by the number of weeks in the course for the following: • Class time: (15 x 3 of units) / 8 of weeks = 5.625 • Preparation time: (30 x 3 of units) / 8 of weeks = 11.25 Required Course Materials Coronel/ Morris(2015). Database Systems Design, Implementation, and Management. (11th Ed.) Cengage Learning. ISBN: 13-978-1-285-19614-5 Instructor Policies Late Assignments Technological issues are not considered valid grounds for late assignment submission. In the event of a server outage, students should submit assignments to the instructor directly through email and when systems are restored, submit those assignments according to syllabus instructions. Unless an Incomplete/In Progress grade has been granted, assignments submitted after the last day of class will not be accepted. Engagement and Discussion Requirements Class engagement and discussion are a part of your final grade. I will assess your level of engagement; however, engagement requires you to be actively engaged in the weekly classroom activities and discussion. The best contributions reflect excellent preparation, good listening, and interpretative and integrative skills. Group Work At times throughout your program you will be expected to work effectively in diverse groups of two to three students to achieve tasks. Group projects are outcome-based, which means that all members in the group will generally earn the same grade for group projects. However, I reserve the right to report different grades for group members if I see a substantial imbalance in individual contribution. I read all of the entries/discussions/interactions on your Group Homepage. If I do not see you active participating in your group, then that will adversely affect your personal grade. It is expected that you will actively participate with your group and contribute to the group discussions by:

• Contributing original work that is accepted and used by the group with proof of originality.

Course ID: Course Name

Course ID Version1ON September 2017

Page 4

• Participating in the project from assignment organization to a meaningful final review of the team project before submission.

• Ensuring that your contributions are your original work and properly quoted, cited, and referenced. • If groups are a component of the course they will be assigned by the end of the Week One. Your

instructor will make an announcement to the class concerning group assignments and you will also be

• able to view the groups by clicking on the “People” link located in the left-hand navigation of your Course

• Webpage. Feedback Each week, I will provide grades/scores and comments on assignments within 4 days of the last day of the week unless I notify you otherwise. Syllabus/Schedule This syllabus does not constitute a contract between the instructor and the students in the course. While every effort will be made to present the material as described the instructor retains the right to alter the syllabus for any reason at any time. When such changes are made every effort will be made to provide students with both adequate notification of the changes and to provide them with sufficient time to meet any changes in the course requirements. The weekly schedule for this course may be viewed online. University Administrative Policies & Student Resources You are held responsible for understanding and adhering to all policies contained within the University’s Catalog located at http://catalog.alliant.edu. However, some of those policies have been selected to be highlighted in this document. Academic Code of Conduct and Ethics The University is committed to principles of scholastic honesty. Its members are expected to abide by ethical standards both in their conduct and in their exercise of responsibility towards other members of the community. Each student’s conduct is expected to be in accordance with the standards of the University. The complete Academic Code, which covers acts of misconduct including assistance during examination, fabrication of da ta, plagiarism, unauthorized collaboration, and assisting other students in acts of misconduct, among others, may be found in the University Catalog. An act of plagiarism (defined in the University catalog as “Any passing off of another’s ideas, words, or work as one’s own”) is considered to be a violation of the University’s Student Code of Conduct and Ethics: Academic and will be addressed using the Policies and Procedures outlined in the University’s Catalog located at http://catalog.alliant.edu. The instructor in this course reserves the right to use computerized detection systems to help prevent plagiarism. Disability Accommodations Request The University provides reasonable access to facilities and services and to programs for which students are otherwise qualified without unlawful discrimination based upon qualified disability. The University will provide reasonable accommodations to individuals who currently have a disabling condition, either physical or mental, that is severe enough to substantially limit a major life activity. Students with disabilities may obtain details about applying for services from the Office of Accessibility at each campus. Students must provide documentation from a qualified professional to establish their disability, along with suggested reasonable and necessary accommodations. Students should request accommodations at the start of each semester. For more information, visit the Office of Accessibility Services at your campus or go to http://www.alliant.edu/about-alliant/consumer-information-heoa/disability-services/index.php. Policy on Religious/Cultural/Spiritual Observance by Students, Staff and Faculty

Course ID: Course Name

Course ID Version1ON September 2017

Page 5

In keeping with the institution’s commitment to respect and affirm cultural, religious, and spiritual diversity, the University supports the rights of students, staff, and faculty to observe religious/cultural/spiritual obligations that conflict with the University’s schedule. Faculty instructors and staff/administrative supervisory personnel are expected to make reasonable accommodations when a student or an employee is absent from class or work because of religious/cultural/spiritual observance. Attendance If you miss more than the allowed absences in a course in consecutive or non-consecutive weeks, you may be withdrawn from the course and not eligible to earn a grade. Sending assignments to me by email, fax, mail or other means does not make up for missed attendance and I cannot excuse absences. Length of Course Absences Allowed Absences Resulting in Drop 1-4 weeks 0 1 5-9 weeks 1 2 10+ weeks 2 3 Note: Academically related activities are used to calculate a student’s official last date of attendance with the institution. In order to be in attendance for the week, you must submit at least two “assignments” on one day during the seven-day online week. An “assignment” is defined as anything that is worth points in the course and can include Discussion and Engagement posts. Technology Requirements and Support Canvas Technical Support is available by calling 1-844-527-0334, or by using the Live Chat option. Answers to the most common issues are found in the Canvas Guides which are accessible by clicking Help link located in the top right-hand side of the canvas course Web Page. For other technical issues not related to canvas, please contact the Alliant Help Desk by email at: [email protected] or by phone at: 1-844-313-4357.

Course ID: Course Name

Course ID Version1ON September 2017

Page 6

Course Overview

Week 1: Introduction to Data Mining and Predictive Analytics .................................................................. 10

Week 2: The Relational Database Model and ER Data Modeling ............................................................... 12

Week 3: Advance Database Models and Normalization of DB Tables ...................................................... 13

Week 4: SQL .................................................................................................................................................... 15

Week 5: Transaction Management, Performance Tuning, and Query Optimization ................................ 16

Week 6: Distributed Database Management Systems, BI, and Data Warehouses ................................... 18

Week 7: Database Connectivity and Web Technologies ............................................................................ 19

Week 8: Database Administration ................................................................................................................. 21

Course ID: Course Name

Course ID Version1ON September 2017

Page 7

Course Grading Grading is in accordance with the academic policies of Alliant International University. Percentage Letter Grade 95-100 A 90-94 A- 87-89 B+ 83-86 B 80-82 B- 77-79 C+ 73-76 C < 72% Unsatisfactory for continuation in the program

Final grades will be determined as follows based on the points obtained in the following categories: Assignment Categories % of Grade Engagement / Discussion 25% Business rules, SQL, and DB tools 25% DB Design, Performance, and queries 20% IT Strategy and Plan Proposal 30%

Course Assessments

Assessment Due Assignment Category Point Value Week 1 Engagement & Discussions Engagement 10

Business Rules and Data Modeling Read Chapter 1 & 2 Review presentations for Chapter 1 & 2

Assignment 20

Week 2 Engagement & Discussions Engagement 10

ER Diagram Read Chapter 3 & 4 Review Presentations for Chapter 3 & 4

Assignment 20

Week 3 Engagement & Discussions Engagement 10

Normalization Read Chapter 5 & 6 Review Presentations for Chapter 5 & 6

Assignment 20

Course ID: Course Name

Course ID Version1ON September 2017

Page 8

Week 4 Engagement & Discussions Engagement 10

SQL Statements Read Chapter 7 & 8 Review Presentations for Chapter 7 & 8

Assignment 20

Week 5 Engagement & Discussions Engagement 10

Database Design Read Chapters 9 & 10 Review Presentations for Chapter 9 & 10

Assignments 20

Week 6 Engagement & Discussions Engagement 10

Performance Tuning & Query Optimization Read Chapter 11 & 12 Review Presentations for Chapter 11 & 12

Assignment 20

Week 7 Engagement & Discussions Engagement 10

Business Intelligence & Data Warehousing Reach Chapter 13 & 14 Review Presentations for Chapter 13 & 14

Assignment 20

Week 8 Engagement & Discussions Engagement 10

Final Project Read Chapter 15 Review Presentation for Chapter 15

Project 100

Total Points 320

Course ID: Course Name

Course ID Version1ON September 2017

Page 9

Course ID: Course Name

Course ID Version1ON September 2017

Page 10

Week 1: Introduction to Data Mining and Predictive Analytics Learning Objectives

1.1 Introduction to Databases CLO1

1.2 Why Databases are important CLO1

1.3 Problems with File System Data Processing CLO1

1.4 Data Modeling and Data Models CLO1, CLO2

1.5 CLO Activities and Resources (Please refer to your Course Page in Canvas for specifics on your Activities and Resources) Assignments

Business rules and data modeling CLO1, CLO2

Step 1: Choose a business that interests you. You will be using this business as a reference point throughout the course. Follow the instructions on p38, and create a list of business rules. Then, translate those business rules into data model components. Submit a Word document including 3 - 5 business rules and their related data model components to the online class. In the document, explain the relationship between the data model components and the business rules. Include information about why this step is important. Feel free to include tables and graphics as appropriate.

Step 2: Watch the tutorial re: how to use MS Access.

Step 3: Start to create your database using: Access. There are sample databases available in Access and on the Web site for the book. You are welcome to review these before you begin. You will be creating the Access Database first, then you will import the database into an Oracle Database on the Cloud, MySQL, or a MS Database. Take screen captures of what you have done so far, and submit them to the professor in Word via the online class.

Course ID: Course Name

Course ID Version1ON September 2017

Page 11

Course ID: Course Name

Course ID Version1ON September 2017

Page 12

Week 2: The Relational Database Model and ER Data Modeling Learning Objectives

2.1 Logical View of Data CLO1, CLO2

2.2 Relational Data Relationships CLO1, CLO2

2.3 Enterprise Relationship Model (ERM) CLO1, CLO2

2.4 ER Diagrams CLO1, CLO2

2.5 Database Design Challenges CLO1, CLO2, CLO3 Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources Assignments

ER Diagram CLO1, CLO2, CLO3

Step 1: Review the business rules and components you identified in week 1, and use the information create an entity relationship diagram. You can add business rules, entities, and structure to the concept as you create the diagram. The diagram should have at least 5 tables. Show the primary key and relationships. You can use Visio, Powerpoint, the Oracle SQL developer data modeler or Access. Paste your graphics or screen captures in a Word document and turn in to the professor via the online class.

Step 2: Continue to work on your database using: Access. Take screen captures of the work you have done so far and include them in a Word document. Turn in to your professor via the online class.

Step 3: Extra information: Review the information re: Oracle data models at: http://www.oracle.com/technetwork/developer- tools/datamodeler/overview/index.html

Course ID: Course Name

Course ID Version1ON September 2017

Page 13

Week 3: Advance Database Models and Normalization of DB Tables Learning Objectives

3.1 Identify the benefits of clustering CLO1, CLO2

3.2 Research Cloud Database models CLO1, CLO2

3.3 Explore Flexible Database Design CLO1, CLO2

3.4 Identify the benefits of normalization CLO1, CLO2, CLO4 Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources

Course ID: Course Name

Course ID Version1ON September 2017

Page 14

Assignments

Normalize ER Diagram CLO1, CLO2, CLO4

Step 1: Normalize the ER Diagram you created last week. The diagram may not have significant changes if it was well designed originally. However, there are usually some changes or updates that would be appropriate. Explain why this step is important. Describe how you eliminated or reduced redundancy through this step. Include all documentation in a Word document and submit to your instructor via the online class.

Step 2: Continue to work on your database using: Access, updating your ER diagram, creating tables, etc. Take screen captures of the database and describe what you learned as you were working in the database this week. Submit in a Word document to your professor via the online class.

Course ID: Course Name

Course ID Version1ON September 2017

Page 15

Week 4: SQL Learning Objectives

4.1 Explore the benefits of SQL CLO1, CLO2

4.2 Determine how queries are used CLO1, CLO2, CLO4

4.3 Justify the selection of a specific set of tables CLO2, CLO3, CLO4

4.4 Design queries for specific business reasons CLO1, CLO4 Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources Assignments

SQL CLO1, CLO2, CLO3, CLO4

Step 1: Using the same company information you used in the first 3 assignments, and write 4 SQL statements for your database information. You may use the information on pgs 294 – 303 for guidance. Include a description of what the SQL statements are intended to do, and why you chose the structure you did. Include all of this information in a Word document and submit it to your professor via the online class.

Step 2: Continue to work on your database using in Access. You may start to use Oracle Cloud or MS Database and import your information. Take screen captures and include them in a Word document with a description of your experience in the database thus far. Submit your Word document to your professor via the online class.

Course ID: Course Name

Course ID Version1ON September 2017

Page 16

4

Week 5: Transaction Management, Performance Tuning, and Query Optimization Learning Objectives

5.1 Identify the function, benefits and impacts of relational set operators. CLO1, CLO2

5.2 Identify the types of database architecture and how they impact data quality and performance CLO1, CLO2

5.3 Differentiate between applications for database, data warehouses, data marts, and document management systems

CLO1, CLO2, CLO3

5.4 Employ database building processes to design and database system using Microsoft Access software CLO1, CLO2, CLO3, CLO5

5.5 CLO

5.6 CLO Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources Assignments

Database Design CLO1, CLO2, CLO3, CLO5

Step 1: Describe the database design approach you would use for the company you have been writing about (or a larger company like Amazon). Include appropriate information about SDLC , DBLC, centralized, decentralized, conceptual design, top down and bottom up approaches. Include the appropriate business rules, your initial thoughts about business continuity, disaster recovery, security, and the database

Course ID: Course Name

Course ID Version1ON September 2017

Page 17

administration approach (roles, permissions, roles & responsibilities.) This 8 – 10 page Word document should include appropriate diagrams, and be submitted to the professor via the classroom.

Step 2: Continue to work on your database. Provide a Word document including the work you completed in the last week and screen captures. Submit via the online class.

Course ID: Course Name

Course ID Version1ON September 2017

Page 18

Week 6: Distributed Database Management Systems, BI, and Data Warehouses Learning Objectives

6.1 Research database performance tuning concepts CLO1, CLO2

6.2 Explain database optimization choices CLO1, CLO2, CLO3

6.3 Research DBMS Performance Tuning options CLO1, CLO3, CLO4

6.4 Determine DDBMS Advantages and Disadvantages CLO1, CLO5, CLO4 Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources Assignments

Database Performance Tuning, Query Optimization, and DB Mgmt Systems CLO1, CLO2, CLO3, CLO4, CLO5

Step 1: Create a Word document: write about your plan for the database performance tuning, query optimization, and distributed database management systems. Include appropriate diagrams. Submit the document to the professor via the online class.

Step 2: Continue to work on your database. Provide a Word document including the work you completed in the last week and screen captures. Submit via the online class.

Course ID: Course Name

Course ID Version1ON September 2017

Page 19

Week 7: Database Connectivity and Web Technologies Learning Objectives

7.1 Explain how database connectivity and cloud computing services benefit businesses CLO1, CLO2, CLO4

7.2 Research Extensible Markup Language CLO2, CLO2, CLO4

7.3 Explain the ethical considerations in designing database systems and IOT. CLO2, CLO3

7.4 CLO Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources Assignments

IT Strategy and Plan Project – Part III: IT and Performance Measurement (Team Assignment) CLO1, CLO2, CLO3, CLO4

Step 1: Describe the expansion of the current database to include a business intelligence and data warehouse. Discuss your strategy for the database connectivity and Web technology. Submit the Word document to your professor via the online class.

Step 2: Continue to work on your database. Provide a Word document including the work you completed in the last week and screen captures. Submit via the online class.

Course ID: Course Name

Course ID Version1ON September 2017

Page 20

Course ID: Course Name

Course ID Version1ON September 2017

Page 21

Week 8: Database Administration Learning Objectives

8.1 Consider the evolution of database administration CLO1, CLO2

8.2 Discuss the human component of database environments CLO1, CLO2, CLO4

8.3 Developing a database administration strategy CLO1, CLO2, CLO3, CLO4

8.4 Working in an Oracle Database administration environment CLO2, CLO3, CLO4, CLO5

8.5 CLO Activities and Resources Please refer to your Course Page in Canvas for specifics on your Activities and Resources Assignments

Final Project: Completed Database Strategy CLO1, CLO2, CLO3, CLO4, CLO5

Final Project: Design a final, detailed database strategy for your company. Include all appropriate details from the first 7 weeks of class. Include screen captures of the database you created, including the ERP diagram, the table design, technical details, disaster recovery plan, security plan, and the approach to database administration. This 10 – 15 page Word document should fully explain the approach and what you learned from the course. Describe which database system you feel is most appropriate for your chosen company.

Course ID: Course Name

Course ID Version1ON September 2017

Page 22

Course ID: Course Name

Course ID Version1ON September 2017

Page 23

Bibliography Include research-based articles for every week in every course. The American Psychological Association (APA) does not accept textbooks as the only source of information in graduate-level courses. Required (A list of all required readings)

Grading Rubric Technology/ Data Analysis Project Rubric:

4 - Excellent 3 - Good 2 - Fair 1 - Needs Improvement

Data and Modeling Integrity (Logistics and Diagnostics)

Comprehensively and thoroughly examines the scenario, environment summary, declaration of problem statement, challenges and summary of issues. Describes and accurately assesses potential actions and resources utilized, through articulated team recommendations. Identifies and interprets calculations to support synthesis

Examines the scenario, environment summary, declaration of problem statement, challenges and summary of issues. Only somewhat describes or assesses potential actions and resources utilized through team recommendations. Somewhat identifies and interprets calculations to support synthesis with scenario

Somewhat examines the scenario, environment summary, declaration of problem statement, challenges and summary of issues. Does not correctly describe or assess potential actions and resources utilized through team recommendations. Does not correctly identify or interpret calculations to support synthesis with scenario

Only partially examines the scenario, environment summary, declaration of problem statement, or challenges and summary of issues. Does not describe or assess potential actions or resources utilized through team recommendations. Does not identify or interpret calculations to support synthesis with scenario

Course ID: Course Name

Course ID Version1ON September 2017

Page 24

with scenario problem statement.

problem statement.

problem statement.

problem statement.

Data Classification Effectively explains key contributing technical, regulatory, and ethical constraints related to solving the problem through the core factors of total IT, process, and people practice. Integrates highly aligned and related analytics industry knowledge, classifications, and terminology.

Somewhat explains key contributing technical, regulatory, and ethical constraints related to solving the problem through the core factors of total IT, process, and people practice. Integrates somewhat aligned and related analytics industry knowledge, classifications, and terminology.

Selectively explains only partial aspects of key contributing technical, regulatory, and ethical constraints related to solving the problem through a partial lens of either total IT, process, or people practice. Lacks an integration of aligned and related analytics industry knowledge, classifications, and terminology.

Does not demonstrate a thorough understanding of key contributing technical, regulatory, or ethical constraints related to solving the problem through the core factors of total IT, process, and people practice. Fails to integrate aligned or related analytics industry knowledge, classifications, or terminology.

Communication Thoroughly articulates critical data solution factors with a high degree of accuracy, clarity, and context to organizational stakeholders with an appropriate level of responsiveness, core competence and personalization

Mostly articulates critical data solution factors with a high degree of accuracy, clarity, and context to organizational stakeholders with an appropriate level of responsiveness, core competence and personalization depending on

Somewhat articulates critical data solution factors with a general degree of accuracy, clarity, and context to organizational stakeholders with an appropriate level of responsiveness, core competence and personalization

Minimally articulates critical data solution factors with a general degree of accuracy, clarity, and context to organizational stakeholders with an appropriate level of responsiveness, core competence and personalization

Course ID: Course Name

Course ID Version1ON September 2017

Page 25

depending on situation, location, urgency, and audience level within organization.

situation, location, urgency, and audience level within organization.

depending on situation, location, urgency, and audience level within organization.

depending on situation, location, urgency, and audience level within organization.

Critical Thinking Identifies, defines, analyzes, interprets, and articulates key performance and/or revenue indicators into tactical performance recommendations through quantitative calculations leading to optimal improvements.

Identifies, defines, analyzes, and interprets some performance and/or revenue indicators into tactical performance recommendations, though lacking in breadth and depth of recommendation justification.

Identifies, defines, and analyzes some performance and/or revenue indicators, though lacks interpretation of results or clearly aligned tactical performance recommendations. Lacking quantitative calculations with little clear connection to potential optimal improvements.

Does not effectively demonstrate an understanding of how to identify, define, analyze, interpret, or articulate key performance and/or revenue indicators into tactical performance recommendations. Fails to include quantitative calculations leading to optimal improvements.

Data-Driven Recommendations

Articulates succinct recommendations based on reported critical data-driven findings, highly aligned with the performance, financial indicators, and goals of the organization.

Provides some recommendations based on reported critical data-driven findings, aligned with the performance, financial indicators, and goals of the organization.

Identifies partial recommendations based on reported critical data-driven findings, aligned with the performance, or financial indicators, or goals of the organization.

Does not demonstrate an understanding of how to identify recommendations based on reported critical data-driven findings, aligned with the performance, or financial indicators, or goals of the organization.

Course ID: Course Name

Course ID Version1ON September 2017

Page 26

Collaboration Effective

collaboration and partnership between team members with clear definition between member roles, duties, and responsibilities in prescribed team charter and exhibited fulfillment of each role within the team in data management, programmatic ETL, visualizations, results interpretation and prescriptive recommendations, or presentation of results.

Mostly exhibits effective collaboration and partnering between team members with some definition between member roles, duties and responsibilities in prescribed team charter and exhibits partial fulfillment of each role within the team in data management, programmatic ETL, visualizations, results interpretation, and prescriptive recommendations, or presentation of results.

Somewhat exhibits effective collaboration and partnering between team members with little definition between member roles, duties and responsibilities in prescribed team charter and exhibits little fulfillment of each role within the team in data management, programmatic ETL, visualizations, results interpretation, and prescriptive recommendations or presentation of results.

Collaboration and partnering details and role mapping is lacking in detail within team charter and exhibits a lack of fulfillment of each role to effectively manage data, programmatic ETL, visualizations, results interpretation, and prescriptive recommendations or presentation of results as a team.