ASSIGNMENT 1 (INDIVIDUAL)
Objective:
To create a report and dashboard of sales analytics. Also, using the power bi technique, different customer types, product groups, and trend analysis over the year.
Task lists
No Task Marks
1. This is the data for the assignment
2. Establish the data modelling. 10
3. Graphical Analysis using Filter / Slicer, which contains all the measurable dimensions. 40
a. Graphical Chart Analysis – Overall Trend Chart
b. Graphical Chart Analysis by Customer Type
c. Graphical Chart Analysis for Product Type
d. Graphical Chart Analysis for Customer Code
4. Dashboard Report Analysis.
a Analyze the performance over time series for all measurable variables. State your observation
b Analyze the performance for the year 2021
c. Data observed in 4b determines the potential customer code with the highest customer return. Display the dashboard graph to prove the finding and update the report.
MPOM7103 Assignment: Strategic Decision-Making and Operational Resilience in Petronas Amid Energy Transition
Read MoreMPIB7103 Assignment: Critical Perspectives on International Business Strategies and Regional Integration
Read MoreMPHR7113 Assignment: Strategic HR Analysis of Golden Heritage Café (HRM)
Read MoreTHEA1013 assignment: Theatrical Storytelling: Exploring the Unique Power of the Stage
Read MoreBusiness Strategy Assignment: Strategic Expansion: A Business Outlook
Read MoreGSGM7324 Assignment: Organisational Development and Change Management
Read MorePHY098 LOD 2, C4 Assignment: Mitigating Damage to Electrical Appliances from Lightning Strikes
Read MoreBM070 Business Research Assignment: Business Report Framework for Corporate Development
Read MoreHBET1203 Assignment: Comparing Pronunciation of Selected Words in Text and Reading to Standard British English
Read MoreIdentify key technological challenges affecting e-invoicing adoption in Malaysia.
Read More