| University | Singapore University of Social Science (SUSS) |
| Subject | Digital Analytics |
DATA ANALYTICS ASSIGNMENT
1. OBJECTIVES
- To identify business issues, given a dataset
- To document and to perform data exploration
- To perform a data extract, transform, and load (ETL) process in order to build a dimensional model
- To create interactive data visualizations.
- To document and to present the business insights and recommendations
2. TASK OVERVIEW
Context:
You are a Digital Marketing Analyst.
You 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) system.
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 Visualizations 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 modeling done
- the data visualization works done
- the business insights found
- the business recommendations
- To present your findings.
3. 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.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Native Singapore Writers Team
- 100% Plagiarism-Free Essay
- Highest Satisfaction Rate
- Free Revision
- On-Time Delivery
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 Visualizations Building • Develop interactive Data Visualizations using Power BI to answer the business problem. |
(40 marks) |
| 4. Business Insight and Recommendation • Prepare report to explain: the data visualization works done; the business insights found; and, the business recommendations. |
(10 marks) |
| 5. Video Recorded Presentation • Presentation of the data model, the data visualization 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.
4. ONLINE PRESENTATION – DEMONSTRATION AND EXPLANATION
You are required to submit a video recorded presentation to showcase and demo your work using your PowerBI Desktop.
During the recording, your webcam must be turn on, clearly showing your face, for authentication.
The video recorded presentation should not exceed 10 minutes.
Video recorded presentations which exceed the allotted time will be penalized.
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 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.
Buy Custom Answer of This Assessment & Raise Your Grades
5. 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 assignment submission link in PoliteMall.
- Your recorded video, submitted via the Bongo app, found in PoliteMall.
6. 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 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-organized • whether presenters show clear understanding of work done • whether presenters can clearly and properly explain how to derive business insights using data visualizations 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 insight and recommendation • a professionally presented report |
| Data Visualizations Building (40 marks) |
The report will be assessed based on: • clarity and correct use of data visualizations to analyze business problem • interactive data visualizations work correctly without errors, bugs or undesired behaviors • interactive data visualizations are designed with appropriate and easy-to-use layout • use of advanced Power BI features |
7. 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.)
Please refer to the following URL for more details:
https://www1.np.edu.sg/clte/antiplagiarism/policy.htm
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Looking for Plagiarism free Answers for your college/ university Assignments.
- MBS661 International Business Expansion Proposal Assignment 1: Market Entry Strategy & SWOT Analysis
- HRM Assignment: Ethical AI Recruitment, Total Rewards Strategy, and Employee Engagement in Modern Workplaces
- AI in Medical Imaging Assignment: Clinical Evaluation and Deployment of uAI for Diagnostic Support
- Commercial Law Assignment 2: Kenny vs Yusof & Aisyah Car Sale Contract Formation Case Study
- Assignment: Applying Psychological Theories to Everyday Life – Development, Learning & Social Behavior
- Economics Consultancy Assignment: Business Analysis for Cafe vs Fine Dining Restaurant
- S3409C Social Determinants of Health Assignment: Impact on Elderly in Singapore and Policy Interventions Analysis
- Operations Strategy Assignment: Case Analysis, Lean & Agile Plan, ESG Debate, and Personal Change Management Insights
- A2379C Pharmaceutical Distribution Audit Assignment Report: CAPA Plan for GDP Compliance and Risk Management
- 5004ACC PAC Assignment: Research Proposal on Accounting & Finance and Career Development Portfolio with CV & Interview Preparation