Data Analytics Assignment: CRM-Based Marketing Insights with Power BI

Published: 28 May, 2025
Category Assignment Subject Computer Science
University Singapore University of Social Science Module Title Digital Analytics

Data Analytics Assignment

Objectives

  • To identify business issues, given a dataset
  • To document and perform data exploration
  • To perform a data extract, transform, and load (ETL) process to build a dimensional model
  • To create interactive data visualisations.
  • To document and present the business insights and recommendations

Task Overview

Context:

  • You are a Digital Marketing Analyst.
  • Your request for marketing information from the Enterprise IT Dept.
  • You received seven data files (collectively a dataset), which are extracted from the company’s Customer Relationship Management System (CRM).

Your Tasks

This project requires you:

  • To identify at least ONE (1) business issue of your choice based on the given dataset.
  • To explore, extract, transform and load the data into a dimensional model using Power BI.
  • To create interactive Data visualisations using Power BI to gain insights on the business issue you have identified.
  • To produce a Report using Microsoft Word to document the following:
  • The business issues
  • The data exploration
  • The data preparation
  • The data modelling done
  • The data visualisation work done
  • The business insights found
  • The business recommendations
  • To present your findings.

Need plagiarism-free Answers for your college/ university Assignments

Order Non-Plagiarised Assignment

Assignment Components

Create a Power BI Visualization and document your work, with the following sections (see Table below). You are free to include other relevant information you deem necessary.

Students are strongly encouraged to use screenshots to aid in their explanation, description and/or analysis.

1. Problem Statement
• Prepare a report to explain the business problem.
Identify ONE (1) business problem of your choice based on the given dataset.
(10 marks)
2. Data Exploration and Dimensional Model Building
• Perform data exploration using Power BI.
• Derive and draw a Dimensional Model based on the dataset to solve the business problem. The model should have clearly labelled dimension tables, measure tables and table attributes. Relations between fact and dimension tables must also be shown clearly. Attach this part as an annex in your report.
• Perform data Extract, Transform and Load (ETL) to build the data model using Power BI based on the Dimensional Model drawn.
• Prepare report to explain: the data exploration and findings; the data Extract, Transform and Load (ETL) steps used to build the Dimensional Model. Details should include descriptions, scripts and screenshots, if any.
(20 marks)
3. Data Visualisations Building
• Develop interactive Data visualisations using Power BI to answer the business problem.
(40 marks)
4. Business Insight and Recommendation
• Prepare a report to explain: the data visualisation works done; the business insights found; and the business recommendations.
(10 marks)
 
5. Video-Recorded Presentation
• Presentation of the data model, the data visualisation that is created, the business insights found, the business recommendations and time management of the presentation.
(20 marks)

The written report must use the “Assignment Report Cover” as its front page, with the Student Name, Student Number fill up.

Online Presentation – Demonstration and Explanation

You are required to submit a video-recorded presentation to showcase and demo your work using your Power BI Desktop.

During the recording, your webcam must be turned on, clearly showing your face, for authentication.

The video-recorded presentation should not exceed 10 minutes.

Video-recorded presentations that exceed the allotted time will be penalised.

This video assignment app, powered by Bongo, allows students to capture their presentations multiple times and finally choose their best presentation to be submitted. Each student is to practice the presentation in advance to ensure completion within 10 minutes. The recording must include both webcam (clearly showing the student’s face for authentication) and your PowerBI Desktop.

Select the RECORD VIDEO option and choose CAMERA + SCREEN as shown in the figure below. The figure may differ with the constant update of the Bongo software, hence, students may see a different layout, but the general steps should still apply.

Data Analytics Assignment: CRM-Based Marketing Insights with Power BI
After recording the video, click save (as shown below), and it will be ready for students to append it for submission.

Select the video by clicking on the Star, and click SUBMIT.

Deliverables

Each Individual is required to submit:

  • A softcopy of the Report (in .doc or .pdf format) via assignment submission link in Politemall, with the first page being the “Assignment Report Cover”
  • The PowerBI file via the assignment submission link in PoliteMall.
  • Your recorded video, submitted via the Bongo app, is found in PoliteMall.

Hire Experts to solve this assignment before your Deadline

Buy Today, Contact Us

Performance Criteria

Problem Statement
(10 marks)
The report will be assessed based on:
• depth and quality of explanation of the business problem based on the given dataset
• a professionally presented report
Data Exploration and Dimensional Model Building (20 marks) The report will be assessed based on:
• clear and appropriate Dimensional model drawing
• working data relationship, and an appropriate Dimensional model built
• a professionally written data exploration and ETL steps, and explanation
Presentation Slides and Presentation (20 marks) The presentations will be assessed based on:
• whether the presentations are clear, concise and well-organised
• whether presenters show a clear understanding of the work done
• whether presenters can clearly and properly explain how to derive business insights using data visualisations created
• whether arguments are logical and well-thought-out
Business Insight and Recommendation
(10 marks)
The report will be assessed based on:
• depth and quality of explanation of the various business insights and recommendations
• a professionally presented report
Data Visualisations Building
(40 marks)
The report will be assessed based on:
• clarity and correct use of data visualisations to analyse business problems
• Interactive data visualisations work correctly without errors, bugs or undesired behaviours
• Interactive data visualisations are designed with an appropriate and easy-to-use layout
• Use of advanced Power BI features

Plagiarism and Copyright Issues

Plagiarism refers to “copying any part of a source, and then submitting it, claiming that it is your own work”.

Please ensure that all the works submitted by you are not copied from other sources.

Any attempt to plagiarize will be dealt with severely, and it may result in your failing the module.

If you have made any references to certain materials, make sure you cite the sources by acknowledging and providing the information necessary to find the source (e.g. Title and author of book, Internet links, etc.)

Get expert assignment help in Singapore for Digital Analytics! We specialise in offering high-quality computer science assignment help, with an option for students to pay our experts to take on their assignment challenges. Need a reference? We also provide a free list of assignment examples to help you get started. With years of experience, our writers deliver 100% plagiarism-free content and offer unlimited revisions to meet your needs. Trust us to help you excel in your studies!

If you want to see the related solution of this brief then click here:- Digital Analytics

Workingment Unique Features

Hire Assignment Helper Today!


CMA3005 – Introduction to Construction Management L3 Assessment Guide

CMA3005 Individual Report: The project involves converting the existing library at GBS into large seminar rooms to support growing student numbers.

CET255 Developing A Smart Greenhouse Monitoring System Prototype Assessment Brief

CET255 – IoT & Robotics Assessment: The aim of this assessment is to provide you with an opportunity to demonstrate your understanding and practical skills in IoT and Robotics.

ICM218 Research Project Assignment Brief 2024-25 | UoR

The Research Project almost always involves the analysis of data. At the start, each student is allocated an academic supervisor who offers advice on their Research Project.

Heisenberg Uncertainty Principle and de Broglie Equation 2024-25

Physics helps us understand the laws that govern our universe. Among the most fascinating areas of modern physics are the Heisenberg Uncertainty Principle and the de Broglie Equation.

SWSP6153 Indigenous Social Work 2025T2 | ACAP

This unit will introduce students to the diversity of the social, cultural and political situation in which Aboriginal and Torres Strait Islander people live. Indigenous Knowledge and practice as a new framework for working effectively.

771762 Assignment: Big Data and Data Mining Project Report 2025

771762 Assignment Task: Your task is to advise the DfT (and any other relevant UK Gov department) on the policy changes/interventions required to improve road safety, as well as to create a model that would predict such accidents and the injuries that people may incur.

MKT62304 Marketing Analytics Group Assignment Task | Taylor's

MKT62304 Group Assignment Task: This assignment aims to assess the role and effectiveness of marketing analytics in the water and SME sectors, focusing on how data-driven approaches can achieve strategic objectives and desired outcomes.

CST4530 Security Solutions and Applications Module Handbook 2024-25 | MUL

This module covers the concepts and critical issues of security with an emphasis on security architecture and mechanisms, standards, protocols, solutions, and applications. It aims to provide students with an understanding of security technologies, algorithms, and solutions.

UMSD87-15-3 Business Innovation and Growth Module Handbook 2024-25 | UWE

We aim to increase your knowledge and understanding of these three themes and of the theories and concepts that surround them, to provide you with some subject-specific and transferable skills.

BTC 3150 Taxation Law Assignment Questions S1, 2025 | Monash University

Part One: Short Answer Questions worth a total of 14 marks;  Part Two: Problem Style Question worth a total of 6 marks; and  Part Three: Problem Style Question (that includes some calculations) worth a total of 10 marks.

Online Assignment Help in UK