Business_Intelligence_and_Dashboards_assessment_202324_-_Tagged

Assessment Information/Brief 2023-24 To be used for all types of assessment and provided to students at the start of the module. Information provided should be compatible with the detail contained in the approved module specification although may contain more information for clarity. Module title Business Intelligence and Dashboards CRN 61606 Level 5 Assessment title Decision making analysis Weighting within module This assessment is worth 100% of the overall module mark. Module Leader/Assessment set by Assessment set by: Andrew Goudie Module leader: Andrew Goudie Submission deadline date and time 4pm on Thursday 26 th October For coursework assessments only: students with a Reasonable Adjustment Plan (RAP) or Carer Support Plan should check your plan to see if an extension to this submission date has been agreed. How to submit You should present your work on the template provided on Blackboard, and submit your assessment via Turnitin. You must make sure that the link to your dashboard is working so that your seminar lecturer can access it. Assessment Information/Brief 1

Assessment task details and instructions The management team of a small business has asked you to prepare a short report to advise them on their future approach to data analysis and business intelligence in your degree subject area. Your seminar leader and the Blackboard site will provide further details. Currently the business is committed to Microsoft Office 365 and use Excel for all their data analysis needs. They are considering adopting Power BI to complement or replace this. Your report will provide a short overview of business intelligence and Power BI, together with a dashboard that you will create to showcase the potential of Power BI to the business. Your report will consist of three sections: Part 1 (40%, 600 words) will provide an introduction to business intelligence and Power BI. Part 2 (20%, 300 words) will describe some of the sources of data relevant to your degree, and introduce the dataset used for the dashboard. Part 3 (40%, 300 words + dashboard) will include a link to your Power BI dashboard and an explanation of what it shows, together with a review of potential materials for training existing staff on the new software. The dataset that you will use to create a dashboard will be provided by your seminar lecturer. Maximum wordcounts are indicated above. The dashboard and any references are not included in the wordcount. Assessment Information/Brief 2

Assignment checklist and further guidance. The checklist below is to help you self-assess and improve your work, and includes some aspects that can have an impact on your mark: Tasks Checklist Most relevant weeks Marks Part 1 BI Platforms BI in Business Have you clearly explained what Business Intelligence is? Have you discussed BI platforms and applications in business? Weeks 1, 2 & 3 20 Excel vs BI Query Have you briefly explained what Excel and Power BI are? Have you included advantages and disadvantages of each? 20 Part 2 Sources of data Sources of data Have you discussed the importance of data analysis in your subject? Have you identified some important data sources for your subject and justified their value? Weeks 3, 4 & 5 10 Dashboard data Have you included the data source used in your dashboard, together with any relevant information about it? Have you explained why your data is meaningful and relevant for the purposes of your dashboard? What are the strengths and weaknesses of the dataset? 10 Part 3 Dashboard to showcase Power BI Dashboard user interface and design Have you published your dashboard and included the URL in your submitted work? Does the dashboard have a clear interface? Is it well-structured and formatted, including meaningful titles? Could it even include a “read me” page to explain the data source etc to the user? Weeks 5 & 6 20 LinkedIn Learning Have you discussed the strengths and weaknesses of the learning materials? Have you included a screenshot of your LinkedIn Learning certificates? 20 Total 100 Assessment Information/Brief 4

Assessment Criteria Assessment criteria can be found at the end of this assessment brief, and on the module Blackboard site. You should look at the assessment criteria to find out what we are specifically looking at during the assessment. Knowledge and Understanding Practical, Professional or Subject Specific Skills Assessed intended learning outcomes On successful completion of this assessment, you will be able to 1. Select data, and identify, perform and draw conclusions from appropriate techniques to aid management decision-making. 2. Use software to aid in decision-making. 3. Use evidence-based decision-making to address relevant practical issues. 4. Recognise terminology, basic tools and concepts of management decision-making. 5. Interpret the results of an analysis of a decision problem, including statistical approaches. 1. Select, organise, analyse and present information relevant to a management decision. 2. Apply decision-making methods to a business issue relevant to students’ degree programme. 3. Discuss and interpret results of a management decision problem and present a report in support of findings. 4. Present data in a variety of formats. Employability Skills developed / demonstrated Communication YES Critical Thinking and Problem Solving YES Data Literacy YES Digital Literacy YES Industry Awareness YES Innovation and Creativity YES Self-management and Organisation YES Word count/ duration (if applicable) Your assessment should be presented on the template provided. The spaces on the template give an indication of the expected response. The total word limit is 1200 words. The dashboard and any references are not included in the word count. Feedback arrangements You can expect to receive feedback within 15 working days of the submission deadline. There will be opportunities for formative Assessment Information/Brief 5

advicecentre-ussu@salford.ac.uk . In Year Retrieval Scheme Your assessment is not eligible for in year retrieval. Reassessment If you fail your assessment, and are eligible for reassessment, you will need to resubmit on or before a date to be advised later . For students with accepted personal mitigating circumstances for absence/non submission, this will be your replacement assessment attempt. The reassessment will be the same as the original assessment. We know that having to undergo a reassessment can be challenging however support is available. Have a look at all the sources of support outlined earlier in this brief and refer to the Personal Effectiveness resources. Assessment Information/Brief 7

Assessment Criteria 0-9 Ext Poor 10-19 Very Poor 20-29 Poor 30-39 Unsatisfactory 40-50 Adequate 50-59 Fair 60-69 Good 70-79 Very Good 80-89 Excellent 90-100 Outstanding Little or no attempt Very little attempt Most sections of the report paper are missing. Little effort to analyse results or data No dashboard. Major sections of the report are missing. Little reference to context. Dashboard has few visualizations with no attempt to improve on the default settings. Most sections of the report are present. Limited reference to context. Some attempt to format the dashboard, but poorly labelled, some output inappropriate for goals, and little insight added. All sections of the report are present. Generally well written with reference to context. Analysis generally sensible. Dashboard is clear and choice of visualizations is appropriate. Charts aid in understanding of the dataset. All sections of the report are present. Well written with reference to context. Some effort to look at implications. Dashboard is clearly labelled and formatted, with a variety of visualizations aiding understanding of the dataset. Clearly structured, signposted and well written with continual reference to context. Sensible and clearly interpreted explanations. The dashboard shows coherence and creativity with a variety of visualizations, all formatted and appropriate for the type of data and goals. Excellent structure and writing with continual reference to context. Results are insightful and clearly interpreted and explained. The dashboard shows coherence with a wide variety of visualizations with excellent presentation and the best choice for the type of data and goals. There is additional creativity in plots to make the required points. Work is of a near- professional standard and could be used as the basis for a consultancy report for a client. Assessment Information/Brief 8