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.
Data Analytics Assignment: CRM-Based Marketing Insights with Power BI
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.
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
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.)