Filter by keyword, subject, or both. Updates live as new model answers are added to our portal.
Databases and Business Intelligence
Databases and Business Intelligence – KAP Speciality Chocolates Database Coursewor
This individual coursework for the Databases and Business Intelligence module provides practical experience of database systems through the realistic KAP Speciality Chocolates case study. Students are required to design and implement a relational database solution that supports the management of products, stock, suppliers and purchase orders for KAP Speciality Chocolates Ltd. The case study describes a growing chocolate business with a shop and a storeroom that requires a database system to reduce operational errors and improve stock control. The first task requires students to analyse the case study and identify appropriate entities, attributes, relationships, primary keys, foreign keys and dependencies. Students must produce an extended Entity Relationship Diagram showing how the identified elements should be related. The diagram must include participation and cardinality constraints, and students must clearly document the assumptions made and the notation used. A range of modelling notations and software tools may be used, provided that the required database elements are clearly represented. The second task requires students to translate the ER design into a relational database implementation by writing SQL Data Definition Language statements. The SQL must define suitable tables, attributes, data types, primary and foreign keys and relevant constraints. The chosen data types should be appropriate and foreign-key data types must correspond correctly to their related primary keys. The third task focuses on SQL Data Manipulation Language and requires students to create queries addressing a range of business information needs. These include producing a product price list, identifying purchase orders due for delivery on a specified day, generating shop re-stocking lists, changing product cost and selling prices, identifying products with outstanding purchase-order deliveries, producing a re-order list for products below their minimum warehouse stock level, and identifying suppliers that provide multiple cartons. Students must populate their tables with sufficient suitable data to demonstrate that the SQL works and provide evidence of testing through screen captures of SQL statements and results. The fourth task requires students to demonstrate that the database design is normalised to Third Normal Form (3NF). The normalisation process must begin with unnormalised data and show the stages through First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF), explaining the changes and reasons at each stage. The final normalised solution must remain consistent with the ER diagram, assumptions and entity and attribute names used in the database implementation. The final submission must combine all tasks into one report written in English, using Arial 12-point font and single spacing. The report must contain the extended ER diagram and assumptions, SQL table definitions, SQL queries with explanations and testing evidence, and a written explanation of the normalisation process. The completed report must be submitted as a single PDF through SurreyLearn by the specified deadline.
Read Model Answer →
Multimodal Sentiment Intelligence Platform for Dynamic Market Insights
This assignment presents the development of a Multimodal Sentiment Intelligence Platform for Dynamic Market Insights. The project addresses the need for real-time market sentiment analysis by combining text and visual data through an AI-driven multimodal approach. Traditional sentiment analysis methods may have limitations when dealing with diverse data modalities, and this project aims to address this gap by integrating multiple artificial intelligence and deep learning techniques. The primary objective is to develop an AI-driven platform capable of performing real-time sentiment analysis and supporting market trend prediction. The proposed system also aims to generate business intelligence insights that can support applications in marketing, finance, and customer service. The project incorporates deep learning, large language models, and multimodal fusion techniques to improve sentiment understanding. For text-based sentiment analysis, the assignment identifies BERT and GPT-2 for sentiment classification. For visual sentiment analysis, YOLOv8 is used for object detection while DeepFace is incorporated for facial emotion recognition. Feature-level and decision-level fusion strategies are applied to combine information from different modalities and improve the overall sentiment analysis process. Retrieval-Augmented Generation (RAG) is also incorporated to provide context-aware sentiment insights. The proposed platform uses Amazon reviews and IMDb reviews as text datasets. For image or video-based multimodal data, the assignment references the CMU-MOSEI dataset and an Amazon-Reddit merged reviews dataset. Overall, the work focuses on combining natural language processing, computer vision, deep learning, large language models, multimodal fusion, and retrieval-augmented generation to create a platform capable of producing dynamic sentiment and market insights.
Read Model Answer →
Data Management / Business Analytics
2,500 words
Data and Decision Making (BS776) — Business Report: Two-Source Data Analysis in Python for Evidence-Based Decision-Making
This Level 7 report applies data management theory to a self-selected industry problem and carries it through to a working Python analysis and a defensible business recommendation. The brief is deliberately open on sector — finance, healthcare, transport, cyber security, business intelligence and others are all permitted — but firm on one point: the chosen topic must carry a genuine business implication rather than being a purely technical or clinical analysis. The work therefore begins by framing a specific data-driven decision the organisation needs to make, and returns to that decision at every stage. Two distinct data sources are then identified from approved open repositories and critically evaluated side by side. The evaluation covers the data types each holds, how the data was collected and what bias that introduces, how each is stored and managed, and where the weaknesses lie — proposing concrete data management solutions for the problems identified rather than simply cataloguing them. The analytical core examines, transforms and explores both datasets using univariate and multivariate techniques. All work is carried out in Python within Google Colab, with full screenshots of the code and outputs placed in the appendices and the live Colab link shared for verification. Charts and tables sit in the main body where they support interpretation, each labelled and referenced back to its data source, and each appendix is cited from the narrative so the reader can move between argument and evidence. Data cleaning and transformation steps are shown and justified, not glossed. Findings are reported at length and converted into a clear recommendation covering both the immediate decision and the current and future direction of data management for the business. The limitations section is written honestly — sample coverage, data recency, the assumptions the transformation forced, and what the proposed solution cannot address. Running alongside this, the module's weekly consolidation discussions are evidenced. Five or more critical responses across units two to nine are screenshotted, dated, individually labelled as appendices, and each supported by academic and practice references. Crucially, these are not left sitting in the appendix: they are cited and used within the main body to support the critical discussion, which is where the marks for that component sit. The report follows the prescribed structure — title page, executive summary, contents, introduction, main section with subsections per task, findings, recommendations, limitations, conclusion, Harvard reference list and full appendices — submitted as a single file.
Read Model Answer →
Data Visualisation / Business Intelligence
2,500 words
Data Visualisation (BS666) — Business Analyst Client Report: Dashboard Development, Tool Evaluation and Accessibility in Power BI and Tableau
This Level 7 resit assessment takes the form of a single client-facing report written from the position of a qualified business analyst. Rather than assembling semester activities, it asks for one sustained piece of analytical writing that carries a business case from raw open data through to a defended set of visualisations and the decisions they support. The report opens by identifying a data source drawn from an approved open repository and setting out the business problem the client faces. Provenance, structure, granularity and known limitations of the dataset are examined honestly at this stage, since every downstream claim rests on them, and all data is referenced in full — including data appearing inside charts, as the brief specifically requires. The main body works through three connected strands of critical evaluation. The first traces the development sequence of the visualisations themselves: how the data was prepared and cleaned, why particular chart types were selected over the alternatives available, how layout and interactivity were arranged for the intended audience, and how the design changed across iterations once weaknesses became visible. At least three completed visualisations are then evaluated individually and critically — what each one reveals, where each falls short, and what a reader could reasonably conclude from it. The second strand compares Power BI and Tableau as working environments for this specific dataset rather than in the abstract. Data connectivity, transformation and calculation capability, visual flexibility, publishing and sharing, licensing and governance are all weighed against what the client actually needs, with the practical friction encountered during the build reported rather than smoothed over. The third strand addresses accessibility and cognitive processing. It examines how each platform handles colour contrast and colour-vision deficiency, text alternatives, keyboard navigation and screen reader support, and then moves into the perceptual side — pre-attentive attributes, data-ink economy, chart junk, working memory limits and how visual encoding choices either reduce or inflate the effort a reader must spend to extract meaning. The argument connects this directly to decision quality in organisations with diverse analytical literacy. Findings are reported at length and translated into concrete business implications, with a conclusion that states what the client should do and on what evidence. The submission follows the prescribed structure throughout: title page, executive summary, contents, introduction, business problem, main evaluative section, findings, conclusion, Harvard reference list and appendices, presented as a single file for Turnitin.
Read Model Answer →
Data Visualisation / Business Intelligence
2,500 words
Data Visualisation (BS664) — Portfolio: Tableau and Power BI Dashboard Development for Evidence-Based Decision-Making
This Level 7 portfolio accumulates work across a full semester of data visualisation study and is submitted as one continuous document combining reflective writing, tool evaluation and an applied dashboard project. The emphasis throughout falls on interpretative rigour — showing not just that a visualisation was built, but why each design decision serves the decision-maker who has to act on it. The first activity documents sustained critical participation across the module's weekly discussion topics. Five or more substantive responses are evidenced with dated screenshots, each paired with the corresponding workshop date, and each grounded in both academic literature and practitioner sources rather than opinion alone. Live URLs to the Power BI and Tableau dashboards built during the module are included, and the activity closes with a consolidated review of how understanding developed across the units. The second activity covers formal training completion in both platforms, with certificates and badges reproduced, and then turns to accessibility. It examines the visualisations produced during that training against accessibility principles — colour contrast and colour-blind safe palettes, text alternatives, chart type legibility, cognitive load — and argues why accessibility is not a compliance afterthought but a determinant of whether a dashboard actually informs decisions inside a global organisation with a diverse user base. The third activity is a structured comparison of Tableau and Power BI, conducted through the evaluative frameworks introduced in workshops rather than a feature checklist. Benefits and limitations are weighed across data connectivity, calculation capability, visual flexibility, licensing and cost, collaboration and governance, and organisational fit. The section ends with a reasoned recommendation of one platform for the applied work that follows, with the trade-offs of that choice acknowledged openly. The fourth and largest activity is the applied project. A dataset is selected from an approved open source and its provenance, quality and limitations discussed. The target business, its stakeholder groups and the varying analytical literacy of the intended audience are analysed, because these determine what the dashboard must show and how plainly. The report then walks through the full development sequence — data preparation and cleaning, chart selection and justification, layout and interactivity, iteration in response to identified weaknesses — with screenshots evidencing each stage. Findings are reported and translated into specific, evidence-based decisions the business could take on the strength of them. The submission follows the prescribed structure with title page, contents, introduction, business problem, main analysis, findings, Harvard reference list and appendices, presented as a single file.
Read Model Answer →
Business Intelligence / Data Analytics / Project Management
Business Intelligence and Data Analytics for Project Progress Evaluation
This assessment for the Data Analytics and Project Management for Business Intelligence module requires students to critically evaluate the progress of a live-style project through the application of business intelligence and data analytics techniques. Working as a group of Project Analysts, students select either a Convocation project or Concert project associated with Northumbria University London and prepare a professional presentation assessing its progress, stakeholders, deliverables and performance. The assessment begins with development of a clear project problem or opportunity statement, followed by identification and analysis of the key stakeholders and deliverables associated with the selected project. Students then use Business Intelligence and Data Analytics techniques to examine project progress and communicate findings through dashboards. The assessment permits the use of Microsoft Excel or other suitable software for dashboard development. A central part of the task is the creation and critical evaluation of a project dashboard. Students are expected to use realistic assumed or projected data where necessary, as the assessment is designed to test the ability to design, interpret and critically evaluate dashboards rather than the accuracy of real project data. The data should therefore be internally consistent, relevant to the selected project and capable of generating meaningful management insights. Students must also critically justify their chosen BI and analytics tools, explaining how the dashboard supports project monitoring and informed decision-making. The assessment concludes with recommendations for the successful implementation and use of a Business Intelligence or Data Analytics solution within the selected project. Academic references and relevant examples should be used to support the analysis. The marking criteria place the greatest emphasis on application of BI tools and techniques (30%), followed by stakeholders and deliverables (20%) and justification of BI tools (20%). Project and opportunity analysis, conclusion and recommendations, and presentation and referencing each contribute a further 10%. Higher-performing work is expected to demonstrate critical evaluation, meaningful dashboard insights, strong theoretical or industry justification and professionally presented recommendations. If the file you want to upload is the resubmission report instead Use the same University, Subject and Module Name, but change these fields: Title: Business Intelligence and Project Analytics: Individual Critical Analysis of Project Performance Assignment type: MS Technical and Scientific Writing Word count: 1,500–2,000 words Key topics: Business Intelligence, Data Analytics, Project Management, Stakeholder Analysis, BI Tools, Dashboard Evaluation, Project Opportunity Analysis, Project Deliverables, Critical Analysis, Project Recommendations The resubmission is an individual written report in which the student selects only one area from the original project—Project & Opportunity Analysis, Stakeholders & Deliverables, Application of BI Tools & Techniques, Justification of BI Tools, or Conclusion & Recommendations—and develops it in depth. It should use the same Convocation or Concert project context while demonstrating independent critical analysis, reflection and application of theory.
Read Model Answer →
Big Data Analytics / Data Analytics
4,000 words
Big Data Analytics Using Python and Business Intelligence with Tableau
This individual Big Data Analytics assessment requires students to critically analyse data using programming languages, statistical techniques, data visualisation methods and business intelligence software. The assessment combines practical data analytics using Python with interactive business intelligence and dashboard development using Tableau, requiring evidence of technical implementation, research, critical appraisal and justification of the selected analytical approaches. The first section, worth 70%, is based on a dataset containing accidental drug-related deaths recorded in Connecticut between 2012 and 2024. The dataset contains 12,964 observations and 49 variables. Students are required to conduct exploratory data analysis using Python, develop three to four research questions, formulate null and alternative hypotheses, and apply appropriate statistical methods. The analytical process also requires an evaluation of alternative technologies and methodological approaches, supported by relevant research. Students must justify their selected methodology and present a clear workflow diagram. The solution-development stage involves data preprocessing, descriptive statistical analysis, visualisation, answering the research questions and conducting statistical significance testing to determine whether the null hypothesis should be accepted or rejected. Evidence of coding and a link to working code are also required. The final Python component requires evaluation of the findings, consideration of limitations and recommendations for future development using emerging technologies. The second section, worth 30%, focuses on Business Intelligence using Tableau and uses a historical Olympic Games dataset containing 271,116 rows and 15 columns. Students analyse relationships between medals and host cities, athlete age and medal type, season and medal counts, and sex and medal type. The section culminates in an interactive Tableau dashboard containing at least four interconnected sheets, where changes to relevant parameters are reflected across the dashboard. Overall, the assessment develops practical competence in Python-based analytics, statistical reasoning, research-question development, hypothesis testing, data visualisation and interactive business intelligence dashboard design. Overview word count: approximately 350 words. AI note: the brief permits AI for limited support such as grammar, structure, organisation of ideas and suggestions, but states that the main content, analysis and conclusions must remain the student's own work. AI use must also be declared.
Read Model Answer →
Business Intelligence / Data Analytics / Project Management
Business Intelligence and Data Analytics Dashboard for Project Progress Evaluation
This group assessment requires students to act as Project Analysts and critically evaluate the progress of a university project using business intelligence, data analytics and project management techniques. The scenario is based on Northumbria University London planning two major events: a Convocation and an associated Concert. Students must select one of these projects and assess its progress through a professionally structured presentation. The assessment requires students to begin by defining the main problem or opportunity associated with the selected project. They must then identify and analyse the project's key stakeholders and deliverables. A major component of the work involves evaluating project progress using suitable business intelligence and data analytics techniques and developing an appropriate dashboard, which may be created using Microsoft Excel or other suitable software. Students must not only present the dashboard but also critically analyse and justify its design, selected metrics, analytical methods and usefulness for project monitoring and decision-making. Because the projects are treated as already being in progress, students are permitted to create assumed or projected data to demonstrate their dashboards. The assessment does not primarily evaluate the accuracy of real project data; instead, it assesses students' ability to design, present and critically evaluate meaningful dashboards. Any assumed data should therefore remain realistic, internally consistent and relevant to the selected project. The presentation should conclude with evidence-based recommendations for the successful implementation and use of the proposed business intelligence or data analytics solution. Academic references and relevant examples must support the presentation, and a single reference list must be included. Assessment weighting places particular emphasis on application of BI tools and techniques (30%), followed by stakeholders and deliverables (20%) and justification of BI tools (20%). Project and opportunity analysis, conclusions and recommendations, and presentation/referencing are each worth 10%. The final assessment is a 15-minute group presentation followed by a 5-minute question-and-answer session. Every group member must contribute to the presentation. The PowerPoint submission is made electronically through Turnitin. Do not select Harvard automatically for this one. Unlike the previous Roehampton brief, this Northumbria brief requires academic references and a reference list but does not state a specific referencing style in the uploaded document.
Read Model Answer →