For your final project in this course, you will choose a small business for which you will complete a Business Intelligence Project Report. You will a

For your final project in this course, you will choose a small business for which you will complete a Business Intelligence Project Report. You will apply the skills and knowledge you have gained throughout the course to identify and display the key performance indicators in such a way that it facilitates data-driven business decisions. To successfully complete this assignment, view the Final Project document.Download Final Project document. View Rubric Final Project Rubric Final Project Rubric Criteria Ratings Pts Executive Summary 20 pts Exemplary (100%) Demonstrates a sophisticated knowledge of business intelligence through the summary of the key points of the report (including the problem and solution); the purpose of the report (including the opportunities and competitive advantages); the major points of the report (including the KPIs and KPI dashboard); the description of the results; and the recommendations made from the report. 17 pts Proficient (85%) Executive Summary highlights the key points of the report, including the problem and solution; states the purpose of the report, including the opportunities and competitive advantages, highlights the major points of the report, including the KPIs and KPI dashboard; and describes the results and makes recommendations from the report. 11 pts Needs Improvement (55%) Executive Summary may be missing some of the following or contain inaccuracies: summarizes the key points of the report, including the problem and solution; states the purpose of the report, including the opportunities and competitive advantages, highlights the major points of the report, including the KPIs and KPI dashboard; and describes the results and makes recommendations from the report. 0 pts Not Evident (0%) This section of the report was not included in submission. / 20 pts Business Intelligence System and Strategic Goals Alignment 15 pts Exemplary (100%) Demonstrates a sophisticated knowledge of business intelligence through the identification of the strategic goal(s) of the business and the recommended BI system; explanation of how the two are aligned; a SWOT analysis; identification of the key performance indicators (KPIs); and explanation of the significance of each KPI. 12.75 pts Proficient (85%) This section of the report clearly states the strategic goal(s) of the business and the recommended BI system; explains how the two are aligned; includes a SWOT analysis; identifies the key performance indicators (KPIs); and explains the significance of each KPI. 8.25 pts Needs Improvement (55%) This section of the report may be missing some of the following or contain inaccuracies: states the strategic goal(s) of the business and the recommended BI system; explains how the two are aligned; includes a SWOT analysis; identifies the key performance indicators (KPIs); and explains the significance of each KPI. 0 pts Not Evident (0%) This section of the report was not included in submission. / 15 pts Business Intelligence Stages 10 pts Exemplary (100%) Demonstrates a sophisticated knowledge of business intelligence through the identification of the data that will be collected, loaded into the system, and analyzed, and where that data will be collected from, as well as the explanation of why specific data types were chosen. 8.5 pts Proficient (85%) This section of the report identifies the data that will be collected, loaded into the system, and analyzed, as well as where that data will be collected from. Also explains why specific data types were chosen. 5.5 pts Needs Improvement (55%) This section of the report may be missing some of the following or contain inaccuracies: identifies the data that will be collected, loaded into the system, and analyzed, as well as where that data will be collected from. Also explains why specific data types were chosen. 0 pts Not Evident (0%) This section of the report was not included in submission. / 10 pts Back-End Processing 10 pts Exemplary (100%) Demonstrates a sophisticated knowledge of business intelligence through the description of the ETL process for the BI system by identifying the data and its source that is to be extracted and determining data formatting, modifications, and calculations. Also describes the data repository or data warehouse specifications by naming specific tables and what they will hold; explaining how the tables are related and how to write joins, as well as what specific columns represent; and identifying any calculations that may be needed and their source. 8.5 pts Proficient (85%) This section of the report describes the ETL process for the BI system by identifying the data and its source that is to be extracted and determining data formatting, modifications, and calculations. Also describes the data repository or data warehouse specifications by naming specific tables and what they will hold; explaining how the tables are related and how to write join,; as well as what specific columns represent; and identifying any calculations that may be needed and their source. 5.5 pts Needs Improvement (55%) This section of the report may be missing some of the following or contain inaccuracies: describes the ETL process for the BI system by identifying the data and its source that is to be extracted and determining data formatting, modifications, and calculations. Also describes the data repository or data warehouse specifications by naming specific tables and what they will hold; explaining how the tables are related and how to write joins, as well as what specific columns represent; and identifying any calculations that may be needed and their source. 0 pts Not Evident (0%) This section of the report was not included in submission. / 10 pts Front-End Processing 10 pts Exemplary (100%) Demonstrates a sophisticated knowledge of business intelligence through the recommendation of an OLAP application technology for data discovery, reporting, analytical, and predictive analysis; and explains the rationale for this recommendation in terms of the prescriptive or predictive analytical application. 8.5 pts Proficient (85%) This section of the report recommends an OLAP application technology for data discovery, reporting, analytical, and predictive analysis; and explains the rationale for this recommendation in terms of the prescriptive or predictive analytical application. 5.5 pts Needs Improvement (55%) This section of the report may be missing some of the following or contain inaccuracies: recommends an OLAP application technology for data discovery, reporting, analytical, and predictive analysis; and explains the rationale for this recommendation in terms of the prescriptive or predictive analytical application. 0 pts Not Evident (0%) This section of the report was not included in submission. / 10 pts Dashboard 25 pts Exemplary (100%) Demonstrates a sophisticated knowledge of business intelligence through the creation of a dashboard mock-up that explains the appropriate visualization metric for each KPI; identifies visualization tools that will present the appropriate data formatting such as charts, graphs, and other reasonable formats; and provides a dashboard mock-up that is elegantly organized to display KPI information in a single place while enabling the user to dig deeper if desired. 21.25 pts Proficient (85%) Dashboard explains the appropriate visualization metric for each KPI; identifies visualization tools that will present the appropriate data formatting such as charts, graphs, and other reasonable formats; and provides a dashboard mock-up that is elegantly organized to display KPI information in a single place while enabling the user to dig deeper if desired. 13.75 pts Needs Improvement (55%) Dashboard may be missing some of the following or contain inaccuracies: explains the appropriate visualization metric for each KPI; identifies visualization tools that will present the appropriate data formatting such as charts, graphs, and other reasonable formats; and provides a dashboard mock-up that is elegantly organized to display KPI information in a single place while enabling the user to dig deeper if desired. 0 pts Not Evident (0%) Dashboard was not submitted. / 25 pts Mechanics 10 pts Exemplary (100%) Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to-read format. 8.5 pts Proficient (85%) Submission has no major errors related to citations, grammar, spelling, syntax, or organization. 5.5 pts Needs Improvement (55%) Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas. 0 pts Not Evident (0%) Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas. / 10 pts Total Points: 0